Re: KDE 4.4.1 SC: address book not working

2010-03-07 Thread Martin Steigerwald
Am Samstag 06 März 2010 schrieb Modestas Vainius:
> Hello,
> 
> On penktadienis 05 Kovas 2010 13:55:19 Martin Steigerwald wrote:
> > I did as I mentioned below.
> > 
> > m...@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
> 
> No, your akonadi is not up-to-date. Anyway, upgrade to akonadi 1.3.1-2
> from sid once it is available.

Thanks. I missed libakonadiprivate1. Works like a charm ;-)

-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7


signature.asc
Description: This is a digitally signed message part.


Re: KDE 4.4.1 SC: address book not working

2010-03-05 Thread Modestas Vainius
Hello,

On penktadienis 05 Kovas 2010 13:55:19 Martin Steigerwald wrote:
> 
> I did as I mentioned below.
> 
> m...@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

No, your akonadi is not up-to-date. Anyway, upgrade to akonadi 1.3.1-2 from 
sid once it is available.

-- 
Modestas Vainius 


signature.asc
Description: This is a digitally signed message part.


Re: KDE 4.4.1 SC: address book not working

2010-03-05 Thread Martin Steigerwald
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.

m...@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 ' > href='/home/martin/.local/share/akonadi/db_data/mysql.err'>/home/mart
> > in/.lo cal/share/akonadi/db_data/mysql.err' 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: read

Re: KDE 4.4.1 SC: address book not working

2010-03-05 Thread 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.

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 ' href='/home/martin/.local/share/akonadi/db_data/mysql.err'>/home/martin/.lo
> cal/share/akonadi/db_data/mysql.err' 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  href='/home/martin/.local/share/akonadi/mysql.conf'>/home/martin/.local/sha
> re/akonadi/mysql.conf 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 
> #
> [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_buff

KDE 4.4.1 SC: address book not working

2010-03-05 Thread 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

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 '/home/martin/.local/share/akonadi/db_data/mysql.err'
 
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 /home/martin/.local/share/akonadi/mysql.conf
 
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 
#
[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=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 ver