misconfiguration results in error message: "Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist"

[Matthias Kretz]

After cleaning the akonadi configuration in ~/.local/share/akonadi and ~/.config/akonadi the resulting default configuration results in the following entries in the MySQL error log on Akonadi startup:

100517 14:45:14 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100517 14:45:14 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

AFAIU this is not fatal for Akonadi itself but it considers this as problematic, thus refusing to work properly (graying out KAdressbook or telling me that I don't have any writable resources).

Additionally I sometimes get a report that no resource agents were found. Next time it's good again... I don't know if this might be related or if it's a race condition in Akonadi itself - and thus an upstream issue.

ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: akonadi-server 1.3.1-0ubuntu3
ProcVersionSignature: Ubuntu 2.6.32-22.33-generic 2.6.32.11+drm33.2
Uname: Linux 2.6.32-22-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Mon May 17 18:53:10 2010
InstallationMedia: Kubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100427)
ProcEnviron:
 LANGUAGE=
 LANG=en_US.UTF-8
 SHELL=/bin/zsh
SourcePackage: akonadi

[Leon Maurer (leon-n-maurer)]

I'm still getting this error using KDE 4.8.0

Here's '~.local/share/akonadi/db_data/mysql.err':

120204 16:58:13 [Note] Plugin 'FEDERATED' is disabled.
120204 16:58:13 InnoDB: Initializing buffer pool, size = 80.0M
120204 16:58:13 InnoDB: Completed initialization of buffer pool
120204 16:58:14 InnoDB: Started; log sequence number 0 330511055
120204 16:58:14 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120204 16:58:14 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120204 16:58:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.58-1ubuntu1' socket: '/home/leon/.local/share/akonadi/socket-leon-desktop/mysql.socket' port: 0 (Ubuntu)

[Launchpad Janitor (janitor)]

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

[Peter Snow (peter-x8o)]

For me I've found the solution.

A few of the directories below "~/.local/share/akonadi/db_data/" were owned by mysql and they needed to be owned by the current user.

sudo chown -R your-user-name:your-user-name /home/your-user-name/.local/share/akonadi/db_data/