Details

    • 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:
    • Environment:
      Ubuntu 16.04, MySQL 5.7

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                widodh Wido den Hollander
                Reporter:
                widodh Wido den Hollander
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: