Akonadi doesn't work, KOrganizer neither

Hello,

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



Distro is Tumbelweed 20181206.

Could you please help me? Any ideas?

You’re running

  1. akonadictl as root
  2. The desktop as root.
    Run both as your normal user.

@donMateo:

Looking further down your CLI trace, you seem to have indeed started Akonadi from the default “normal” user – UID == ‘1000’ …

Please check if, in the “/tmp/akonadi-«User Name»/” directory, the following sockets and file are present:

  1. ‘akonadiserver-cmd.socket’
  2. ‘akonadiserver-ntf.socket’
  3. ‘mysql.pid’
  4. ‘mysql.socket’

Also, check if, in the user’s directory “~/.local/share/akonadi/”, the following files and symbolic links are present:


akonadi_control.error.old
akonadictl.error.old
akonadiserver.error.old
db_data
db_misc
file_db_data
file_lost+found
mysql.conf
search_db
socket-eck001
socket-eck001.fritz.box

[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 …

Hi,

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> 


you need to start akonadictl start as the normal user.

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> 


There is no socket in tmp folder:


matep@linux-7px1:/tmp/akonadi-matep.UDO37i> ls -all
razem 0
drwx------ 1 matep users   0 12-08 18:16 .
drwxrwxrwt 1 root  root  494 12-08 21:47 ..
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> 


Please show


ls -ld /tmp/akonadi*

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
 > 


matep@linux-7px1:~> ls -ld /tmp/akonadi*
drwx------ 1 matep users 0 12-08 18:16 **/tmp/akonadi-matep.UDO37i**
matep@linux-7px1:~> cd /tmp/akonadi-matep.UDO37i/
matep@linux-7px1:/tmp/akonadi-matep.UDO37i> ls -all
razem 0
drwx------ 1 matep users    0 12-08 18:16 **.**
drwxrwxrwt 1 root  root  1582 12-13 17:56 ..
matep@linux-7px1:/tmp/akonadi-matep.UDO37i>  

and


matep@linux-7px1:~/.local/share/akonadi> cd ~/.local/share/akonadi
matep@linux-7px1:~/.local/share/akonadi> ls -all
razem 28
drwxr-xr-x  5 matep users  271 12-13 17:02 **.**
drwxr-xr-x 54 matep users 4096 12-09 19:24 **..**
-rw-r--r--  1 matep users  150 12-13 17:02 akonadi_control.error
-rw-r--r--  1 matep users  150 12-13 17:02 akonadi_control.error.old
-rw-r--r--  1 matep users    0 12-08 21:43 akonadictl.error
-rw-r--r--  1 matep users    0 12-08 21:43 akonadictl.error.old
-rw-r--r--  1 matep users  592 12-13 17:02 akonadiserver.error
-rw-r--r--  1 matep users  592 12-13 17:02 akonadiserver.error.old
drwxr-xr-x  6 matep users  259 12-13 17:02 **db_data**
drwxr-xr-x  2 matep users    6 11-27 20:41 **db_misc**
drwxr-xr-x 88 matep users 4096 11-27 21:46 **file_db_data**
-rw-r--r--  1 matep users 3385 11-27 20:41 mysql.conf
lrwxrwxrwx  1 matep users   25 12-08 18:16 socket-linux-7px1 -> **/tmp/akonadi-matep.UDO37i**
matep@linux-7px1:~/.local/share/akonadi>  


any ideas ? :slight_smile:

Try this, as your normal user:


touch /tmp/akonadi-matep.UDO37i/akonadiserver-cmd.socket
touch /tmp/akonadi-matep.UDO37i/akonadiserver-ntf.socket
chmod 4755 /tmp/akonadi-matep.UDO37i/*
akondictl start

Hello,


matep@linux-7px1:~/.local/share/akonadi> touch /tmp/akonadi-matep.UDO37i/akonadiserver-cmd.socket
matep@linux-7px1:~/.local/share/akonadi> touch /tmp/akonadi-matep.UDO37i/akonadiserver-ntf.socket
matep@linux-7px1:~/.local/share/akonadi> chmod 4755 /tmp/akonadi-matep.UDO37i/*
matep@linux-7px1:~/.local/share/akonadi> /usr/sbin/rcmysql status
**●** mariadb.service - MySQL server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: **active (running)** since Thu 2018-12-13 18:26:57 CET; 1min 6s ago
  Process: 4460 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS)
  Process: 4452 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
 Main PID: 4584 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 30 (limit: 4915)
   Memory: 109.2M
   CGroup: /system.slice/mariadb.service
           └─4584 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql
matep@linux-7px1:~/.local/share/akonadi> akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
matep@linux-7px1:~/.local/share/akonadi> 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-13 18:28:16 139721148968960 [Note] /usr/sbin/mysqld (mysqld 10.2.19-MariaDB) st
arting as process 4748 ...
"
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...


Still nothing :frowning:

Why are you looking at the system’s mysql service? Akonadi starts it’s own mysql process by default.

A question here: How do you upgrade your Tumbleweed install?

In the same folder


touch mysql.socket
chmod 4755 mysql.socket
akonadictl start

Hi,

today I run “zypper dup” and this is my current distro:


matep@linux-7px1:~> cat /etc/issue
Welcome to openSUSE Tumbleweed 20181219 - Kernel \r (\l).

eno1: \4{eno1} \6{eno1}


now Akonadi works perfectly.
Thank you very much for your time and support!

We can close this thread.