On 12/22/05, Steve <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I'm sure this is true, but for basic functionality (specifically,
> checking if a user accepts mail at the MTA without using LMTP), Postfix
> does this quite easily:
>
> alias_maps = pgsql:/etc/postfix/sql-recipients.cf
> (Belongs in Postfix's main.cf)
>
> Where sql-recipients.cf looks like this:
>
> user = <db user>
> password = <db password>
> hosts = <db host (typically 127.0.0.1)>
> dbname = <db name>
> table = dbmail_aliases
> select_field = alias
> where_field = alias
>
> This is, of course, another opinion. :)
>
> For additional information, you might look at this article on comparing
> MTAs:
> http://shearer.org/en/writing/mtacomparison.html
> A bit old, but most of the information should still be relevant.
Yes. It's goodfor me as postfix users and it is fast because it is a sql
query.
Good luck,
> -Steve
>
>
> Thomas Mueller wrote:
> > Hi,
> >
> >
> >>p.s. - If anyone has any strong opinions on the Postfix/Exim front, I'm
> >>all ears. I'm currently leaning toward investing some significant time
> >>in Exim, but if there are any gotcha's or other considerations, I'd
> >>rather know sooner than later. This is OT for this list, so just send
> >>me an email directly. Thanks.
> >
> >
> > Exim is very nice and mighty - the ACLs are very, very useful.
> > I have an ACL at SMTP level (rcpt) that checks if a user is in the
> > database. If not I can reject and don't have to pass the mail to
> > dbmail-lmtpd to get an error.
> >
> > deny
> > message = recipient [EMAIL PROTECTED] is not known here
> > domains = +local_domains
> > condition = ${if >{${lookup pgsql{SELECT alias_idnr \
> > FROM dbmail_aliases \
> > WHERE alias =
> > '${quote_pgsql:[EMAIL PROTECTED]' \
> > OR alias =
> > '${quote_pgsql:@$domain}' \
> > LIMIT 1}}}{0}{no}{yes}}
> >
> > You can do lot of cool things with ACLs.
> >
> >
> > Thomas
> >
> > _______________________________________________
> > Dbmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
>
>
> --
> Steve Cox
> Linux User #365987
> www.stevecox.us
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
