Akonadi won't start

[Paul Brown]

On Tuesday, 19 April 2022 20:50:28 CEST Mike Diehl wrote:
> On Tuesday, April 19, 2022 2:37:43 PM EDT Paul Brown wrote:
> > On Tuesday, 19 April 2022 18:25:58 CEST Mike Diehl wrote:
> > > Hi all,
> > > 
> > > I've been using kde on this machine for several months, now.  But
> > > suddenly,
> > > akonadi won't start:
> > > 
> > > 
> > > =====================================================================
> > > mdiehl at mikeworkstation:~$ akonadictl start
> > > 
> > > Connecting to deprecated signal
> > > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > > mdiehl at mikeworkstation:~$ 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-akonadi"
> > > org.kde.pim.akonadiserver: arguments:
> > > ("--defaults-file=/home/mdiehl/.local/share/akonadi/mysql.conf",
> > > "--datadir=/home/mdiehl/.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: "mysqld-akonadi: [ERROR] Failed to
> > > open
> > > required defaults file:
> > > /home/mdiehl/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR]
> > > Fatal
> > > error in defaults handling. Program aborted!\n"
> > > 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...
> > > =====================================================================
> > > 
> > > Any ideas would be most appreciated.
> > > 
> > > Mike.
> > 
> > Hey Mike,
> > 
> > Try moving your akonadi directory out of the way:
> > 
> > mv .local/share/akonadi/ .local/share/akonadi_old
> > 
> > And then try starting akonadi again.
> > 
> > Akonadi will rebuild the databases and you won't loose any emails or
> > calendars, although you may have to tweak stuff in you email profiles and
> > folders, as, when rebuilding, you may discover that Kmail is now saving
> > sent message in... oh... the drafts folder or the trashbin... it can be
> > anywhere.
> > 
> > Another thing that may be affected are your local email filters, and, if
> > you have more than one identity, the identity associated with each
> > folder.
> > 
> > ... Yeah, my setup is a bit clunky.
> > 
> > Cheers
> > 
> > Paul
> 
> Hi Paul,
> 
> Thanks for getting back to me so quickly.
> 
> Well, I tried what you suggested:
> 
> ====================================================
> mdiehl at mikeworkstation:~/.local/share$ mv akonadi akonadi.orig
> 
> mdiehl at mikeworkstation:~/.local/share$ akonadictl start
> 
> Connecting to deprecated signal
> QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> mdiehl at mikeworkstation:~/.local/share$ org.kde.pim.akonadiserver: Starting
> up the Akonadi Server... mysqld-akonadi: [ERROR] Failed to open required
> defaults file: /home/mdiehl/.local/share/ mysqld-akonadi: [ERROR] Fatal
> error in defaults handling. Program aborted! 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-akonadi"
> org.kde.pim.akonadiserver: arguments:
> ("--defaults-file=/home/mdiehl/.local/share/akonadi/mysql.conf",
> "--datadir=/home/mdiehl/.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: "mysqld-akonadi: [ERROR] Failed to open
> required defaults file:
> /home/mdiehl/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR] Fatal
> error in defaults handling. Program aborted!\n" 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...
> 
> ====================================================
> 
> 
> It would seem that more drastic measures are required....
> 
> Mike.

Hm... Annoying. Have you checked that 

/run/user/1000/akonadi/mysql.socket

exists?
-- 
Promotion & Communication

www: http://kde.org
Mastodon: https://mastodon.technology/@kde
Facebook: https://www.facebook.com/kde/
Twitter: https://twitter.com/kdecommunity
LinkedIn: https://www.linkedin.com/company/kde