akonadi won't start

[Mike Diehl]

So, I tried to run the mysql server manually with this command:

=====================================================================
/usr/sbin/mysqld-akonadi --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
=====================================================================


That resulted in this error message:

=====================================================================
mysqld-akonadi: [ERROR] Failed to open required defaults file: /home/
mdiehl/.local/share/akonadi/mysql.conf

mysqld-akonadi: [ERROR] Fatal error in defaults handling. Program aborted!
=====================================================================

And when I run the command under strace, I can confirm that it is opening the 
correct file and getting permission denied:

 

=====================================================================

stat("/home/mdiehl/.local/share/akonadi/mysql.conf", {st_mode=S_IFREG|0664, 
st_size=3660, ...}) = 0

openat(AT_FDCWD, "/home/mdiehl/.local/share/akonadi/mysql.conf", O_RDONLY) = 
-1 EACCES (Permission denied)

=====================================================================


However, I own the entire filesystem hierchy down to the mysql.conf file and the 
permissions allow me to read/write as appropriate.

So, what could I be missing?

Thanks in advance.

Mike

 

On Thursday, July 14, 2022 3:31:00 AM EDT Robert Voinea wrote:
> Hello
> 
> I have encountered the same situation some time ago.
> I'm on Archlinux and it happened after an update of mariadb.
> 
> If you try to start mysqld by hand, you'll see that it is trying to open a
> file that is not there.
> Creating that file allowed mysqld to start.
> I can't remember the name of that file though... and it had nothing to do
> with mysqld.conf
> 
> On Thursday, 14 July 2022 01:53:08 EEST Mike Diehl wrote:
> > Hi all.
> > 
> > I posted this to the user's group some time ago.  It was suggested that I
> > post to the dev group.  So, here I go.
> > 
> > I'm having trouble getting akonadi to start.  When I try to start it, I
> > get
> > this error message:
> > 
> > $ akonadictl start
> > Connecting to deprecated signal
> > QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
> > mdiehl at mikeworkstation:~$ org.kde.pim.akonadiserver: Starting up the
> > Akonadi Server... mysqld-akonadi: [ERROR] Failed to open required defaults
> > file: /home/mdiehl/ 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/mysq l.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
> > mysqld-akonadi: [ERROR] Fatal error in defaults handling. Program
> > aborted!"
> > 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...
> > 
> > 
> > I can confirm that /home/mdiehl/.local/share/akonadi/mysql.conf does exist
> > and has readable permissions.
> > 
> > Any suggestions would be most appreciated.
> > 
> > Mike

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kde-devel/attachments/20220718/2f4a0282/attachment.htm>