My OS is:

Code: Select all

$ lsb_release -idrc
Distributor ID: neon
Description:    KDE neon User Edition 5.7
Release:        16.04
Codename:       xenial

I can't run akonadi. This problem has begun with last upgrade.

Code: Select all

akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
pablo@B85M-DS3H ~ $ akonadiprivate_log: search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  "/usr/bin/mysql_install_db"
Found mysqlcheck:  "/usr/bin/mysqlcheck"
Using mysqld: "/usr/sbin/mysqld-akonadi"
mysqld reports version 5.7.13 (Oracle MySQL)
Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/pablo/.local/share/akonadi/mysql.conf --datadir=/home/pablo/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-pablo.Bt5GCJ/mysql.socket"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/pablo/.local/share/akonadi/mysql.conf", "--datadir=/home/pablo/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-pablo.Bt5GCJ/mysql.socket")
stdout: ""
stderr: "mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)\n2016-08-04T19:35:25.489760Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.\n2016-08-04T19:35:25.489805Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\n2016-08-04T19:35:25.489842Z 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-08-04T19:35:25.489846Z 0 [ERROR] Aborting\n\n2016-08-04T19:35:25.489857Z 0 [Note] Binlog end\n"
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...

PabliNet-ar wrote:stderr: "mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)

You need to install mysql server (unfortunately I don't recall the exact package name).

After you have installed it just logoff/login again and it *should* work.

Hi,

Had the same problem after the latest upgrade.
mysql-files was missing from /var/lib. I just (re)created the missing directory, that was sufficient in my case anyway...

Is already reported: Bug #366400 [After upgrading PIM: Akonadi fails to start]

PatientZero wrote:mysql-files was missing from /var/lib. I just (re)created the missing directory, that was sufficient in my case anyway...

Did it for me too.

I can already solve the problem.
I created the directory: /var/lib/mysql-files

Code: Select all

sudo mkdir /var/lib/mysql-files

Thanks.