| Summary: | Can't start MySQL when authenticated via domain server | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Ivo Smelhaus <ismelhaus> |
| Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED NOT A BUG | ||
| Severity: | grave | CC: | dvratil, ismelhaus |
| Priority: | NOR | ||
| Version: | 4.13 | ||
| Target Milestone: | --- | ||
| Platform: | Kubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | Akonadi bug report | ||
|
Description
Ivo Smelhaus
2014-05-29 10:28:38 UTC
Created attachment 86894 [details]
Akonadi bug report
Do I understand it correctly that /home/KSAT/ismelhaus is a remote mount via Samba, AFS or something like that? There is a known problem with MySQL not working with some remote FS (I only know it works with NFS), see for example bug 326188. You can try PostgreSQL, or SQLite, or if you want to stick with MySQL, you either have to use system instance of a centralized server. No, that's local directory (ext4), no remote mounting at all. The computer, resp. all the mentioned computers have both local users and domain users. All of them have local home (the domain usershaving their home in /home/domain/ subdirectory). The diference between them is only in authentication, i.e. local and winbind through krb5. Ok, thanks for clarification. This is almost definitely not an Akonadi bug, but either a MySQL bug, or problem in your configuration. The problem is, that MySQL server process cannot access the configuration file ("Could not open required defaults file: /home/KSAT/ismelhaus/.local/share/akonadi/mysql.conf"), so I recommend to check that the file (and everything in that folder) is accessible.
I'll close this bug as invalid, if you are sure that your configuration is correct, please open a ticket in MySQL tracker.
Yes, I can confirm, that it's not an Akonadi bug. You are right, the problem is with access, but not with the access rights, which are correct. The problem is with Apparmor
apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/home/KSAT/ismelhaus/.local/share/akonadi/mysql.conf" pid=12000 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=11107 ouid=11107
It looks like, the problem was with missing variant /home/KSAT/ for {HOMEDIRS} but not sure.
But I'm not a big friend with Apparmor.
Anyway, working according the official documentation leads to state, where Akonadi doesn't work. So, this is the category, which makes me all the time very sad, i.e. 99% is done, but from user point of view it's unusable. Can you plese help me, where to correct it? Should it be done automatically and by which process Aparmor or Winbind, where homedir for domain users is set or it should be done manually, so only the documentation for adding ubuntu to samba-domain should be corrected by adding an item "apparmor setting".
Thank you for your help and would be very happy to be helpfull with moving akonadi and Kontact from "error-free from developer point of view" state to "usable for users" state.
I'm sorry, but I have no idea how AppArmor works, so I can't help. I recommend trying distribution forum/ML, or AppArmor forum. You will more likely find a working solution to your problem. |