[Kde-pim] Akonadi mysql deployment issue on openSUSE

[Will Stephenson]

Testing our KDE SC 4.4 packages on openSUSE 11.2, with mysql 5.1.36, a new 
user account gets the following errors on Akonadi startup:

100120 15:54:59 [ERROR] Can't open and lock privilege tables: Table 
'mysql.servers' doesn't exist
100120 15:54:59 [ERROR] Cannot open mysql.db
100120 15:54:59 [ERROR] Cannot open mysql.user
100120 15:54:59 [ERROR] Cannot open mysql.event
100120 15:54:59 [ERROR] Event Scheduler: An error occurred when initializing 
system tables.

This is addressed by the userbase article here: 
http://userbase.kde.org/Akonadi#Table_.27mysql._servers.27_doesn.27t_exist

However the suggested remedy (sql_mode=strict_trans_tables in local 
mysql.conf) doesn't work.  In fact I fail to see why this is suggested, unless 
it assumes the user had previously run akonadi with an older mysql version 
that requires some table translation...

So

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

clears the error. 

The default akonadi-installed mysqld.conf uses the skip-grant-tables options 
which should (IIUC) mean that the mysql.* tables are not important.  This 
could be disabled at mysql build time by  --disable-grant-options, but this 
option is not used by the openSUSE build. 

Anyone else understand why mysql is getting upset here?

Will
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/