John Peacock wrote: > 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. > Unnecessary, if you use Postfix -> qpsmtpd -> postfix Don't need to develop anything, it already works.
> 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. > > Just like the postfix address verification feature in Postfix -> qpsmtpd -> postfix Don't need to develop anything, it already works.