OSEC

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

steeeeeveeegmx.net
Date: Mon Sep 03 2007 - 13:30:00 CDT


-------- Original-Nachricht --------
> Datum: Mon, 03 Sep 2007 10:32:48 +0100
> Von: Dick Middleton <dickfouter.net>
> An: postfix-userspostfix.org
> Betreff: mysql domain lookups

> 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?
>
Where do you do those checks? It can't be smtpd_helo_restrictions?

> Thanks
>
> Dick
>
>
>
>

--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer