kpilot 5.2.0 (kde 4.2.0) : Server protocol version is too old

Hi all,

I use kubuntu 8.10 and I want use kpilot for palm m515 synchronization.
The conduits setup runs ok only for the memo file and time sync conduit.
For To-do, Calendar, and contats the Kpilot main Configuration window
says:  akonadi not operational.

I installed the following packages via synaptic:

Package: kpilot
Version: 4:4.2.0-0ubuntu1~intrepid3

Package: libpisock9
Version: 0.12.3-4ubuntu3

Package: korganizer
Version: 4:4.1.2-0ubuntu2


Below is a clipboard copy of the details.

Any help welcome.

Frank

-----------------------------------------------------------------------------

> Akonadi Server Self-Test Report
> ===============================
> 
> Test 1:  SUCCESS
> --------
> 
> Database driver found.
> Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi 
> server configuration.
> The following drivers are installed: QMYSQL3, QMYSQL.
> Make sure the required driver is installed.
> 
> File content of '/home/fth/.config/akonadi/akonadiserverrc':
> [%General]
> Driver=QMYSQL
> 
> [QMYSQL]
> Name=akonadi
> User=
> Password=
> Options="UNIX_SOCKET=/home/fth/.local/share/akonadi/db_misc/mysql.socket"
> StartServer=true
> ServerPath=/usr/sbin/mysqld-akonadi
> Host=
> 
> 
> 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.0.67-0ubuntu6 for debian-linux-gnu on i486 ((Ubuntu))
> 
> 
> Test 4:  WARNING
> --------
> 
> MySQL server log contains warnings.
> Details: The MySQL server log file '<a 
> href='/home/fth/.local/share/akonadi/db_data/mysql.err'>/home/fth/.local/share/akonadi/db_data/mysql.err</a>&apos; 
> contains warnings.
> 
> File content of '/home/fth/.local/share/akonadi/db_data/mysql.err':
> 090415 22:57:02 [Note] /usr/sbin/mysqld-akonadi: Normal shutdown
> 
> 090415 22:57:04  InnoDB: Starting shutdown...
> 090415 22:57:06  InnoDB: Shutdown completed; log sequence number 0 135239
> 090415 22:57:06 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete
> 
> 090416 17:11:56  InnoDB: Started; log sequence number 0 135239
> 090416 17:11:56 [Warning] Can't open and lock time zone table: Table 
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 090416 17:11:56 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
> Version: '5.0.67-0ubuntu6-log'  socket: 
> '/home/fth/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)
> 090416 18:04:21 [Note] /usr/sbin/mysqld-akonadi: Normal shutdown
> 
> 090416 18:04:23  InnoDB: Starting shutdown...
> 090416 18:04:25  InnoDB: Shutdown completed; log sequence number 0 135249
> 090416 18:04:25 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete
> 
> 090416 20:51:10  InnoDB: Started; log sequence number 0 135249
> 090416 20:51:10 [Warning] Can't open and lock time zone table: Table 
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 090416 20:51:10 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
> Version: '5.0.67-0ubuntu6-log'  socket: 
> '/home/fth/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)
> 090416 21:26:27 [Note] /usr/sbin/mysqld-akonadi: Normal shutdown
> 
> 090416 21:26:29  InnoDB: Starting shutdown...
> 090416 21:26:31  InnoDB: Shutdown completed; log sequence number 0 135259
> 090416 21:26:31 [Note] /usr/sbin/mysqld-akonadi: Shutdown complete
> 
> 090419 21:36:18  InnoDB: Started; log sequence number 0 135259
> 090419 21:36:18 [Warning] Can't open and lock time zone table: Table 
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 090419 21:36:18 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
> Version: '5.0.67-0ubuntu6-log'  socket: 
> '/home/fth/.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 <[email protected]>
> #
> [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
> 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=1M
> max_connections=20
> # 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/fth/.local/share/akonadi/mysql.conf'>/home/fth/.local/share/akonadi/mysql.conf</a> 
> and is readable.
> 
> File content of '/home/fth/.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 <[email protected]>
> #
> [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
> 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=1M
> max_connections=20
> # 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 Control: running
> Akonadi Server: running
> 
> 
> 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:  ERROR
> --------
> 
> Server protocol version is too old.
> Details: The server protocol version is 2, but at least version 6 is 
> required. Install a newer version of the Akonadi server.
> 
> Test 12:  SUCCESS
> --------
> 
> Resource agents found.
> Details: At least one resource agent has been found.
> 
> Directory listing of '/usr/share/akonadi/agents':
> distlistresource.desktop
> icalresource.desktop
> imaplibresource.desktop
> kabcresource.desktop
> kcalresource.desktop
> knutresource.desktop
> localbookmarksresource.desktop
> maildirresource.desktop
> mailthreaderagent.desktop
> nepomukcontactfeeder.desktop
> nepomukemailfeeder.desktop
> nepomuktagresource.desktop
> nntpresource.desktop
> strigifeeder.desktop
> vcarddirresource.desktop
> vcardresource.desktop
> Directory listing of '/usr/share/akonadi/agents':
> distlistresource.desktop
> icalresource.desktop
> imaplibresource.desktop
> kabcresource.desktop
> kcalresource.desktop
> knutresource.desktop
> localbookmarksresource.desktop
> maildirresource.desktop
> mailthreaderagent.desktop
> nepomukcontactfeeder.desktop
> nepomukemailfeeder.desktop
> nepomuktagresource.desktop
> nntpresource.desktop
> strigifeeder.desktop
> vcarddirresource.desktop
> vcardresource.desktop
> 
> Environment variable XDG_DATA_DIRS is set to 
> '/usr/share:/usr/share:/usr/local/share'
> 
> Test 13:  SUCCESS
> --------
> 
> No current Akonadi server error log found.
> Details: The Akonadi server did not report any errors during its current 
> startup.
> 
> Test 14:  SUCCESS
> --------
> 
> No previous Akonadi server error log found.
> Details: The Akonadi server did not report any errors during its 
> previous startup.
> 
> Test 15:  SUCCESS
> --------
> 
> No current Akonadi control error log found.
> Details: The Akonadi control process did not report any errors during 
> its current startup.
> 
> Test 16:  SUCCESS
> --------
> 
> No previous Akonadi control error log found.
> Details: The Akonadi control process did not report any errors during 
> its previous startup.
>