| Summary: | Akonadi will not start | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Stuart <sbeech> |
| Component: | general | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | CONFIRMED --- | ||
| Severity: | critical | CC: | claudio.bruzzese, dvratil, etienne, kdepim-bugs, loewe.e, mr.rostami94, msovin55, sbopsahl, shawn.thor |
| Priority: | NOR | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Other | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Stuart
2016-11-09 02:47:33 UTC
Could you please state your distribution and/or updates that cause this issue? *** Bug 372278 has been marked as a duplicate of this bug. *** (In reply to Christoph Feck from comment #1) > Could you please state your distribution and/or updates that cause this > issue? Linux Mint 17.2 Rafaela I have tended to do updates maybe once a week or fortnight. I'm not sure as to which update may have caused Akonadi to stop working. *** Bug 372462 has been marked as a duplicate of this bug. *** (In reply to Christoph Feck from comment #4) > *** Bug 372462 has been marked as a duplicate of this bug. *** my distribution is debian 8. kmail started to fail immediately after I installed the lsb-core package as requested by message of apt-get dist-upgrade to make operative google-earth. This is a known issue with MySQL and certain distribution setups. You can workaround it by creating a file ~/.config/akonadi/mysql-local.conf with the following line: secure_file_priv= (yup, there's nothing after the "=") Then MySQL should start as expected. (In reply to Daniel Vrátil from comment #6) > This is a known issue with MySQL and certain distribution setups. > > You can workaround it by creating a file ~/.config/akonadi/mysql-local.conf > with the following line: > > secure_file_priv= > > > > (yup, there's nothing after the "=") > > Then MySQL should start as expected. Thanks Daniel, I tried but this does not work for me. I have have also updated the system (apt-get dist-update has detected some update for akonadi), but without effects (kmail always returns the same error as before). Same report for me on KDE 5, Kubuntu 16.10 up to date.
Daniel's workaround not worked for me either.
Using "aconadictl start" gives me :
titi@TiTi-MSI-GT70-2OC:~$ sudo akonadictl start
Starting Akonadi Server...
done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
titi@TiTi-MSI-GT70-2OC:/var/lib$ akonadiprivate_log: search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/snap/bin", "/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.16 (Oracle MySQL)
Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/etc/xdg/akonadi/mysql-global.conf --initialize --datadir=/home/titi/.local/share/akonadi/db_data/"
mysqld: [ERROR] Could not open required defaults file: /etc/xdg/akonadi/mysql-global.conf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/titi/.local/share/akonadi/mysql.conf --datadir=/home/titi/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-root.gPGaHw/mysql.socket"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/titi/.local/share/akonadi/mysql.conf", "--datadir=/home/titi/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-root.gPGaHw/mysql.socket")
stdout: ""
stderr: "mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)\n2016-11-25T22:44:21.765496Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.\n2016-11-25T22:44:21.765542Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\n2016-11-25T22:44:21.765585Z 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-11-25T22:44:21.765589Z 0 [ERROR] Aborting\n\n2016-11-25T22:44:21.765601Z 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...
Found DENIED access reports in Syslog so I disabled mysqld-akonady profile in AppArmor. Found /var/lib/mysql-files not found trying to start "/usr/sbin/mysqld-akonadi --defaults-file=/etc/xdg/akonadi/mysql-global.conf --initialize --datadir=/home/titi/.local/share/akonadi/db_data/" manually Installed mysql-server Finally got an Unknown Error... Don't know where to look further. *** Bug 373073 has been marked as a duplicate of this bug. *** *** Bug 373140 has been marked as a duplicate of this bug. *** *** Bug 376219 has been marked as a duplicate of this bug. *** *** Bug 376174 has been marked as a duplicate of this bug. *** |