[Kde-pim] Akonadi mysql deployment issue on openSUSE

[laurent Montel]

Le Jeudi 21 Janvier 2010 01:49:21, Will Stephenson a écrit :
> 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.

Hi,
I had the same errors on my kubuntu. Your command fixed it thanks.
 Regards

-- 
Laurent Montel | laurent at kdab.com | KDE/Qt Senior Software Engineer
Klarälvdalens Datakonsult AB, a KDAB Group company
Tel. Sweden (HQ) +46-563-540090, USA +1-866-777-KDAB(5322)
KDAB - Qt Experts - Platform-independent software solutions
_______________________________________________
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/