Bug#969171: akonadi-server expects akonadi-backend-mysql allthough any sql backend should work

[Martin Steigerwald]

severity 969171 normal
thanks

Dear Eric.

Akonadi will use whatever database is set in the configuration file, by 
default on first startup MySQL if the MySQL backend has been installed at 
first startup. So if you use it with an existing home directory that has 
MySQL specified as database backend it needs the MySQL database backend 
of Akonadi to operate with the existing configuration. See the file: 
'~/.config/akonadi/akonadiserverrc'. This can happen as easily as 
starting once with the MySQL backend installed, as Plasma starts Akonadi 
automatically in its default configuration. Then you have an empty 
MariaDB based Akonadi. If you then switch to PostgreSQL this error 
occurs.

Please ask on debian-kde and/or upstream kdepim-users mailing list for 
support. The Debian bug tracker is not for user support questions. Also 
review previous threads on this topic there. Note that on switching the 
database Akonadi will start anew and some information only stored in the 
database will be lost.

I think it is not a bug of the package. But it is definitely not severity 
grave as Akonadi is perfectly usable here in exact the same version 
(usable to the extent Akonadi works reliable, but that is an upstream 
issue). So downgrading severity to normal.

I have seen repeatedly seen that you set too high bug severity. If the 
package does not work for me does not mean that its automatically grave 
severity. Especially when it is, as I assume, a configuration error. So 
please refrain from setting grave when it isn't. It just causes 
additional work for the already overloaded Debian Qt/KDE team. If you 
are unsure please ask first in debian-kde mailing list. That is part of 
what it is there for.

Best,
-- 
Martin

Bug#969171: akonadi-server expects akonadi-backend-mysql allthough any sql backend should work

[Eric Valette]

Package: akonadi-server
Version: 4:20.04.1-2+b1
Severity: grave
Justification: renders package unusable

akonadi server support any backend from package dependency point of view.
However trying to start it via 

akonadictl start you get:

org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:done.
Connecting to deprecated signal 
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
valette@tri-yann4:~$ 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...

However the file

/etc/xdg/akonadi/mysql-global.conf  comes only with package
akonadi-backend-mysql and manually adding an empty file the error disappers but 
then it
barks again later with mysql not running.



-- System Information:
Debian Release: bullseye/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 5.4.61 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=fr_FR.UTF8, LC_CTYPE=fr_FR.UTF8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/bash
Init: systemd (via /run/systemd/system)

Versions of packages akonadi-server depends on:
ii  akonadi-backend-sqlite   4:20.04.1-2+b1
ii  libc62.31-3
ii  libgcc-s110.2.0-5
ii  libkf5akonadiprivate5abi2 [libkf5akonadiprivate5-20.04]  4:20.04.1-2+b1
ii  libkf5akonadiwidgets5abi1 [libkf5akonadiwidgets5-20.04]  4:20.04.1-2+b1
ii  libkf5configcore55.70.0-1
ii  libkf5coreaddons55.70.0-2
ii  libkf5crash5 5.70.0-1
ii  libkf5i18n5  5.70.0-1
ii  libqt5core5a 5.14.2+dfsg-6
ii  libqt5dbus5  5.14.2+dfsg-6
ii  libqt5gui5   5.14.2+dfsg-6
ii  libqt5network5   5.14.2+dfsg-6
ii  libqt5sql5   5.14.2+dfsg-6
ii  libqt5widgets5   5.14.2+dfsg-6
ii  libqt5xml5   5.14.2+dfsg-6
ii  libstdc++6   10.2.0-5

akonadi-server recommends no packages.

Versions of packages akonadi-server suggests:
pn  akonadi-backend-mysql   
pn  akonadi-backend-postgresql  
ii  akonadi-backend-sqlite  4:20.04.1-2+b1

-- no debconf information



Subject: akonadi-server: xxx
Package: akonadi-server
Version: 4:20.04.1-2+b1
Severity: normal



-- System Information:
Debian Release: bullseye/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 5.4.61 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=fr_FR.UTF8, LC_CTYPE=fr_FR.UTF8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/bash
Init: systemd (via /run/systemd/system)

Versions of packages akonadi-server depends on:
ii  akonadi-backend-sqlite   4:20.04.1-2+b1
ii  libc62.31-3
ii  libgcc-s110.2.0-5
ii  libkf5akonadiprivate5abi2 [libkf5akonadiprivate5-20.04]  4:20.04.1-2+b1
ii  libkf5akonadiwidgets5abi1 [libkf5akonadiwidgets5-20.04]  4:20.04.1-2+b1
ii  libkf5configcore55.70.0-1
ii  libkf5coreaddons55.70.0-2
ii  libkf5crash5 5.70.0-1
ii  libkf5i18n5  5.70.0-1
ii  libqt5core5a 5.14.2+dfsg-6
ii  libqt5dbus5  5.14.2+dfsg-6
ii  libqt5gui5   5.14.2+dfsg-6
ii  libqt5network5   5.14.2+dfsg-6
ii  libqt5sql5   5.14.2+dfsg-6
ii  libqt5widgets5   5.14.2+dfsg-6
ii  libqt5xml5   5.14.2+dfsg-6
ii  libstdc++6   10.2.0-5

akonadi-server recommends no packages.

Versions of packages akonadi-server suggests:
pn  akonadi-backend-mysql   
pn  akonadi-backend-postgresql  
ii  akonadi-backend-sqlite