Announcement

**vinnywright** · Feb 13, 2010, 02:24 PM

Re: KDE 4.4.0 Akonadi Server

I just did this

http://socceroosd.blogspot.com/2010/...d-nepomuk.html

befor ever trying to enabel it in systemsettings>advanced>desktop search then......K>applacations>utillitys>Akonadi tray utillity and use that to start the server

and it just worked.

VINNY

**Snowhog** · Feb 13, 2010, 03:13 PM

Re: KDE 4.4.0 Akonadi Server

Long post, but has all the details.

Click on Akonaditray from K > Utilities

Right-click the Akonadi System Tray icon and click on Configure. Akonadi Configuration - KDE Control Module opens and on the Akonadi Resouces
Configuration tab a red square with a white X and the text 'Akonadi not operational. Details...'

Click on Details and one sees:

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/paul/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

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

[Debug]
Tracer=null

[QPSQL]
Name=akonadi
Host=
User=
Password=
Port=5432

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.37-1ubuntu5 for debian-linux-gnu on i486 ((Ubuntu))

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

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

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100213 10:18:43 [Note] Plugin 'FEDERATED' is disabled.
100213 10:18:44 InnoDB: Started; log sequence number 0 293013
100213 10:18:44 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 10:18:44 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 10:18:44 [ERROR] Cannot open mysql.db
100213 10:18:44 [ERROR] Cannot open mysql.user
100213 10:18:44 [ERROR] Cannot open mysql.event
100213 10:18:44 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100213 10:18:44 [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)
100213 11:27:23 [Note] /usr/sbin/mysqld-akonadi: Normal shutdown

100213 11:27:23 InnoDB: Starting shutdown...
100213 11:27:25 InnoDB: Shutdown completed; log sequence number 0 329341
100213 11:27:25 [Warning] Forcing shutdown of 1 plugins
100213 11:27:25 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete

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,st rict_error_for_division_by_zero,no_auto_create_use r,no_auto_value_on_zero,no_engine_substitution,
no_zero_date,no_zero_in_date,only_full_group_by,pi pes_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/paul/.local/share/akonadi/mysql.conf'>/home/paul/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/home/paul/.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,st rict_error_for_division_by_zero,no_auto_create_use r,no_auto_value_on_zero,no_engine_substitution,
no_zero_date,no_zero_in_date,only_full_group_by,pi pes_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: ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 10: ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

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: SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

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:/usr/share:/usr/local/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:/usr/share:/usr/local/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/paul/.local/share/akonadi/akonadiserver.error.old'>/home/paul/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/paul/.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.

Click on Akonadi Server Configuration tab.
Database driver Mysql
Use internal MySQL server is checked
MySQL server executable: /usr/sbin/mysqld-akonadi

Status reports 'The Akonadi server is not running.'

I click on the Start button.
Status now reports 'The Akonadi server is running' but a Mail Dispather Agent - AkonadiTray popup reports:

Could not access the outbox folder (Unknown error. (Could not fetch root collection of resource akonadi_maildir_resource_0)).

Click on OK which is all you can do.

Click the Test... button (Akonadi Configuration - KDE Control Module). Results of test:

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/paul/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

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

[Debug]
Tracer=null

[QPSQL]
Name=akonadi
Host=
User=
Password=
Port=5432

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.37-1ubuntu5 for debian-linux-gnu on i486 ((Ubuntu))

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

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

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100213 11:53:02 [Note] Plugin 'FEDERATED' is disabled.
100213 11:53:02 InnoDB: Started; log sequence number 0 329341
100213 11:53:02 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 11:53:02 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 11:53:02 [ERROR] Cannot open mysql.db
100213 11:53:02 [ERROR] Cannot open mysql.user
100213 11:53:02 [ERROR] Cannot open mysql.event
100213 11:53:02 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100213 11:53:02 [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)

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,st rict_error_for_division_by_zero,no_auto_create_use r,no_auto_value_on_zero,no_engine_substitution,
no_zero_date,no_zero_in_date,only_full_group_by,pi pes_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/paul/.local/share/akonadi/mysql.conf'>/home/paul/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/home/paul/.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,st rict_error_for_division_by_zero,no_auto_create_use r,no_auto_value_on_zero,no_engine_substitution,
no_zero_date,no_zero_in_date,only_full_group_by,pi pes_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: SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

Test 14: SUCCESS
--------

Resource agents found.
Details: At least one resource agent has been found.

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:/usr/share:/usr/local/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: SUCCESS
--------

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

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.

Down now to one reported ERROR and some SKIPPED tests. It appears to revolve around MySQL not being installed? I'm in no way a MySQL expert, so I'd like some assistance on this. What I want to achieve: To have the Akonadi Server Self-Test report no errors and perform all required tests - no skipped tests as a result of 'errors.'

So, you experts out there, what do I need to do here?

**Snowhog** · Feb 13, 2010, 03:53 PM

Re: KDE 4.4.0 Akonadi Server

Synaptic shows me that mysql-server-core-5.1 is installed - makes sense, and the description includes:

This package includes the core server files, as used by Akonadi.

Hmm.

**vinnywright** · Feb 13, 2010, 04:02 PM

Re: KDE 4.4.0 Akonadi Server

not shure as I sead I just did the comands in the link in my first post then sarted enabeling things

I still get 2 errors but it works ........if you would like to see eney files on my sys just ask but just what youd nead to see I dont know.

[img width=400 height=300]http://i29.photobucket.com/albums/c291/vinnywright/aconadi2.png[/img]

[img width=400 height=300]http://i29.photobucket.com/albums/c291/vinnywright/aconadi1.png[/img]

[img width=400 height=300]http://i29.photobucket.com/albums/c291/vinnywright/aconadi.png[/img]

VINNY

**Snowhog** · Feb 13, 2010, 04:41 PM

Re: KDE 4.4.0 Akonadi Server

Akonadi - KDE UserBase - Folder not found: "/Local"

Many people have reported this error, when Kontact would not start. There seems to be a bug in the migration that is telling KMail to look for local mail in /home/anne/.local/share/Local, a directory that had not been set up. The cure for this is not to attempt to correct it, but, with KMail/Kontact closed, to open the Akonadi Console (user krunner, Alt-F2, or 'akonadiconsole' in konsole), and remove the resource that it says is for local mail. You should now find that you can start Kontact or KMail, and that a new resource will be created, pointing to /home/anne/.local/share/local-mail

