Thanks Nick - I guess the question is whether the checkuser patch will query the mysql database or whether it determines valid domains/users/aliases/mailinglists by querying /etc/control/assign. From reading the vpopmail.mysql docs it appears only the contents of vpasswd is stored in the mysql database which would not be sufficient to provide the functionality we need - since that would exclude aliases and mailinglists.
At 04:33 PM 1/14/2004, you wrote:On Wed, 2004-01-14 at 15:26, Jeff Koch wrote:
> We're setting up a smart-host mail router to just handle qmail scanning.
> The mail will then go to the appropriate mailserver where spam filtering
> will be done and the mail dropped into vpopmail accounts.
>
> We get about 50-60K spam emails per day that are addressed to real domains
> but non-existent users. We need to be able to reject emails to non-existent
> users at the entry to the smart host mail router so that we don't waste
> time virus scanning them or delivering them to the mailservers. The
> checkuser patch has the functionality to accomplish this as long as we
> setup a mirror of vpopmail on the smart-host mail router.
Why don't you just use vpopmail with users stored in mysql, then have
each server query the mysql server? You can even use MySQL replication
to run local read only copies of the database for efficiency.
> So we'll use the
> checkuser patch and setup domains and users with vpopmail on the smart host
> mail router so that we can reject email to non-existent users. We'll write
> some programs to keep vpopmail on the smart-host mail router in sync with
> the vpopmails on the mailservers.
This'd be called MySQL and replication.
>
> Of course if the checkuser patch could consult a mysql database instead it
> would be cleaner but gotta live with what we have. If anyone has a better
> solution let me know.
>
I run a cluster of qmail/vpopmail using mysql replication and NFS, and
it all works flawlessly. I'm planning on integrating the chkuser patch
shortly to start reducing the volume of queued bounces I have to deal
with.
>
>
> At 03:17 PM 1/14/2004, you wrote:
>
> >Can you explain better what are you trying to do?
> >
> >How the "patched qmail-smtpd" is run?
> >
> >Have both servers the same domains declared and the same "users data base"?
> >
> >Tonino
> >
> >At 14/01/2004 14/01/2004 -0500, Jeff Koch wrote:
> >
> >>We trying to setup a Smart Host mail router but kludge the checkuser
> >>patch and vpopmail to verify the domain and user name before smpt'ing the
> >>mail to the appropriate mailserver. However, we're getting stuck - the
> >>server keeps trying to deliver the mail locally even though we have
> >>smtproutes setup.
> >>
> >>We'd like to keep the junk from being pushed through the smarthost (we
> >>get about 60K messages a day to non-existent usernames) - and the
> >>checkuser patch seemed to be the answer. We thought that having
> >>smtproutes setup would prevent local delivery.
> >>
> >>Does anyone know of any other patches or have any thoughts on how this
> >>could be done?
> >>
> >>
> >>
> >>Best Regards,
> >>
> >>Jeff Koch, Intersessions
> >
> >------------------------------------------------------------
> > [EMAIL PROTECTED] Interazioni di Antonio Nati
> > http://www.interazioni.it [EMAIL PROTECTED]
> >------------------------------------------------------------
> >
>
> Best Regards,
>
> Jeff Koch, Intersessions
>
Best Regards,
Jeff Koch, Intersessions
Best Regards,
Jeff Koch, Intersessions
