Calendar can't accept new entries; akonadi and nepomuk problems

The links in email invitations that should add an entry to the calendar produce errors. I’ve searched openSuse forums, tried switching from MariaDB to MySQL, reinstalled the KDE components, changed config of AppArmor to complain from enforce for avahi-daemon, and restarted several times. KOrganizer continues to complain that akonadi and nepomuk are not registered at d-bus. The saved file is below. Any suggestions?

Akonadi Server Self-Test Report

Test 1: SUCCESS

Database driver found.
Details: The QtSQL driver ‘QMYSQL’ is required by your current Akonadi server configuration and was found on your system.

File content of ‘/home/konsultor/.config/akonadi/akonadiserverrc’:
%General]
Driver=QMYSQL

[QMYSQL]
Name=akonadi
Host=
Options=“UNIX_SOCKET=/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket”
ServerPath=/usr/sbin/mysqld
StartServer=false

[Debug]
Tracer=null

Test 2: SUCCESS

Akonadi is not running as root
Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.

Test 3: SKIP

MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.

Test 4: SKIP

MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.

Test 5: SKIP

MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.

Test 6: SUCCESS

akonadictl found and usable
Details: The program ‘/usr/bin/akonadictl’ to control the Akonadi server was found and could be executed successfully.
Result:
Akonadi 1.10.3

Test 7: ERROR

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 8: ERROR

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 9: ERROR

Nepomuk search service not registered at D-Bus.
Details: The Nepomuk search service is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 10: SKIP

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

Test 11: ERROR

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: ‘/usr/share/akonadi/agents’. The XDG_DATA_DIRS environment variable is set to ‘/usr/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share’; make sure this includes all paths where Akonadi agents are installed.

Directory listing of ‘/usr/share/akonadi/agents’:
akonadinepomukfeederagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
facebookresource.desktop
googlecalendarresource.desktop
googlecontactsresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
microblog.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
nepomuktagresource.desktop
newmailnotifieragent.desktop
nntpresource.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
sendlateragent.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to ‘/usr/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share’

Test 12: ERROR

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can be found in <a href=’/home/konsultor/.local/share/akonadi/akonadiserver.error’>/home/konsultor/.local/share/akonadi/akonadiserver.error</a>.

File content of ‘/home/konsultor/.local/share/akonadi/akonadiserver.error’:
Database error: Cannot open database.
Last driver error: “QMYSQL: Unable to connect”
Last database error: “Can’t connect to local MySQL server through socket ‘/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket’ (2)”
Unable to open database “Can’t connect to local MySQL server through socket ‘/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket’ (2) QMYSQL: Unable to connect”
"
0: akonadiserver(_Z11akBacktracev+0x38) [0x4584d8]
1: akonadiserver() [0x458762]
2: /lib64/libc.so.6(+0x358d0) [0x7fc89356a8d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fc89356a849]
4: /lib64/libc.so.6(abort+0x148) [0x7fc89356bcd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7fc895082204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x45a96d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fc89511c830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7fc895129c2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7fc895132813]
10: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x4e2) [0x45d812]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fc8951a411e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fc89518c0ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7fc89518f0ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7fc8951b9493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fc892c45316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7fc892c45668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc892c4570c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7fc8951b8d55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fc89518ad0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fc89518b005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7fc89519013b]
22: akonadiserver(main+0x1bf) [0x45074f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fc893556be5]
24: akonadiserver() [0x450df9]
]
"

Test 13: ERROR

Previous Akonadi server error log found.
Details: The Akonadi server reported errors during its previous startup. The log can be found in <a href=’/home/konsultor/.local/share/akonadi/akonadiserver.error.old’>/home/konsultor/.local/share/akonadi/akonadiserver.error.old</a>.

File content of ‘/home/konsultor/.local/share/akonadi/akonadiserver.error.old’:
Database error: Cannot open database.
Last driver error: “QMYSQL: Unable to connect”
Last database error: “Can’t connect to local MySQL server through socket ‘/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket’ (2)”
Unable to open database “Can’t connect to local MySQL server through socket ‘/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket’ (2) QMYSQL: Unable to connect”
"
0: akonadiserver(_Z11akBacktracev+0x38) [0x4584d8]
1: akonadiserver() [0x458762]
2: /lib64/libc.so.6(+0x358d0) [0x7f0b0e6cb8d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f0b0e6cb849]
4: /lib64/libc.so.6(abort+0x148) [0x7f0b0e6cccd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f0b101e3204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x45a96d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7f0b1027d830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7f0b1028ac2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7f0b10293813]
10: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x4e2) [0x45d812]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f0b1030511e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f0b102ed0ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7f0b102f00ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7f0b1031a493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7f0b0dda6316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7f0b0dda6668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f0b0dda670c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7f0b10319d55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f0b102ebd0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f0b102ec005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7f0b102f113b]
22: akonadiserver(main+0x1bf) [0x45074f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f0b0e6b7be5]
24: akonadiserver() [0x450df9]
]
"

