[Tumbleweed] Akonadi can't connect to its MySQL database
After the latest update yesterday evening, aside from Konsole forgetting where the tab bar was located Akonadi won't start anymore. Manual checking leads up to this: --8<---------------cut here---------------start------------->8--- ~> Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: Starting up the Akonadi Server... org.kde.pim.akonadiserver: mysqld for Akonadi is already running, trying to connect to it. /usr/bin/mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'akonadi' when selecting the database This installation of MariaDB is already upgraded to 10.11.2-MariaDB. There is no need to run mysql_upgrade again for 10.11.2-MariaDB. You can use --force if you still want to run mysql_upgrade org.kde.pim.akonadiserver: Failed to create database org.kde.pim.akonadiserver: Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: Database error: "" org.kde.pim.akonadiserver: Shutting down AkonadiServer... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally... ~> mysql --defaults-file=/home/gratz/.local/share/akonadi/mysql.conf --socket=/run/user/1000/akonadi/mysql.socket --user=gratz Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 46 Server version: 10.11.2-MariaDB MariaDB package Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> status -------------- mysql Ver 15.1 Distrib 10.11.2-MariaDB, for Linux (x86_64) using EditLine wrapper Connection id: 46 Current database: Current user: gratz@localhost SSL: Not in use Current pager: less Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.11.2-MariaDB MariaDB package Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb3 Db characterset: utf8mb3 Client characterset: utf8mb3 Conn. characterset: utf8mb3 UNIX socket: /run/user/1000/akonadi/mysql.socket Uptime: 35 min 37 sec Threads: 2 Questions: 821 Slow queries: 0 Opens: 294 Open tables: 0 Queries per second avg: 0.384 -------------- MariaDB [(none)]> use akonadi; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'akonadi' --8<---------------cut here---------------end--------------->8--- Does anyone have an idea why suddenly the user name doesn't seem to get through to the DB instance anymore, which I think is why it doesn't work? Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+
Achim Gratz writes:
After the latest update yesterday evening, aside from Konsole forgetting where the tab bar was located Akonadi won't start anymore. […]
I've verified there were no missing parts in the installation and then did a reboot, after that it works again. KMail had forgotten which folders were open, so it seems that configuration migration might have interfered with the first startup, but I'd still like to know how this strange mismatch of the DB user happened. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ Wavetables for the Terratec KOMPLEXER: http://Synth.Stromeko.net/Downloads.html#KomplexerWaves
* Achim Gratz <Stromeko@nexgo.de> [04-29-23 03:21]:
Achim Gratz writes:
After the latest update yesterday evening, aside from Konsole forgetting where the tab bar was located Akonadi won't start anymore. […]
I've verified there were no missing parts in the installation and then did a reboot, after that it works again. KMail had forgotten which folders were open, so it seems that configuration migration might have interfered with the first startup, but I'd still like to know how this strange mismatch of the DB user happened.
encountered same problem, restarted mysql alleviated, which you achieved by rebooting. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet oftc
participants (2)
-
Achim Gratz
-
Patrick Shanahan