Bug#934488: akonadi-backend-mysql: Failed to use database "akonadi"
Package: akonadi-backend-mysql
Version: 4:18.08.3-5
Severity: important
Dear Maintainer,
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation?
sudo apt install kontact
* What exactly did you do (or not do) that was effective (or
ineffective)?
kontact &
* What was the outcome of this action?
akonadi_control(2751)/(default) [31munknown[0m: Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
kontact(3305)/(org.kde.pim.kontact) [31m[34munknown[0m: "Part activated:"
KMailPart(0x7fa164014840) "with stack id." 1
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: Found
mysql_install_db: "/usr/bin/mysql_install_db"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: Found
mysqlcheck: "/usr/bin/mysqlcheck"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: Using
mysqld: "/usr/sbin/mysqld-akonadi"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31munknown[0m: Failed to use
database "akonadi"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31munknown[0m: Database error:
"Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: Trying to
create database now...
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31munknown[0m: Failed to
connect to database!
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31munknown[0m: Database error:
"Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: terminating
connection threads
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: terminating
service threads
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: stopping db
process
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31munknown[0m: Failed to
remove runtime connection config file
akonadiserver(2770)/(org.kde.pim.akonadiserver) [31m[34munknown[0m: Shutting
down AkonadiServer...
akonadi_control(2751)/(org.kde.pim.akonadicontrol) [31munknown[0m: Application
'akonadiserver' exited normally...
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Resize event enter
(viewport width is 256 )
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Identical folder
reloaded, not saving old threading cache
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: No threading cache
file for collection ""
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Resize event enter
(viewport width is 526 )
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Resize event enter
(viewport width is 505 )
kontact(2726)/(org.kde.pim.kontact) [31m[34munknown[0m: Kontact already
running, exiting.
kontact(3305)/(org.kde.pim.akonadi.ETM) [31m[34munknown[0m: GEN true false
false
kontact(3305)/(org.kde.pim.akonadi.ETM) [31m[34munknown[0m: collection:
QVector()
kontact(3305)/(org.kde.pim.akonadi.ETM) [31m[34munknown[0m:
EntityTreeModelPrivate::fetchTopLevelCollections
kontact(3305)/(org.kde.pim.calendarsupport) [31munknown[0m: Failed to fetch
tags: ""
kontact(3305)/(org.kde.pim.kmail) [31munknown[0m: ""
kontact(3305)/(org.kde.pim.kmail) [31munknown[0m: ""
kontact(3305)/(org.kde.pim.akonadiwidgets) [31m[34munknown[0m: 4
kontact(3305)/(org.kde.pim.akonadicore) [31munknown[0m: Job error: "" for
collection: QVector()
kontact(3305)/(org.kde.pim.akonadicore) [31munknown[0m: Job error: "" for
collection: QVector()
kontact(3305)/(org.kde.pim.kmail) [31m[34munknown[0m: KMKernel has akonadi
state changed to: 4
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Resize event enter
(viewport width is 505 )
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: Identical folder
reloaded, not saving old threading cache
kontact(3305)/(org.kde.pim.messagelist) [31m[34munknown[0m: No threading cache
file for collection ""
* What outcome did you expect instead?
Functional kontact.
MORE INFO
akonadiselftest
Akonadi Server Self-Test Report
===============================
Test 1: SUCCESS
--------
Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server
configuration and was found on your system.
File content of '/home/scarlett/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
[QMYSQL]
Host=
Name=akonadi
Options=
ServerPath=/usr/sbin/mysqld-akonadi
StartServer=false
Test 2: SUCCESS
--------
Akonadi is not running as root
Details: Akonadi is not running as a root/administrator user, which is the
recommended setup for a secure system.
Test 3: SKIP
--------
MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.
Test 4: SKIP
--------
MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.
Test 5: SKIP
--------
MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.
Test 6: SUCCESS
--------
akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was
found and could be executed successfully.
Result:
akonadictl 5.9.3
Test 7: ERROR
--------
Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically
means it was not started or encountered a fatal error during startup.
Test 8: ERROR
--------
Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically
means it was not started or encountered a fatal error during startup.
Test 9: SKIP
--------
Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the
protocol version meets the requirements.
Test 10: ERROR
--------
No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at
least one. This usually means that no resource agents are installed or that
there is a setup problem. The following paths have been searched:
'/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to
'/usr/share/netrunner-desktop-settings/plasma5-profile:/usr/share/default-
settings/plasma5-profile:/usr/local/share:/usr/share:/var/lib/snapd/desktop';
make sure this includes all paths where Akonadi agents are installed.
Directory listing of '/usr/share/akonadi/agents':
akonadiindexingagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
ewsmtaresource.desktop
ewsresource.desktop
facebookresource.desktop
followupreminder.desktop
googlecalendarresource.desktop
googlecontactsresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kolabresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
migrationagent.desktop
mixedmaildirresource.desktop
newmailnotifieragent.desktop
notesagent.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
sendlateragent.desktop
tomboynotesresource.desktop
vcarddirresource.desktop
vcardresource.desktop
Environment variable XDG_DATA_DIRS is set to '/usr/share/netrunner-desktop-
settings/plasma5-profile:/usr/share/default-
settings/plasma5-profile:/usr/local/share:/usr/share:/var/lib/snapd/desktop'
Test 11: ERROR
--------
Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log
can be found in <a
href="/home/scarlett/.local/share/akonadi/akonadiserver.error">/home/scarlett/.local/share/akonadi/akonadiserver.error</a>.
File content of '/home/scarlett/.local/share/akonadi/akonadiserver.error':
Failed to use database "akonadi"
Database error: "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
Failed to connect to database!
Database error: "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
Failed to remove runtime connection config file
Test 12: ERROR
--------
Previous Akonadi server error log found.
Details: The Akonadi server reported errors during its previous startup. The
log can be found in <a
href="/home/scarlett/.local/share/akonadi/akonadiserver.error.old">/home/scarlett/.local/share/akonadi/akonadiserver.error.old</a>.
File content of '/home/scarlett/.local/share/akonadi/akonadiserver.error.old':
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
Using mysqld: "/usr/sbin/mysqld-akonadi"
Failed to use database "akonadi"
Database error: "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
Trying to create database now...
Failed to connect to database!
Database error: "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect"
terminating connection threads
terminating service threads
stopping db process
Failed to remove runtime connection config file
Shutting down AkonadiServer...
Test 13: ERROR
--------
Current Akonadi control error log found.
Details: The Akonadi control process reported errors during its current
startup. The log can be found in <a
href="/home/scarlett/.local/share/akonadi/akonadi_control.error">/home/scarlett/.local/share/akonadi/akonadi_control.error</a>.
File content of '/home/scarlett/.local/share/akonadi/akonadi_control.error':
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Application 'akonadiserver' exited normally...
Test 14: ERROR
--------
Previous Akonadi control error log found.
Details: The Akonadi control process reported errors during its previous
startup. The log can be found in <a
href="/home/scarlett/.local/share/akonadi/akonadi_control.error.old">/home/scarlett/.local/share/akonadi/akonadi_control.error.old</a>.
File content of
'/home/scarlett/.local/share/akonadi/akonadi_control.error.old':
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Application 'akonadiserver' exited normally...
Please help!
Scarlett
-- System Information:
Debian Release: buster/sid
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.19.0-5-amd64 (SMP w/12 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages akonadi-backend-mysql depends on:
ii default-mysql-client-core 1.0.5
ii default-mysql-server-core 1.0.5
ii libqt5sql5-mysql 5.11.3+dfsg1-1
ii mariadb-client-core-10.3 [virtual-mysql-client-core] 1:10.3.15-1
ii mariadb-server-core-10.3 [virtual-mysql-server-core] 1:10.3.15-1
Versions of packages akonadi-backend-mysql recommends:
ii akonadi-server 4:18.08.3-5
akonadi-backend-mysql suggests no packages.
-- no debconf information
Reply to: