-------- Original Message -------- Subject: Re: Cyrus questions, lost emails, reconstruct From: Simon Matter <simon.matter@xxxxxxxxx> To: Derrick Seymour <seymourdh@xxxxxxxxx> 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 packagingthe -i is from one of apples documents on how to reconstruct the entire database for cyrus. the -risfor a single user, knowing now that it is brokenmakesa 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 userthathas 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 BROKENUSERlrswipcdauser.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,ibelieve this is case sensitive, so now how do ichangethis back to lowercase and or which reconstruct command (i know -r is broken) will work. I don'tmindthe broken construct if i can edit the mailbox.db successfully to fix the one issue with the caps.canalways do up a script.use cyradm to change ACL, using "sam" commandi'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; |
---- 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