Bug 298314 - [kcm] database driver dropdown menu always lists mysql and postgresql regardless of what backends are actually installed
Summary: [kcm] database driver dropdown menu always lists mysql and postgresql regardl...
Status: RESOLVED UNMAINTAINED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: general (show other bugs)
Version: unspecified
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-17 17:04 UTC by JR
Modified: 2017-01-07 22:09 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screenshot showing how the kcm is not aware of installed backends (324.90 KB, image/png)
2012-04-17 17:06 UTC, JR
Details

Note You need to log in before you can comment on or make changes to this bug.
Description JR 2012-04-17 17:04:58 UTC
Kubuntu 12.04b amd64, KDE 4.8.2 packages from Kubuntu PPAs.

In the Server Configuration tab in the Akonadi kcm, there's a dropdown list where you can choose what backend it should use to store its database. In the (K)ubuntu repositories, there are packages for MySQL, PostgreSQL, SQLite and ODBC backends (akonadi-server-{mysql,postgresql,sqlite,odbc}).

The kcm always offers to only pick between mysql and postgresql, regardless of what backends are actually available. This is even if the postgresql backend is not installed at all. Other backends are never listed.

Reproducible: Always

Steps to Reproduce:
1. Install the SQLite backend
2. Remove the PostgreSQL backend
3. kbuildsycoca4
4. kcmshell4 akonadi
5. Open Server Configuration tab and view the Database driver alternatives
Actual Results:  
6. The drop-down menu lists MySQL and PostgreSQL, despite the latter not being installed at all and without mention of SQLite

Expected Results:  
6. The drop-down menu should list the installed MySQL and SQLite backends

I tested this on two different machines and on a new user. Also worthy of mention is that Akonadi is packaged in Kubuntu with the mysql backend as a hard dependency.

I did manage to get it to switch to sqlite by manually modifying the [%General] section of ~/.config/akonadi/akonadiserverrc;

>[%General]
>Driver=QSQLITE3

Opening the kcm now the Database driver menu shows as having an empty selection, and expanding the menu it still lists mysql and postgresql.
Comment 1 JR 2012-04-17 17:06:41 UTC
Created attachment 70458 [details]
Screenshot showing how the kcm is not aware of installed backends
Comment 2 Irenux 2012-05-07 11:52:25 UTC
Same here. I'd like to use Sqlite because MySql is horribly slow.
Comment 3 Denis Kurz 2016-09-24 20:34:46 UTC
This bug has only been reported for versions older than KDEPIM 4.14 (at most akonadi-1.3). Can anyone tell if this bug still present?

If noone confirms this bug for a recent version of akonadi (part of KDE Applications 15.08 or later), it gets closed in about three months.
Comment 4 Denis Kurz 2017-01-07 22:09:45 UTC
Just as announced in my last comment, I close this bug. If you encounter it again in a recent version (at least 5.0 aka 15.08), please open a new one unless it already exists. Thank you for all your input.