Cosmic
akonadi 4:18.04.3-0ubuntu1
On a new user or fresh install with no existing akonadi database present, akonadi fails to start as below:
$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
mysqld: [ERROR] Could not open required defaults file: /home/cosmic2/
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=/home/cosmic2/.local/share/akonadi/mysql.conf", "--datadir=/home/cosmic2/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-cosmic2.D2M7Vb/mysql.socket", "--pid-file=/tmp/akonadi-cosmic2.D2M7Vb/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "mysqld: Can't change dir to '/home/cosmic2/.local/share/akonadi/db_data/' (Errcode: 2 - No such file or directory)\n2018-10-12T20:43:35.453607Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.\n2018-10-12T20:43:35.453700Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\n2018-10-12T20:43:35.454504Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.\n2018-10-12T20:43:35.454549Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.\n2018-10-12T20:43:35.455216Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-2ubuntu1) starting as process 11227 ...\n2018-10-12T20:43:35.536547Z 0 [Warning] Can't create test file /home/cosmic2/.local/share/akonadi/db_data/cosmic2-VirtualBox.lower-test\n2018-10-12T20:43:35.536581Z 0 [Warning] Can't create test file /home/cosmic2/.local/share/akonadi/db_data/cosmic2-VirtualBox.lower-test\n2018-10-12T20:43:35.536618Z 0 [ERROR] failed to set datadir to /home/cosmic2/.local/share/akonadi/db_data/\n2018-10-12T20:43:35.536622Z 0 [ERROR] Aborting\n\n2018-10-12T20:43:35.536631Z 0 [Note] Binlog end\n2018-10-12T20:43:35.543857Z 0 [Note] /usr/sbin/mysqld: Shutdown complete\n\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...
dmesg output
ces/system/node/" pid=11843 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 648.247460] audit: type=1400 audit(1539377270.325:55): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=11843 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 648.252570] audit: type=1400 audit(1539377270.329:56): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=11844 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 648.252573] audit: type=1400 audit(1539377270.329:57): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/home/cosmic2/" pid=11844 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=1000
[ 648.256661] audit: type=1400 audit(1539377270.333:58): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=11845 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 716.311650] audit: type=1400 audit(1539379319.310:59): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=11891 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 716.312669] audit: type=1400 audit(1539379319.310:60): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=11891 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 716.348455] audit: type=1400 audit(1539379319.346:61): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=11892 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
[ 716.349006] audit: type=1400 audit(1539379319.346:62): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/home/cosmic2/" pid=11892 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=1000
[ 716.353072] audit: type=1400 audit(1539379319.350:63): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld-akonadi///usr/sbin/mysqld" name="/sys/devices/system/node/" pid=11893 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
ProblemType: Bug
DistroRelease: Ubuntu 18.10
Package: akonadi-server 4:18.04.3-0ubuntu1
ProcVersionSignature: Ubuntu 4.18.0-8.9-generic 4.18.7
Uname: Linux 4.18.0-8-generic x86_64
ApportVersion: 2.20.10-0ubuntu11
Architecture: amd64
CurrentDesktop: KDE
Date: Fri Oct 12 22:25:33 2018
InstallationDate: Installed on 2018-10-12 (0 days ago)
InstallationMedia: Kubuntu 18.10 "Cosmic Cuttlefish" - Beta amd64 (20181012)
SourcePackage: akonadi
UpgradeStatus: No upgrade log present (probably fresh install)
Created attachment 115390
Akonadi selftest report
SUMMARY
STEPS TO REPRODUCE
1. in a fresh installation of KDE Neon, I have apt install Kontact
OBSERVED RESULT
— A error windows appear, here is the log joined
— I have try a : akonadictl start but I have a error (commande line result joined)
EXPECTED RESULT
$ akonadictl start Interface: :serviceOwnerCh anged(QString, QString, QString)
Connecting to deprecated signal QDBusConnection
FATAL ERROR: Could not find my_print_defaults
The following directories were searched:
/usr/bin
/usr/extra
If you compiled from source, you need to either run 'make install' to
copy the software into the correct location ready for operation.
If you don't want to do a full install, you can use the --srcddir
option to only install the mysql database and privilege tables
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
The latest information about mysql_install_db is available at /mariadb. com/kb/ en/installing- system- tables- mysql_install_ db pim.akonadiserv er: database server stopped unexpectedly pim.akonadiserv er: Database process exited unexpectedly during initial connection! pim.akonadiserv er: executable: "/usr/sbin/ mysqld- akonadi" pim.akonadiserv er: arguments: ("--defaults- file=/home/ patrice/ .local/ share/akonadi/ mysql.conf" , "--datadir= /home/patrice/ .local/ share/akonadi/ db_data/ ", "--socket= /tmp/akonadi- patrice. 21Y4l2/ mysql.socket" , "--pid- file=/tmp/ akonadi- patrice. 21Y4l2/ mysql.pid" ) pim.akonadiserv er: stdout: "" pim.akonadiserv er: stderr: "2018-10-03 11:25:50 139824482577536 [Note] /usr/sbin/mysqld (mysqld 10.1.34- MariaDB- 0ubuntu0. 18.04.1) starting as process 3306 ...\n2018-10-03 11:25:50 139824482577536 [Warning] Can't create test file /home/patrice/ .local/ share/akonadi/ db_data/ neon.lower- test\n\ x07/usr/ sbin/mysqld: Can't change dir to '/home/ patrice/ .local/ share/akonadi/ db_data/ ' (Errcode: 2 \"No such file or directory\ ")\n2018- 10-03 11:25:50 139824482577536 [ERROR] Aborting\n\n" pim.akonadiserv er: exit code: 1 pim.akonadiserv er: process error: "Unknown error" pim.akonadiserv er: Failed to remove runtime connection config file pim.akonadicont rol: Application 'akonadiserver' exited normally...
https:/
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
org.kde.
SOFTWARE VERSIONS
(available in About System)
KDE Plasma Version: 5.13.5
KDE Frameworks Version: 5.50
Qt Version: 5.11.1
ADDITIONAL INFORMATION