Dear all,

due to configuration troubles with kontact/kmail and/or akonadi I switched from postgres to default mariadb as database for akonadi.

According to [ the Arch wiki ], setting this up seems straight forward to me, so that it should work out of the box, right? Or do I also need other additional preparations?

Anyway, I now can't run akonadi at all, as it can't connect to any database:

Code: Select all

$ akonadictl start --verbose
$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db:  "/usr/bin/mysql_install_db"
org.kde.pim.akonadiserver: Found mysqlcheck:  "/usr/bin/mysqlcheck"
org.kde.pim.akonadiserver: Using mysqld: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: Failed to use database "akonadi_mito"
org.kde.pim.akonadiserver: Database error: "Access denied for user 'mito'@'localhost' (using password: NO) QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Trying to create database now...
org.kde.pim.akonadiserver: Failed to connect to database!
org.kde.pim.akonadiserver: Database error: "Access denied for user 'mito'@'localhost' (using password: NO) QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: stopping db process
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

On the other hand, [ the wiki section ] mentions folder "~/.local/share/akonadi/db_data/", which is empty in my case. – Hence I am confused: Does akonadi fail because this folder is empty? Or because of "Access denied"? Or, because of the "Access denied" that very folder simply doesn't get populated?

Further, though I don't know exactly if a [ system-wide MySQL instance ] is an advantage, anyway I created such a file "akonadiserverrc", including e.g. such a line "Name=akonadi_mito".

Well, sure I also consulted [ the MariaDB entry ]. But what's the clue then, how would this be of help for akonadi? – Yet I am quite new to database stuff, and it's quite confusing.

So ideas, anybody?
Thanks in advance

Hi!

You might want to try starting from zero, backup and delete everything akonadi related, e.g.:

Code: Select all

~/.cache/akonadi*
~/.config/akonadi*
~/.local/share/akonadi*


Then start akonadi and let it do its thing.