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 <kdepim-users@xxxxxxx>;

> > 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