Fortinet white logo
Fortinet white logo

Database Support

Database Support

The following MySQL versions are supported:

  • MySQL 5.5.x
  • MySQL 5.7.x
  • MySQL 8.0.0
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:

  • MariaDB 10.2.x

  • MariaDB 10.4.x

  • MariaDB 10.6.x

See Basic setup in the FortiPortal 6.0.9 Administration Guide.

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

Database Support

The following MySQL versions are supported:

  • MySQL 5.5.x
  • MySQL 5.7.x
  • MySQL 8.0.0
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:

  • MariaDB 10.2.x

  • MariaDB 10.4.x

  • MariaDB 10.6.x

See Basic setup in the FortiPortal 6.0.9 Administration Guide.

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.