On 2 June 1999, Christian Steger <christian(_dot_)steger(_at_)indis(_dot_)at>
wrote:
On 2 June 1999, V Suryanarayana Rao
<suryanarayana(_dot_)viriyala(_at_)cmcltd(_dot_)com> wrote:
Hi,
I have a prob with procmail while delivering mails into mailboxes.
We have just migrated our mail server from SCO Openserver
5.0 to RedHat linux 5.2 . We are facing problems in mail
delivery. Sometimes the incoming mails are being clubbed into
a single mesg. Like mail sent by different people are being
displayed as a single mail.
no, actually currently everything is working fine without any
problems. the thing i want to realise as following:
we have around 4500.- email accounts which are all together seperatly
on 4 different mashines.
maybe i am not 100 correct but we will realise folling thing:
i have already setup a mysqldatabase with all accounts (passwd unix
crypted)
pop3 authentication via qpop and the mysql-qpop0.5 patch works already
fine. so the pop of course is not the problem. we can now also
authenticate users to the accesserver via the same database. also
authentiacting via mysqlauthmodule (apache) works great to give the
user the ability to change his password in the mysqldatabase.
the question is the delivery agent via sendmail:
how can i setup/modify the sendmail (procmail probably) that he is
checking the presents of users in the mysql-database.
so the thing if that is possible is much more easier to handle disable
and assign users.
is there a way for doing that verification ?
Ok, if I understand you correctly, there are two different issues
here:
(1) Convincing sendmail to lookup users in a MySQL database, in order to
bounce messages addressed to non-existing users and so on.
(2) Keeping procmail happy WRT file permissions when you filter incoming
mail for your "virtual" users.
(1) has actually nothing to do with authenticating users (no
password lookups are involved), all you need is to find out if a given
user is in the database or not. One way or another, to the best of my
knowledge you can't do that with sendmail. However, you might want to
take a look at Postfix:
http://www.postfix.org/
Among many other nice things, there is a patch for it (experimental,
but stable) that allows it to do MySQL lookups. See the "experimental"
directory at one of the FTP sites listed on the home page. People claim
they got it working that way with cyrus:
http://andrew2.andrew.cmu.edu/cyrus/
(that's a nice IMAP/POP server; I don't know if you need a MySQL patch
for it; people on the Postfix list might give you more details).
(2) depends on your exact setup. Procmail looks at the user under
whose authority it's running; obviously, this can't be a "virtual"
user. With Postfix there is a workaround for that too, provided that
you either keep all the mailboxes owned by Postfix, or you map all your
virtual users to real (not necessarily distinct) users.
Your description is way too vague for somebody to be able to help
you. Messages being "displayed as a single mail" may mean either that
hopefully now better for you to understand :)
Personally, I'm still at loss WRT how is this related to "incoming
mails [...] being clubbed into a single mesg" and "mail sent by
different people are being displayed as a single mail".
(1) your MUA doesn't parse the folder correctly, or
(2) the folder is corrupted (the messages don't have the proper
separators).
that is not the problem, the problem/question is described on the top.
Are you 100% sure you followed up the right thread?
Regards,
Liviu Daia
--
Dr. Liviu Daia e-mail: Liviu(_dot_)Daia(_at_)imar(_dot_)ro
Institute of Mathematics web page: http://www.imar.ro/~daia
of the Romanian Academy PGP key: http://www.imar.ro/~daia/daia.asc