From: Victor Duchovni (Victor.DuchovniMorganStanley.com)
Date: Mon Sep 03 2007 - 09:21:54 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 abcde.ad 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:majordomopostfix.org?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.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]