[CLOUDSTACK-9871] MySQL 5.7 compatibility

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.10.0.0
• Fix Version/s: 4.10.0.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Labels: jdbc mysql
• Environment: Ubuntu 16.04, MySQL 5.7
• Assignee: Wido den Hollander
• Reporter: Wido den Hollander
• Created: 12/Apr/17 07:55
• Updated: 26/May/17 13:45
• Resolved: 26/May/17 13:45

Description

MySQL 5.7 comes with a more strict SQL mode by default which causes problems for CloudStack as the queries it executes are not all compatible with MySQL 5.7.

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

A work-around is setting the sql_mode to a more relaxed mode in the my.cnf:

[mysqld]
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 the future CloudStack should be fully compatible with the new SQL mode.

Issue Links

• links to: GitHub Pull Request #2037