From 044d748c1df4c9158bf86e65d815c24a9cac8451 Mon Sep 17 00:00:00 2001 From: Andre Heinecke <aheinecke@intevation.de> Date: Tue, 29 Nov 2016 09:04:18 +0100 Subject: [PATCH 36/40] Apply ubuntu fix for mysql permission check This is needed now both on debian stable and on ubuntu versions. Patch in packaging was described as: Description: disable the secure_file_priv check MySQL 5.7 introduced a premission check for export and import operations. In Ubuntu, only the full mysql-server package creates the set system wide directory causing mysqld-akonadi to error out on startup if only mysql-server-core-5.7 is installed. To prevent that the key is set to empty, which reverts mysqld to the 5.6 behavior. See http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv Author: Philip Muskovac <yofel@gmx.net> --- server/src/storage/mysql-global.conf | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/server/src/storage/mysql-global.conf b/server/src/storage/mysql-global.conf index b49f18d8c..8a9459c7b 100644 --- a/server/src/storage/mysql-global.conf +++ b/server/src/storage/mysql-global.conf @@ -100,5 +100,9 @@ wait_timeout=31536000 # 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= + [client] default-character-set=utf8 -- 2.14.1