Ich würde gerne versuchen das mit mysql8.0 zu lösen.
Da virtual-mysql-server-core mysql8.0 referenziert, glaube ich nicht, dass es damit zusammenhängen muss.
Ich mache dazu aber noch einen eigenen Thread.
Ooops. Mit der Einschätzung liege ich wohl falsch?
$ dpkg -l *mysql-server*
Gewünscht=Unbekannt/Installieren/R=Entfernen/P=Vollständig Löschen/Halten
| Status=Nicht/Installiert/Config/U=Entpackt/halb konFiguriert/
Halb installiert/Trigger erWartet/Trigger anhängig
|/ Fehler?=(kein)/R=Neuinstallation notwendig (Status, Fehler: GROSS=schlecht)
||/ Name Version Architektur Beschreibung
+++-=========================-=======================-============-===================================================================
un default-mysql-server <keine> <keine> (keine Beschreibung vorhanden)
ii mysql-server 8.0.23-0ubuntu0.20.04.1 all MySQL database server (metapackage depending on the latest version)
un mysql-server-5.5 <keine> <keine> (keine Beschreibung vorhanden)
un mysql-server-5.7 <keine> <keine> (keine Beschreibung vorhanden)
ii mysql-server-8.0 8.0.23-0ubuntu0.20.04.1 amd64 MySQL database server binaries and system database setup
un mysql-server-core-5.7 <keine> <keine> (keine Beschreibung vorhanden)
ii mysql-server-core-8.0 8.0.23-0ubuntu0.20.04.1 amd64 MySQL database server binaries
un virtual-mysql-server <keine> <keine> (keine Beschreibung vorhanden)
un virtual-mysql-server-core <keine> <keine> (keine Beschreibung vorhanden)
This package includes the core server files, as used by Akonadi.
conflicts: [...] mysql-server-8.0, virtual-mysql-server-core
$ apt info mariadb-server-core-10.3 -a
Package: mariadb-server-core-10.3
Version: 1:10.3.25-0ubuntu0.20.04.1
Priority: optional
Section: universe/database
Source: mariadb-10.3
Origin: Ubuntu
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Original-Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 38,4 MB
Provides: virtual-mysql-server-core
Depends: mariadb-common (>= 1:10.3.25-0ubuntu0.20.04.1), libaio1 (>= 0.3.93), libc6 (>= 2.29), libcrypt1 (>= 1:4.1.0), liblz4-1 (>= 0.0~r130), libpcre3, libsnappy1v5 (>= 1.1.8), libstdc++6 (>= 9), libsystemd0, zlib1g (>= 1:1.2.0)
Conflicts: mariadb-galera-server-5.5, mysql-server-5.5, mysql-server-5.6, mysql-server-5.7, mysql-server-8.0, virtual-mysql-server-core
Breaks: mariadb-client-10.1, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-10.3 (<< 1:10.3.13-2), mariadb-server-core-10.0, mariadb-server-core-10.1, mariadb-server-core-10.2, mariadb-server-core-5.5, mysql-client-5.5, mysql-client-5.6, mysql-server-core-5.5, mysql-server-core-5.6, mysql-server-core-5.7, mysql-server-core-8.0
Replaces: mariadb-client-10.1, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-10.3 (<< 1:10.3.13-2), mariadb-server-core-10.0, mariadb-server-core-10.1, mariadb-server-core-10.2, mariadb-server-core-5.5, mysql-client-5.5, mysql-client-5.6, mysql-client-5.7, mysql-client-8.0, mysql-server-core-5.5, mysql-server-core-5.6, mysql-server-core-5.7, mysql-server-core-8.0, virtual-mysql-server-core
Homepage: https://mariadb.org/
Download-Size: 5.987 kB
APT-Sources: http://security.ubuntu.com/ubuntu focal-security/universe amd64 Packages
Description: MariaDB database core server files
MariaDB is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MariaDB are speed, robustness and
ease of use.
.
This package includes the core server files, as used by Akonadi.
Package: mariadb-server-core-10.3
Version: 1:10.3.22-1ubuntu1
Priority: optional
Section: universe/database
Source: mariadb-10.3
Origin: Ubuntu
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Original-Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 38,3 MB
Provides: virtual-mysql-server-core
Depends: mariadb-common (>= 1:10.3.22-1ubuntu1), libaio1 (>= 0.3.93), libc6 (>= 2.29), libcrypt1 (>= 1:4.1.0), liblz4-1 (>= 0.0~r130), libpcre3, libsnappy1v5 (>= 1.1.8), libstdc++6 (>= 9), libsystemd0, zlib1g (>= 1:1.2.0)
Conflicts: mariadb-galera-server-5.5, mysql-server-5.5, mysql-server-5.6, mysql-server-5.7, mysql-server-8.0, virtual-mysql-server-core
Breaks: mariadb-client-10.1, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-10.3 (<< 1:10.3.13-2), mariadb-server-core-10.0, mariadb-server-core-10.1, mariadb-server-core-10.2, mariadb-server-core-5.5, mysql-client-5.5, mysql-client-5.6, mysql-server-core-5.5, mysql-server-core-5.6, mysql-server-core-5.7, mysql-server-core-8.0
Replaces: mariadb-client-10.1, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-10.3 (<< 1:10.3.13-2), mariadb-server-core-10.0, mariadb-server-core-10.1, mariadb-server-core-10.2, mariadb-server-core-5.5, mysql-client-5.5, mysql-client-5.6, mysql-client-5.7, mysql-client-8.0, mysql-server-core-5.5, mysql-server-core-5.6, mysql-server-core-5.7, mysql-server-core-8.0, virtual-mysql-server-core
Homepage: https://mariadb.org/
Download-Size: 6.011 kB
APT-Sources: http://de.archive.ubuntu.com/ubuntu focal/universe amd64 Packages
Description: MariaDB database core server files
MariaDB is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MariaDB are speed, robustness and
ease of use.
.
This package includes the core server files, as used by Akonadi.
Depends: libqt5sql5-mysql, mariadb-client-core-10.3 | virtual-mysql-client-core, mariadb-server-core-10.3 | virtual-mysql-server-core
$ apt info akonadi-backend-mysql
Package: akonadi-backend-mysql
Version: 4:19.12.3-0ubuntu2
Priority: extra
Section: universe/misc
Source: akonadi
Origin: Ubuntu
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Original-Maintainer: Debian/Kubuntu Qt/KDE Maintainers <debian-qt-kde@lists.debian.org>
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 66,6 kB
Depends: libqt5sql5-mysql, mariadb-client-core-10.3 | virtual-mysql-client-core, mariadb-server-core-10.3 | virtual-mysql-server-core
Recommends: akonadi-server
Breaks: akonadi-server (<< 1.3.60~)
Replaces: akonadi-server (<< 1.3.60~)
Homepage: http://pim.kde.org/akonadi
Download-Size: 11,8 kB
APT-Manual-Installed: yes
APT-Sources: http://de.archive.ubuntu.com/ubuntu focal/universe amd64 Packages
Description: MySQL storage backend for Akonadi
Akonadi is an extensible cross-desktop Personal Information Management
(PIM) storage service. It provides a common framework for applications to
store and access mail, calendars, addressbooks, and other PIM data.
.
This package installs everything what's needed for Akonadi to work with
MySQL as underlying data storage engine. By default, a local MySQL server
instance will be started for each user. Alternatively, connection to an
external MySQL database is supported as well.
~$ apt info virtual-mysql-client-core
Package: virtual-mysql-client-core
State: kein reales Paket (virtuell)
N: Es kann kein Installationskandidat von Paket »virtual-mysql-client-core« ausgewählt werden, da kein solcher existiert.
N: Es können keine Versionen von Paket »virtual-mysql-client-core« ausgewählt werden, da es rein virtuell ist.
N: Keine Pakete gefunden
~$ apt info virtual-mysql-server-core
Package: virtual-mysql-server-core
State: kein reales Paket (virtuell)
N: Es kann kein Installationskandidat von Paket »virtual-mysql-server-core« ausgewählt werden, da kein solcher existiert.
N: Es können keine Versionen von Paket »virtual-mysql-server-core« ausgewählt werden, da es rein virtuell ist.
N: Keine Pakete gefunden
Na, da kann ich ja lange versuchen das zum Laufen zu bringen ...
–
Hier meine Fehlermeldung:
$ org.kde.pim.akonadicontrol: Service ":1.364" owner changed from ":1.364" to ""
org.kde.pim.akonadicontrol: Service ":1.366" owner changed from "" to ":1.366"
org.kde.pim.akonadicontrol: Service ":1.367" owner changed from "" to ":1.367"
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db: ""
org.kde.pim.akonadiserver: Found mysqlcheck: "/usr/bin/mysqlcheck"
org.kde.pim.akonadiserver: Using mysqld: "/usr/sbin/mysqld-akonadi"
org.kde.pim.akonadiserver: mysqld reports version 8.0.23 (Oracle MySQL)
org.kde.pim.akonadiserver: Executing: "/usr/sbin/mysqld-akonadi" "--defaults-file=/home/gerhard/.local/share/akonadi/mysql.conf --datadir=/home/gerhard/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid"
org.kde.pim.akonadicontrol: Service ":1.368" owner changed from "" to ":1.368"
org.kde.pim.akonadicontrol: Service ":1.368" owner changed from ":1.368" to ""
org.kde.pim.akonadicontrol: Service ":1.369" owner changed from "" to ":1.369"
org.kde.pim.akonadicontrol: Service ":1.369" owner changed from ":1.369" to ""
org.kde.pim.akonadicontrol: Service ":1.370" owner changed from "" to ":1.370"
org.kde.pim.akonadicontrol: Service ":1.370" owner changed from ":1.370" to ""
org.kde.pim.akonadicontrol: Service ":1.371" owner changed from "" to ":1.371"
org.kde.pim.akonadicontrol: Service ":1.371" owner changed from ":1.371" to ""
org.kde.pim.akonadicontrol: Service ":1.372" owner changed from "" to ":1.372"
org.kde.pim.akonadicontrol: Service ":1.372" owner changed from ":1.372" to ""
org.kde.pim.akonadicontrol: Service ":1.373" owner changed from "" to ":1.373"
org.kde.pim.akonadicontrol: Service ":1.373" owner changed from ":1.373" to ""
org.kde.pim.akonadicontrol: Service ":1.374" owner changed from "" to ":1.374"
org.kde.pim.akonadicontrol: Service ":1.374" owner changed from ":1.374" to ""
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/gerhard/.local/share/akonadi/mysql.conf", "--datadir=/home/gerhard/.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: ""
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: stopping db process
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: Service ":1.367" owner changed from ":1.367" to ""
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
$ tail /home/gerhard/.local/share/akonadi/Akonadi.error.old
2021-05-07T19:16:25 [WARN ] default: Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
$ tail /home/gerhard/.local/share/akonadi/Akonadi.error
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/gerhard/.local/share/akonadi/mysql.conf", "--datadir=/home/gerhard/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadiserver: stdout: ""
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadiserver: stderr: ""
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadiserver: exit code: 1
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadiserver: process error: "Unknown error"
2021-05-07T19:16:30 [DEBUG] org.kde.pim.akonadiserver: terminating connection threads
2021-05-07T19:16:30 [DEBUG] org.kde.pim.akonadiserver: terminating service threads
2021-05-07T19:16:30 [DEBUG] org.kde.pim.akonadiserver: stopping db process
2021-05-07T19:16:30 [CRITICAL] org.kde.pim.akonadise2021-05-07T19:16:30 [DEBUG] org.kde.pim.akonadicontrol: Service ":1.389" owner changed from ":1.389" to ""
2021-05-07T19:16:30 [INFO ] org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
$ strace akonadictl start --verbose 2>&1 |grep -i found
org.kde.pim.akonadiserver: Found mysql_install_db: ""
org.kde.pim.akonadiserver: Found mysqlcheck: "/usr/bin/mysqlcheck"
apparmor
Mai 07 19:16:25 ubuntu kernel: kauditd_printk_skb: 6 callbacks suppressed
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.311:426): apparmor="ALLOWED" operation="open" profile="/usr/sbin/mysqld" name="/home/gerhard/.my.cnf" pid=40862 comm="mysqld-akonadi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.323:427): apparmor="ALLOWED" operation="open" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/mysql.conf" pid=40863 comm="mysqld-akonadi" requested_mask="r" denied_mask="r" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:428): apparmor="ALLOWED" operation="mknod" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="c" denied_mask="c" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:429): apparmor="ALLOWED" operation="open" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="wrc" denied_mask="wrc" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:430): apparmor="ALLOWED" operation="unlink" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="d" denied_mask="d" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:431): apparmor="ALLOWED" operation="mknod" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="c" denied_mask="c" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:432): apparmor="ALLOWED" operation="open" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="wrc" denied_mask="wrc" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:433): apparmor="ALLOWED" operation="unlink" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysqld_tmp_file_case_insensitive_test.lower-test" pid=40863 comm="mysqld-akonadi" requested_mask="d" denied_mask="d" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:434): apparmor="ALLOWED" operation="mknod" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysql.err" pid=40863 comm="mysqld-akonadi" requested_mask="c" denied_mask="c" fsuid=1000 ouid=1000
Mai 07 19:16:25 ubuntu kernel: audit: type=1400 audit(1620407785.519:435): apparmor="ALLOWED" operation="open" profile="/usr/sbin/mysqld" name="/home/gerhard/.local/share/akonadi/db_data/mysql.err" pid=40863 comm="mysqld-akonadi" requested_mask="ac" denied_mask="ac" fsuid=1000 ouid=1000
$ sudo aa-status --pretty-json | egrep 'kmail|mysql|akonadi'
"/usr/sbin/mysqld": "complain",
"/usr/sbin/mysqld-akonadi": "complain",
config
$ egrep -v '#|^ *$' ~/.config/akonadi/akonadiserverrc
[Debug]
Tracer=null
[%General]
Driver=QMYSQL
[QMYSQL]
Host=
Name=akonadi
Options="UNIX_SOCKET=/run/user/1000/akonadi/mysql.socket"
ServerPath=/usr/sbin/mysqld-akonadi
StartServer=true
$ egrep -v '#|^ *$' /home/gerhard/.local/share/akonadi/mysql.conf
[mysqld]
character_set_server=utf8
collation_server=utf8_general_ci
default_storage_engine=innodb
innodb_buffer_pool_size=128M
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=1M
innodb_log_file_size=64M
log_error=mysql.err
log_warnings=2
lower_case_table_names=1
max_allowed_packet=32M
max_connections=256
query_cache_size=0
query_cache_type=0
skip_grant_tables
skip_networking
table_open_cache=200
thread_cache_size=3
wait_timeout=31536000
key_buffer_size=16K
secure_file_priv=
sql_mode=NO_ENGINE_SUBSTITUTION
[client]
default-character-set=utf8