Fortinet black logo

Database Support

Database Support

The following MySQL versions are supported:

  • MySQL 5.5.x
  • MySQL 5.7.x
Tooltip

If you are using MySQL 5.7.x, the following changes must be added to the my.cnf file:

sql_mode =
STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION

In addition, the following MariaDB server versions are supported:

  • 10.2.X-MariaDB-10.2.X+maria~xenial-log mariadb.org binary distribution
Note

The MariaDB server versions do not require additional configuration, except for Bind-Address and Grant Privileges. See FortiPortal Administration Guide > Upgrading FortiPortal software on the Fortinet Docs Library.

Database Support

The following MySQL versions are supported:

  • MySQL 5.5.x
  • MySQL 5.7.x
Tooltip

If you are using MySQL 5.7.x, the following changes must be added to the my.cnf file:

sql_mode =
STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION

In addition, the following MariaDB server versions are supported:

  • 10.2.X-MariaDB-10.2.X+maria~xenial-log mariadb.org binary distribution
Note

The MariaDB server versions do not require additional configuration, except for Bind-Address and Grant Privileges. See FortiPortal Administration Guide > Upgrading FortiPortal software on the Fortinet Docs Library.