Appendix: MySQL and MariaDB differences
Your FortiPortal database configuration will differ depending on the database software you use, as well as the version and OS. The following table identifies some of the possible differences.
|
Database |
Version |
OS |
Configuration path |
Notes |
|---|---|---|---|---|
|
MySQL |
MySQL 5.7.x |
Ubuntu 14.0.4 LTS |
/etc/mysql/mysql.conf.d/mysqld.cnf |
Update the server bind-address to the system IP address. Add the following statement to the configuration path:
|
|
MariaDB |
10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04 |
Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-31-generic x86_64) |
/etc/mysql/mariadb.conf.d/50-server.cnf |
Update the server bind-address to the system IP address. |
|
MariaDB |
10.2.20-MariaDB-1:10.2.20+maria~bionic mariadb.org binary distribution |
Ubuntu 18.04.3 LTS |
/etc/mysql/mariadb.conf.d/50-server.cnf |
Update the server bind-address to the system IP address. Add the following statement to the configuration path:
|