Curious behaviour after deleting a mailbox

[Stefan Jurisch]

Hi,

I'm just examining a curious problem on an Open-Xchange ASE server. I
have removed a user and so his mailbox, too. After that, all data has
been gone, including the data directory. So far, so good...

But the problem is: using 'lm' within cyradm still shows a rest of the
mailbox: user/tanja.heinrich/Trash@...
But trying to delete this ends up in a System I/O error because there
ist no more user subdirectory in the spool. 'ctl_mboxlist' also shows
this single entry.

Neither a reconstruct or a database recovery did remove that stuff.

Now my question: how can I remove this rest of that mailbox so I can
create this user completely new? That curious mailbox rest prevents the
correct new creation of a fully functional mailbox, I guess.

Thanks in advance.

Best regards
Stefan



-- 
STEFAN JURISCH | System Engineer | VMware(R), Software Development  Support

OpenPGP: ID: 0xC6F20B3E   keyserver: pool.sks-keyservers.net

SIEGNETZ.Informationstechnologie(R) GmbH
Schneppenkauten 1a, DE-57076 Siegen, Phone +49 (271) 68193 -0, Facsimile -28
http://www.siegnetz.de | supp...@siegnetz.de | developm...@siegnetz.de

Geschaeftsfuehrer (executive): Oliver Seitz
Handelsregister (comm. register): Amtsgericht (local court) Siegen HRB4838
Sitz der Gesellschaft/domicile: Siegen, Germany 


pgpNeqIBriOsj.pgp
Description: PGP signature

Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/

Re: Curious behaviour after deleting a mailbox

[Dan White]

On 19/04/11 10:57 +0200, Stefan Jurisch wrote:
Hi,

I'm just examining a curious problem on an Open-Xchange ASE server. I
have removed a user and so his mailbox, too. After that, all data has
been gone, including the data directory. So far, so good...

But the problem is: using 'lm' within cyradm still shows a rest of the
mailbox: user/tanja.heinrich/Trash@...
But trying to delete this ends up in a System I/O error because there
ist no more user subdirectory in the spool. 'ctl_mboxlist' also shows
this single entry.

Neither a reconstruct or a database recovery did remove that stuff.

Now my question: how can I remove this rest of that mailbox so I can
create this user completely new? That curious mailbox rest prevents the
correct new creation of a fully functional mailbox, I guess.

If you're using at least version 2.3.7, you can use cyr_dbtool to remove the
mailbox directly from the mailboxes database. As the cyrus user:

cyrus@mail:/var/spool/imap$ file /var/lib/imap/mailboxes.db 
/var/lib/imap/mailboxes.db: Cyrus skiplist DB

cyrus@mail:/var/spool/imap$ cyr_dbtool /var/lib/imap/mailboxes.db skiplist show 
user.test1234
user.test1234   (uniqueid 6ebe0fe04dad935f) 0 default test1234 lrswipkxtecda   
user.test1234.trash (uniqueid 638c3a464dad9368) 0 default test1234 
lrswipkxtecda   

cyrus@mail:/var/spool/imap$ cyr_dbtool /var/lib/imap/mailboxes.db skiplist get 
'user.test1234.trash'
(uniqueid 638c3a464dad9368) 0 default test1234  lrswipkxtecda   
cyrus@mail:/var/spool/imap$ cyr_dbtool /var/lib/imap/mailboxes.db skiplist 
delete 'user.test1234.trash'
cyrus@mail:/var/spool/imap$ cyr_dbtool /var/lib/imap/mailboxes.db skiplist get 
'user.test1234.trash'

cyrus@mail:/var/spool/imap$ 

Another option was discussed on the list recently, which is to convert the
mailboxes database to flat text, edit the database, and reimport it.

You might also be able to create the directory structure for the mailbox,
perform a reconstruct/cyrreconstruct, then delete the mailbox cyradm (and
then clean up the filesystem).


-- 
Dan White

Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/