recently I’ve installed OpenSUSE Tumbelweed (image from 2016-02). When instalation process finished KOrganizer was working fine. I configured everything and decided to run “zypper dup”. Upgrade was successfull but KOrganizer stopped working - it claims that Akonadi is not responding.
linux-7px1:/ # systemctl status mysql.service
● mariadb.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: inactive (dead)
linux-7px1:/ # systemctl start mysql.service
linux-7px1:/ # systemctl status mysql.service
● mariadb.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Sat 2018-12-08 18:16:17 CET; 4s ago
Process: 4640 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
Process: 4632 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
Main PID: 4648 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 30 (limit: 4915)
Memory: 94.5M
CGroup: /system.slice/mariadb.service
└─4648 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
gru 08 18:16:10 linux-7px1 systemd[1]: Starting MySQL server...
gru 08 18:16:13 linux-7px1 mysql-systemd-helper[4648]: 2018-12-08 18:16:13 139921037254656 [Note] /usr/sbin/mysqld (mysqld>
gru 08 18:16:17 linux-7px1 systemd[1]: Started MySQL server.
linux-7px1:/ # akonadic
akonadiconsole akonadictl
linux-7px1:/ # akonadic
akonadiconsole akonadictl
linux-7px1:/ # akonadictl start
QStandardPaths: wrong ownership on runtime directory /run/user/1000, 1000 instead of 0
D-Bus session bus is not available!
KCrash: Application 'akonadictl' crashing...
KCrash: Attempting to start /usr/lib64/libexec/drkonqi from kdeinit
sock_file=/kdeinit5__0
Warning: connect() failed: : Nie ma takiego pliku ani katalogu
KCrash: Attempting to start /usr/lib64/libexec/drkonqi directly
QStandardPaths: wrong ownership on runtime directory /run/user/1000, 1000 instead of 0
QStandardPaths: wrong ownership on runtime directory /run/user/1000, 1000 instead of 0
kf5.kwidgetsaddons: Invalid pixmap specified.
[1]+ Zatrzymano akonadictl start
linux-7px1:/ # Unable to start Dr. Konqi
Re-raising signal for core dump handling.
ex
e[1]+ Przerwane (zrzut pamięci) akonadictl start
linux-7px1:/ # exit
exit
matep@linux-7px1:~> akonadic
akonadiconsole akonadictl
matep@linux-7px1:~> akonadic
akonadiconsole akonadictl
matep@linux-7px1:~> akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
matep@linux-7px1:~> 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"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/matep/.local/share/akonadi/mysql.conf", "--datadir=/home/matep/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-matep.UDO37i/mysql.socket", "--pid-file=/tmp/akonadi-matep.UDO37i/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2018-12-08 18:17:00 140689967484928 [Note] /usr/sbin/mysqld (mysqld 10.2.19-MariaDB) starting as process 4726 ...
"
org.kde.pim.akonadiserver: exit code: 7
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-matep.UDO37i/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/akonadi-matep.UDO37i/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
^C
matep@linux-7px1:~>
matep@linux-7px1:~> cd /tmp/
matep@linux-7px1:/tmp> ls
akonadi-matep.UDO37i
matep@linux-7px1:/tmp> cd akonadi-matep.UDO37i/
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> ls
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> ls
matep@linux-7px1:/tmp/akonadi-matep.UDO37i>
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> cat /etc/issue
Welcome to openSUSE Tumbleweed 20181206 - Kernel \r (\l).
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> mysql
**Welcome to the MariaDB monitor. Commands end with ; or \g.**
**Your MariaDB connection id is 8**
**Server version: 10.2.19-MariaDB openSUSE package**
**Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.**
**Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.**
MariaDB (none)]> exit
[HR][/HR]Please note that, Akonadi is a «User» cache system used by the KDE PIM “Kontact” – everything happens at user level – nothing happens at system level …
“akonadictl fsck” is the usual 1st step to repair any caching issues which may occur when the caching mechanism is “touched” outside of the PIM application …
folder in tmp is empty (it was also included in previous listing):
Please check listing below:
matep@linux-7px1:~/> cd /tmp/akonadi-matep.UDO37i/
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> ls
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> akonadictl fsck
Akonadi Server is not running, check will not run
matep@linux-7px1:/tmp/akonadi-matep.UDO37i>
I run it as normal user (it was also part of my first, quite long listing):
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> 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"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/matep/.local/share/akonadi/mysql.conf", "--datadir=/home/mate
p/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-matep.UDO37i/mysql.socket", "--pid-file=/tmp/akonadi-matep.UDO37i/
mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2018-12-08 21:43:56 140382360854528 [Note] /usr/sbin/mysqld (mysqld 10.2.19-MariaDB) st
arting as process 15966 ...
"
org.kde.pim.akonadiserver: exit code: 7
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-matep.UDO37i/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/tmp/akonadi-matep.UDO37i/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
and separately as it’s easier to read status of MySQL:
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> systemctl status mysql.service
● mariadb.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Sat 2018-12-08 18:16:17 CET; 3h 30min ago
Process: 4640 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
Process: 4632 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
Main PID: 4648 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 30 (limit: 4915)
Memory: 77.6M
CGroup: /system.slice/mariadb.service
└─4648 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
matep@linux-7px1:/tmp/akonadi-matep.UDO37i>
If there ain’t a socket in the user’s “/tmp/akonadi-«Username».«Random String»/” directory then, it’s because there ain’t a link to the socket automatically defined by KDE Kontact in the user’s “~/.local/share/akonadi/” directory …
> pwd
/home/yyy/.local/share/akonadi
>
> file socket-xxx
socket-xxx: symbolic link to /tmp/akonadi-yyy.t05tT3
>