Sunday, September 22, 2019

How To Setup Go Web Application Using Apache on Ubuntu 18.04

Video Tutorial- https://youtu.be/t9Wl5hyGJec

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Go is an open source programming language developed by a team at Google. It provides easy to build simple, reliable, and efficient software.
Apache is the most widely used web server software.               
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

curl -O https://dl.google.com/go/go1.12.1.linux-amd64.tar.gz
tar -xvf go1.12.1.linux-amd64.tar.gz -C /usr/local
chown -R root:root /usr/local/go ; mkdir -p $HOME/go/{bin,src} ; nano ~/.profile
export GOPATH=$HOME/go
export PATH=$PATH:$GOPATH/bin
export PATH=$PATH:$GOPATH/bin:/usr/local/go/bin
. ~/.profile
echo $PATH ; go version

mkdir $GOPATH/go-web ; cd $GOPATH/go-web
nano main.go
package main

import (
    "fmt"
    "net/http"
)

func main() {
    http.HandleFunc("/", func(w http.ResponseWriter, r *http.Request) {
        fmt.Fprintf(w, "Hello World")
    })

    http.HandleFunc("/greet/", func(w http.ResponseWriter, r *http.Request) {
        name := r.URL.Path[len("/greet/"):]
        fmt.Fprintf(w, "Hello %s\n", name)
    })

    http.ListenAndServe(":9990", nil)
}

go build main.go
nano /lib/systemd/system/goweb.service
[Unit]
Description=goweb

[Service]
Type=simple
Restart=always
RestartSec=5s
ExecStart=/root/go/go-web/main


[Install]
WantedBy=multi-user.target

systemctl daemon-reload
service goweb start ; service goweb status

apt-get install apache2 -y
a2enmod proxy proxy_http
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>
    ServerName yourdomain.com
    ServerAdmin admin@yourdomain.com
    ProxyPreserveHost On
    ProxyPass / http://127.0.0.1:9990/
    ProxyPassReverse / http://127.0.0.1:9990/
    TransferLog /var/log/apache2/yourdomain_access.log
    ErrorLog /var/log/apache2/yourdomain_error.log
</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To setup Go Web Application Using Nginx on Ubuntu 18.04

Video Tutorial -https://youtu.be/5PIZjnwo3NM
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Go is an open source programming language developed by a team at Google. It provides easy to build simple, reliable, and efficient software.
NGINX is a famous open source web server software.               
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

curl -O https://dl.google.com/go/go1.12.1.linux-amd64.tar.gz
tar -xvf go1.12.1.linux-amd64.tar.gz -C /usr/local
chown -R root:root /usr/local/go
mkdir -p $HOME/go/{bin,src}
nano ~/.profile
export GOPATH=$HOME/go
export PATH=$PATH:$GOPATH/bin
export PATH=$PATH:$GOPATH/bin:/usr/local/go/bin
. ~/.profile
echo $PATH ; go version

mkdir $GOPATH/go-web ; cd $GOPATH/go-web
nano main.go
package main

import (
    "fmt"
    "net/http"
)

func main() {
    http.HandleFunc("/", func(w http.ResponseWriter, r *http.Request) {
        fmt.Fprintf(w, "Hello World")
    })

    http.HandleFunc("/greet/", func(w http.ResponseWriter, r *http.Request) {
        name := r.URL.Path[len("/greet/"):]
        fmt.Fprintf(w, "Hello %s\n", name)
    })

    http.ListenAndServe(":9990", nil)
}

go build main.go
nano /lib/systemd/system/goweb.service
[Unit]
Description=goweb

[Service]
Type=simple
Restart=always
RestartSec=5s
ExecStart=/root/go/go-web/main


[Install]
WantedBy=multi-user.target

systemctl daemon-reload
service goweb start ; service goweb status

apt install nginx -y
nano /etc/nginx/conf.d/yourdomain.conf
server {
    listen [::]:80;
    listen 80;
    server_name www.yourdomain.com;

    location / {
        proxy_set_header Host $http_host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_pass http://127.0.0.1:9990;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_next_upstream error timeout http_502 http_503 http_504;
    }
}
rm /etc/nginx/sites-enabled/default ; nginx -t  ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl restart nginx 
www.yourdomain.com


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Wednesday, September 18, 2019

How To install TYPO3 With LAMP On Ubuntu 18.04 LTS

Video Tutorial -https://youtu.be/CIuH7GPB-Jc

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TYPO3 is a free and open source enterprise content management system. It is written in PHP and uses MySQL to store its data. TYPO3 is a responsive, mobile ready, multilingual and secure CMS. It can be easily customized and extended without writing any code.
Offcial Website: https://typo3.org/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

