problems with akonadi and mysql
by Walter Cazzola
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
--
1 month, 3 weeks
F38 kwin-x11 Desktop effects were restarted...
by John Pilkington
Hi: On 9 Feb my f38 system was updated from kwin 5.27.4 to 5.27.10 and
I started seeing popups and minor hesitations linked to graphics resets.
I haven't found a reliable way to reproduce them. Today I downgraded
kwin-x11 etc back to 5.27.4, and opening Firefox still gave the popup.
nVidia 470xx from rpmfusion, MythTV master.
Google finds lots of years-old hits, including kde bug 385324, and a
suggestion to retoggle kwin with Alt/Shift/f12, but this behaviour was
new to me. Any comments or suggestions?
TIA
John P
1 month, 3 weeks
How to specify desktop location from the command line?
by José Abílio Matos
Hi,
I am writing this from Plasma 6.0 RC2. :-)
The only issue that I saw until the moment is that some kde applications
appear with small sizes. Resize works so it is just a mater of adjusting it.
My question is related with the issue of session handling but from a different
angle.
Is it possible to specify, e.g from the command line, in which screen/desktop
to launch an application?
Sometimes I like to define some kind of activities, where I launch a set of
applications that I define from a program. Yes, I can do it by hand but that
is boring. :-)
Regarding the distinction from X11 to Wayland I never saw how to do it in any
of it.
Regards,
--
José Abílio Matos
2 months
dnf update issue
by Sbob
Hi everyone.
I am runing Fedore 39 - KDE spin on a Dell XPS17
Today when I run dnf update I get this:
Dependencies resolved.
Problem 1: package qt5-qtwebengine-freeworld-5.15.12-6.fc39.x86_64 from
@System requires qt5-qtbase(x86-64) = 5.15.11, but none of the providers
can be installed
- cannot install both qt5-qtbase-5.15.12-1.fc39.x86_64 from updates
and qt5-qtbase-5.15.11-7.fc39.x86_64 from @System
- cannot install the best update candidate for package
qt5-qtwebengine-freeworld-5.15.12-6.fc39.x86_64
- cannot install the best update candidate for package
qt5-qtbase-5.15.11-7.fc39.x86_64
Problem 2: problem with installed package
qt5-qtwebengine-freeworld-5.15.12-6.fc39.x86_64
- package qt5-qtwebengine-freeworld-5.15.12-6.fc39.x86_64 from @System
requires qt5-qtbase(x86-64) = 5.15.11, but none of the providers can be
installed
- package qt5-qtwebengine-freeworld-5.15.12-6.fc39.x86_64 from
rpmfusion-free-updates requires qt5-qtbase(x86-64) = 5.15.11, but none
of the providers can be installed
- cannot install both qt5-qtbase-5.15.12-1.fc39.x86_64 from updates
and qt5-qtbase-5.15.11-7.fc39.x86_64 from @System
- package kf5-akonadi-server-23.08.4-2.fc39.x86_64 from updates
requires qt5-qtbase(x86-64) = 5.15.12, but none of the providers can be
installed
- cannot install the best update candidate for package
kf5-akonadi-server-23.08.4-1.fc39.x86_64
Is this something I should be concerned with?
2 months, 3 weeks