On Mon, Mar 4, 2024 at 5:03 AM Walter Cazzola <cazzola(a)di.unimi.it> wrote:
Hi Again,
anyone can help on this?
Walter
On Tue, 20 Feb 2024, Walter Cazzola wrote:
> 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.
>
Akonadi should not care about whether or not you are using MySQL as an
actual SQL server in Fedora. We don't have that packaging issue that
Debian family distributions have. I am not sure what's going on here,
as I left it with the default usage of MariaDB, which makes it a
little hard to reproduce...
--
真実はいつも一つ!/ Always, there's only one truth!