<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
-------- Original Message --------<br>
Subject: Re: Cyrus questions, lost emails, reconstruct<br>
From: Simon Matter <a class="moz-txt-link-rfc2396E" href="mailto:simon.matter@invoca.ch"><simon.matter@invoca.ch></a><br>
To: Derrick Seymour <a class="moz-txt-link-rfc2396E" href="mailto:seymourdh@yahoo.com"><seymourdh@yahoo.com></a><br>
Date: Friday, May 16, 2008 1:53:52 AM<br>
<blockquote
cite="mid:33260.192.168.10.25.1210920832.squirrel@webmail.bi.corp.invoca.ch"
type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">I am on a mac os x server 10.3.9
not sure how to find the cyrus version, naive i
know...
</pre>
</blockquote>
<pre wrap="">I dont know anything to os x packaging
</pre>
<blockquote type="cite">
<pre wrap="">the -i is from one of apples documents on how to
reconstruct the entire database for cyrus. the -r
</pre>
</blockquote>
<pre wrap="">is
</pre>
<blockquote type="cite">
<pre wrap="">for a single user, knowing now that it is broken
</pre>
</blockquote>
<pre wrap="">makes
</pre>
<blockquote type="cite">
<pre wrap="">a lot of sense with the problems i am having
reconstructing.
</pre>
</blockquote>
<pre wrap="">-r is for "recursive" (on usual cyrus install)
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap="">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
<a class="moz-txt-link-freetext" href="http://www.oreilly.com/catalog/mimap/chapter/ch09.html">http://www.oreilly.com/catalog/mimap/chapter/ch09.html</a>
Is your mail store on a networked disk ?
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">that
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">lrswipcda
</pre>
<blockquote type="cite">
<pre wrap="">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,
</pre>
</blockquote>
<pre wrap="">i
</pre>
<blockquote type="cite">
<pre wrap="">believe this is case sensitive, so now how do i
</pre>
</blockquote>
<pre wrap="">change
</pre>
<blockquote type="cite">
<pre wrap="">this back to lowercase and or which reconstruct
command (i know -r is broken) will work. I don't
</pre>
</blockquote>
<pre wrap="">mind
</pre>
<blockquote type="cite">
<pre wrap="">the broken construct if i can edit the mailbox.db
successfully to fix the one issue with the caps.
</pre>
</blockquote>
<pre wrap="">can
</pre>
<blockquote type="cite">
<pre wrap="">always do up a script.
</pre>
</blockquote>
<pre wrap="">use cyradm to change ACL, using "sam" command
</pre>
<blockquote type="cite">
<pre wrap="">i've checked other users, all of there info is in
lowercase....
</pre>
</blockquote>
<pre wrap="">
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.
</pre>
</blockquote>
<pre wrap=""><!---->
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). <a class="moz-txt-link-freetext" href="http://www.invoca.ch/pub/packages/pam_deny_uc/">http://www.invoca.ch/pub/packages/pam_deny_uc/</a>
Simon
----
Cyrus Home Page: <a class="moz-txt-link-freetext" href="http://cyrusimap.web.cmu.edu/">http://cyrusimap.web.cmu.edu/</a>
Cyrus Wiki/FAQ: <a class="moz-txt-link-freetext" href="http://cyrusimap.web.cmu.edu/twiki">http://cyrusimap.web.cmu.edu/twiki</a>
List Archives/Info: <a class="moz-txt-link-freetext" href="http://asg.web.cmu.edu/cyrus/mailing-list.html">http://asg.web.cmu.edu/cyrus/mailing-list.html</a>
</pre>
</blockquote>
<br>
There is a squirrelmail option for this... <br>
$force_username_lowercase = true; <br>
</body>
</html>