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 Desktop Packages, which is subscribed to akonadi in Ubuntu. https://bugs.launchpad.net/bugs/1572100 Title: Akonadi fresh install fails to start with MySQL 5.7 Status in akonadi package in Ubuntu: New Bug description: 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 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1572100/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
