Re: Amavisd-new to qpsmtpd

[John Peacock]

Max Clark wrote:
My preference would be qpsmtpd->postfix - how do I lookup and validate 
the receipients from mysql using qpsmtpd (using the postfix virtual 
tables we have a domain table, an alias table, and a mailbox table)?

Take a look at the plugins/auth/auth_vpopmail_sql for an example of 
querying an external database (in that case it is for AUTH purposes, but 
you can see how to query the database from within qpsmtpd).  It should 
be very straightforward to create a check_postfix plugin which validates 
all RCPT addresses vs. the postfix tables.

In another way to do it, for my network, I have a single user database 
in MySQL (for vpopmail, but postfix is very similar).  Then I have two 
MX boxes with no local users installed, and I chose to use finger to 
query the central database (rather than querying MySQL directly from the 
remote boxes).  I chose finger because it is a very lightweight query 
and I can specify exactly what I consider a valid address.  I'd be happy 
to send you that code, which just does a SQL query (actually three) 
using the C interface to MySQL.

HTH

John