[Akonadi] [Bug 421922] New: kde-apps/akonadi-{19.08.3,19.12.2} with dev-db/mysql-8.0.19{-r1} - error: 'Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (2)'

[Stephan Karacson]

https://bugs.kde.org/show_bug.cgi?id=421922

            Bug ID: 421922
           Summary: kde-apps/akonadi-{19.08.3,19.12.2} with
                    dev-db/mysql-8.0.19{-r1} - error: 'Can't connect to
                    local MySQL server through socket
                    '/run/user/1000/akonadi/mysql.socket' (2)'
           Product: Akonadi
           Version: unspecified
          Platform: Gentoo Packages
                OS: Linux
            Status: REPORTED
          Severity: major
          Priority: NOR
         Component: general
          Assignee: kdepim-bugs at kde.org
          Reporter: stkaopen at gmx.at
  Target Milestone: ---

As suggested on Gentoo I report this bug here as it hit us and is noticed as an
serious problem.
Gentoo bug: https://bugs.gentoo.org/709812

Hit me first on akonadi-19.08.3 (whole kdepim doesnt work since update)

I tried to rebuild database (delete ~/.local/share/akonadi/ ~/.config/akonadi/
~/.config/akonadi*) 

Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial
connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld"
org.kde.pim.akonadiserver: arguments:
("--defaults-file=/home/USER/.local/share/akonadi/mysql.conf",
"--datadir=/home/USER/.local/share/akonadi/db_data/",
"--socket=/run/user/1000/akonadi/mysql.socket",
"--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/run/user/1000/akonadi/mysql.socket' (2)'
Check that mysqld is running and that the socket:
'/run/user/1000/akonadi/mysql.socket' exists!
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...

reemerge akonadi* and qtsql with new mysql doesn't work

downgrade to mysql 5.7 works with resetting (delete folders and setting up
whole kdepim) again.


STEPS TO REPRODUCE
1. Upgrade to mysql 8
2. start any kdepim-program
3. See that no KDE-applikation can access akonadi

Thomas Deutschmann said I should "make sure that this server configuration is
compatible with MySQL v8".
As I use the auto-configuration of akonady with an user-mysql-instance I coul'd
only tweak it after wrong auto-config by akonadi, somehow...
He and Manfred Knick also suggested that the lower_case_table_names must be
initialized or converted correctly.

As you see, I am no expert in mysql. But it seems akonadi fails on confing
mysql  version 8 and breaks my whole, single productive kdepim-installation.
(and sorry, I had a hell of work in the last two month so this report is a
little late.)

-- 
You are receiving this mail because:
You are the assignee for the bug.