[Kde-pim] Akonadi mysql deployment issue on openSUSE

[Ben Cooksley]

On Thu, Jan 21, 2010 at 1:49 PM, Will Stephenson <wstephenson at kde.org> wrote:
> 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.
>

I have helped numerous users correct their system with this command
also, which can be especially hard with systems like Apparmor and
SELinux enabled.

Is it possible to have this fixed for 4.4.0?

Regards,
Ben
KDE Forums Administrator
_______________________________________________
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/