Bug#921987: mysqld-akonadi: Could not open required defaults file
I confirm the bug:
$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during
initial connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: arguments:
("--defaults-file=/home/mylogin/.local/share/akonadi/mysql.conf",
"--datadir=/home/mylogin/.local/share/akonadi/db_data/",
"--socket=/tmp/akonadi-mylogin.VlHeqb/mysql.socket",
"--pid-file=/tmp/akonadi-mylogin.VlHeqb/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "Could not open required defaults
file: /home/mylogin/.local/share/akonadi/mysql.conf\nFatal error in
defaults handling. Program aborted\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/akonadi-mylogin.VlHeqb/mysql.socket' (2)'
Check that mysqld is running and that the socket:
'/tmp/akonadi-mylogin.VlHeqb/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
ii akonadi-backend-mysql 4:18.08.3-4
ii akonadi-server4:18.08.3-4
ii default-mysql-server1.0.5
ii mysql-common5.8+1.0.5
ii mariadb-common 1:10.3.12-2
ii mariadb-server-10.31:10.3.12-2
The file /home/mylogin/.local/share/akonadi/mysql.conf exists,
permissions: -rw-r--r--
The problem appeared after upgrade a week ago…
I used the kmail2 program as a mail client. Now I am giving up.
Any ideas haw can I extract my mail messages?
Aleksander.
Bug#921987: mysqld-akonadi: Could not open required defaults file
I removed mysql from my computer and installed akonadi-backend-mysql; that installed mariadb and mariadb started without problems and I am now using the mysql-backend. Reinhard
Bug#921987: mysqld-akonadi: Could not open required defaults file
Hey, > I used mysql and not mariadb. well mysql is not in buster. mysql-5.5 is oldstable So using mysql can't be a supported case. I strongly encourage you to switch to mariadb! If you need to use mysql, than you find a workaround at the upstream bugreport: https://bugs.kde.org/show_bug.cgi?id=399346 > As I changed to sqlite3 I can't test with mariadb. So you get the error with sqlite3 backend? The sqlite3 backend is not recommended to be used in production. As sqlite3 lacks about many features of a proper sql database. > Some times ago I tested mariadb, but mariadb didn't start, I forget the exact message, but it complaned about unknown version 5.7. I'm using mariadb without issues for several years now. We had an issue with fresh installations, that was solved with 18.08.3-2. But without any concrete log messages I can't help. regards hefee signature.asc Description: This is a digitally signed message part.
Bug#921987: mysqld-akonadi: Could not open required defaults file
I used mysql and not mariadb. As I changed to sqlite3 I can't test with mariadb. Some times ago I tested mariadb, but mariadb didn't start, I forget the exact message, but it complaned about unknown version 5.7. That is the version of mysql. Reinhard Am Dienstag, 12. Februar 2019, 23:11 schrieb Sandro Knauß: > > do you use mysql or mariadb? Can you debug more into this issue? I can't > reproduce this issue on sid with mariadb-server 1:10.3.12-2 and apparmor > 2.13.2-7. >
Bug#921987: mysqld-akonadi: Could not open required defaults file
Hey, > I have the same problem and it didn't go away. > Using the version from testing solved the problem. > Using the version from sid and the problem reappeared. > Strace showed the message ACCESS DENIED on > ~/.local/share/akonadi/mysql.conf. Now, I'm using the version from testing. do you use mysql or mariadb? Can you debug more into this issue? I can't reproduce this issue on sid with mariadb-server 1:10.3.12-2 and apparmor 2.13.2-7. hefee signature.asc Description: This is a digitally signed message part.
Bug#921987: mysqld-akonadi: Could not open required defaults file
I have the same problem and it didn't go away. Using the version from testing solved the problem. Using the version from sid and the problem reappeared. Strace showed the message ACCESS DENIED on ~/.local/share/akonadi/mysql.conf. Now, I'm using the version from testing. Reinhard
Bug#921987: mysqld-akonadi: Could not open required defaults file
Package: akonadi-backend-mysql
Version: 4:18.08.3-3
Severity: important
Dear Maintainer,
Since yesturday, akonadi is not able to start in Debian Sid (up-do-date).
When I run "akonadictl start", here is the result:
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial
connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/[my
login]/.local/share/akonadi/mysql.conf", "--datadir=/home/[my
login]/.local/share/akonadi/db_data/", "--socket=/tmp/user/1000/akonadi-[my
login].449afV/mysql.socket", "--pid-file=/tmp/user/1000/akonadi-[my
login].449afV/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "mysqld-akonadi: [ERROR] Could not open
required defaults file: /home/[my
login]/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR] Fatal error in
defaults handling. Program aborted!\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/user/1000/akonadi-[my login].449afV/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/user/1000/akonadi-[my
login].449afV/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
mysql.conf is set as following: -rw-r--r--
-- System Information:
Debian Release: buster/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.16.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE=
(charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages akonadi-backend-mysql depends on:
ii libqt5sql5-mysql 5.11.3+dfsg-4
ii mysql-client-core-5.7 [virtual-mysql-client-core] 5.7.25-1
ii mysql-server-5.7 [virtual-mysql-server]5.7.25-1
Versions of packages akonadi-backend-mysql recommends:
ii akonadi-server 4:18.08.3-3
akonadi-backend-mysql suggests no packages.
-- Configuration Files:
/etc/apparmor.d/usr.sbin.mysqld-akonadi changed [not included]
-- no debconf information
