OSEC

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

From: Dick Middleton (dickfouter.net)
Date: Mon Sep 03 2007 - 04:32:48 CDT


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?

Thanks

Dick