Am Freitag 05 März 2010 schrieb Ferdinand Thommes:
> 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.
I did as I mentioned below.
ms@shambhala:~> apt-show-versions | grep akonadi
akonadi-server/sid uptodate 1.3.1-1
akonadiconsole/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadi-contact4/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadi-kabc4/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadi-kcal4/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadi-kde4/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadi-kmime4/experimental-snapshots uptodate 4:4.4.1-0rc1
libakonadiprivate1/squeeze uptodate 1.2.1-1+b1
> > 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/mart
> > in/.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_divi
> > sion_b
> > y_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitut
> > ion,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/.loc
> > al/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_divi
> > sion_b
> > y_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitut
> > ion,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
So this second akonadi error log was with 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,
--
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA B82F 991B EAAC A599 84C7
Attachment:
signature.asc
Description: This is a digitally signed message part.