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)"
1) sudo aptitude install mysql-server-5.1 d/usr.sbin. mysqld and /etc/apparmor. d/usr.sbin. mysqld- akonadi /.local/ share/akonadi/ rw, /.local/ share/akonadi/ ** rwk, share/akonadi/ .config/akonadi/ .kde/share/ config/ akonadi_ * $HOME/. local/share/ akonadi/ db_data/
2) Add the following to /etc/apparmor.
@{HOME}
@{HOME}
3) sudo service apparmor restart
4) akonadictl stop
5) rm -r .local/
6) mysql_install_db --datadir=
7) akonadictl start
The error following messages are now *gone* from mysql.err: time_zone_ leap_second' doesn't exist trying to live without them
100327 12:30:43 [Warning] Can't open and lock time zone table: Table 'mysql.
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: akonadi_ imap_resource] akonadi_ imap_resource_ 0(9320) ImapResource: :onIdleCollecti onFetchDone: CollectionFetch for mail box "INBOX" failed. error= 103 , errorString= "Unknown error. (Hierarchical RID does not specify a unique collection)"
[/usr/bin/