Followed this and that particular error is now gone. Akonadi still reports an error with MySQL however:

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

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

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100213 13:28:24 [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!
100213 13:28:24 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 43703, file name ./mysql-bin.000014
100213 13:28:24 InnoDB: Started; log sequence number 0 371355
100213 13:28:24 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 13:28:24 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 13:28:24 [ERROR] Cannot open mysql.db
100213 13:28:24 [ERROR] Cannot open mysql.user
100213 13:28:24 [ERROR] Cannot open mysql.event
100213 13:28:24 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100213 13:28:24 [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)

paul@myotherbrain:~/.local/share/akonadi/db_data$ ls -l

total 141832
drwx------ 2 paul paul 4096 2010-02-10 22:59 akonadi
-rw-rw---- 1 paul paul 10485760 2010-02-13 13:29 ibdata1
-rw-rw---- 1 paul paul 67108864 2010-02-13 13:29 ib_logfile0
-rw-rw---- 1 paul paul 67108864 2010-02-10 22:59 ib_logfile1
-rw-rw---- 1 paul paul 5 2010-02-13 13:28 myotherbrain.pid
-rw-rw---- 1 paul paul 7804 2010-02-10 23:29 mysql-bin.000003
-rw-rw---- 1 paul paul 3261 2010-02-11 20:02 mysql-bin.000004
-rw-rw---- 1 paul paul 12819 2010-02-11 20:15 mysql-bin.000005
-rw-rw---- 1 paul paul 33048 2010-02-11 20:38 mysql-bin.000006
-rw-rw---- 1 paul paul 75347 2010-02-11 21:53 mysql-bin.000007
-rw-rw---- 1 paul paul 2840 2010-02-12 18:51 mysql-bin.000008
-rw-rw---- 1 paul paul 1933 2010-02-12 20:32 mysql-bin.000009
-rw-rw---- 1 paul paul 11329 2010-02-12 21:26 mysql-bin.000010
-rw-rw---- 1 paul paul 2767 2010-02-12 22:35 mysql-bin.000011
-rw-rw---- 1 paul paul 2767 2010-02-12 23:16 mysql-bin.000012
-rw-rw---- 1 paul paul 35784 2010-02-13 11:27 mysql-bin.000013
-rw-rw---- 1 paul paul 43722 2010-02-13 13:24 mysql-bin.000014
-rw-rw---- 1 paul paul 6480 2010-02-13 13:29 mysql-bin.000015
-rw-rw---- 1 paul paul 247 2010-02-13 13:28 mysql-bin.index
-rw-rw---- 1 paul paul 1215 2010-02-13 13:28 mysql.err
-rw-rw---- 1 paul paul 86861 2010-01-13 21:42 mysql.slow

**Snowhog** · Feb 13, 2010, 05:11 PM

Re: KDE 4.4.0 Akonadi Server

For these errors:
Table 'mysql. servers' doesn't exist

Followed those instructions. Akonadi Server Self-Test still has the same MySQL error at step 4:

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

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

File content of '/home/paul/.local/share/akonadi/db_data/mysql.err':
100213 13:59:55 [Note] Plugin 'FEDERATED' is disabled.
100213 13:59:56 InnoDB: Started; log sequence number 0 378594
100213 13:59:56 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
100213 13:59:56 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
100213 13:59:56 [ERROR] Cannot open mysql.db
100213 13:59:56 [ERROR] Cannot open mysql.user
100213 13:59:56 [ERROR] Cannot open mysql.event
100213 13:59:56 [ERROR] Event Scheduler: An error occurred when initializing system tables.
100213 13:59:56 [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)

A search of my system (sudo locate) for mysql.servers, mysql.db, mysql.user, mysql.event doesn't find them. Are they truly not installed?

Using find:
paul@myotherbrain:~$ sudo find / -name mysql.*

/home/paul/.local/share/akonadi/db_data/mysql.err.old
/home/paul/.local/share/akonadi/db_data/mysql.err
/home/paul/.local/share/akonadi/db_data/mysql.slow
/home/paul/.local/share/akonadi/db_misc/mysql.socket
/home/paul/.local/share/akonadi/mysql.conf

**vinnywright** · Feb 13, 2010, 05:40 PM

Re: KDE 4.4.0 Akonadi Server

this is my error log looks close to yours

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

and the fles tharein

vinny@desktop:~/.local/share/akonadi/db_data$ ls -l
total 143048
drwx------ 2 vinny vinny 4096 2010-02-12 02:08 akonadi
-rw-rw---- 1 vinny vinny 5 2010-02-13 12:50 desktop.pid
-rw-rw---- 1 vinny vinny 10485760 2010-02-13 18:09 ibdata1
-rw-rw---- 1 vinny vinny 67108864 2010-02-13 18:09 ib_logfile0
-rw-rw---- 1 vinny vinny 67108864 2010-02-12 02:08 ib_logfile1
-rw-rw---- 1 vinny vinny 16478 2010-02-12 03:22 mysql-bin.000003
-rw-rw---- 1 vinny vinny 1880 2010-02-12 04:33 mysql-bin.000004
-rw-rw---- 1 vinny vinny 1880 2010-02-12 13:18 mysql-bin.000005
-rw-rw---- 1 vinny vinny 1880 2010-02-12 15:25 mysql-bin.000006
-rw-rw---- 1 vinny vinny 1006 2010-02-12 15:48 mysql-bin.000007
-rw-rw---- 1 vinny vinny 1006 2010-02-12 17:06 mysql-bin.000008
-rw-rw---- 1 vinny vinny 1880 2010-02-12 18:30 mysql-bin.000009
-rw-rw---- 1 vinny vinny 2414 2010-02-13 02:45 mysql-bin.000010
-rw-rw---- 1 vinny vinny 1613 2010-02-13 11:41 mysql-bin.000011
-rw-rw---- 1 vinny vinny 1594 2010-02-13 12:50 mysql-bin.000012
-rw-rw---- 1 vinny vinny 190 2010-02-13 12:50 mysql-bin.index
-rw-rw---- 1 vinny vinny 776 2010-02-13 12:50 mysql.err
-rw-r--r-- 1 vinny vinny 15988 2010-02-13 12:50 mysql.err.old
-rw-rw---- 1 vinny vinny 1524350 2010-02-05 16:20 mysql.slow
vinny@desktop:~/.local/share/akonadi/db_data$

but like I say it works hear ....... for search and kontact.

[img width=400 height=300]http://i29.photobucket.com/albums/c291/vinnywright/stergi.png[/img]

[img width=400 height=300]http://i29.photobucket.com/albums/c291/vinnywright/stergi1.png[/img]

one thing I have notesed is that Nepomuk Strigi File Indexing seams to keep runing every so often ......... 2,310 files in index 59.7MiB

VINNY

**Snowhog** · Feb 13, 2010, 05:55 PM

Re: KDE 4.4.0 Akonadi Server

Hmm. Okay. So maybe this is an oversight on the part of the developers, or...

Does this mean that the MySQL files aren't actually required for Akonadi?

**vinnywright** · Feb 13, 2010, 07:00 PM

Re: KDE 4.4.0 Akonadi Server

Originally posted by Snowhog

Hmm. Okay. So maybe this is an oversight on the part of the developers, or...

Does this mean that the MySQL files aren't actually required for Akonadi?

good queshton..............it seams to be working hear...............is it working for you now??...........................no more errors as when first seting up (I mean the one s that pop up and say somthing's not right) and search works well......very well.

but just what it dose for kontact I dont know as I dont use Kontact that mutch I can check my gmail thrugh kontact but usualey just do that in firefox as google is my home page and it's so easey to check it from thare.

VINNY

**Snowhog** · Feb 13, 2010, 07:07 PM

Re: KDE 4.4.0 Akonadi Server

Yes, so far, the pop-up error and the Akonadi Server Self-Test pop-up don't occur. I still have to do one more reboot just to be sure, but...

Kontact starts up and I have access to my Contacts without error, where as before, I had to quit Kontact and restart it in order to have Contacts working.

**jim.hitch** · Feb 15, 2010, 03:46 AM

Re: KDE 4.4.0 Akonadi Server EDIT

Well Kontact is not working for me.

I'm getting the standard mysql error:

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

100215 9:07:19 InnoDB: Starting shutdown...
100215 9:07:21 InnoDB: Shutdown completed; log sequence number 0 10238950
100215 9:07:21 [Warning] Forcing shutdown of 1 plugins
100215 9:07:21 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete

And have tried the fix here

http://userbase.kde.org/Akonadi#Tabl...oesn.27t_exist

But am still getting the same error. I'm sure I had this problem when I first came across akonadi, but can remember how to fix it.

As it stands I can't access kontact, and therefore my calendar etc. Which is a little unfortunate, to say the least.

Any help asap much appreciated.

Jim

EDIT: The MySql error has now gone now, instead I'm getting

Akonadi control process is not registered at D-Bus

is this related to the fact the the User Management module is no longer usable since I upgraded to 4.4?

**Fintan** · Feb 15, 2010, 05:15 AM

Re: KDE 4.4.0 Akonadi Server

Thank you for the link Jim

Hmm...
this partially worked for me as well.

Following this:
http://userbase.kde.org/Akonadi#Tabl...oesn.27t_exist

Quote:

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 and openSuSE users the file ist located in /etc/akonadi/mysql-global.conf). Then open it and uncomment the line sql_mode=strict_trans_tables.

when doing this:

.....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.

Akonadi server will not start at all!!!

My contacts / calendars (google) are all up and no more nepomuk errors.

Will do a few reboots to confirm.

Edit: I still get the MYSQL server error though.

**jim.hitch** · Feb 15, 2010, 06:22 AM

Re: KDE 4.4.0 Akonadi Server

Lucky for you. I can't get Kontact useable, it remains frozen with the 'starting akonadi server' dialogue in front of it until the whole thing crashes.

Not good.

**Fintan** · Feb 15, 2010, 06:53 AM

Re: KDE 4.4.0 Akonadi Server

Just a few things to try.

Install virtuosoconverter from the repos and run it in a termional or krunner (alt+f2).

When you start kontact does it crash before you can deactivate akonadi ?

Sorry, I have to run but I'll get back to this later.

Announcement

[SEMI-RESOLVED] KDE 4.4.0 Akonadi Server

[SEMI-RESOLVED] KDE 4.4.0 Akonadi Server

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment