Q4OS Forum

samtfalterblau

Member

Registered: 2022-11-30

Posts: 10

[Closed] Connection fail to MYSQL-database of Akonadi

I recently installed Q4OS 4.10 Gemini Plasma on my Laptop. All works well - better than Debian 11, siduction and KDEneon, which I tried too. There is only one exception: KDEPIM with Akonadi!

I installed it from the repositories:

sudo apt install kdepim mariadb-common mariadb-server akonadi-server akonadi-backend-mysql kdepim-runtime default-mysql-server

Did I miss some packages?

After starting Kontact the akonadi_migration_agent was working ("In process ...") during Akonadi tried to start a local MYSQL-Server. But unfortunately without success. The error message from the Akonadi Console appeared: "Failed to connect to database: Access denied for user 'samtfalterblau'@'localhost' QMYSQL: No connection can be established."

What can I do to still start a local MYSQL-Server like Akonadi tried to?

Suggestions are welcome! Thanks in advance, Robert

Last edited by samtfalterblau (2022-11-30 10:59)

samtfalterblau

Member

Registered: 2022-11-30

Posts: 10

Re: [Closed] Connection fail to MYSQL-database of Akonadi

I'd like to mention that this is a Q4OS-issue ONLY! In Debian 11 "Bullseye" it is working, in Siduction as well. Therefore I'd like to get a guess of the Q4OS makers, what could be the reason for my problem with kdepim, I described above.

Last edited by samtfalterblau (2023-01-24 09:56)

q4osteam

Q4OS Team

Registered: 2015-12-06

Posts: 5,062

Website

Re: [Closed] Connection fail to MYSQL-database of Akonadi

We are investigating the issue reported. We will post back as soon as we make a progress.

q4osteam

Q4OS Team

Registered: 2015-12-06

Posts: 5,062

Website

Re: [Closed] Connection fail to MYSQL-database of Akonadi

We can definitely confirm this bug. The culprit is the Akonadi server, what doesn't follow XDG standard variable $XDG_CONFIG_HOME properly. This bug is reproducible on a plain Debian installation with $XDG_CONFIG_HOME variable set to anything other then "$HOME/.config".

The quick workaround for Q4OS is to run Kontact and thus Akonadi server this way:
$ XDG_CONFIG_HOME="" kontact

As working on a fix, we post more info here.

samtfalterblau

Member

Registered: 2022-11-30

Posts: 10

Re: [Closed] Connection fail to MYSQL-database of Akonadi

Thank you very much for the investigation! I will try it.

q4osteam

Q4OS Team

Registered: 2015-12-06

Posts: 5,062

Website

Re: [Closed] Connection fail to MYSQL-database of Akonadi

The issue is now fixed. Now you can download a new installation iso "q4os-4.11-x64.r2.iso" from our downloads page to install a fresh and fixed OS.

It's also possible to fix the current system, so follow the instructions:
Backup your data
Run in terminal:
$ sudo apt update
$ sudo apt dist-upgrade
Edit file "/etc/q4os/q4base.conf" and modify lines:
tdehome_plasma=.configkde/trinity
xdgcfghome_plasma=.configkde
to:
tdehome_plasma=.trinitykde
xdgcfghome_plasma=.config
Run in terminal:
$ rsync -a $HOME/.configkde/. $HOME/.config/
$ rsync -a $HOME/.configkde/trinity/. $HOME/.trinitykde/
Reboot and login again. You system should now be fixed.