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/

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