Bug 236535

Version:           1.3.1-3 debian packages (using KDE 4.4.3)
OS:                Linux
Installed from:    Debian testing/unstable Packages

Often, possibly always when I start Kontact the first time after initiating a KDE session I get:

martin@shambhala:~> cat /home/martin/.local/share/akonadi/db_data/mysql.err
100506 10:44:38 [Note] Plugin 'FEDERATED' is disabled.
100506 10:44:39  InnoDB: Started; log sequence number 0 2895515
100506 10:44:40 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100506 10:44:40 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100506 10:44:40 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.45-3-log'  socket: '/home/martin/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Debian)

But when I close Kontact and start another time it usually works. This is since upgrading to KDE 4.4.3. I am not sure for earlier KDE 4.4 version, at least it wasn't that regular.

Expected results:

Akonadi just works without any user interaction whatsoever.


Since the problem does not happen always and there is a /etc/akonadi/mysql-global.conf configuration that Akonadi could use if there is no local one, I just don't believe the following to be a proper fix for the root cause of the problem:

------------------------------------------------------
Table 'mysql. servers' doesn't exist
If MySQL server log contains the following error: 
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[ERROR] Cannot open mysql.db
[ERROR] Cannot open mysql.user
[ERROR] Cannot open mysql.event
then, most probably, you don't have your MySQL configuration file in place. Copy it from /usr/share/config/akonadi/mysql-global.conf into ~/.config/akonadi/mysql-local.conf. (For debian and openSuSE users the file ist located in /etc/akonadi/mysql-global.conf). Then open it and uncomment the line sql_mode=strict_trans_tables. If, after that, you get the following errors: 
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE 
failed.
[ERROR] Unknown/unsupported table type: innodb
[ERROR] Aborting
then in the same file find the line that starts just like the one above (which you have uncommented), but has additional parameters, separated by commas (something like sql_mode=strict_trans_tables,strict_all_tables, ...etc). Comment the shorter sql_mode=... line and uncomment the longer one. 
On openSUSE 11.2 running the command 
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
will fix this problem."
------------------------------------------------------

http://userbase.kde.org/Akonadi_4.4/Troubleshooting#Table_.27mysql._servers.27_doesn.27t_exist

This just seems to be a work-around for me.

So please advise on a proper fix or explain to me why the solution from the wiki page is needed.

I will attach the global Akonadi MySQL configuration from the debian package. If it needs to be adapted, please tell so and I will file a debian bug.

I am using:

martin@shambhala:~> apt-show-versions | egrep "(akonadi|virtuoso|libqt4-gui/|kdelibs5/|kontact|kaddressbook|mysql)"
akonadi-server/sid uptodate 1.3.1-3
akonadiconsole/sid uptodate 4:4.4.3-1
kaddressbook/sid uptodate 4:4.4.3-1
kdelibs5/sid uptodate 4:4.4.3-1
kontact/sid uptodate 4:4.4.3-1
libakonadi-contact4/sid uptodate 4:4.4.3-1
libakonadi-kabc4/sid uptodate 4:4.4.3-1
libakonadi-kcal4/sid uptodate 4:4.4.3-1
libakonadi-kde4/sid uptodate 4:4.4.3-1
libakonadi-kmime4/sid uptodate 4:4.4.3-1
libakonadiprivate1/sid uptodate 1.3.1-3
libaprutil1-dbd-mysql/squeeze uptodate 1.3.9+dfsg-3
libdbd-mysql-perl/squeeze uptodate 4.014-1
libkontactinterface4/sid uptodate 4:4.4.3-1
libmysqlclient16/sid uptodate 5.1.45-3
libqt4-gui/squeeze uptodate 4:4.6.2-4
libqt4-sql-mysql/squeeze uptodate 4:4.6.2-4
mysql-client-5.1/sid uptodate 5.1.45-3
mysql-common/sid uptodate 5.1.45-3
mysql-server-5.1/sid uptodate 5.1.45-3
mysql-server-core-5.1/sid uptodate 5.1.45-3
php5-mysql/squeeze uptodate 5.3.2-1
virtuoso-minimal/sid uptodate 6.1.1+dfsg1-1
virtuoso-opensource-6.1-bin/sid uptodate 6.1.1+dfsg1-1
virtuoso-opensource-6.1-common/sid uptodate 6.1.1+dfsg1-1