Dear KDE Experts,
I'm using KDE on Fedora 38 fully updated. I normally use KPIM services
(korganizer and kcontact) with MySQL (no MariaDB). Everything was working well
up to the last update of Plasma and KDEPim.
Since then I'm unable to have akonadi started.
Initially it was refusing to connect to the db:
> 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: Failed to connect to database!
org.kde.pim.akonadiserver: Database error: "Can't connect to local server through socket '/run/user/526/akonadi/mysql.socket' (2) QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
It seems this is a well know bug:
https://gist.github.com/aldolat/e8066baf8a390e5d5f5ed6e0849ec78c
following their advice I have modified my ~/.config/akonadi/akonadiserverrc in:
[Debug]
Tracer=null
[%General]
Driver=QMYSQL
[QMYSQL]
Host=localhost
Name=akonadi
Options="UNIX_SOCKET=/var/run/mysqld/mysqlx.sock"
ServerPath=/usr/sbin/mysqld
StartServer=false
Now akonadi connects to the local server but it fails to use the database "akonadi"
> 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: Failed to use database "akonadi"
org.kde.pim.akonadiserver: Database error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Failed to connect to database!
org.kde.pim.akonadiserver: Database error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
But MySQL is running and looking at it:
> mysql -u root -p
mysql> SELECT version();
+-----------+
| version() |
+-----------+
| 8.0.36 |
+-----------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| akonadi |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)
The "akonadi" database exists
mysql> SHOW GRANTS FOR 'cazzola'@'localhost' ;
+--------------------------------------------------------------+
| Grants for cazzola@localhost |
+--------------------------------------------------------------+
| GRANT USAGE ON *.* TO `cazzola`@`localhost` |
| GRANT ALL PRIVILEGES ON `akonadi`.* TO `cazzola`@`localhost` |
+--------------------------------------------------------------+
2 rows in set (0.00 sec)
My user has all privileges to access it.
mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS
-> FROM INFORMATION_SCHEMA.PLUGINS
-> WHERE PLUGIN_NAME LIKE '%socket%';
+-------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+-------------+---------------+
| auth_socket | ACTIVE |
+-------------+---------------+
1 row in set (0.00 sec)
Also the authentication plugin is installed and active.
I tried to google the last error I get without luck.
To complete the picture I've the following packages installed:
akonadi.x86_64 1.13.0-122.fc38
akonadi-import-wizard.x86_64 23.08.3-1.fc38
kf5-akonadi-calendar.x86_64 23.08.3-1.fc38
kf5-akonadi-contacts.x86_64 23.08.3-1.fc38
kf5-akonadi-mime.x86_64 23.08.3-1.fc38
kf5-akonadi-notes.x86_64 23.08.3-1.fc38
kf5-akonadi-search.x86_64 23.08.3-1.fc38
kf5-akonadi-server.x86_64 23.08.3-1.fc38
kf5-akonadi-server-mysql.x86_64 23.08.3-1.fc38
kf5-mailimporter-akonadi.x86_64 23.08.3-1.fc38
kf5-pimcommon-akonadi.x86_64 23.08.3-1.fc38
kf5-akonadi-server-mysql.x86_64 23.08.3-1.fc38
mysql-community-client.x86_64 8.0.36-10.fc38
mysql-community-client-plugins.x86_64 8.0.36-10.fc38
mysql-community-common.x86_64 8.0.36-10.fc38
mysql-community-icu-data-files.x86_64 8.0.36-10.fc38
mysql-community-libs.x86_64 8.0.36-10.fc38
mysql-community-server.x86_64 8.0.36-10.fc38
mysql-connector-odbc.x86_64 8.3.0-10.fc38
mysql-selinux.noarch 1.0.10-1.fc38
mysql-shell.x86_64 8.0.36-1.fc38
mysql80-community-release.noarch fc38-4
qt5-qtbase-mysql.x86_64 5.15.11-7.fc38
My Linux Box runs:
- Fedora 38,
- plasmashell 5.27.10,
- Qt: 5.15.11
- KDE Frameworks: 5.113.0
- kf5-config: 1.0
Sorry for the long message but I tried to show whatever I discovered in these last weeks.
Any help is really appreciated.
Best
Walter
--
--
_______________________________________________
kde mailing list -- kde@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to kde-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/kde@xxxxxxxxxxxxxxxxxxxxxxx
Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
