Re: KDE 4.4.1 SC: address book not working
Am Freitag 05 März 2010 12:03:08 schrieb Martin Steigerwald:
> Hi!
>
> The new address book does not appear to work.
>
> It says the server protocol is too old.
>
> Hmmm, seems it needs a newer version of akonadi.
>
> shambhala:~> apt-show-versions | grep akonadi
> akonadi-server/squeeze uptodate 1.2.1-1+b1
> akonadiconsole/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-contact4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kabc4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kcal4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kde4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kmime4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadiprivate1/squeeze uptodate 1.2.1-1+b1
> shambhala:~> apt-cache policy akonadi-server
> akonadi-server:
> Installiert: 1.2.1-1+b1
> Kandidat: 1.2.1-1+b1
> Versions-Tabelle:
> 1.3.1-1 0
> 400 http://ftp.de.debian.org sid/main Packages
> *** 1.2.1-1+b1 0
> 450 http://ftp.de.debian.org squeeze/main Packages
> 100 /var/lib/dpkg/status
you should update akonadi-server to 1.3.1-1 0 from unstable.
greetz
devil
> shambhala:~> apt-show-versions | grep mysql
> libaprutil1-dbd-mysql/squeeze uptodate 1.3.9+dfsg-3
> libdbd-mysql-perl/squeeze uptodate 4.012-1+b1
> libmysqlclient16/squeeze uptodate 5.1.41-3
> libqt4-sql-mysql/experimental uptodate 4:4.6.2-1
> mysql-client-5.1/squeeze uptodate 5.1.41-3
> mysql-common/squeeze uptodate 5.1.41-3
> mysql-server/squeeze uptodate 5.1.41-3
> mysql-server-5.1/squeeze uptodate 5.1.41-3
> php5-mysql/squeeze uptodate 5.3.1-5
>
>
> Akonadi Server Self-Test Report
> ===============================
>
> [[... successes ...]]
> Test 4: ERROR
> --------
>
> MySQL server log contains errors.
> Details: The MySQL server error log file '<a
> href='/home/martin/.local/share/akonadi/db_data/mysql.err'>/home/martin/.lo
> cal/share/akonadi/db_data/mysql.err</a>' contains errors.
>
> File content of '/home/martin/.local/share/akonadi/db_data/mysql.err':
> 100305 11:03:31 [Note] Plugin 'FEDERATED' is disabled.
> 100305 11:03:32 InnoDB: Started; log sequence number 0 60409331
> 100305 11:03:32 [Warning] Can't open and lock time zone table: Table
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 100305 11:03:32 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist
> 100305 11:03:32 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.41-3-log' socket:
> '/home/martin/.local/share/akonadi/db_misc/mysql.socket' port: 0
> (Debian)
>
> [...]
>
> 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/martin/.local/share/akonadi/mysql.conf'>/home/martin/.local/sha
> re/akonadi/mysql.conf</a> and is readable.
>
> File content of '/home/martin/.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_b
> y_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=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.2.1
>
> [...]
>
> Test 13: ERROR
> --------
>
> Server protocol version is too old.
> Details: The server protocol version is 15, but at least version 23 is
> required. Install a newer version of the Akonadi server.
>
> Test 16: ERROR
> --------
>
> Previous Akonadi server error log found.
> Details: The Akonadi server did report error during its previous startup
> into <a
> href='/home/martin/.local/share/akonadi/akonadiserver.error.old'>/home/mart
> in/.local/share/akonadi/akonadiserver.error.old</a>.
>
> File content of
> '/home/martin/.local/share/akonadi/akonadiserver.error.old':
> Control process died, committing suicide!
>
>
> So I installed the newer akonadi-server 1.3.1-1. So avoid having old
> incompatible stuff around I also did:
>
> mv ~/.config/akonadi ~/.config/akonadi-2010-03-05
> mv ~/.local/share/akonadi ...
>
> as I was logged out.
>
> Then I logged in again.
>
> Now I get:
>
>
> 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/martin/.config/akonadi/akonadiserverrc':
> [%General]
> Driver=QMYSQL
> SizeThreshold=4096
> ExternalPayload=false
>
> [QMYSQL]
> Name=akonadi
> User=
> Password=
> Options="UNIX_SOCKET=/home/martin/.local/share/akonadi/db_misc/mysql.socket
> " ServerPath=/usr/sbin/mysqld
> StartServer=true
>
> [Debug]
> Tracer=null
>
>
> Test 2: SUCCESS
> --------
>
> MySQL server found.
> Details: You currently have configured Akonadi to use the MySQL server
> '/usr/sbin/mysqld'.
> 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 Ver 5.1.41-3 for debian-
> linux-gnu on i486 ((Debian))
>
>
> Test 4: ERROR
> --------
>
> MySQL server log contains errors.
> Details: The MySQL server error log file '<a
> href='/home/martin/.local/share/akonadi/db_data/mysql.err'>/home/martin/.lo
> cal/share/akonadi/db_data/mysql.err</a>' contains errors.
>
> File content of '/home/martin/.local/share/akonadi/db_data/mysql.err':
> 100305 11:50:49 [Note] Plugin 'FEDERATED' is disabled.
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 100305 11:50:50 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 100305 11:50:51 InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 64 MB
> InnoDB: Database physically writes the file full: wait...
> 100305 11:50:56 InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 64 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 100305 11:51:02 InnoDB: Started; log sequence number 0 0
> 100305 11:51:03 [Warning] Can't open and lock time zone table: Table
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 100305 11:51:03 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist
> 100305 11:51:03 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.41-3-log' socket:
> '/home/martin/.local/share/akonadi/db_misc/mysql.socket' port: 0
> (Debian)
>
>
> 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_b
> y_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/martin/.local/share/akonadi/mysql.conf'>/home/martin/.local/sha
> re/akonadi/mysql.conf</a> and is readable.
>
> File content of '/home/martin/.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_b
> y_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: ERROR
> --------
>
> Server protocol version is too old.
> Details: The server protocol version is 15, but at least version 23 is
> required. Install a newer version of the Akonadi server.
>
> 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
> nepomukemailfeeder.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
> nepomukemailfeeder.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.
>
>
> martin@shambhala:~/.local/share/akonadi/db_data> cat mysql.err
> 100305 11:50:49 [Note] Plugin 'FEDERATED' is disabled.
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 100305 11:50:50 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 100305 11:50:51 InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 64 MB
> InnoDB: Database physically writes the file full: wait...
> 100305 11:50:56 InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 64 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 100305 11:51:02 InnoDB: Started; log sequence number 0 0
> 100305 11:51:03 [Warning] Can't open and lock time zone table: Table
> 'mysql.time_zone_leap_second' doesn't exist trying to live without them
> 100305 11:51:03 [ERROR] Can't open and lock privilege tables: Table
> 'mysql.servers' doesn't exist
> 100305 11:51:03 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.41-3-log' socket:
> '/home/martin/.local/share/akonadi/db_misc/mysql.socket' port: 0
> (Debian)
>
> Mysql error logs and resource agents spring to my attention.
>
> To me it appears my package installs are pretty much complete:
>
> martin@shambhala:~> apt-show-versions | grep akonadi
> akonadi-server/sid uptodate 1.3.1-1
> akonadiconsole/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-contact4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kabc4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kcal4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kde4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadi-kmime4/exp-snapshots uptodate 4:4.4.1-0rc1
> libakonadiprivate1/squeeze uptodate 1.2.1-1+b1
> martin@shambhala:~> apt-cache search akonadi
> akonadi-kde-resource-googledata - Google calendar and contacts resource
> for Akonadi
> libakonadi-ruby - Akonadi Ruby bindings
> libakonadi-dev - development files for the Akonadi PIM storage service
> libakonadi-ruby1.8 - Akonadi Ruby 1.8 bindings
> libakonadi2.2-cil - Akonadi bindings for CLI
> libsmokeakonadi2 - Akonadi Smoke library
> akonadi-dbg - Debug-Symbole für den Akonadi PIM Speicherdienst
> akonadi-server - PIM-Speicherdienst von Akonadi
> libakonadiprivate1 - Bibliotheken für den Akonadi PIM Speicherdienst
> python-kde4 - Python-Anbindungen für die KDE-4-Bibliotheken
> akonadiconsole - the Management and Debugging Console for Akonadi
> kdepim-runtime - Runtime components for akonadi-kde
> kdepim-runtime-dbg - debugging files for akonadi kde runtime components
> kmail - KDE Email client
> libakonadi-contact4 - library for using the Akonadi PIM data server
> libakonadi-kabc4 - library for using the Akonadi PIM data server
> libakonadi-kcal4 - library for using the Akonadi PIM data server
> libakonadi-kde4 - library for using the Akonadi PIM data server
> libakonadi-kmime4 - library for using the Akonadi PIM data server
> libmicroblog4 - library for using the Microblog Akonadi Resource
>
> Any hints?
>
> Ciao,
>
Reply to: