This is a similar problem to what others are seeing, though not quite the same.

(P.S. ignore the "19.04" prompt; I forgot to change the shell prompt. This is 19.10)

Code: Select all

greenman@Crynfyd19.04 ~$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman@Crynfyd19.04 ~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
2019-11-01T14:11:19.947154Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) initializing of server in progress as process 10526
2019-11-01T14:11:48.125931Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ?PzAGB/kk9>;
2019-11-01T14:12:06.370475Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) initializing of server has completed
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-akonadi"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/greenman/.local/share/akonadi/mysql.conf", "--datadir=/home/greenman/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/default/mysql.socket", "--pid-file=/run/user/1000/akonadi/default/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/user/1000/akonadi/default/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/run/user/1000/akonadi/default/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

I followed the instructions for "clean start after failed migration" but still get the same error.

I tried to teardown apparmor, but apparently that option has been removed:

Code: Select all

greenman@Crynfyd19.04 ~$ sudo service apparmor stop
greenman@Crynfyd19.04 ~$ sudo service apparmor teardown
Usage: /etc/init.d/apparmor {start|stop|restart|reload|force-reload|status}
greenman@Crynfyd19.04 ~$

I also tried converting from mysql to postgresql, but I get the same kind of error.

Further experiments:

I figured out how to get aa-complain, and I did aa-complain /usr/sbin/mysqld-akonadi and rebooted.
Then I deleted ~/.local/share/akonadi and ~/.config/akonadi
Then I tried akonadictl start .

Still no good:

Code: Select all

greenman@Crynfyd19.10 ~$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
greenman@Crynfyd19.10 ~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
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-akonadi"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/greenman/.local/share/akonadi/mysql.conf", "--datadir=/home/greenman/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/default/mysql.socket", "--pid-file=/run/user/1000/akonadi/default/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/user/1000/akonadi/default/mysql.socket' (2)'
Check that mysqld is running and that the socket: '/run/user/1000/akonadi/default/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...


And this is what I found in /var/log/syslog:

Code: Select all

Nov  1 15:23:24 localhost kernel: [  871.936246] audit: type=1400 audit(1572647004.320:75): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=6772 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov  1 15:23:24 localhost kernel: [  871.937496] audit: type=1400 audit(1572647004.320:76): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/etc/mysql/mysql.cnf" pid=6772 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov  1 15:23:24 localhost kernel: [  871.949785] audit: type=1400 audit(1572647004.332:77): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=6773 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov  1 15:23:24 localhost kernel: [  872.249366] audit: type=1400 audit(1572647004.632:78): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/etc/ssl/openssl.cnf" pid=6773 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0