On Friday 13 August 2010 08:30:11 C. Brouerius van Nidek wrote:
After I have been pestered long enough by Nepomuk, even if it should not work, I finally decided to let it run. Problem up to now, the results of the akonadi test which can be only dealt with by closing the info window after which I have to restart KMail again. Now the box of Nepomuk is ticked and I would expect to get the akonadi/nepomuk thingy to work. I still get the akonadi test with the info that there is an error after which I have to close the program and restart kmail in order to write this email to the list.
The error information is as follows:
100813 13:18:08 [Note] Plugin 'ndbcluster' is disabled. 100813 13:18:08 InnoDB: Started; log sequence number 0 548330 100813 13:18:08 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 100813 13:18:08 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 100813 13:18:08 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.46' socket: '/home/constant113/.local/share/akonadi/db_misc/mysql.socket' port: 0 SUSE MySQL RPM
I am not able to understand this cryptic info. Could somebody help me out with a translation in plain english?
KMail now uses Akonadi for address book lookups. Akonadi uses a database as a cache for the data it provides access to. We discovered during the development of 11.3 that the MySQL we ship requires an extra initialization step than was porvided by Akonadi, and added a patch to perform this initialization if needed on startup. I'm not sure why you are still getting this error if you are using the distro and KDE mentioned in your signature. Even if you imported your $HOME from a previous installation or KDE version, it should create the mysql.* tables that the errors above mention. You should be able to fix the error by either: (purge the akonadi cache and allow it to be regenerated) 1) quit kmail, kontact, korganizer, kaddressbook etc 2) do "akonadictl stop" 3) rm -rf ~/.local/share/akonadi ~/.config/akonadi 4) start kmail or (fix the existing setup) 1) "mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data" Please let me know if you still have problems after carrying out either of these. Will -- Will Stephenson, KDE Developer, openSUSE Boosters Team SUSE LINUX Products GmbH - Nürnberg - AG Nürnberg - HRB 16746 - GF: Markus Rex -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org