如何修复Akonadi找不到mysql-global.conf Kubuntu 20.04？

Question

我让一个数据库服务器重新安装。我安装了MariaDB，虽然它运行良好，但MySQL工作台的某些方面发现很难与MariaDB兼容。最后，我用标准的MySQL 8.0安装取代了它。到目前为止，整个系统运行良好，但看来Akonadi服务没有正常启动。

我使用KOrganizer保存我的所有事件，因为它依赖于Akonadi，所以它无法启动。这就是我得到的状态：

$ akonadictl start

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Did not find MySQL server default configuration (mysql-global.conf)
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...

与第三行相反，此位置上存在MySQL配置文件：

$ /usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf 

没有办法对服务进行重置。我也不能重新安装它。有什么建议吗？

编辑重新安装模块后，我在启动Akonadi时得到这个日志：

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
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"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/shivendra/.local/share/akonadi/mysql.conf", "--datadir=/home/shivendra/.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...
org.kde.pim.akonadicore: ""
org.kde.pim.akonadicore: Job error:  "" for collection: QVector() 

QSqlQuery::prepare: database not open
QSqlDatabasePrivate::removeDatabase: connection 'qt_sql_default_connection' is still in use, all queries will cease to work.
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/shivendra/.local/share/akonadi/search_db/calendars/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/shivendra/.local/share/akonadi/search_db/contacts/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/shivendra/.local/share/akonadi/search_db/email/"
org.kde.pim.akonadi_search_xapian: Xapian Database does not exist at  "/home/shivendra/.local/share/akonadi/search_db/notes/"
org.kde.pim.akonadiconsole: DatabaseOpeningError "DatabaseOpeningError: Couldn't detect type of database" 

Answer 1

必须通过以下方式重新安装包，提供mysql-global.conf文件

sudo apt-get install --reinstall akonadi-backend-mysql