|
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 (dick
fouter.net)
Date: Mon Sep 03 2007 - 04:32:48 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 ab
cde.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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]