KDE-Forum.org

I have tried now many ways to get Akonadi to start after my upgrade to KDE 4.8, to no avail.

I have wiped my account, tried with a new one, and still it does not start. After some debugging, this is what I know:
- system is kubuntu 11.10 oneiric, with the kubuntu-backports ppa

$ dpkg -l | grep akonadi
ii akonadi-backend-mysql 1.7.0-0ubuntu1~oneiric1~ppa2 MySQL storage backend for Akonadi
ii akonadi-backend-sqlite 1.7.0-0ubuntu1~oneiric1~ppa2 SQLite storage backend for Akonadi
ii akonadi-server 1.7.0-0ubuntu1~oneiric1~ppa2 Akonadi PIM storage service
ii akonadiconsole 4:4.8.0a-0ubuntu2~oneiric1~ppa1 management and debugging console for akonadi
ii kdepim-runtime 4:4.8.0a-0ubuntu1~oneiric1~ppa1 Runtime components for akonadi-kde
ii libakonadi-calendar4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library providing calendar helpers for Akonadi items
ii libakonadi-contact4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library for using the Akonadi PIM data server
ii libakonadi-kabc4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library for using the Akonadi PIM data server
ii libakonadi-kcal4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library for using the Akonadi PIM data server
ii libakonadi-kde4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library for using the Akonadi PIM data server
ii libakonadi-kmime4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library for using the Akonadi PIM data server
ii libakonadi-notes4 4:4.8.0a-0ubuntu1~oneiric1~ppa1 library providing notes helpers for Akonadi items
rc libakonadiprivate1 1.4.0-0ubuntu1 libraries for the Akonadi PIM storage service
ii libakonadiprotocolinternals1 1.7.0-0ubuntu1~oneiric1~ppa2 libraries for the Akonadi PIM storage service

I have also wiped the Akonadi info a few times, with
rm -rf ~/.local/share/akonadi ~/.config/akonadi ~/.kde/share/config/akonadi*


But when I try to start it, it fails with a strange error:
$ akonadictl start
Starting Akonadi Server...
done.
fleury@fuji:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths: ("/store/home/fleury/bin", "/usr/local/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/store/home/fleury/.local/share/akonadi/mysql.conf", "--datadir=/store/home/fleury/.local/share/akonadi/db_data/", "--socket=/store/home/fleury/.local/share/akonadi/socket-fuji/mysql.socket")
stdout: ""
stderr: "Could not open required defaults file: /store/home/fleury/.local/share/akonadi/mysql.conf
Fatal error in defaults handling. Program aborted
120304 23:07:45 [Warning] Can't create test file /store/home/fleury/.local/share/akonadi/db_data/fuji.lower-test
120304 23:07:45 [Warning] Can't create test file /store/home/fleury/.local/share/akonadi/db_data/fuji.lower-test
120304 23:07:45 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
120304 23:07:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120304 23:07:45 InnoDB: Initializing buffer pool, size = 8.0M
120304 23:07:45 InnoDB: Completed initialization of buffer pool
120304 23:07:45 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x44f594]
1: akonadiserver() [0x44f92c]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36420) [0x7f9788be5420]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f9788be53a5]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b) [0x7f9788be8b0b]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x11b) [0x7f978a69b5cb]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x92) [0x451962]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xaf) [0x7f978a7374af]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x118a82) [0x7f978a742a82]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f978a74b919]
10: akonadiserver(_ZN6QDebugD1Ev+0x46) [0x448da6]
11: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x18e3) [0x4d52c3]
12: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xd1) [0x452781]
13: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xb1) [0x453f41]
14: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x37) [0x455587]
15: akonadiserver(main+0x26a) [0x4482ea]
16: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f9788bd030d]
17: akonadiserver() [0x448c31]
]
"

I have tried to track this down, it seems that the mysql_install_db call does not work properly. I have removed/reinstalled mysql-server-5.1 and still get the same failure. I can access the directory in which it tried to create files from user 'nobody', and have tried with both mysqld and mysqld-akonadi (that exist on my system, no reason why).

Any clues of what should be done in this case ? Obviously, it prevents all parts of Kontact of being of any use...