From: Victor Duchovni (no email)
Date: Mon Sep 03 2007 - 10:21:54 EDT
On Mon, Sep 03, 2007 at 10:32:48AM +0100, Dick Middleton wrote:
> Hello,
>
> For better or worse I'm trying to setup mysql to do helo checks on a
> country basis. I've got a table set up with the tld as the "key" and
> query it like this:
>
> query = SELECT helo FROM country WHERE code = '%1'
>
> If I do a lookup with an email address it works fine:
>
> # postmap -q mysql:/etc/postfix/local.d/helo_country.mysql
> reject_unknown_client_hostname
>
> but if I do the same without the user part (which is what helo checks
> will do I think) I get no output:
>
> postmap -q cde.ad mysql:/etc/postfix/local.d/helo_country.mysql
>
> I using postfix version 2.3.7. What is it I'm not doing right?
Sorry, the "%n" macros are not designed for domain-only lookup keys.
-- Viktor. Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the "Reply-To" header. To unsubscribe from the postfix-users list, visit http://www.postfix.org/lists.html or click the link below: <mailto:?body=unsubscribe%20postfix-users> If my response solves your problem, the best way to thank me is to not send an "it worked, thanks" follow-up. If you must respond, please put "It worked, thanks" in the "Subject" so I can delete these quickly.
|
|
|