On Mon, Mar 4, 2024 at 5:03 AM Walter Cazzola <cazzola@xxxxxxxxxxx> 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! -- _______________________________________________ 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
