LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Akonadi in Debian 8 (https://www.linuxquestions.org/questions/linux-software-2/akonadi-in-debian-8-a-4175558786/)

platypo 11-13-2015 09:51 AM
Akonadi in Debian 8
 
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?

jdkaye 11-13-2015 12:11 PM
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.
You can find more detailed information here.
jdk

platypo 01-04-2016 08:51 AM
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?

Habitual 01-04-2016 09:19 AM
Start by reading the FAQ and other documentation at https://userbase.kde.org/Akonadi#Fre...sked_Questions
If you have any additional questions after that, fire away.

platypo 01-04-2016 03:42 PM
thanks

platypo 11-11-2016 03:45 AM
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.

kilgoretrout 11-11-2016 07:50 AM
It's a bug/regression caused by the latest mysql update. I've experienced the same thing. See:

https://mail-archive.com/debian-bugs...sg1468800.html

There is a workaround given in the above bug report. Namely, in ~/.local/share/akonadi/ edit the mysql.conf file by adding the following line:
Code:
secure_file_priv=
Note, when editing mysql.conf, the above edit must be inserted before the current last lines which are:
Code:
[client]
default-character-set=utf8
or the workaround edit won't work. For example, the end of my mysql.conf file looks like:
Code:
# Workaround for mysql update issue
secure_file_priv=

[client]
default-character-set=utf8

platypo 11-13-2016 10:11 AM
thank you, worked for me.

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.

jailbait 11-13-2016 10:18 AM
Quote:
Originally Posted by platypo (Post 5629289)
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.
This problem was solved in the following thread:

http://www.linuxquestions.org/questi...nt-4175592271/

-------------------------
Steve Stites

kilgoretrout 11-13-2016 08:25 PM
Quote:
This problem was solved in the following thread:

http://www.linuxquestions.org/questi...nt-4175592271/
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.


All times are GMT -5. The time now is 05:11 PM.