On Wed, Feb 15, 2012 at 05:57:55PM +0100, Jack Knowlton wrote:
> Do you think this could work

postmap(1) is your friend.

postmap -q listed@address mysql:/path/to/your/query

Where "listed@address" is in the recipient_access table address 
column.

> CREATE TABLE IF NOT EXISTS `recipient_access` (
>   `id` int(4) NOT NULL AUTO_INCREMENT,
>   `insdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
>   `address` varchar(64) NOT NULL,
>   `action` text NOT NULL,
>   PRIMARY KEY (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
> 
> with this query:
> 
> dbname = postfix
> hosts = 10.0.1.54
> query = SELECT action FROM recipient_access WHERE address='%s'
-- 
  http://rob0.nodns4.us/ -- system administration and consulting
  Offlist GMX mail is seen only if "/dev/rob0" is in the Subject:

Reply via email to