OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: sender_checks via Mysql

From: /dev/rob0 (rob0gmx.co.uk)
Date: Mon Nov 28 2005 - 16:35:59 CST


On Monday 2005-November-28 13:55, Magnus Bäck wrote:
> select_field = action
> table = whatever your table is called
> where_field = email
>
> http://www.postfix.org/mysql_table.5.html

FWIW this is the old syntax. The new way has "query =" with the SQL
query itself:

query = SELECT action FROM tablename WHERE email = '%s'

For sender checks one might want a conditional query to also check
against '%u' and '%d', but I have not gotten that far yet. :)
--
    mail to this address is discarded unless "/dev/rob0"
    or "not-spam" is in Subject: header