Bug#843520: [akonadi-server] Fails to start after mysql upgrade
Package: akonadi-server
Version: 1.13.0-2+deb8u1
Severity: important
Tags: patch
--- Please enter the report below this line. ---
After this apt upgrade:
Upgrade: mysql-server-core-5.5:amd64 (5.5.52-0+deb8u1, 5.5.53-0+deb8u1), mysql-common:amd64 (5.5.52-0+deb8u1, 5.5.53-0+deb8u1), libmysqlclient18:amd64 (5.5.52-0+deb8u1, 5.5.53-0+deb8u1)
I rebooted and noticed that Akonadi was unable to start.
akonadiserver.error:
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/fld/.local/share/akonadi/mysql.conf", "--datadir=/home/fld/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-fld.T7GgAn/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161107 13:16:09 [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
161107 13:16:09 [ERROR] Aborting
I was able to fix it by adding "secure_file_priv=" to ~/.local/share/akonadi/mysql.conf
--- System information. ---
Architecture: amd64
Kernel: Linux 4.7.0-0.bpo.1-amd64
Debian Release: 8.6
990 stable security.debian.org
990 stable ftp.debian.org
500 stable repos.wine-staging.com
500 stable deb.i2p2.no
500 jessie-backports mozilla.debian.net
100 jessie-backports ftp.debian.org
--- Package information. ---
Package's Depends field is empty.
Package's Recommends field is empty.
Package's Suggests field is empty.
Reply to: