I noticed today that although the akonadi server icon is in the system tray, the server itself is not running. When I try to start it, I get a bunch of errors, inclduing one that says, "Unknown Error (could not create collection)".
Looking through the test panel, I see a message that says, "Mysql server log contains errors." Tracing this out, I get the following:

Code: Select all

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

So, the box says to read userbase.kde.org/Akonadi, which I did, and found a section describing exactly those errors. I followed these instructions:

Table 'mysql. servers' doesn't exist

If MySQL server log contains the following error:

[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
[ERROR] Cannot open mysql.db
[ERROR] Cannot open mysql.user
[ERROR] Cannot open mysql.event
then, most probably, you don't have your MySQL configuration file in place. Copy it from /usr/share/config/akonadi/mysql-global.conf into ~/.config/akonadi/mysql-local.conf. (For debian users the file ist located in /etc/akonadi/mysql-global.conf). Then open it and uncomment the line sql_mode=strict_trans_tables. If, after that, you get the following errors:

[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
[ERROR] Unknown/unsupported table type: innodb
[ERROR] Aborting
then in the same file find the line that starts just like the one above (which you have uncommented), but has additional parameters, separated by commas (something like sql_mode=strict_trans_tables,strict_all_tables, ...etc). Comment the shorter sql_mode=... line and uncomment the longer one.

I tried copying over the file specified, and making the changes suggested, but no luck. It just crashes on startup.

Although the systray icon says akonadi is running, it clearly is not working. A calendar resource does not show any data in Korganizer, but when the calendar is loaded as a local file, it works. So akonadi may be running, but non-functional. Here is the output from starting akonadi manually:

Code: Select all

greenman@Wolfenstein:~$ akonadictl start
Starting Akonadi Server...             
   done.                               
greenman@Wolfenstein:~$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()                                                   
[akonadiserver] checking table  "SchemaVersionTable"                                   
[akonadiserver] checking table  "ResourceTable"                                       
[akonadiserver] checking table  "CollectionTable"                                     
[akonadiserver] checking table  "MimeTypeTable"                                       
[akonadiserver] checking table  "PimItemTable"                                         
[akonadiserver] checking table  "FlagTable"                                           
[akonadiserver] checking table  "PartTable"                                           
[akonadiserver] checking table  "CollectionAttributeTable"                             
[akonadiserver] checking relation  "PimItemFlagRelation"                               
[akonadiserver] checking relation  "CollectionMimeTypeRelation"                       
[akonadiserver] checking relation  "CollectionPimItemRelation"                         
[akonadiserver] DbInitializer::run() done                                             
[akonadiserver] skipping update 2                                                     
[akonadiserver] skipping update 3                                                     
[akonadiserver] skipping update 4                                                     
[akonadiserver] skipping update 8                                                     
[akonadiserver] skipping update 10                                                     
[akonadiserver] skipping update 12                                                     
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                       
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                       
[akonadiserver] Nepomuk QueryServer interface not available!                           
PLUGINS:  "/usr/share/akonadi/agents"                                                 
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop",
"imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop",
kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop",
"microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop",
"nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop",
"vcarddirresource.desktop", "vcardresource.desktop")                                                                             
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource")                                                       
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")                                                         
PLUGINS inserting:  "akonadi_ical_resource" 2 ("Resource")                                                             
PLUGINS inserting:  "akonadi_imap_resource" 0 ("Resource")                                                             
PLUGINS inserting:  "akonadi_kabc_resource" 0 ("Resource")                                                             
PLUGINS inserting:  "akonadi_kcal_resource" 0 ("Resource")                                                             
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 3 ("Resource")
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop",
"imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop",
"kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop",
"microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop",
"nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop",
"vcarddirresource.desktop", "vcardresource.desktop")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry
'0-akonadi_ical_resource_1' for key 'parentAndNameIndex' QMYSQL3: Unable to execute statement"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

Hmm.

Try this:

shut down Akonadi and check that the mysql process for the current user has also been stopped.
The run this
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/

Seems to help other people with problems after upgrades.

Cheers,
_

That seems to have fixed it. Thank You!

also see here:
http://userbase.kde.org/Akonadi_4.4/Tro ... .4_Upgrade
chapter "Kubuntu 10.4 Upgrade"

Kubuntu 9.10. I ill-advisedly attempted to fix this same problem by upgrading to 4.4, only to make things worse.

Now, what is to be done if there is NO /usr/share/config/ (let alone an /akonadi/ subfolder) folder from which to copy the mysql-global.conf file?

I do not doubt that my upgrade (from the KDE backports) has messed this all up. This all came about because of another problem, floundering about, trying to find out why KDM wouldn't start the X-server, with no obvious reason not to.

Thanks for any assistance.

The following is a copy of the Akonadi Server MySQL configuration file ( mysql-global.conf ) from trunk.

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

# Do not drop the connection to the DB after 8 hours of inactivity
wait_timeout=1296000

