Hello,

I'm trying to start akonadi on Ubuntu 20.04.3 LTS: with mysql-server 8.0.27-0ubuntu0.20.04.

Code: Select all

peter@alfredo:~:3> akonadictl -v
akonadictl 5.13.3 (19.12.3)
peter@alfredo:~:3>


Initial start:

Code: Select all

peter@alfredo:~:3> rm -rf .local/share/akonadi .config/akonadi
peter@alfredo:~:3>

peter@alfredo:~:3> akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
2022-01-30T08:54:51.855016Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld-akonadi (mysqld 8.0.27-0ubuntu0.20.04.1) initializing of server in progress as process 267050
2022-01-30T08:54:51.860835Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-30T08:54:52.292863Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-30T08:54:53.239597Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-30T08:54:53.239614Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-30T08:54:53.344540Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ud#&j8g=)2-E
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/peter/.local/share/akonadi/mysql.conf", "--datadir=/home/peter/.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"
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...

peter@alfredo:~:3>


The mysql.err shows

Code: Select all

peter@alfredo:~/.local/share/akonadi/db_data:3> cat mysql.err
2022-01-30T08:54:56.194014Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2022-01-30T08:54:56.194058Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld-akonadi (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 267104
2022-01-30T08:54:56.195484Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-01-30T08:54:56.195491Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-01-30T08:54:56.201446Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-30T08:54:56.311166Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-30T08:54:56.315243Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').
2022-01-30T08:54:56.315387Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-01-30T08:54:56.315546Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-01-30T08:54:56.831392Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld-akonadi: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
peter@alfredo:~/.local/share/akonadi/db_data:3>


I changed lower_case_table_names value:

Code: Select all

peter@alfredo:~/.local/share/akonadi/db_data:3> grep lower_case_table_names  ../mysql.conf
lower_case_table_names=1
peter@alfredo:~/.local/share/akonadi/db_data:3> vi ../mysql.conf
peter@alfredo:~/.local/share/akonadi/db_data:3> grep lower_case_table_names  ../mysql.conf
lower_case_table_names=0
peter@alfredo:~/.local/share/akonadi/db_data:3>


Start with same akonadi error but other MySQL error message:

Code: Select all

peter@alfredo:~:3> cat .local/share/akonadi/db_data/mysql.err
2022-01-30T08:57:50.340518Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2022-01-30T08:57:50.340563Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld-akonadi (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 267305
2022-01-30T08:57:50.342016Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-01-30T08:57:50.342023Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-01-30T08:57:50.346789Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-30T08:57:50.447632Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-30T08:57:50.502582Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2022-01-30T08:57:50.502610Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't open lock file /var/run/mysqld/mysqlx.sock.lock'
2022-01-30T08:57:50.578527Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-30T08:57:50.578542Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-30T08:57:50.578967Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-30T08:57:50.578986Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-30T08:57:50.580563Z 0 [ERROR] [MY-000067] [Server] unknown variable 'log_warnings=2'.
2022-01-30T08:57:50.580752Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-01-30T08:57:52.146187Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld-akonadi: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1)  (Ubuntu).
peter@alfredo:~:3>


Any ideas on how do proceed?

Thanks and kind regards -- Peter

Maybe akonadi is incompatible with mysql 8.0?

If you don't need mysql 8.0 I'd sugest removing it and installing mariadb 10.3 instead.

I don't have an Ubuntu 20.04 system at hand to try it fully but with a quick check via docker I see akonadi-backend-mysql depends on mariadb-server-core-10.3 or virtual-mysql-server-core (which doesn't exist, but there's a default-mysql-server-core which depends on mysql-server-core-8.0):

Code: Select all

root@2004:/# apt show 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-Sources: http://archive.ubuntu.com/ubuntu focal/universe amd64 Packages
Description: MySQL storage backend for Akonadi