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 [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
