problems with akonadi and mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KDE Users]     [Fedora General Discussion]     [Older Fedora Users Mail]     [Fedora Advisory Board]     [Fedora Security]     [Fedora Maintainers]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [ATA RAID]     [Fedora Marketing]     [Fedora Mentors]     [Fedora Package Announce]     [Fedora Package Review]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Triage]     [Coolkey]     [Yum Users]     [Yosemite Forum]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]

  Powered by Linux