Lalit Mohan Jaimini – Page 3 – Lalit Mohan Jaimini

Sql query (Update a column value, replacing part of a string)

UPDATE your_table_name SET `column_name` = REPLACE(`column_name`, 'CurrentString', 'To_replace_String');

Git Commands

Git Initialization – $ git init
Git Clone – $ git clone <repository url>
Git Clone From an branch – $ git clone -b <branch name> <repository url>
For view branch – $ git branch , $git branch -a
For checkout new branch – $ git checkout <branch name>
for create and checkout new branch – $ git checkout -b <branch name>
for file changes – $ git status
Add file for commit – $ git add <file or folder name>
Commit message – $ git commit -m “commit message”
for pull code from repository – $ git pull <repository url or remote name like – origin / destination> <branch name>
for push code from repository – $ git push <repository url or remote name like – origin / destination> <branch name>

Remove remote and add new remote in git

First Check Remote List Using Following –

$ git remote -v

(remote name like – origin) repository url (fetch)

(remote name like – origin) repository url (push)

2. Remove Remote

$ git remote rm (remote name like – origin)

3. then add new remote

$ git remote add origin repo url

Create ssl in ubuntu, centos and linux

sudo openssl req -new -newkey rsa:2048 -nodes -keyout domain-name.key -out domain-name.csr

Generating a 2048 bit RSA private key

…………………..+++

………………….+++

writing new private key to ‘domain-name.key’

—–

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter ‘.’, the field will be left blank.

—–

Country Name (2 letter code) [AU]:Country Code

State or Province Name (full name) [Some-State]:state name

Locality Name (eg, city) []:City Name

Organization Name (eg, company) [Internet Widgits Pty Ltd]:Company name

Organizational Unit Name (eg, section) []:Unit name

Common Name (e.g. server FQDN or YOUR name) []: domain name

Email Address []:email address

Please enter the following ‘extra’ attributes

to be sent with your certificate request

A challenge password []:

An optional company name []:

2. copy csr file and paste third party ssl provider website, then verify domain

3. After verify domain third party given certificate file (like cert.crt), bundle file(like bundle.crt or bundle.ca-bundle)

4. edit in apache sites conf file

ServerName domain-name

ServerAlias www.domain-name

DocumentRoot document

SSLEngine on

SSLCertificateFile /etc/ssl/cert.crt #certificate file full path

SSLCertificateKeyFile /etc/ssl/domain-name.key #key file full path

SSLCertificateChainFile /etc/ssl/bundle.ca-bundle #bundle file full path

</VirtualHost>

</IfModule>

Assign ftp user to specific directory

usermod -d directory-path username
sudo chown username:username directory-path
sudo chmod a-w directory-path
sudo service vsftpd restart

Install vsftpd and create new Ftp user with specific directory in ubuntu

sudo apt-get update
sudo apt-get install vsftpd
sudo vim /etc/vsftpd.confuncomment write_enable=YES
uncomment chroot_local_user=YES

Add at last in file
user_sub_token=$USER

allow_writeable_chroot=YES
sudo mkdir directory-path
sudo adduser –home=directory-path username
sudo chmod -R 0777 directory-path
sudo chown nobody:nogroup directory-path
sudo chown username:username directory-path
sudo chmod a-w directory-path
sudo service vsftpd restart

Get Python Wsgi Module Path Specific Django Project

After Activate Environment
mod_wsgi-express module-config

Set Mysql root Password In ubuntu 18

sudo mysql UPDATE mysql.user SET plugin="mysql_native_password" WHERE User='root'; UPDATE mysql.user SET authentication_string=PASSWORD("password") WHERE User='root'; FLUSH PRIVIlEGES; quit sudo service mysql restart

Run Python Project On Port 80 Apache2 Configuration

ServerName domain.com
ServerAlias www.domain.com
ServerAdmin webmaster@localhost
DocumentRoot /var/www/html/(python project folder Name)

<Directory /var/www/html/(python project folder Name)>
AllowOverride All
</Directory>
Alias /static /var/www/html/(python project folder Name)/static
<Directory /var/www/html/(python project folder Name)/static>
Require all granted
</Directory>
Alias /static /var/www/html/(python project folder Name)/media
<Directory /var/www/html/(python project folder Name)/media>
Require all granted
</Directory>
<Directory /var/www/html/(python project folder Name)/(python project folder Name)>
<Files wsgi.py>
Require all granted
</Files>
Require all granted
</Directory>

LoadModule wsgi_module “/var/www/html/myenv/lib/python3.6/site-packages/mod_wsgi/server/mod_wsgi-py36.cpython-36m-x86_64-linux-gnu.so”

WSGIDaemonProcess myenv1 python-path=/var/www/html/(python project folder Name):/var/www/html/myenv/lib/python3.6/site-packages
WSGIProcessGroup myenv1
WSGIScriptAlias / /var/www/(python project folder Name)/(python project folder Name)/wsgi.py

WSGIPassAuthorization On
WSGIApplicationGroup %{GLOBAL}