Re: Akonadi won't start

On Thursday, April 21, 2022 6:07:24 AM EDT Paul Brown wrote:
> On Tuesday, 19 April 2022 22:44:12 CEST René J.V. Bertin wrote:
> > On Tuesday April 19 2022 14:50:28 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:
> > Hi,
> > 
> > You may get more insider information if you ask on <[email protected]>;
> > the KDE PIM devs are there too.
> > 
> > R.
> 
> I have to agree with René. I am just a user, probably like yourself.
> 
> That said, it seems like your local mysql server is not starting. Check if
> it is around with
> 
> ps aux| grep mysql
> 
> And. if it is not you could try running it by hand from the command line. If
> that fails, you will at least see the error and be closer to figuring it
> out.
> 
> Paul

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:

=====================================================================
mdiehl@mikeworkstation:~/.local/share/akonadi$ ls -la 
total 32
drwxrwxr-x  6 mdiehl mdiehl 4096 Apr 21 16:04 .
drwxrwxr-x 46 mdiehl mdiehl 4096 Apr 21 15:16 ..
-rw-rw-r--  1 mdiehl mdiehl 1363 Apr 21 15:22 Akonadi.error
drwxrwxr-x  2 mdiehl mdiehl 4096 Apr 21 11:39 db_data
drwxrwxr-x  2 mdiehl mdiehl 4096 Apr 19 14:42 db_data.orig
drwxrwxr-x  2 mdiehl mdiehl 4096 Apr 19 14:42 db_misc
drwxrwxr-x  2 mdiehl mdiehl 4096 Apr 19 14:42 file_db_data
-rw-rw-r--  1 mdiehl mdiehl 3660 Apr 19 14:42 mysql.conf
lrwxrwxrwx  1 mdiehl mdiehl   22 Apr 19 14:42 socket-mikeworkstation-default -
> /run/user/1000/akonadi
=====================================================================


So, what could I be missing?

Thanks in advance.

Mike