Thank you for all the suggestions and references. Akonadi, MySQL seem to be working; I haven't tried Nepomuk, but best of all, KMail is working. However, strangely enough, although sound was working before when Akonadi wasn't, now the sound isn't, and I can't bring up KMixer either. Phonon does still try to tell me that I should remove any number of devices every so often when I boot it up, but it did that before. However, it just occurred to me that I may have been getting the sound to work before because I was running as root, the only way it would boot up, as I was having the bin/bash: /dev/null permission denied symptom. I found that the upgrade (even though no errors were reported) had removed the 50-udev-default.rules file in /lib/udev/rules.d. Copying that from my installation of the GDE ubuntu 9.10 version fixed that, and I have been able to log on (startx only, KDM still not working), so I will check that out. However, Googling has suggested that this is a very common problem, so I'm not very sanguine about that. Any suggestions would be very welcome.

Kontact worked perfectly for me in Ubuntu 9.04 and 9.10. When I upgraded to 10.4 and run kontact, the calendar runs fine but I lost thousands of names in my address book. I backed up the .kde folder and subfolder before upgrading. The error messages are posted below. Any suggestions?

Akonadi Server Self-Test Report
===============================

Test 1: SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration and was found on your system.

File content of '/home/denis/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=akonadi
User=
Password=
Options="UNIX_SOCKET=/home/denis/.local/share/akonadi/db_misc/mysql.socket"
ServerPath=/usr/sbin/mysqld-akonadi
StartServer=true
Host=

[Debug]
Tracer=null


Test 2: SUCCESS
--------

MySQL server found.
Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/mysqld-akonadi'.
Make sure you have the MySQL server installed, set the correct path and ensure you have the necessary read and execution rights on the server executable. The server executable is typically called 'mysqld', its locations varies depending on the distribution.

Test 3: SUCCESS
--------

MySQL server is executable.
Details: MySQL server found: /usr/sbin/mysqld-akonadi Ver 5.1.41-3ubuntu11 for debian-linux-gnu on i486 ((Ubuntu))


Test 4: SUCCESS
--------

MySQL server log contains no errors.
Details: The MySQL server log file &apos;<a href='/home/denis/.local/share/akonadi/db_data/mysql.err'>/home/denis/.local/share/akonadi/db_data/mysql.err</a>&apos; does not contain any errors or warnings.

File content of '/home/denis/.local/share/akonadi/db_data/mysql.err':
100620 18:04:19 [Note] Plugin 'FEDERATED' is disabled.
100620 18:04:20 InnoDB: Started; log sequence number 0 124846
100620 18:04:21 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.41-3ubuntu11-log' socket: '/home/denis/.local/share/akonadi/db_misc/mysql.socket' port: 0 (Ubuntu)


Test 5: SUCCESS
--------

MySQL server default configuration found.
Details: The default configuration for the MySQL server was found and is readable at <a href='/etc/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.

File content of '/etc/akonadi/mysql-global.conf':
#
# 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



Test 6: SKIP
--------

MySQL server custom configuration not available.
Details: The custom configuration for the MySQL server was not found but is optional.

Test 7: SUCCESS
--------

MySQL server configuration is usable.
Details: The MySQL server configuration was found at <a href='/home/denis/.local/share/akonadi/mysql.conf'>/home/denis/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/home/denis/.local/share/akonadi/mysql.conf':
#
# 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



Test 8: SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
Result:
Akonadi 1.3.1


Test 9: SUCCESS
--------

Akonadi control process registered at D-Bus.
Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.

Test 10: SUCCESS
--------

Akonadi server process registered at D-Bus.
Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.

Test 11: SUCCESS
--------

Nepomuk search service registered at D-Bus.
Details: The Nepomuk search service is registered at D-Bus which typically indicates it is operational.

Test 12: SUCCESS
--------

Nepomuk search service uses an appropriate backend.
Details: The Nepomuk search service uses one of the recommended backends.

Test 13: SUCCESS
--------

Server protocol version is recent enough.
Details: The server Protocol version is 23, which equal or newer than the required version 23.

Test 14: ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents /usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/share/gnome:/usr/local/share/:/usr/share/', make sure this includes all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop
Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/share/gnome:/usr/local/share/:/usr/share/'

Test 15: SUCCESS
--------

No current Akonadi server error log found.
Details: The Akonadi server did not report any errors during its current startup.

Test 16: ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous startup into <a href='/home/denis/.local/share/akonadi/akonadiserver.error.old'>/home/denis/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/denis/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!


Test 17: SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.

Test 18: SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous startup.

That error message is caused by the self-test not waiting for Akonadi to fully start. This bug is fixed in KDE 4.5. Please start Akonadi by running "akonadictl start" prior to opening Kontact as a temporary workaround.

The "akonadictl start" did in fact allow the address portion of Kontact to open without the error. But there are no names or addresses present. So now I need to know which files contained this information in 9.10, and where to copy them in 10.4 to restore all my contact addresses and phone numbers.

Please read the UserBase pages for Akonadi and KAddressBook, including the pages linked from them.

Procedure: found the following files in /home/xxxxx/.kde/share/apps/kabc/
distlists
std.vcf
std.vcf_0
std.vcf_1
std.vcf_2
std.vcf_3
std.vcf_4
std.vcf_5
std.vcf_6
std.vcf_7
created new directory: /home/xxxxx/.kde/share/apps/kabc/stdvcf/
Moved all files from /kabc to /kabc/stdvcf/ directory.
From command line every day, run akonadictl start
Result: Working properly.