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.
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 $local_part $domain
is not known here
> domains = +local_domains
> condition = ${if >{${lookup pgsql{SELECT
alias_idnr
> FROM
dbmail_aliases
> WHERE alias =
> '${quote_pgsql:$local_part$domain}'
> OR alias =
> '${quote_pgsql:$domain}'
> LIMIT
1}}}}
>
> You can do lot of cool things with ACLs.
>
>
> Thomas
>
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
--
Steve Cox
Linux User #365987
www.stevecox.us
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|