Comment 16 for bug 448705

Revision history for this message
Dennis Schridde (devurandom) wrote :

1) sudo aptitude install mysql-server-5.1
2) Add the following to /etc/apparmor.d/usr.sbin.mysqld and /etc/apparmor.d/usr.sbin.mysqld-akonadi
  @{HOME}/.local/share/akonadi/ rw,
  @{HOME}/.local/share/akonadi/** rwk,
3) sudo service apparmor restart
4) akonadictl stop
5) rm -r .local/share/akonadi/ .config/akonadi/ .kde/share/config/akonadi_*
6) mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
7) akonadictl start

The error following messages are now *gone* from mysql.err:
100327 12:30:43 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100327 12:30:43 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

But there seems to be another issue, maybe related to the sloppy db creation process, when trying to synchronise the akonadi_imap_resource:
[/usr/bin/akonadi_imap_resource] akonadi_imap_resource_0(9320) ImapResource::onIdleCollectionFetchDone: CollectionFetch for mail box "INBOX" failed. error= 103 , errorString= "Unknown error. (Hierarchical RID does not specify a unique collection)"