Created attachment 117168 [details] Akonadi Server Self-Test Report SUMMARY akonadiserver do not start - mysql error STEPS TO REPRODUCE $ akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) tonal@hius2:/etc/mysql/mysql.conf.d$ akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.relationtable OK akonadi.relationtypetable OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK akonadi.tagtypetable OK org.kde.pim.akonadiserver: "" org.kde.pim.akonadiserver: Unable to initialize database. mysqladmin: The query to get the server's pid file failed, error: 'Table 'performance_schema.session_variables' doesn't exist'. Continuing. org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally... SOFTWARE/OS VERSIONS KDE neon 5.14 4.15.0-43-generic amd64 KDE Plasma Version: 5.14.4 KDE Frameworks Version: 5.53.0 Qt Version: 5.11.2 MySQL version: 5.7.24-0ubuntu0.18.04.1 (Ubuntu)
see also https://bugs.kde.org/show_bug.cgi?id=374636
see also https://bugs.kde.org/show_bug.cgi?id=411093
Have the same problem. When install clean system akonadi works good and kate work. When I install mysqlserver akonadi crashed same as at links below: https://bugs.kde.org/show_bug.cgi?id=374636 https://bugs.kde.org/show_bug.cgi?id=411093 Deleting mysqlserver does not solve problem. Operating System: Kubuntu 20.04 KDE Plasma Version: 5.18.4 KDE Frameworks Version: 5.68.0 Qt Version: 5.12.5 Kernel Version: 5.4.0-21-generic OS Type: 64-bit Processors: 8 × Intel® Core™ i7-7700HQ CPU @ 2.80GHz Memory: 15,5 ГиБ
Should be fixed with https://invent.kde.org/pim/akonadi/-/commit/d6a1c057327332487adc9ad39252f9481ae28288
$ akonadictl --version akonadictl 5.23.0 (23.04.0) $ akonadictl start org.kde.pim.akonadictl: Starting Akonadi Server... org.kde.pim.akonadictl: done. Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: Starting up the Akonadi Server... org.kde.pim.akonadiserver: Running DB initializer tonal@hius2:~/lang/projects/promsoft/epool$ org.kde.pim.akonadiserver: DB initializer done Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: Unable to connect to dbus service: "An AppArmor policy prevents this sender from sending this message to this recipient; type=\"method_call\", sender=\":1.145\" (uid=1000 pid=413638 comm=\"/usr/bin/akonadiserver \" label=\"/usr/bin/akonadiserver (enforce)\") interface=\"org.freedesktop.DBus\" member=\"RequestName\" error name=\"(unset)\" requested_reply=\"0\" destination=\"org.freedesktop.DBus\" (bus)" org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally... Operating System: KDE neon 5.27 KDE Plasma Version: 5.27.4 KDE Frameworks Version: 5.105.0 Qt Version: 5.15.9 Kernel Version: 5.19.0-41-generic (64-bit) Graphics Platform: X11 Processors: 4 × Intel® Core™ i5-6200U CPU @ 2.30GHz Memory: 31.2 ГиБ of RAM Graphics Processor: NVIDIA GeForce 940MX/PCIe/SSE2 Manufacturer: Acer Product Name: TravelMate P259-MG System Version: V1.51
Ok the new issue is caused by appammor which block akonadi :( The debian/neon packaging should normally includes appamor rules to prevent that.
(In reply to Carl Schwan from comment #6) > Ok the new issue is caused by appammor which block akonadi :( > > The debian/neon packaging should normally includes appamor rules to prevent > that. the rules are in the apparmor/mysqld_akonadi file
(In reply to Christophe Marin from comment #7) > the rules are in the apparmor/mysqld_akonadi file I found 3 files: ``` /etc/apparmor.d$ ls *akonadi* mariadbd_akonadi mysqld_akonadi usr.bin.akonadiserver ```
A possibly relevant merge request was started @ https://invent.kde.org/pim/akonadi/-/merge_requests/137
Git commit 620ea58f76e00aed52c1acee9c8d11b6f3279953 by Christophe Marin. Committed on 28/04/2023 at 14:36. Pushed by krop into branch 'master'. Allow running mysql_upgrade when starting Akonadi Amends d6a1c057327332487adc9ad39252f9481ae28288 M +2 -1 apparmor/mariadbd_akonadi M +1 -0 apparmor/mysqld_akonadi M +2 -0 apparmor/usr.bin.akonadiserver https://invent.kde.org/pim/akonadi/commit/620ea58f76e00aed52c1acee9c8d11b6f3279953
Git commit 5d6bf9ab17c89bb42ba6dc579ea564d105c6efcb by Christophe Marin. Committed on 28/04/2023 at 15:22. Pushed by krop into branch 'release/23.04'. Allow running mysql_upgrade when starting Akonadi Amends d6a1c057327332487adc9ad39252f9481ae28288 (cherry picked from commit 620ea58f76e00aed52c1acee9c8d11b6f3279953) M +2 -1 apparmor/mariadbd_akonadi M +1 -0 apparmor/mysqld_akonadi M +2 -0 apparmor/usr.bin.akonadiserver https://invent.kde.org/pim/akonadi/commit/5d6bf9ab17c89bb42ba6dc579ea564d105c6efcb