Lars, Akonadi is failing because of the new secure_file_priv default location. Since akonadi doesn't install the full mysql-server-5.5 package, but only the mysql-server-core-5.5 package, the secure_file_priv directory isn't created, and mysql won't start.
This was fixed by having Akonadi set the secure_file_priv setting to empty. -- 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/1633855 Title: akonadi fails to start after upgrade to yakkety Status in akonadi package in Ubuntu: Triaged Status in mysql-5.5 package in Ubuntu: New Status in akonadi source package in Precise: Fix Released Status in mysql-5.5 source package in Precise: New Status in akonadi source package in Trusty: Fix Released Status in mysql-5.5 source package in Trusty: New Status in akonadi source package in Yakkety: New Status in mysql-5.5 source package in Yakkety: New Status in akonadi source package in Zesty: Triaged Status in mysql-5.5 source package in Zesty: New Bug description: After yesterday 15 sept. upgrade to Kubuntu 16.10 Yakkety Yak, kmail fails to start, because akonadi backend fails. Starting akonadi from command line, $ akonadictl start the output contains: stderr: "mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)\n2016-10-16T11:54:23.365277Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.\n2016-10-16T11:54:23.365377Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\n2016-10-16T11:54:23.365479Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files\n2016-10-16T11:54:23.365488Z 0 [ERROR] Aborting\n\n2016-10-16T11:54:23.365508Z 0 [Note] Binlog end\n" The cause is a regression in the file /etc/xdg/akonadi/mysql-global.conf provided by the package akonadi-backend-mysql Diff of the content of mysql-global.conf from Yakkety vs Xenial: <code> diff -u "akonadi-backend-mysql_16.04.3-0ubuntu2_all.deb - mysql-global.conf" "akonadi-backend-mysql_15.12.3-0ubuntu6_all.deb - mysql-global.conf" --- "akonadi-backend-mysql_16.04.3-0ubuntu2_all.deb - mysql-global.conf" 2016-06-24 15:51:12.000000000 +0200 +++ "akonadi-backend-mysql_15.12.3-0ubuntu6_all.deb - mysql-global.conf" 2016-04-20 10:42:09.000000000 +0200 @@ -100,5 +100,14 @@ # We use InnoDB, so don't let MyISAM eat up memory key_buffer_size=16K +# KUBUNTU: +# Unset the export dir check as only the full mysql-server package creates it +secure_file_priv= + +# KUBUNTU: +# workaround for 5.7 being more strict with column types +# (reverts to 5.6 behavior) +sql_mode=NO_ENGINE_SUBSTITUTION + [client] default-character-set=utf8 </code> Applying this patch fixes the bug. The "secure_file_priv" setting went missing is referenced in the package changelog: akonadi (4:15.12.3-0ubuntu5) xenial; urgency=medium * kubuntu_disable_secure_file_priv_check.diff: - Set secure_file_priv to empty as that directory is not set in a default kubuntu install -- Philip Muškovac <yo...@kubuntu.org> Mon, 18 Apr 2016 15:24:43 +0200 Marco Gamberoni To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1633855/+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
