بسم الله الرحمن الرحيم
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.
