Questions around moving from 2.2.12 to 2.4.12

[Stefan G. Weichinger]

Am 29.02.2012 13:38, schrieb Adam Tauno Williams:
> On Wed, 2012-02-29 at 13:17 +0100, Stefan G. Weichinger wrote:
>> Am 29.02.2012 12:47, schrieb Bron Gondwana:
>>> Make sure you get /var/imap or wherever the DB files are stored
>>> as well, /var/spool/imap is just the emails - you want to keep
>>> the indexes!
>> Afai understand this would mean these 3 dirs: configdirectory:
>> /var/lib/imap partition-default: /var/spool/imap sievedir:
>> /var/lib/sieve
> 
> Yes.

ok. I rsync /var/spool/imap/user now.

Does it matter:

new server has one subdir per character:

a
b
c
d
...

while old server has:

auser1
auser2
auser5
...

?


>>> Your biggest risk is berkeley DB files.  If you are using
>>> berkeley, either convert to skiplist first, or dump and restore.
>> sigh ... I don't even *know* if I use berkeley. I suspect, yes, I
>> see db-files in /var/lib/imap # ls /var/lib/imap annotations.db db 
>> db.backup2 deliverdb mailboxes.db [...]
> 
> "file {filename}" should tell you what they are. With 2.2.x it is
> likely they are Berkeley.   Berkeley is an administrator's nightmare.
> If they Berkelely convert them and make sure the server still works
> *BEFORE* migrating if you are using a rsync method.
> 
>> Is the conversion hard to do? What do you recommend?
> 
> cvt_cyrusdb  [I think this was around in 2.2x?]
> 
> <https://sourceforge.net/projects/coils/files/WMOGAG-Coils.pdf/download>
> 
> see page 97

Ah, I see.

Yes, the binary is here and is able to:

# su cyrus -c /usr/lib/cyrus/bin/cvt_cyrusdb
Usage: /usr/lib/cyrus/bin/cvt_cyrusdb [-C altconfig] <old db> <old db
backend> <new db> <new db backend>
Usable Backends:  berkeley, berkeley-nosync, flat, skiplist, quotalegacy

> You'll probably need to change the database type in imapd.conf as
> well.

I will give it a try in the evening when I can stop the server for a moment.

Forgive me my questions, but which files do I have to convert:

/var/lib/imap # ls -l
total 202180
drwxr-x---  13 cyrus mail      4096 Feb 29 13:44 .
drwxr-xr-x  28 root  root      4096 Feb 29 06:56 ..
-rw-------   1 cyrus mail      5480 Feb  4 08:09 annotations.db
drwx------   2 cyrus mail     98304 Feb 29 06:45 backup
drwxr-x---   2 cyrus mail      4096 Feb 24 01:13 db
drwx------   2 cyrus mail      4096 Feb 29 13:44 db.backup1
drwx------   2 cyrus mail      4096 Feb 29 13:14 db.backup2
-rw-------   1 cyrus mail  10817536 Feb 29 13:44 deliver.db
drwxr-x---   3 cyrus mail      4096 Feb 18  2005 deliverdb
drwxr-x---   2 cyrus mail      4096 Feb 18  2005 log
-rw-------   1 cyrus mail    102600 Feb 29 13:48 mailboxes.db
-rw-r--r--   1 cyrus mail     18101 Nov 23  2006 mailboxes.txt
drwxr-x---   2 cyrus mail      4096 Feb 18  2005 msg
drwxr-x---   2 cyrus mail      8192 Feb 29 13:51 proc
drwxr-x---  28 cyrus mail      4096 Feb 18  2005 quota
drwxr-x---   2 cyrus mail      4096 Feb  4 08:09 socket
-rw-r--r--   1 cyrus mail     18101 Nov 23  2006 testexport
-rw-------   1 cyrus mail 195685416 Feb 29 13:51 tls_sessions.db
drwxr-x---  28 cyrus mail      4096 Feb 18  2005 user


only *.db ?


>>> Beware of mailbox sort order issues if you change that config.
>> You talk of the sort order in the mail-clients view
> 
> No, it is sorting order in the database.  It is much easier to
> convert everything before migrating.

So the initial conversion on the old box takes care of the sorting
issue, do I understand correct?

Thanks for your help, Stefan