How to Setup phpMyAdmin in an iocage Jail on FreeNAS 11.1

بسم الله الرحمن الرحيم

Abstract

Tutorial on how to setup phpMyAdmin in an iocage Jail on FreeNAS 11.1.

Assumptions and Prerequisites

• OS: FreeNAS 11.1-U6
• FreeNAS Host: fn
• FreeNAS Network Interface: igb0
• FreeNAS IP: 10.0.0.2
• FreeNAS Subnet Mask: 24
• Jail Container: iocage
• iocage Version: 1.0 Alpha
• Jail Release: 11.1-RELEASE
• Jail Name: test
• Jail Network Interface: vnet0
• Jail Network Config: DHCP
• Jail Default Route: 10.0.0.1
• IP Version: IPv4
• Bridge Network Interface: bridge0
• DNS 1: 10.0.0.1 
• Domain: example.com
• ZPool Volume: tank
• Database: MariaDB v10.2.17
• Web Server: NGINX v1.14.0_12
• Web Directory: /usr/local/www/html
• PHP Version: 7.2
• phpMyAdmin Version: 4.8.3
• Setup iocage Jail
• Setup NGINX Web Server
• Setup MariaDB 

Install phpMyAdmin

Since we are using php72 on the nginx webserver, we will install phpMyAdmin for the php72 version
root@test:~ # pkg install phpMyAdmin-php72

Create a Symbolic Link to the phpMyAdmin directory into the webroot directory
root@test:~ # ln -s /usr/local/www/phpMyAdmin /usr/local/www/html/phpmyadmin

Restart nginx and php-fpm service
root@test:~ # service nginx restart; service php-fpm restart

Configure phpMyAdmin 

Edit the /usr/local/www/phpMyAdmin/config.inc.php file and configure phpMyAdmin settings or delete the /usr/local/www/phpMyAdmin/config.inc.php and then go to http://test/phpmyadmin/setup to configure a database server host. For our example, I am going to use the phpMyAdmin setup wizard.

First delete /usr/local/www/phpMyAdmin/config.inc.php file
root@test:~ # rm -v /usr/local/www/phpMyAdmin/config.inc.php

Go to http://test/phpmyadmin/setup and configure a database server host

Copy the text of the generated configuration file and then paste it into the /usr/local/www/phpMyAdmin/config.inc.php file

Paste the config text into /usr/local/www/phpMyAdmin/config.inc.php and Save File
root@test:~ # ee /usr/local/www/phpMyAdmin/config.inc.php

Login to phpMyAdmin

Go to http://test/phpmyadmin in your browser and login using your root username and password.

Resource Links

• Setup iocage Jail
• Setup NGINX Web Server
• Setup MariaDB 

How to Setup a MariaDB Server v10.2 in an iocage Jail on FreeNAS 11.1

بسم الله الرحمن الرحيم

Abstract

Tutorial on how to setup MariaDB Database Server v10.2.17 in an iocage Jail on FreeNAS 11.1.

Assumptions and Prerequisites

• OS: FreeNAS 11.1-U6
• FreeNAS Host: fn
• FreeNAS Network Interface: igb0
• FreeNAS IP: 10.0.0.2
• FreeNAS Subnet Mask: 24
• Jail Container: iocage
• iocage Version: 1.0 Alpha
• Jail Release: 11.1-RELEASE
• Jail Name: test
• Jail Network Interface: vnet0
• Jail Network Config: DHCP
• Jail Default Route: 10.0.0.1
• IP Version: IPv4
• Bridge Network Interface: bridge0
• DNS 1: 10.0.0.1 
• Domain: example.com
• ZPool Volume: tank
• Database: MariaDB
• Database Version: 10.2.17
• Setup iocage Jail

Install MariaDB

root@test:~ # pkg install mariadb102-server

MariaDB Configuration

Choose the configuration file from template for Database server eg: my-small.cnf, my-medium.cnf, my-large.cnf, or my-huge.cnf

root@test:~ # cp /usr/local/share/mysql/my-small.cnf /usr/local/etc/my.cnf 

Enable MariaDB Server to start on boot

root@test:~ # sysrc mysql_enable="yes"

Start MariaDB Server

root@test:~ # service mysql-server start

Configure and Secure MariaDB Server for production

root@test:~ # mysql_secure_installation

   Enter current password for root (enter for none): [Press Enter]

   Set root password? [Y/n]: y

   Remove anonymous users? [Y/n]: y

   Disallow root login remotely? [Y/n]: y

   Remove test database and access to it? [Y/n]: y

   Reload privilege tables now? [Y/n]: y

Test Login of 'root' user

root@test:~ # mysql -u root -p

Test SQL Queries

MariaDB [(none)]> select user,host,password from mysql.user;

MariaDB [(none)]> show databases; 

MariaDB [(none)]> exit;

Helpful Commands

Search for package
root@test:~ # pkg search mariadb

Resource Links

• MariaDB
• https://www.cyberciti.biz/faq/how-to-install-mariadb-databases-on-a-freebsd-v10-unix-server/

How to install phpMyAdmin on a FreeNAS Jail

بسم الله الرحمن الرحيم

Abstract

A tutorial to install phpMyAdmin on a FreeNAS Jail. 

Assumptions and Prerequisites

• Domain: example.com
• Hostname: www.example.com
• OS: FreeNAS 9.10.1-U2 (FreeBSD 10.3-STABLE)
• Container: Warden Jail
• Jail Name: www
• Private IP: 10.0.0.56
• Subnet Mask: 255.255.255.0/24
• Apache has already been installed.
• php56 is already installed.
• Restrict Access only to local LAN (10.0.0.0/24).

Instructions

- First install php extensions required for phpMyAdmin.    

# pkg install php56-session php56-json php56-mbstring php56-zip php56-gd php56-openssl php56-curl php56-ctype php56-bz2 php56-mcrypt php56-zlib

- Install and Configure phpMyAdmin for Database Web Administration

# pkg install phpmyadmin

- Create phpMyAdmin configuration file /usr/local/etc/apache24/Includes/phpmyadmin.conf

# vi /usr/local/etc/apache24/Includes/phpmyadmin.conf

   (1)      Alias /phpmyadmin "/usr/local/www/phpMyAdmin/"

   (2)       

   (3)      <Directory "/usr/local/www/phpMyAdmin/">                  

   (4)          Options None

   (5)          AllowOverride Limit

   (6)

   (7)          Require local

   (8)          Require ip 10.0.0.0/24

   (9)      </Directory>

- Reload Apache Configurations

# service apache24 graceful

- Configure phpMyAdmin to connect with Database

Goto http://10.0.0.56/phpmyadmin/setup via web browser.

Click the button 'New server' and add a new server settings.

After configuring settings for the database server connection, click the 'Display' button.

- Copy the php code generated into the file /usr/local/www/phpMyAdmin/config.inc.php

# vi /usr/local/www/phpMyAdmin/config.inc.php

- Goto http://10.0.0.56/phpmyadmin via web browser and Login to phpmyadmin with your database username and password.