Failed to access directory for --secure-file-priv

[Kai Stian Olstad]

Hi

After upgrading from Kubuntu 14.04 to 16.04 Akonadi won't start.

   $ akonadictl start
   Starting Akonadi Server...
      done.
   executable: "/usr/sbin/mysqld-akonadi"
   arguments: 
("--defaults-file=/home/ks/.local/share/akonadi/mysql.conf", 
"--datadir=/home/ks/.local/share/akonadi/db_data/", 
"--socket=/tmp/akonadi-ks.juJXTz/mysql.socket")
   stdout: ""
   stderr: "mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 
2 - No such file or directory)
   2016-08-02T06:17:23.703826Z 0 [Warning] The syntax '--log_warnings/-W' 
is deprecated and will be removed in a future release. Please use 
'--log_error_verbosity' instead.
   2016-08-02T06:17:23.703874Z 0 [Warning] TIMESTAMP with implicit 
DEFAULT value is deprecated. Please use 
--explicit_defaults_for_timestamp server option (see documentation for 
more details).
   2016-08-02T06:17:23.703916Z 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
   2016-08-02T06:17:23.703920Z 0 [ERROR] Aborting

   2016-08-02T06:17:23.703934Z 0 [Note] Binlog end
   "
   exit code: 1
   process error: "Unknown error"
   terminating service threads
   terminating connection threads
   stopping db process
   Failed to remove Unix socket
   Failed to remove runtime connection config file
   Application 'akonadiserver' exited normally...


On a another machine where Akonadi is running I have these lines in my 
~/.local/share/akonadi/mysql.conf

   # 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


These lines is missing on the machine I upgraded to 16.04.

I guess if a manually add them in Akonadi will start, but shouldn't this 
be part of the upgrade?


-- 
Kai Stian Olstad