akonadi-server too dependent on MySQL and prevent percona instalation

Bug #1336005 reported by Raul Dias
32
This bug affects 5 people
Affects Status Importance Assigned to Milestone
akonadi (Ubuntu)
Fix Released
Medium
Philip Muškovac
Trusty
Triaged
Medium
Unassigned

Bug Description

There are a few serious packaging problems with akonadi:

1 - akonadi-server depends on akonadi-backend-mysql.
      It can also work with postgresql and sqllite, but mysql is mandatory, it should be optional.

2 - akonadi-backend depends on either mysql-server-core-5.5 or mariadb-server-core-5.5

2.1 - depending on a specific version of mysql is very bad. If there is a need for a feature on 5.5, it should be something like:
mysql-server-core >= 5.5. As 5.6 has all feature of 5.5, it still cannot be installed.
The same goes to the clients too.

2.2 - the percona-server-(server|client) should be added to the mix.
PPA: http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html

Basically the choice is either use mysql|mariadb 5.5 or no kde.

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: akonadi-server 1.12.1-0ubuntu1.1
ProcVersionSignature: Ubuntu 3.13.0-30.54-generic 3.13.11.2
Uname: Linux 3.13.0-30-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.2
Architecture: amd64
CurrentDesktop: KDE
Date: Mon Jun 30 16:56:55 2014
InstallationDate: Installed on 2014-05-12 (49 days ago)
InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Release amd64 (20140417)
SourcePackage: akonadi
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Raul Dias (rsd) wrote :
Revision history for this message
Janusz Mordarski (janusz-mordarski) wrote :

Confirmed, this bug prevents users from replacing mysql with percona packages. A quick fix is to extract akonadi -backend-mysql page, modify control file (change Depends), repack .deb file and reinstall (the solution below is more or less working - I'm tweaking the Depends section now)

apt-get install --reinstall --download-only akonadi-backend-mysql
mv /var/cache/apt/archives/akonadi-backend-mysql_1.12.1-0ubuntu1.1_all.deb .
ar x akonadi-backend-mysql_1.12.1-0ubuntu1.1_all.deb
tar xvzf control.tar.gz
vi control
Depends: virtual-mysql-server-core | mariadb-server-core-5.5 | percona-server-server, mysql-client-core-5.5 | mariadb-client-core-5.5 | percona-server-client-5.6, libqt4-sql-mysql
rm control.tar.gz
tar c postinst postrm md5sums control conffiles | gzip -c > control.tar.gz
ar rcs akonadi-backend-mysql_1.12.1-0ubuntu1.1_percona_all.deb debian-binary control.tar.gz data.tar.xz
dpkg -i akonadi-backend-mysql_1.12.1-0ubuntu1.1_percona_all.deb

apt-get install percona-server-server-5.6 percona-server-client-5.6

Revision history for this message
Janusz Mordarski (janusz-mordarski) wrote :

For the above to work with percona-server, control file in percona-server-server package MUST list , mysql-server-core-5.5, mysql-server-core-5.6 in both Replaces and Provides sections

Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in akonadi (Ubuntu):
status: New → Confirmed
Philip Muškovac (yofel)
Changed in akonadi (Ubuntu):
assignee: nobody → Philip Muškovac (yofel)
importance: Undecided → Medium
status: Confirmed → In Progress
Philip Muškovac (yofel)
Changed in akonadi (Ubuntu Trusty):
assignee: nobody → Philip Muškovac (yofel)
importance: Undecided → Medium
status: New → Triaged
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package akonadi - 1.13.0-2ubuntu3

---------------
akonadi (1.13.0-2ubuntu3) vivid; urgency=medium

  * Still prefer mysql 5.6, but allow any mysql implementation that provides
    virtual-mysql-server-core and virtual-mysql-client-core
    (LP: #1336005)
  * Force dependency on akonadi-backend-mysql for akonadi-server.
    (was accidentally dropped in the last debian merge)
 -- Philip Muskovac <email address hidden> Wed, 15 Apr 2015 16:57:20 +0200

Changed in akonadi (Ubuntu):
status: In Progress → Fix Released
Revision history for this message
Rafael Kassner (kassner) wrote :

Can we expect to see this in trusty?

Revision history for this message
Alex (alex00888) wrote :

+1 for trusty, can't work without it

Revision history for this message
willfe (willfe) wrote :

Any chance this can also be updated to support MariaDB installations? Or is there an alternate way for MariaDB to provide virtual-mysql-[client|server]-core to satisfy akonadi-backend-mysql's dependencies?

Revision history for this message
willfe (willfe) wrote :

Scratch that -- I'm running MariaDB's own .debs instead of Ubuntu's; it looks like the stock Ubuntu .debs are set up properly.

Philip Muškovac (yofel)
Changed in akonadi (Ubuntu Trusty):
assignee: Philip Muškovac (yofel) → nobody
Revision history for this message
Thilo Pfennig (lagsh) wrote :

For me this is still the case. Default shoud be sqlite because no further configuration is required.

Package: akonadi-server
Architecture: amd64
Version: 4:19.12.3-0ubuntu2
Priority: extra
Section: universe/net
Source: akonadi
Origin: Ubuntu
Maintainer: Ubuntu Developers <email address hidden>
Original-Maintainer: Debian/Kubuntu Qt/KDE Maintainers <email address hidden>
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 3396
Depends: libaccounts-qt5-1, libc6 (>= 2.14), libgcc-s1 (>= 3.0), libkf5akonadiprivate5abi2 (= 4:19.12.3-0ubuntu2), libkf5akonadiwidgets5abi1 (= 4:19.12.3-0ubuntu2), libkf5configcore5 (>= 4.97.0), libkf5coreaddons5 (>= 4.100.0), libkf5crash5 (>= 5.15.0), libkf5i18n5 (>= 4.97.0), libqt5core5a (>= 5.12.2), libqt5dbus5 (>= 5.6.1~), libqt5gui5 (>= 5.6.1~) | libqt5gui5-gles (>= 5.6.1~), libqt5network5 (>= 5.6.1~), libqt5sql5 (>= 5.6.1~), libqt5widgets5 (>= 5.6.1~), libqt5xml5 (>= 5.6.1~), libstdc++6 (>= 5.2)
Recommends: akonadi-backend-mysql (= 4:19.12.3-0ubuntu2)
Suggests: akonadi-backend-postgresql (= 4:19.12.3-0ubuntu2), akonadi-backend-sqlite (= 4:19.12.3-0ubuntu2)
Breaks: akonadiconsole (<< 4:16.12), kapptemplate (<< 4:17.11.80~), kdepimlibs-data (<< 4:16.04), kmail (<< 4:16.12), korganizer (<< 4:16.12), libkf5akonadicore-bin (<< 4:19.08.0~)
Replaces: kapptemplate (<< 4:17.11.80~), kdepimlibs-data (<< 4:16.04), libkf5akonadicore-bin (<< 4:19.08.0~)
Filename: pool/universe/a/akonadi/akonadi-server_19.12.3-0ubuntu2_amd64.deb
Size: 947908
MD5sum: a35ca7dba3abd5d38cbf7afd2cffca6e
SHA1: 4ed3435957614dbc8b7a88ae06e32007f0ff27ee
SHA256: 6b57b394099010b7b741236f92ce7bd8049cf07a2a4e2008d773d11b

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.