Akonadi won't start for Domain Users

Wed Apr 17 14:54:33 BST 2019

Hi Don,

more replies inline.

On Thursday, 11 April 2019 01:10:10 CEST Don Robertson wrote:
> Hi - first, the directory '/var/lib/mysql-files' exists, owned by
> root.root and has 755 permissions.

The MySQL database that Akonadi uses stores everything in $HOME/.local/share/
akonadi/db_data, it does not use the system-wide instance.

> 
> So it is not that.
> 
> Now - I am not sure if this is a bug or if I have done something wrong,
> but have been messing with the problem for a while now. I have a hunch -
> which may be way off, but ....
> 
> I'm running a CentOS based server, Nethserver, and have set up domain
> logins. I log into my Kubuntu desktop machines using a domain logon and
> get the user name 'user at domain.name@machine-name'.
> 
> Launching Kontact or Kmail fails to launch Akonadi. When I try to launch
> Akonadi, I get:
> 
> username at domain.name@machine-name:~$ mysqld: [ERROR] Could not open
> required defaults file: /var/lib/nethserver/home/username/
> mysqld: [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=/var/lib/nethserver/home/username/.local/share/akonadi/mys
> ql.conf",
> "--datadir=/var/lib/nethserver/home/username/.local/share/akonadi/db_data/"

Is this the standard home path on your system? /var/lib/nethserver/home/
username/?

> , "--socket=/tmp/akonadi-username at domain.name.KhWSEz/mysql.socket",
> "--pid-file=/tmp/akonadi-username at domain.name.KhWSEz/mysql.pid")
> org.kde.pim.akonadiserver: stdout: ""
> org.kde.pim.akonadiserver: stderr: "mysqld: [ERROR] Could not open
> required defaults file:
> /var/lib/nethserver/home/username/.local/share/akonadi/mysql.conf\nmysqld:
> [ERROR] Fatal error in defaults handling. Program aborted!\n"
> org.kde.pim.akonadiserver: exit code: 1
> org.kde.pim.akonadiserver: process error: "Unknown error"
> org.kde.pim.akonadiserver: Failed to remove runtime connection config file
> org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
> 
> Permissions on /var/lib/username/ seem to be okay - it is the users home
> directory, and the users have no other (software related) problems. The
> user can also read the ~/.local/share/akonadi/mysql.conf file and access
> the ~./local/share/akonadi/db_data/ directory.
> 
> Listing the ~/.local/share/akonadi/ directory gives:
> 
> $ ll ~/.local/share/akonadi/
> total 28
> drwxr-xr-x  2 username at domain.name domain users at domain.name 4096 Apr 11
> 10:36 ./
> drwxr-xr-x 34 username at domain.name domain users at domain.name 4096 Apr 11
> 09:53 ../
> -rw-r--r--  1 username at domain.name domain users at domain.name  150 Apr 11
> 10:36 akonadi_control.error
> -rw-r--r--  1 username at domain.name domain users at domain.name  150 Apr 11
> 10:36 akonadi_control.error.old
> -rw-r--r--  1 username at domain.name domain users at domain.name    0 Apr 11
> 10:36 akonadictl.error
> -rw-r--r--  1 username at domain.name domain users at domain.name    0 Apr 11
> 10:36 akonadictl.error.old
> -rw-r--r--  1 username at domain.name domain users at domain.name  734 Apr 11
> 10:36 akonadiserver.error
> -rw-r--r--  1 username at domain.name domain users at domain.name  734 Apr 11
> 10:36 akonadiserver.error.old
> -rw-r--r--  1 username at domain.name domain users at domain.name 3660 Apr  3
> 09:30 mysql.conf
> lrwxrwxrwx  1 username at domain.name domain users at domain.name   40 Apr 11
> 10:02 socket-Aspire-S3-391 -> '/tmp/akonadi-username at domain.name.KhWSEz'/
> 
> If I have a look in /tmp, I see:
> 
> $ ll /tmp/
> total 88
> drwxrwxrwt 16 root                 root 4096 Apr 11 10:53  ./
> drwxr-xr-x 24 root                 root 4096 Apr  3 12:22  ../
> drwx------  2 username at domain.name domain users at domain.name  4096 Apr 11
> 10:02 'akonadi-username at domain.name.KhWSEz'/
> 
> For local users, Akonadi/ Kontact works, and listing
> ~.local/share/akonadi/ gives
> 
> $ ll ~/.local/share/akonadi/
> total 28
> drwxrwxr-x  4 username usergroup 4096 Apr  3 09:29 ./
> drwxr-xr-x 21 username usergroup 4096 Apr  3 09:29 ../
> -rw-rw-r--  1 username usergroup  827 Apr  3 09:30 akonadi_control.error
> -rw-rw-r--  1 username usergroup    0 Apr  3 09:29 akonadictl.error
> -rw-rw-r--  1 username usergroup    0 Apr  3 09:29 akonadictl.error.old
> -rw-rw-r--  1 username usergroup  230 Apr  3 09:29 akonadiserver.error
> drwxr-x---  6 username usergroup 4096 Apr  3 09:30 db_data/
> -rw-rw-r--  1 username usergroup 3660 Apr  3 09:28 mysql.conf
> drwxrwxr-x  8 username usergroup 4096 Apr  3 09:29 search_db/
> lrwxrwxrwx  1 username usergroup   23 Apr  3 09:28 socket-Aspire-S3-391
> -> /tmp/akonadi-username.RoDq2s
> 
> So I am thinking it is something to do with the @ in the domain user
> name, which is resulting in the inverted commas around the
> /tmp/'akonadi-username at domain.name.xxxxxx' directory?

Yes, I do suspect that the un-escaped "@" in the file path might be confusing 
MySQL. Could you open a bug report against Akonadi on bugs.kde.org, please?

> Anyway - I'm using the nextcloud mail client and Thunderbird for my mail
> now, but would like to go with the Kontact PIM if possible. Any help
> would be appreciated.

I don't know if this can be fixed on your side at this moment, sorry.

- Dan

> 
> Cheers
> 
> Don

-- 
Daniel Vrátil
www.dvratil.cz | dvratil at kde.org
IRC: dvratil on Freenode (#kde, #kontact, #akonadi, #fedora-kde)

GPG Key: 0x4D69557AECB13683
Fingerprint: 0ABD FA55 A4E6 BEA9 9A83 EA97 4D69 557A ECB1 3683
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20190417/57ee9b4d/attachment.sig>