Arch Linux

jithin1987

Member

From: Bangalore

Registered: 2009-09-12

Posts: 182

[solved] akonadi does not have mysql db

Hi,
I noticed that my akonadi logs keeps telling me that
091022  8:55:18 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
091022  8:55:18 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

I connected to the askonadi mysqld socket and looked at the db's. it didnot have a mysql db.

jithine ~  $ mysql -S /home/jithine/.local/share/akonadi/db_misc/mysql.socket -u jithine
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.39-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| akonadi            |
+--------------------+
2 rows in set (0.00 sec)

mysql> Bye
jithine ~  $ mysql -S /home/jithine/.local/share/akonadi/db_misc/mysql.socket -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.1.39-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| akonadi            |
+--------------------+
2 rows in set (0.00 sec)

mysql>

Has anyone noticed this. How is it working w/o mysql database.
In the .local/share/akonadi/mysql.conf I can see that the settings have been repeated 3 times

Last edited by jithin1987 (2009-12-09 00:06:41)

---

Thanks
Jithin

axel

Member

Registered: 2007-12-10

Posts: 77

Re: [solved] akonadi does not have mysql db

I also get the same error message. Did you find any solution?

Edit: Solved

http://forum.kde.org/viewtopic.php?f=20&t=83092

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

Last edited by axel (2009-12-08 22:16:03)