Re: Akonadi won't start

On Tuesday, April 19, 2022 2:58:46 PM EDT Paul Brown wrote:
> 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@mikeworkstation:~$ akonadictl start
> > > > 
> > > > Connecting to deprecated signal
> > > > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > > > mdiehl@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@mikeworkstation:~/.local/share$ mv akonadi akonadi.orig
> > 
> > mdiehl@mikeworkstation:~/.local/share$ akonadictl start
> > 
> > Connecting to deprecated signal
> > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > mdiehl@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?

No, this file doesn't exist.  Shouldn't the mysql server create it, though?

Mike.