Test 14: ERROR

Current Akonadi control error log found.
Details: The Akonadi control process reported errors during its current startup. The log can be found in <a href=’/home/konsultor/.local/share/akonadi/akonadi_control.error’>/home/konsultor/.local/share/akonadi/akonadi_control.error</a>.

File content of ‘/home/konsultor/.local/share/akonadi/akonadi_control.error’:
Unable to register service as “org.freedesktop.Akonadi.Control.lock” Maybe it’s already running?
"
0: /usr/bin/akonadi_control(_Z11akBacktracev+0x38) [0x43ca38]
1: /usr/bin/akonadi_control() [0x43ccc2]
2: /lib64/libc.so.6(+0x358d0) [0x7f38562b38d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f38562b3849]
4: /lib64/libc.so.6(abort+0x148) [0x7f38562b4cd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f38572e2204]
6: /usr/bin/akonadi_control(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x43ee4d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7f385737c830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7f3857389c2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7f3857392813]
10: /usr/bin/akonadi_control(_ZN6QDebugD1Ev+0x30) [0x41b550]
11: /usr/bin/akonadi_control(main+0x34b) [0x41812b]
12: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f385629fbe5]
13: /usr/bin/akonadi_control() [0x4182f1]
]
"

Test 15: SUCCESS

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous startup.

DO NOT randomly switch between MariaDB and MySQL, or different versions thereof!
Chances are that the database file formats are not 100% compatible and the database server will fail to start.

And this is exactly what happened apparently:


Test 12:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can be found in <a href='/home/konsultor/.local/share/akonadi/akonadiserver.error'>/home/konsultor/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/konsultor/.local/share/akonadi/akonadiserver.error':
Database error: Cannot open database. 
  Last driver error: "QMYSQL: Unable to connect" 
  Last database error: "Can't connect to local MySQL server through socket '/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket' (2)" 
Unable to open database "Can't connect to local MySQL server through socket '/home/konsultor/.local/share/akonadi/socket-Linshiba/mysql.socket' (2) QMYSQL: Unable to connect" 
"
0: akonadiserver(_Z11akBacktracev+0x38) [0x4584d8]
1: akonadiserver() [0x458762]
2: /lib64/libc.so.6(+0x358d0) [0x7fc89356a8d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fc89356a849]
4: /lib64/libc.so.6(abort+0x148) [0x7fc89356bcd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7fc895082204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x45a96d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fc89511c830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7fc895129c2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7fc895132813]
10: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x4e2) [0x45d812]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fc8951a411e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fc89518c0ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7fc89518f0ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7fc8951b9493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fc892c45316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7fc892c45668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fc892c4570c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7fc8951b8d55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fc89518ad0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fc89518b005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7fc89519013b]
22: akonadiserver(main+0x1bf) [0x45074f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fc893556be5]
24: akonadiserver() [0x450df9]

"

So decide whether you want to use MariaDB or MySQL (MariaDB is the default in openSUSE), and install/switch to the corresponding packages.
Then remove the Akonadi database (remove or better rename the folder ~/.local/share/akonadi/), and akonadi should start again.

Please note that the database is just a cache, so no data should be lost by this, but there’s no guarantee of course.

You might find the following from the first post in this KDE Forums post useful
https://forum.kde.org/viewtopic.php?f=20&t=86097&start=20
(paste the following into a script)

rm -rf ~/.local/share/akonadi/
akonadictl start
sleep 30s
akonadictl stop
sleep 15s
killall -9 mysqld
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
akonadictl start

It essentially stops akonadi, wipes and recreates related MySQL/MariaDB artifacts, and restarts.

Should be done after wolfi’s recommendation, to stay with one database app.
Should address any missing/orphaned artifacts in your configuration, so whether your original problem was related to your database app or not, has a chance to resolve your problem.

TSU

Shouldn’t really be necessary though.
The rm removed the complete akonadi database, i.e. all files comprising the database.
And there should be no need for “mysql_install_db” either as akonadi creates the database itself on start when it doesn’t exist.

This “script” was posted as a tentative work-around for some user’s particular strange problem over 4 years ago.
And it didn’t help either…