OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: use postfix var in mysql query?

From: Kim Emax (postfixemax.dk)
Date: Tue Apr 01 2003 - 07:13:26 CST


Hello

----- Original Message -----
From: <Victor.Duchovnimorganstanley.com>
Sent: Tuesday, April 01, 2003 1:41 AM

> The feature in question is both unavailable and architecturally
> incompatible with the Postfix key/value map abstraction.
>
> Other more context sensitive abstractions may be available in the future,
> but they would be quite complex, one of the key selling points of Postfix
> is high functionality with low complexity, so context sensitive maps are
> hard, though the TCP map may evolve into something of this sort one day.

It would be nice in the future since, what I want to do is have a block of a
sender address pr. domain, so for instance domain1.com is blocking for mail
from thecoolestofferever.com, but domain2.com is not. My table would then
look like this:

table accesslist:
sender -
       - domain
thecoolestofferever.com - REJECT No spam Allowed - domain1.com

and the query would be:

"SELECT reason FROM accesslist WHERE sender = 'thecoolestofferever.com' AND
domain = 'domain1.com'";

I wan´t to give domain owners access to block senders to their domain, and
_only_ their own domain.

--
Take Care
Kim Emax - Freelance programmør
http://www.emax.dk - http://www.ayianapa.dk
Køb din vin online på http://www.gmvin.dk,
Danmarks måske mest avancerede VinWebShop