misconfiguration results in error message: "Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist"
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
akonadi (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
After cleaning the akonadi configuration in ~/.local/
100517 14:45:14 [Warning] Can't open and lock time zone table: Table 'mysql.
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
ProcVersionSign
Uname: Linux 2.6.32-22-generic i686
NonfreeKernelMo
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
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. time_zone_ leap_second' doesn't exist trying to live without them leon/.local/ share/akonadi/ socket- leon-desktop/ mysql.socket' port: 0 (Ubuntu)
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.
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/