[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Carl Schwan changed: What|Removed |Added CC||c...@carlschwan.eu Resolution|--- |DOWNSTREAM Status|REOPENED|RESOLVED -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #34 from Ahmad Samir --- @Aldo: this looks like a downstream packaging issue, I suggest you file a bug report in your distro's bug tracker. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #33 from Aldo Latino --- After many tests (either on my work computer and in some VirtualBox machines) I discovered that this problem happens to me when I install the package mysql-server which removes some Akonadi related packages[1]. In other words, if I don't install mysql-server, Akonadi works fine. After the installation of mysql-server, Akonadi stops working. In this situation, since I need a LAMP server on my machine, I have to perform some actions in order to make Akonadi work with mysql-server. [1] MySQL is correctly installed but these are some of the lines printed during the installation process: Preconfiguring packages ... dpkg: mariadb-client-core-10.3: dependency problems, but removing anyway as you requested: akonadi-backend-mysql depends on mariadb-client-core-10.3 | virtual-mysql-client-core; however: Package mariadb-client-core-10.3 is to be removed. Package virtual-mysql-client-core is not installed. Package mariadb-client-core-10.3 which provides virtual-mysql-client-core is to be removed. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #32 from Erasmo Caponio --- This bug seems solved in kde neon based on Ubuntu 20.04 (at least on my upgraded system). Removing and reinstalling apparmor and snapd may help (Anyway I still have snapd removed) -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Ahmad Samir changed: What|Removed |Added CC||a.samir...@gmail.com --- Comment #31 from Ahmad Samir --- So basically this means, misconfigured AppArmor rules prevent mysqld-akonadi from reading ~/.local/share/akonadi/mysql.conf, which causes this bug? if so, then it's a downstream issue in Kubuntu, and has to be fixed there, IIUC. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Sebastian Kuhne changed: What|Removed |Added See Also||https://bugs.kde.org/show_b ||ug.cgi?id=423684 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Andy Goossens changed: What|Removed |Added CC||andygooss...@telenet.be --- Comment #30 from Andy Goossens --- Someone already created an issue for this on Launchpad: https://bugs.launchpad.net/ubuntu/+source/akonadi/+bug/1873087 Following the instructions in the ticket description has fixed the issue for me. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Poborskiii changed: What|Removed |Added CC||poborsk...@centrum.cz --- Comment #29 from Poborskiii --- Better is disabling only akonadiserver instead of whole mysql: sudo ln -s /etc/apparmor.d/usr.bin.akonadiserver /etc/apparmor.d/disable/ But in my case this file was missing. I had to copy from https://cgit.kde.org/akonadi.git/tree/apparmor/usr.bin.akonadiserver Also if have KDEAPPS older than 19.12.2 you should update /etc/apparmor.d/mysqld_akonadi to latest from https://cgit.kde.org/akonadi.git/tree/apparmor/mysqld_akonadi (because patch) This (for me working) solution became from https://bugs.kde.org/show_bug.cgi?id=416016 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Steffen Michalek changed: What|Removed |Added CC||stef...@michalek.de --- Comment #28 from Steffen Michalek --- 1) updated Kubuntu 19-10 -> 20.04 yesterday, problems with kmail & kontact: akonadi not running 2) > akonadictl start - didn't work, error "Could not open required defaults file: /home/NNN/.local/share/akonadi/mysql.conf"[...] 3) started apparmor notification: > started aa-notify -p saw problem with mysql 4) searched more, found: https://askubuntu.com/questions/1144497/how-to-disable-apparmor-for-mysql , followed instructions: 5) > sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/ > sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld 6) > akonadictl start- works! :-) (in kontact, the calendars were no longer chosen, I had to reactivate the checkboxes, kmail works) If I understand correctly, apparmor is now not longer protecting mysql. I have to re-activate, once another solution is found: same askubuntu... -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #27 from Sandro Knauß --- @GK: please report this issue at kubuntu directly as this is properly a packaging issue. Otherwise this may be a unrelated issue. Also for the people having this issue with Neon please report directly on Neon, I am quite sure, that the neon people are NOT aware of this issue. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #26 from GK --- Hi, Yes I tried to disable, but does not change anything. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093
Alexander Zhigalin changed:
What|Removed |Added
Platform|Neon Packages |Ubuntu Packages
Product|neon|Akonadi
Assignee|neon-b...@kde.org |kdepim-b...@kde.org
Component|general |server
--- Comment #25 from Alexander Zhigalin ---
(In reply to GK from comment #24)
> Same here since an update in Kubuntu 18.04. I moved to 19.10 and then a few
> days ago to 20.04, but got the same errors while launching akonadictl from
> terminal:
>
> QUOTE
> rg.kde.pim.akonadiserver: Starting up the Akonadi Server...
> mysqld-akonadi: [ERROR] Failed to open required defaults file:
> /home/gkourtev/
> 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/gkourtev/.local/share/akonadi/mysql.conf",
> "--datadir=/home/gkourtev/.local/share/akonadi/db_data/",
> "--socket=/run/user/1000/akonadi/mysql.socket",
> "--pid-file=/run/user/1000/akonadi/mysql.pid")
> org.kde.pim.akonadiserver: stdout: ""
> org.kde.pim.akonadiserver: stderr: "mysqld-akonadi: [ERROR] Failed to open
> required defaults file:
> /home/gkourtev/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR]
> Fatal error in defaults handling. Program aborted!\n"
> 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...
> UNQUOTE
>
> Operating System: Kubuntu 20.04
> KDE Plasma Version: 5.18.4
> KDE Frameworks Version: 5.68.0
> Qt Version: 5.12.8
> Kernel Version: 5.4.0-28-generic
> OS Type: 64-bit
> Processors: 4 × Intel® Core™ i7-6500U CPU @ 2.50GHz
> Memory: 15,5 GiB of RAM
Can you try to disable AppArmor and start it?
It helped for me when I had this bug.
Seems to be something wrong with the AA policy which causes mysqld-akonadi to
be unable to read it's configuration.
Anyway, I'm changing this bug product because it's not really Neon-specific.
--
You are receiving this mail because:
You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #10 from Dan --- This thread https://forum.kde.org/viewtopic.php?f=215=162239=akonadi+won%27t+start points out that it appears a dev accidentally has pasted a newline into a file path, and that maybe this could be causing the problem: org.kde.pim.akonadiserver: stderr: "mysqld-akonadi: [ERROR] Could not open required defaults file: /home/andrea/.local/share/akonadi/mysql.conf\nmysqld-akonadi: [ERROR] Fatal error in defaults handling. Program aborted!\n" -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #9 from Erasmo Caponio --- *** Bug 411417 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Erasmo Caponio changed: What|Removed |Added CC||erasmocapo...@tiscali.it --- Comment #8 from Erasmo Caponio --- Same problem here. I am running kde neon user edition, plasma version 5.17.1 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Dmitry changed: What|Removed |Added CC||dmitry-kog...@mail.ru -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Alexander Zhigalin changed: What|Removed |Added Resolution|WORKSFORME |--- Version|5.12.0 |GIT (master) CC||alexan...@zhigalin.tk Ever confirmed|0 |1 Status|RESOLVED|REOPENED --- Comment #7 from Alexander Zhigalin --- The worksforme status is for bugs which can't be reproduced. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #6 from Dan --- So, this worked for me, but after rebooting my machine, akonadi did not start, and a manual start with akonadictl resulted in the same old failure and error messages, and I had to tear down and restart apparmor again. I assume I'll have to do this every time I start my desktop or laptop. So, this is an ugly work-around, not really a solution. Any idea how to get apparmor to permit access to the required files permanently? -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Daniel Kraus changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |WORKSFORME --- Comment #5 from Daniel Kraus --- The problem was solved by tearing down AppArmor, then restarting it. ``` sudo service apparmor teardown sudo service apparmor start ``` (NB: `systemctl` cannot handle the `teardown` task, and `stop` won't do it) -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #4 from Daniel Kraus --- I `tail -f`ed /var/syslog and issued akonadictl start: Aug 20 21:34:26 localhost kernel: [63166.278573] audit: type=1400 audit(1566329666.867:197): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22974 comm="mysqld-akonadi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0 Aug 20 21:34:26 localhost kernel: [63166.295499] audit: type=1400 audit(1566329666.883:198): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=22975 comm="mysqld-akonadi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0 Aug 20 21:34:26 localhost kernel: [63166.297604] audit: type=1400 audit(1566329666.883:199): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/home/$(USER)/.local/share/akonadi/mysql.conf" pid=22975 comm="mysqld-akonadi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=1000 As mentioned above, I did try to relax AppArmor rules as per forum suggestions. Possibly the solution is very simple, but I'm not familiar with the AppArmor DSL. Any help would be appreciated. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093
Raphael Posmyk changed:
What|Removed |Added
CC||duzy.trzm...@web.de
--- Comment #3 from Raphael Posmyk ---
I think the second error message about connection via socket to local server
results from a fallback after start of a local instance of mysql failed. The
main problem is access to /home/${USER}/.local/share/akonadi/mysql.conf.
--
You are receiving this mail because:
You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 Dan changed: What|Removed |Added CC||k...@foskett.org --- Comment #2 from Dan --- Same error (and same system info), and would just like to add an observation or two, in case they're helpful. First, when following these directions: https://docs.kde.org/stable5/en/pim/kmail2/clean-start-after-a-failed-migration.html the process fails with the same error report, and only creates some of the files it should. /etc/apparmor.d/usr.sbin.mysqld-akonadi features a line added in a previous bugfix to allow for creation of mysql lockfile (i think?): owner /run/user/*/akonadi/default/* wr, but my output shows an argument using a different directory: "--socket=/run/user/1000/akonadi/mysql.socket" and akonadiserverrc uses the same directory: [QMYSQL] Host= Name=akonadi Options="UNIX_SOCKET=/run/user/1000/akonadi/mysql.socket" ServerPath=/usr/sbin/mysqld-akonadi StartServer=true ...after the clean start process, /run/user/1000/akonadi/ is empty. Thanks! -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 411093] Unable to start Akonadi: Could not open required defaults file
https://bugs.kde.org/show_bug.cgi?id=411093 --- Comment #1 from Daniel Kraus --- NB: I replaced my original user name with 'USER' in this report (albeit not in all places...). -- You are receiving this mail because: You are watching all bug changes.
