[Bug 1572100] [NEW] Akonadi fresh install fails to start with MySQL 5.7

Lars Tangvald lars.tangvald at oracle.com
Tue Apr 19 11:55:00 UTC 2016


Public bug reported:

On a fresh install with MySQL 5.7, akonadi will fail to start up because 
a) mysql_install_db is run with options that are removed in 5.7
--force has been removed, and to keep the old behavior we need to add --insecure and --basedir=/usr

b) Database init sql scripts are rejected by 5.7's stricter default mode: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
5.7 is more restrictive of allowed values for different column types (no data truncation, no 0-dates, etc.)
A workaround is to add sql_mode=NO_ENGINE_SUBSTITUTION, which was the default value in 5.6

Bug is also reported, with suggested fixes, in the kde tracker:
https://bugs.kde.org/show_bug.cgi?id=361485

** Affects: akonadi (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Kubuntu
Bugs, which is subscribed to akonadi in Ubuntu.
https://bugs.launchpad.net/bugs/1572100

Title:
  Akonadi fresh install fails to start with MySQL 5.7

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1572100/+subscriptions




More information about the kubuntu-bugs mailing list