leafpad /etc/php/7.2/apache2/php.ini &>/dev/null
max_execution_time = 360
max_input_vars = 1500


Create Mariadb Database :
mysql -u root -p
create database dbname character set utf8 collate utf8_general_ci;
create user 'dbuser'@'localhost' identified by 'dbpassword';
grant all privileges on dbname.* to 'dbuser'@'localhost';
flush privileges;
exit;

cd /var/www/html ; wget --content-disposition https://get.typo3.org/9
tar xzf typo3_src-9.5.9.tar.gz
mv typo3*/ typo3/
touch /var/www/html/typo3/FIRST_INSTALL
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/


Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/typo3
     ServerName www.yourdomain.com

     <Directory /var/www/html/typo3/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To install Bolt CMS with LAMP On Ubuntu 18.04 LTS

 Video Tutorial -https://youtu.be/s0YP36MqI2w

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL.
Bolt is an open source CMS written in PHP. Bolt source code is hosted on GitHub.
Offcial Website: https://bolt.cm/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com

lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

Create Mariadb Database :
mysql -u root -p
create database yourdbname;
grant all on db.* to 'yourdbuser'@'localhost' identified by 'yourdbpass';
flush privileges;
quit

mkdir -p /var/www/ ; cd /var/www/ ; wget https://bolt.cm/distribution/bolt-latest.zip && sudo unzip bolt-latest.zip
rm bolt-latest.zip
mv bolt-v3.6.10/ bolt ; cd bolt/
mv .bolt.yml.dist .bolt.yml
mv composer.json.dist composer.json
mv composer.lock.dist composer.lock
mv src/Site/CustomisationExtension.php.dist src/Site/CustomisationExtension.php
chown -R www-data:www-data /var/www/ ; chmod -R 755 /var/www/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/bolt/public
     ServerName www.yourdomain.com

     <Directory /var/www/bolt/public/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sunday, September 15, 2019

How To Install Automad CMS on Ubuntu 18.04

Video Tutorial -https://youtu.be/_LHTA7MqPc0

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Automad is a file-based content management system (CMS) and a template engine written in PHP. All content is stored in human-readable text files instead of a database. An Automad site is therefore fully portable, easy to install, and can be version controlled by using Git or Mercurial. It nevertheless offers database features like searching and tagging. The built-in template engine allows even inexperienced developers and designers to create beautiful themes and templates .
Offcial Website: https://automad.org/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion

apt-get update ; apt install -y apache2 php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 ; systemctl enable apache2

cd /tmp/ ; wget https://bitbucket.org/marcantondahmen/automad/get/b218af08c7ce.zip
unzip b218af08c7ce.zip
mv marcantondahmen-automad-b218af08c7ce /var/www/html/automad
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/automad/
     ServerName www.yourdomain.com

     <Directory /var/www/html/automad/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thursday, September 12, 2019

How To Install and Configure pgAdmin4 on Ubuntu 18.04


Video Tutorial -https://youtu.be/2n9tt6lvWkA

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

pgAdmin is a web-based interface for management of PostgreSQL database instances.
Offcial Website: https://www.pgadmin.org/           
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

apt -y install postgresql postgresql-contrib phppgadmin apache2
sudo -u postgres psql postgres
\password postgres

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
apt-get update ; apt install pgadmin4 pgadmin4-apache2 -y
http://www.yourdomain.com/pgadmin4

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To Deploy PmWiki On Ubuntu 18.04 LTS

Video Tutorial -https://youtu.be/nkyKRW0WlxE

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

PmWiki is a free and an open source wiki application that is  lightweight. PmWiki was at first release in 2004. PmWiki is a wiki-based system for collaborative creation and maintenance of websites. The web-pages created using PmWiki looks like normal web pages, but they also have the edit link to modify existing pages and add new pages in the website.
Offcial Website: https://www.pmwiki.org/

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

add-apt-repository ppa:ondrej/php -y
apt-get update ; apt install -y apache2 php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 ; systemctl enable apache2

wget http://www.pmwiki.org/pub/pmwiki/pmwiki-latest.zip
unzip pmwiki-latest.zip -d /var/www/html/
mv /var/www/html/pmwiki-2.2.118/ /var/www/html/pmwiki
nano /var/www/html/pmwiki/index.php
<?php include('pmwiki.php');
cd /var/www/html/pmwiki/ ; cp docs/sample-config.php local/config.php
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/pmwiki/
     ServerName www.yourdomain.com

     <Directory /var/www/html/pmwiki/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Wednesday, September 4, 2019

How To Install Nextcloud with Nginx Php 7.3 Mariadb 10.4 on Ubuntu 18.04 LTS

Video Tutorial -https://youtu.be/3c_nk2_IS_I

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. 
Offcial Website: https://nextcloud.com/                       
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification- [ Os: Ubuntu 18.04 LTS Bionic Beaver 64Bit ] HosTname: www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd  ; getconf LONG_BIT ; whoami ; apt update -y ; apt install -y build-essential software-properties-common curl gdebi wget aptitude nano git net-tools lsb-release apt-transport-https

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main'
add-apt-repository ppa:ondrej/php -y
apt-get update ; apt-get install nginx mariadb-server mariadb-client php7.3 php7.3-cli php7.3-fpm php7.3-cgi php7.3-bcmath php7.3-curl php7.3-gd php7.3-intl php7.3-json php7.3-mbstring php7.3-mysql php7.3-opcache php7.3-sqlite3 php7.3-xml php7.3-zip php7.3-snmp php7.3-json php7.3-imap php7.3-common php7.3-tidy -y

systemctl start php7.3-fpm nginx ; systemctl enable php7.3-fpm nginx
mysql_secure_installation

gedit /etc/php/7.3/fpm/php.ini &>/dev/null
date.timezone ="Asia/Kolkata"
cgi.fix_pathinfo=0

gedit /etc/php/7.3/fpm/pool.d/www.conf &>/dev/null
env[HOSTNAME] = $HOSTNAME
env[PATH] = /usr/local/bin:/usr/bin:/bin
env[TMP] = /tmp
env[TMPDIR] = /tmp
env[TEMP] = /tmp

ls /run/php/
gedit /etc/nginx/sites-available/default &>/dev/null
server {
    server_name www.yourdomain.com;

    access_log /var/log/nginx/yourdomain-access.log;
    error_log /var/log/nginx/yourdomain-error.log;
    root /var/www/html/nextcloud;

    location / {
        index index.php;
        try_files $uri $uri/ /index.php$is_args$args;
    }

    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php7.3-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
}
nginx -t
cd /var/www/html/ ; wget https://download.nextcloud.com/server/releases/latest.zip
unzip latest.zip
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

mysql -u root -p
create database nextclouddb;
grant all on nextclouddb.* to 'nextclouduser'@'localhost' identified by 'password';
quit
systemctl restart php7.3-fpm nginx mariadb
echo "192.168.11.132 www.yourdomain.com" >> /etc/hosts
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To Install Nextcloud with Apache Php 7.3 Mariadb 10.4 on Ubuntu 18.04 LTS

Video Tutorial -https://youtu.be/CH2DLz8gpC0

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite. In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc. 
Offcial Website: https://nextcloud.com/   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification- [ Os:  Ubuntu 18.04.2 LTS Bionic Beaver 64Bit ] Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd  ; getconf LONG_BIT ; whoami ; apt update -y ; apt install -y build-essential software-properties-common curl gdebi wget nano git net-tools lsb-release apt-transport-https

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main'


add-apt-repository ppa:ondrej/php -y


apt-get update ;apt install apache2 apache2-utils mariadb-server mariadb-client php7.3 libapache2-mod-php7.3 php7.3-cli php7.3-fpm php7.3-cgi php7.3-bcmath php7.3-curl php7.3-gd php7.3-intl php7.3-json php7.3-mbstring php7.3-mysql php7.3-opcache php7.3-sqlite3 php7.3-xml php7.3-zip php7.3-snmp php7.3-json php7.3-imap php7.3-common php7.3-tidy -y
a2enmod rewrite headers env dir mime

systemctl start apache2 mariadb ; systemctl enable apache2 mariadb
mysql_secure_installation

gedit /etc/apache2/mods-enabled/dir.conf &>/dev/null
gedit /etc/apache2/conf-enabled/security.conf &>/dev/null
ServerTokens Prod
echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf
gedit /etc/php/7.3/apache2/php.ini &>/dev/null
date.timezone ="Asia/Kolkata"

mysql -u root -p
create database yourdbname;
grant all on yourdbname.* to 'yourdbusername'@'localhost' identified by 'yourdbpassword';
quit

leafpad /etc/apache2/sites-available/nextcloud.conf &>/dev/null
<VirtualHost *:80>
     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/nextcloud
     ServerName www.yourdomain.com

     <Directory /var/www/html/nextcloud/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/nextcloud_error.log
     CustomLog ${APACHE_LOG_DIR}/nextcloud_access.log combined

