The problem is the missing "mysql" database I believe.

Someone recently reported on our IRC channel that the following command made it work for them:

mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/

Cheers,
_

And it worked as well for me. Thanks a lot !

Thanks, this did solve the problem for me, too (Kubuntu 9.10)

First I was not sure in which order to apply the steps mentioned in this thread. So in case other users are confused about this, too:

- First delete $HOME/.local/share/akonadi including all subfolders
- Manually start Akonadi via System Settings
- mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ (this will throw a bunch of error messages. Just ignore them.)
- mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
- shutdown and start Akondi again.

I tried the steps described above, but i get an error (other than the usual ones mentioned) after the mysql_install_db command

Code: Select all

mysql_install_db --datadir=/home/philipp/.local/share/akonadi/db_data/
Installing MySQL system tables...
091115 13:09:53 [Warning] Can't create test file /home/philipp/.local/share/akonadi/db_data/philuntu.lower-test
091115 13:09:53 [Warning] Can't create test file /home/philipp/.local/share/akonadi/db_data/philuntu.lower-test
ERROR: 1005  Can't create table 'db' (errno: 13)
091115 13:09:53 [ERROR] Aborting

091115 13:09:53 [Warning] Forcing shutdown of 2 plugins
091115 13:09:53 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/home/philipp/.local/share/akonadi/db_data/ for more information.


Could be a variant of this issue:
http://userbase.kde.org/Akonadi#Apparmor

Cheers,
_

Well, i did everything mentioned there about the apparmor issue, then tried the above steps again. The mysql_install_db command fails with the same error message, anyway, i executed the mysql_update command and that seemed to work, akonadi's selftest now succeeds.

Thanks!

anda_skoa wrote:Someone recently reported on our IRC channel that the following command made it work for them:

mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/

Cheers,
_

Having followed the thread up to here I got akonadi-1.2.1_1 running without errors.

But after reboot same old errors regarding d-bus are back.

KDE4.3.4@FreeBSD 8.0-RELEASE-p2

iskarion wrote:- First delete $HOME/.local/share/akonadi including all subfolders
- Manually start Akonadi via System Settings
- mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/ (this will throw a bunch of error messages. Just ignore them.)
- mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket
- shutdown and start Akondi again.

That worked here on lucid beta too. It seems that mysql_install_db with datadir won't work until you've upgraded it. But you'll have to give it the dir before upgrading. So just like Iskarion said.. Just ignore all errors that mysql_install_db gives...
+m

Hmm - I missed the fact that it is kubuntu. I've read elsewhere that the mysql package as shipped caused problems, so these suggestions make sense to me.

After ignoring the Akonadi server never starting since I built KDE SC from trunk on Kubuntu 10.04 Lucid. But, now I need to use it, so trying to troubleshoot. Following advices all over the Internet, I tried things-

1. Tried AppArmor fix, didn't help
2. Deleted .local/share/akonadi and executed "mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/", output at http://pastebin.com/TgcJW7xB
3. Executing "mysql_upgrade --socket=$HOME/.local/share/akonadi/db_misc/mysql.socket" gives the output - http://pastebin.com/KXCfqWXL
The above is due to the fact that there is no dir called db_misc there, just db_data . How do I regenerate that?

Thanks

That error is because Akonadi's own mysqld instance is not running. This instance is started by Akonadi on startup, and shutdown by it when Akonadi shuts down. All that should be needed to get Akonadi running now is running "akonadictl start"

I tried to start it and then it reports these errors http://pastebin.com/JwJrRkAd
Weird why its trying to access mysql as root. Or is it normal ?

Then, I tried to run the mysql_install_db thingy which again gave the same output, and even mysql_upgrade gives the same errors.

Please check the contents of ~/.config/akonadi/akonadiserverrc

Its content should look like follows:

Code: Select all

[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=
User=
Password=
ServerPath=/usr/sbin/mysqld
StartServer=true
Host=
Options=

[Debug]
Tracer=null

Note that the ServerPath may vary, and need not be changed as long as it is pointing at a valid mysqld binary ( running <path> --version should confirm this )

The file's contents on my system reads-

Code: Select all

[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=akonadi
Host=
ServerPath=/usr/sbin/mysqld
StartServer=true
Options="UNIX_SOCKET=/home/hunny/kde/share/akonadi/db_misc/mysql.socket"

[Debug]
Tracer=null

Is it fine, or do I need to change something? Also, after a reboot, akonadictl status now shows the server running, but even then if I run a PIM app (say, Kontact) it starts kres-migrator which displays "Starting Akonadi Server" endlessly.

I tried akonadictl stop followed by akonadictl start which says http://pastebin.com/8GZsnD4p and the directory .local/share/akonadi/db_misc still doesn't exist. I've no idea about what .socket file it requires (or why its used for mysql) or I'd create it myself. Any hints?