Cyrus questions, lost emails, reconstruct

[Blake Hudson]

-------- Original Message  --------
Subject: Re: Cyrus questions, lost emails, reconstruct
From: Simon Matter <simon.matter at invoca.ch>
To: Derrick Seymour <seymourdh at yahoo.com>
Date: Friday, May 16, 2008 1:53:52 AM
>>> I am on a mac os x server 10.3.9
>>>
>>> not sure how to find the cyrus version, naive i
>>> know...
>>>       
>> I dont know anything to os x packaging
>>
>>     
>>> the -i is from one of apples documents on how to
>>> reconstruct the entire database for cyrus.  the -r
>>>       
>> is
>>     
>>> for a single user, knowing now that it is broken
>>>       
>> makes
>>     
>>> a lot of sense with the problems i am having
>>> reconstructing.
>>>       
>> -r is for "recursive" (on usual cyrus install)
>>
>>     
>>> latest system changes was the installation of
>>> spamassassin with procmail for the relay.  This i
>>> believe this caused my initial problem with the
>>> disappearing emails.  Not to concerned about that
>>> right now, though i will be very happy to receive
>>> suggestions on that.
>>>       
>> cyrus users use SIEVE instead of procmail.
>> Of course sieve is not as flexible as procmail, but a
>> lot lot
>> faster, more secure, and part of cyrus
>>
>> Read this, to be sure your procmail configuration is
>> compatible with
>>  cyrus
>> http://www.oreilly.com/catalog/mimap/chapter/ch09.html
>>
>> Is your mail store on a networked disk ?
>>
>>     
>>> Main problem is to get reconstruct working, I will
>>> deal with the disappearing emails later on, need to
>>> get them back now and be able to get them back
>>> reliably in the future until i fix the core problem
>>> with the disappearing emails.
>>>
>>> updated info that i found:
>>>
>>> when i take a look at the mailbox.db for the user
>>>       
>> that
>>     
>>> has a corrupted in box i get this....
>>>
>>> myserver2:/var/imap user# sudo -u cyrus
>>> /usr/bin/cyrus/bin/ctl_mboxlist -d | grep brokenuser
>>> user.brokenuser   default BROKENUSER
>>>       
>> lrswipcda
>>     
>>> user.brokenuser.INBOX^Drafts      default brokenuser
>>>     lrswipcda
>>> user.brokenuser.INBOX^Sent        default brokenuser
>>>     lrswipcda
>>> user.brokenuser.INBOX^Trash       default brokenuser
>>>     lrswipcda
>>>
>>> as you can see the inbox has the user in all caps,
>>> makes sense now why they can't get into there inbox,
>>>       
>> i
>>     
>>> believe this is case sensitive, so now how do i
>>>       
>> change
>>     
>>> this back to lowercase and or which reconstruct
>>> command (i know -r is broken) will work.  I don't
>>>       
>> mind
>>     
>>> the broken construct if i can edit the mailbox.db
>>> successfully to fix the one issue with the caps.
>>>       
>> can
>>     
>>> always do up a script.
>>>       
>> use cyradm to change ACL, using "sam" command
>>
>>     
>>> i've checked other users, all of there info is in
>>> lowercase....
>>>       
>>
>> First off let me thank all of you for your help so
>> far.
>>
>> To answer the above questions:
>>
>> My mail store is on a fiber channel RAID
>> Procmail looks to be set up properly, i will look into
>> this further
>> Mac os x 10.3.9 ships with cyrus 2.2.10, or should i
>> say was updated to 2.2.10
>> Up until the installation of spamassassin and procmail
>> there has been no 'reported' problems
>>
>> though i don't think the reconstruct problem has
>> anything to do with the install, the disappearing
>> emails maybe.
>>
>> Here is some updates:
>>
>> Through long searching I decided to try this, after i
>> backed up everything....twice ;-)
>>
>> stopped mail
>>
>> sudo -u cyrus /usr/bin/cyrus/bin/ctl_mboxlist -d >
>> /mailboxdb.txt
>>
>> edited the caps user to lower case with pico
>>
>> sudo -u cyrus /usr/bin/cyrus/bin/ctl_mboxlist -u <
>> /mailboxdb.txt
>>
>> started mail
>>
>> this worked, as far as i can tell, no loss of email
>> and the user can log back in with squirrelmail with
>> out the error "mailbox does not exist"
>>
>> Logged in with a couple of other users via IMAP and
>> POP everything looks good.
>>
>> While editing the mailboxdb i found something
>> strange.....
>>
>> as you can see below there is an entry for some users
>> in all upper case, there is also complete entries for
>> these users also in lower case.
>>
>>     
>
> Are you using autocreate inbox? I don't know much about your config but
> that kind of problems usually comes when you let your users login with all
> caps usernames and you have an authentication method which is not case
> sensitive on the username side (like LDAP). Then your users can
> successfully login using all CAPS, but that means they don't get their
> true mailbox but a new empty one. Check the username_tolower setting in
> imapd.conf. But, you simply should not let your users login with
> squirrelmail with uppercase because the username may be lowered by cyrus
> but squirrelmail creates new preferences for the uppercase user. I made my
> own PAM module which denies all upper case usernames (we wanted all
> lowercase). http://www.invoca.ch/pub/packages/pam_deny_uc/
>
> Simon
>
>
> ----
> Cyrus Home Page: http://cyrusimap.web.cmu.edu/
> Cyrus Wiki/FAQ: http://cyrusimap.web.cmu.edu/twiki
> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
>   

There is a squirrelmail option for this...
$force_username_lowercase = true;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20080516/b1d07818/attachment.html