I thought I'd give KMail a shot. I already set up an e-mail account, but never downloaded all of my e-mails. I wanted to do so today, and I was told there is an error when trying to start Akonadi server. I'm not using Bugzilla, because it is something propably simple. I think the best solution would be to purge all KMail's Akonadi data and configuration and start over.

here's the error log:

http://pastebin.ca/1807279

Please replace the content of ~/.local/share/akonadi/mysql.conf with the following, then remove ~/.local/share/akonadi/db_data and try again

Code: Select all

#
#
#
# Global Akonadi MySQL server settings,
#
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
#
#
# Based on advice by Kris K�¶hntopp <kris@mysql.com>
#
#
#
[mysqld]
#
#skip_grant_tables
#
skip_networking
#
 
#
# strict query parsing/interpretation
#
# TODO: make Akonadi work with those settings enabled
#
#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
#
#sql_mode=strict_trans_tables
#
 
#
# use InnoDB for transactions and better crash recovery
#
default_storage_engine=innodb
#
# case-insensitive table names, avoids trouble on windows
#
lower_case_table_names=1
#
character_set_server=latin1
#
collation_server=latin1_general_ci
#
table_cache=200
#
thread_cache_size=3
#
log_bin=mysql-bin
#
expire_logs_days=3
#
#sync_bin_log=0
#
# error log file name, relative to datadir
#
log_error=mysql.err
#
log_warnings=2
#
# log all queries, useful for debugging but generates an enormous amount of data
#
#log=mysql.full
#
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
#
#log_slow_queries=mysql.slow
#
#long_query_time=1
#
# log queries not using indices, debug only, disable for production use
#
#log_queries_not_using_indexes=1
#
# maximum blob size
#
max_allowed_packet=32M
#
max_connections=256
#
# makes sense when having the same query multiple times
#
# makes no sense with prepared statements and/or transactions
#
query_cache_type=0
#
query_cache_size=0
#
 
#
innodb_file_per_table=1
#
innodb_log_buffer_size=1M
#
innodb_additional_mem_pool_size=1M
#
# messure database size and adjust
#
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
#
innodb_buffer_pool_size=80M
#
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
#
innodb_log_file_size=64M
#
innodb_flush_log_at_trx_commit=2

Looks like still the same problem:

http://pastebin.ca/1807868

http://img695.imageshack.us/img695/1522/akonadierr.png

from your test #14:

Code: Select all

Directory listing of '/usr/share/akonadi/agents':
nepomukemailfeeder.desktop

Is kdepim-runtime installed ?

You may also run the command mentioned here: http://userbase.kde.org/Akonadi#Table_. ... .27t_exist that should resolve the test #4 errors.

kdepim-runtime was not installed. Slightly different errors now:

http://pastebin.ca/1808241

These MySQL tips didn't help. This error #4 is still in there.

My /home/warnec/.local/share/akonadi/db_data/mysql.err:

http://pastebin.ca/1808246

'akonadictl start' output:

http://pastebin.ca/1808250

Please remove the folder: $HOME/.local/share/akonadi/db_data

Thanks! Seems to work now. I was sure I've done that, that's why I posted it still doesn't work... Sorry!

Thanks once again for helping me

KDE 4.4.00
Kubuntu 9.10 32-bit

I've done what was identified at http://userbase.kde.org/Akonadi#Table_. ... .27t_exist

I have to manually start the Akonadi Server via the Akonaditray application and then click on Configuration and double-click on Personal Contacts, click OK and OK to get it 'on-line' so my mail contacts are available.

Akonadi Server Self-Test still shows errors at:

Test 4: ERROR
--------

MySQL server log contains errors.
Details: The MySQL server error log file &apos;<a href='/home/paul/.local/share/akonadi/db_data/mysql.err'>/home/paul/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100226 11:41:07 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100226 11:41:07 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 24443, file name ./mysql-bin.000050
100226 11:41:08 InnoDB: Started; log sequence number 0 889092
100226 11:41:08 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100226 11:41:08 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100226 11:41:08 [ERROR] Cannot open mysql.db
100226 11:41:08 [ERROR] Cannot open mysql.user
100226 11:41:08 [ERROR] Cannot open mysql.event
100226 11:41:08 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100226 11:41:08 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log' socket: '/home/paul/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)

