Kolab 3.1 -> 3.2 upgrade on Debian 7: my experiences

[hede]

Hi List,

I've upgraded from Kolab 3.1 to Kolab 3.2 on Debian 7 on ARM.
(build from sources)

Things to say:

#### 1 ####

Versioning seems inconsistend. On many places this kolab say's it is v3.1, 
I've double checked if I really installed all packages from 3.2 sources...
... it seems I did so!?

#### 2 ####

I had to manually update the sql schemata:

mysql> ALTER TABLE `kolab_cache_contact` ADD `name` VARCHAR(255) NOT NULL,
    ->   ADD `firstname` VARCHAR(255) NOT NULL,
    ->   ADD `surname` VARCHAR(255) NOT NULL,
    ->   ADD `email` VARCHAR(255) NOT NULL;

Without this, roundcube doesn't show contacts but logs errors:

[19-Feb-2014 18:36:35,000000 +0100]: DB Error: [1054] Unknown column 'surname' 
in 'order clause' (SQL Query: SELECT * FROM kolab_cache_contact WHERE 
folder_id='11'  AND `type` = 'contact' ORDER BY surname, email LIMIT 50) ...

[19-Feb-2014 18:48:52,000000 +0100]: DB Error: [1054] Unknown column 'name' in 
'field list' (SQL Query: INSERT INTO kolab_cache_contact  (folder_id, msguid, 
uid, created, changed, data, xml, tags, words , type, name, firstname, surname, 
email) VALUES (...)

#### 3 ####

claws-mail 2.5 destroyed all my data. First it seems working, in the logs 
there's plenty of:

Index upgrade: ... (12 -> 13)

but also plenty of:

DBERROR: error fetching quota root=<(domain)!user.(name)> value=<%(S 
(1362816848 3145728) M (2281) AS (0) NF (1))>

So I tried to use /usr/lib/cyrus-imapd/quota to repair this.

... it kind of "repaired" the thing by deleting all quotas *argh*.
Then I tried /usr/lib/cyrus-imapd/reconstruct, which kind of "repaired" the 
mailboxes by deleting all mails *ARGH!*. 
(reconstruct[16261]: (domain)!user.(name) uid 69 not found)

So I restored some backup and downgraded to the old cyrus. 
I'm still using cyrus-imapd 2.4.17 now.

#### 4 ####

At least a good thing: Some nasty bug that previously occurred has vanished, 
now I can add yearly recurring events in roundcube. :-)

##

Yet I haven't tried activesync, which worked before. Maybe there are more new 
bugs to come...

##

Greetings
hede