</VirtualHost>
a2dissite 000-default ; a2ensite nextcloud

cd /var/www/html/ ; wget https://download.nextcloud.com/server/releases/latest.zip
unzip latest.zip
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

apache2ctl configtest ; systemctl reload apache2
hostname -I
echo "192.168.11.136 www.yourdomain.com" >> /etc/hosts
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Tuesday, September 3, 2019

How To Install BlogoText CMS on an Ubuntu 18.04

Video Tutorial -https://youtu.be/tz0yj0iTCGA

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BlogoText CMS is a simple and lightweight, free and open source Content Management System (CMS) and minimalist blog engine. BlogoText CMS features built in RSS feeds, links sharing, drag and drop image and file upload, JSON/ZIP/HTML import and export, as well as Wordpress import. BlogoText is ideal for bloggers and developers who like to take a more minimalist approach to blogging.
Features-
Blog with comments and RSS feeds
Links sharing
RSS Reader
Images/Files uploading and sharing
JSON/ZIP/HTML import-export; WordPress import
Support Addons
Github: https://github.com/BlogoText
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-   
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.0 libapache2-mod-php7.0 php7.0-cli php7.0-fpm php7.0-cgi php7.0-bcmath php7.0-curl php7.0-gd php7.0-intl php7.0-json php7.0-mbstring php7.0-mysql php7.0-opcache php7.0-sqlite3 php7.0-xml php7.0-zip php7.0-snmp php7.0-json php7.0-imap php7.0-common php7.0-tidy php7.0-mcrypt php7.0-pgsql php-pear php-imagick php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

Create Mariadb Database :
mysql -u root -p
create database db;
grant all on db.* to 'dbuser'@'localhost' identified by 'dbpass';
flush privileges;
quit

cd /tmp && wget https://github.com/BlogoText/blogotext/archive/3.7.6.zip
unzip 3.7.6.zip
mv blogotext-3.7.6 /var/www/html/blogotext
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/blogotext
     ServerName www.yourdomain.com

     <Directory /var/www/html/blogotext/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To install MarketplaceKit ECommerce Platform with LAMP On Ubuntu 18.04 LTS

 Video Tutorial - https://youtu.be/Zhu9NR33Zyo

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MarketplaceKit is a platform for building different types of online marketplaces. MarketplaceKit attempts to reduce the development effort required to build product, rental, service and listing marketplaces such as Etsy, AirBnB, Handy and Zillow. It does this by attempting to cover the main components a marketplace needs, including the following:
Powerful search across multiple fields, geolocation and custom fields
Geolocalization for users and listings
Frontend listing creation and browsing
User profiles
Direct messaging between users
Multilingual functionality
Offcial Website: https://marketplacekit.com/
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

apt-get update ; apt install -y apache2 mysql-server mysql-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-xsl php7.2-recode php7.2-redis php7.2-xmlrpc php7.2-snmp php7.2-xml php7.2-zip php-imagick php-pear php-memcache php-apcu redis-server libpng-dev

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mysql ; systemctl enable apache2 mysql ; mysql_secure_installation

Create Mariadb Database :
mysql -u root -p
CREATE DATABASE marketplacekit;
CREATE USER 'marketplacekituser'@'localhost' IDENTIFIED BY 'new_password_here';
GRANT ALL ON marketplacekit.* TO 'marketplacekituser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -
apt-get install -y nodejs
npm install -g npm
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer
cd /var/www/ ; composer create-project marketplacekit/marketplacekit:dev-master marketplacekit
leafpad /var/www/marketplacekit/.env &>/dev/null
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=marketplacekit
DB_USERNAME=marketplacekituser
DB_PASSWORD=new_password_here

cd /var/www/marketplacekit ; php artisan storage:link
php artisan migrate
php artisan migrate:refresh --seed
composer install
npm install
chown -R www-data:www-data /var/www/ ; chmod -R 755 /var/www/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/marketplacekit/public/
     ServerName www.yourdomain.com

     <Directory /var/www/marketplacekit/public/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com
Default username: admin
Default password: changeme

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sunday, September 1, 2019

How To Deploy DbNinja On Ubuntu 18.04 LTS

Video Tutorial-https://youtu.be/-R0IQa5hUDo

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

DbNinja is an advanced web-based application for MySQL database administration and development. It's a must-have for those who wish to access their hosted servers remotely. DbNinja supports all the latest features including: triggers, events, views, stored routines and foreign keys; in addition it allows to import and backup data and MySQL object structures, manage users and much more. DbNinja has a highly functional and elegant user interface, and can be used securely in any modern browser on any OS.

Offcial Website: https://www.dbninja.com/

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Our Server Specification-    

Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:

 

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

 

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

 

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

 

cd /var/www/html/ ; wget http://dbninja.com/download/dbninja.tar.gz

tar -zxvf dbninja.tar.gz

chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/ 

 

Apache VirtualHost :

leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null

<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com

     DocumentRoot /var/www/html/dbninja/

     ServerName www.yourdomain.com

     <Directory /var/www/html/dbninja/>

          Options FollowSymlinks

          AllowOverride All

          Require all granted

     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log

     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

 

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2 

 

http://www.yourdomain.com       

ls /var/www/html/dbninja/_users/

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Setup Sidu Database Web admin Tool for MySQL, PostgreSQL and SQLite On Ubuntu 18.04

Video Link -https://youtu.be/pol9APqG-VA

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SIDU is a FREE database client working via web browser. SIDU is a simple, intuitive and easy database admin tool. Simply copy SIDU to your website and run without any setup. Written in PHP.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

cd /var/www/html/ ; wget https://excellmedia.dl.sourceforge.net/project/sidu/sidu/sidu60.zip
unzip sidu60.zip
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/sidu60/
     ServerName www.yourdomain.com

     <Directory /var/www/html/sidu60/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

How To Deploy Adminer on Ubuntu 18.04

 Video Tutorial-https://youtu.be/sHYCO-DRq6Y

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Adminer is a lightweight alternative to phpMyAdmin. In comparison, its total package size is 400KB, versus the 4.2MB of phpMyAdmin. Unlike phpMyAdmin, which can only manage MySQL databases, this lite database manager can be used to manage MySQL, PostgreSQL, SQLite, MS SQL, Oracle, and SimpleDB database.
Offcial Website: https://www.adminer.org
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Our Server Specification-    
Os:Ubuntu 18.04 LTS Bionic Beaver 64Bit   |IP address- 192.168.1.50  | Hostname :www.yourdomain.com
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lsb_release -cd ; hostname ; hostname -I ; whoami ; getconf LONG_BIT ; apt install -y build-essential software-properties-common curl gdebi net-tools wget curl sqlite3 dirmngr nano lsb-release apt-transport-https leafpad git sudo unzip socat bash-completion checkinstall imagemagick openssl

MariaDB Repositories & Php PPA:
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 ; add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.biznetgio.com/mariadb/repo/10.4/ubuntu bionic main' && add-apt-repository ppa:ondrej/php -y

apt-get update ; apt install -y apache2 mariadb-server mariadb-client php7.2 libapache2-mod-php7.2 php7.2-cli php7.2-fpm php7.2-cgi php7.2-bcmath php7.2-curl php7.2-gd php7.2-intl php7.2-json php7.2-mbstring php7.2-mysql php7.2-opcache php7.2-sqlite3 php7.2-xml php7.2-zip php7.2-snmp php7.2-json php7.2-imap php7.2-common php7.2-tidy php7.2-pgsql php7.2-ldap php7.2-soap php7.2-snmp php7.2-xsl  php7.2-recode php-imagick php-pear php-memcache php-apcu

a2enmod dir env headers mime rewrite setenvif ; sed -i "s/;date.timezone.*/date.timezone = Asia\/\Kolkata/" /etc/php/*/apache2/php.ini ; echo ServerName 127.0.0.1 >> /etc/apache2/apache2.conf ; systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation

Create Mariadb Database :
mysql -u root -p
create database yourdbname;
grant all on db.* to 'yourdbuser'@'localhost' identified by 'yourdbpass';
flush privileges;
quit

mkdir /usr/share/adminer ; wget "http://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php
echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf-available/adminer.conf
a2enconf adminer.conf
chown -R www-data:www-data /var/www/html/ ; chmod -R 755 /var/www/html/

Apache VirtualHost :
leafpad /etc/apache2/sites-available/yourdomain.conf &>/dev/null
<VirtualHost *:80>

     ServerAdmin admin@yourdomain.com
     DocumentRoot /var/www/html/
     ServerName www.yourdomain.com

     <Directory /var/www/html/>
          Options FollowSymlinks
          AllowOverride All
          Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/yourdomain_error.log
     CustomLog ${APACHE_LOG_DIR}/yourdomain_access.log combined

</VirtualHost>

a2ensite yourdomain ; a2dissite 000-default.conf  ; apache2ctl configtest ; echo "192.168.1.50 www.yourdomain.com" >> /etc/hosts ; systemctl reload apache2
http://www.yourdomain.com/adminer.php

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------