Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Hello, i've recently stubled upon the term akonadi and had no idea what this is. After a bit of research i learned that it runs a local sql server wich a ring of applications have access to. What remote services require acces to the local sql database? I've also read about possible security issues like SQL Injection - If so, does this only affect the database or is this a possible breach further into the system?
Is there any good (and possibly simple explained) information about how all of this works together in debian 8?
Is this the kind of information you're looking for?
Quote:
Description: Akonadi PIM storage service
Akonadi is an extensible cross-desktop Personal Information Management (PIM) storage service. It
provides a common framework for applications to store and access mail, calendars, addressbooks, and
other PIM data.
i guess i should have posted in linux-newbie.
Is the akonadi server an internal server like pulseaudio or xorg (if you could compare it this way) or are there outgoing connections to the mailserver or something similar?
I dug out this thread because i recently had the following issue with akonadi:
Using Debian 8 with KDE Plasma i started Kmail and got the following Error Message:
"The akonadi personal information management service is not operational"
Further Details:
"MYSQL Server custom configuration not available"
"Akonadi Control Process not registered at D-Bus"
"Akonadi server process not registered at D-Bus"
"Protocol version check not possible"
"no resource agents found"
"Current akonadi Server Error log found"
"Previous akonadi server error log found"
When i try to start akonadi with
Code:
akonadictl start
the following error appears:
Code:
Starting Akonadi Server...
done.
me@pc:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-bw.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb770cd5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb770cd79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6e51367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6e52a23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb7441224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb74e9d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb74fa96f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb7503d88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb7578b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb7581119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb756661c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb756667e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb756642a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb7569fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb756a525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb75986e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d02684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d029a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d02a76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb7598839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb7564d9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb756512e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb756b2b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6e3ca63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/bw/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-me.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7767d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7767d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6eac367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6eada23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb749c224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb7544d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb755596f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb755ed88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75d3b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb75dc119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75c161c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75c167e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75c142a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75c4fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75c5525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb75f36e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d5d684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d5d9a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d5da76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb75f3839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75bfd9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75c012e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75c62b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6e97a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-bw.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7788d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7788d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6ecd367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6ecea23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb74bd224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb7565d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb757696f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb757fd88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75f4b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb75fd119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75e261c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75e267e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75e242a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75e5fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75e6525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb76146e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d7e684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d7e9a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d7ea76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb7614839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75e0d9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75e112e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75e72b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6eb8a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-me.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7792d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7792d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6ed7367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6ed8a23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb74c7224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb756fd0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb758096f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb7589d88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75feb6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb7607119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75ec61c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75ec67e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75ec42a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75effb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75f0525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb761e6e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d88684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d889a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d88a76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb761e839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75ead9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75eb12e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75f12b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6ec2a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
The issue keeps up after i log out and back in to kde or restart the whole system.
I have very few knowledge of that service and i don't know where to start troubleshooting. Thank you for your help.
I'm still looking for documentation that is comprehensible for non-developers or newbies or simple hints of the big picture how akonadi works together in the debian enviroment so if anyone knows a related website i'd be glad.
I dug out this thread because i recently had the following issue with akonadi:
Using Debian 8 with KDE Plasma i started Kmail and got the following Error Message:
"The akonadi personal information management service is not operational"
Further Details:
"MYSQL Server custom configuration not available"
"Akonadi Control Process not registered at D-Bus"
"Akonadi server process not registered at D-Bus"
"Protocol version check not possible"
"no resource agents found"
"Current akonadi Server Error log found"
"Previous akonadi server error log found"
When i try to start akonadi with
Code:
akonadictl start
the following error appears:
Code:
Starting Akonadi Server...
done.
me@pc:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-bw.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb770cd5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb770cd79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6e51367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6e52a23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb7441224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb74e9d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb74fa96f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb7503d88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb7578b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb7581119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb756661c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb756667e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb756642a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb7569fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb756a525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb75986e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d02684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d029a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d02a76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb7598839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb7564d9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb756512e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb756b2b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6e3ca63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/bw/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-me.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7767d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7767d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6eac367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6eada23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb749c224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb7544d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb755596f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb755ed88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75d3b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb75dc119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75c161c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75c167e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75c142a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75c4fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75c5525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb75f36e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d5d684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d5d9a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d5da76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb75f3839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75bfd9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75c012e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75c62b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6e97a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-bw.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7788d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7788d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6ecd367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6ecea23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb74bd224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb7565d0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb757696f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb757fd88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75f4b6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb75fd119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75e261c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75e267e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75e242a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75e5fb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75e6525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb76146e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d7e684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d7e9a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d7ea76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb7614839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75e0d9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75e112e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75e72b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6eb8a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/usr/local/games", "/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: ""
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-me.L1VMbG/mysql.socket")
stdout: ""
stderr: "/usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2)
161111 10:40:50 [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
161111 10:40:50 [ERROR] Aborting
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805c67b]
1: akonadiserver() [0x805c929]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7792d5c]
3: linux-gate.so.1(__kernel_vsyscall+0x9) [0xb7792d79]
4: /lib/i386-linux-gnu/i686/cmov/libc.so.6(gsignal+0x47) [0xb6ed7367]
5: /lib/i386-linux-gnu/i686/cmov/libc.so.6(abort+0x143) [0xb6ed8a23]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x124) [0xb74c7224]
7: akonadiserver() [0x805e672]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xab) [0xb756fd0b]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11696f) [0xb758096f]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x38) [0xb7589d88]
11: akonadiserver() [0x80c9720]
12: akonadiserver() [0x805f277]
13: akonadiserver() [0x8061a49]
14: akonadiserver() [0x812a441]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x2a) [0xb75feb6a]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1b9) [0xb7607119]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x5c) [0xb75ec61c]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x4e) [0xb75ec67e]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8a) [0xb75ec42a]
20: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x211) [0xb75effb1]
21: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x25) [0xb75f0525]
22: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1b46e3) [0xb761e6e3]
23: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0xb6d88684]
24: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x479a9) [0xb6d889a9]
25: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x36) [0xb6d88a76]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x69) [0xb761e839]
27: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4f) [0xb75ead9f]
28: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1ae) [0xb75eb12e]
29: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x96) [0xb75f12b6]
30: akonadiserver() [0x8056af8]
31: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xb6ec2a63]
32: akonadiserver() [0x80575a8]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
The issue keeps up after i log out and back in to kde or restart the whole system.
I have very few knowledge of that service and i don't know where to start troubleshooting. Thank you for your help.
It's the same problem but handled differently in Debian than in Mint. The *buntus, like kubuntu and mint, issued a subsequent akonadi update after the problematic mysql update which essentially made the edit I gave above to mysql.conf. That fixed the problem for them. The mysql update was a security update and the workaround edit to mysql.conf has possible security implications according to the Debian bug report I cited in my post. Accordingly, Debian has refused to issue an update which will make that edit to mysql.conf. And the bug report states that they cannot issue such an update but users are free to edit mysql.conf on their own as a workaround.
Long story short, in Debian you have to hand edit mysql.conf and in the *buntus an update was issued to akonadi which makes the edit for you.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.