I would very much like specific guidance/instructions on how to remedy this. I am of the opinion that properly configured and setup, there should be no reported errors in the self-test.

What can I provide to assist in this?

Well, it appears that I am wrong here. I've tested the following twice, and both times Akonadi started and my Mail Contacts when clicked, displayed as expected.

What I tested:

Close Kontact.
Reboot.
Login (KDM)
When Desktop is present, launch Kontact (K Menu)
Akonadi started - saw the progress bar.
Verified it was running by right-clicking on Akonaditray (System Tray)
Kontact started Mail and KOrganizer.
I allowed KOrganizer notification on the Panel to disappear - a few seconds.
Clicked on Contacts and it displayed as expected without error.
Repeat test. Same results.

So, it all works as expected. However, testing the Akonadi Server still shows:

Test 4: ERROR
--------

MySQL server log contains errors.
Details: The MySQL server error log file &apos;<a href='/home/paul/.local/share/akonadi/db_data/mysql.err'>/home/paul/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100226 16:42:13 [Note] Plugin 'FEDERATED' is disabled.
100226 16:42:14 InnoDB: Started; log sequence number 0 931207
100226 16:42:14 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100226 16:42:14 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100226 16:42:14 [ERROR] Cannot open mysql.db
100226 16:42:14 [ERROR] Cannot open mysql.user
100226 16:42:14 [ERROR] Cannot open mysql.event
100226 16:42:14 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100226 16:42:14 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log' socket: '/home/paul/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)

And this I would still like a remedy for.

Was there any message about and old mysql log? I'm just wondering if this is reporting errors in your old one, rather than the new one. That might be something you could check. If the error doesn't exist in the newest one, just delete the older one.

Giving this a try. Deleted the mysql.err* files (two - mysql.err and mysql.err.old) along with mysql.slow. Going to close Kontact and restart my PC and see what happens when I launch Kontact.

Performed a shutdown (power off). From a cold start, when the desktop was present, I launched Kontact. Did not see the Akonadi status bar indicator, as I have seen previously. Saw KOrganizer and Kmail being started. Switched to the desktop I have Kontact running in and clicked on Contacts. Displayed correctly without the Akonadi error.

.local/share/akonadi/db_data had a 'new' mysql.err file with the following contents:

100227 11:58:03 [Note] Plugin 'FEDERATED' is disabled.
100227 11:58:04 InnoDB: Started; log sequence number 0 1006800
100227 11:58:04 [Warning] Can't open and lock time zone table: Table 'mysql.time
_zone_leap_second' doesn't exist trying to live without them
100227 11:58:04 [ERROR] Can't open and lock privilege tables: Table 'mysql.serve
rs' doesn't exist
100227 11:58:04 [ERROR] Cannot open mysql.db
100227 11:58:04 [ERROR] Cannot open mysql.user
100227 11:58:04 [ERROR] Cannot open mysql.event
100227 11:58:04 [ERROR] Event Scheduler: An error occurred when initializing sys
tem tables.
100227 11:58:04 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log' socket: '/home/paul/.local/share/akonadi/db_misc
/mysql.socket' port: 0 (Ubuntu)

This is of course, from Test #4 on the Akonadi Server Self-Test. So this issue remains. How do I get it resolved?

Have you replaced the contents of mysql.conf as stated here? viewtopic.php?f=20&t=86097#p149114

Yes. Updated the mlocate database (updatedb) and did a locate on the files identified in the error:

100227 11:58:04 [ERROR] Can't open and lock privilege tables: Table 'mysql.serve
rs' doesn't exist
100227 11:58:04 [ERROR] Cannot open mysql.db
100227 11:58:04 [ERROR] Cannot open mysql.user
100227 11:58:04 [ERROR] Cannot open mysql.event

They do not exist on my system. What, and how, were/are they supposed to be created? I'm obviously missing something.

They aren't files, they are tables of a database "mysql" which is used for internal MySQL uses. Did you remove ~/.local/share/akonadi/db_data after replacing your mysql.conf file?