[Exim] Mysql and exim ( single lookups and lists ) help

Etusivu
Poista viesti
Vastaa
Lähettäjä: Terry M
Päiväys:  
Vastaanottaja: exim-users
Aihe: [Exim] Mysql and exim ( single lookups and lists ) help
Greetings,,

looking to replace this type thing

deny hosts = 192.168.0.0/16 : 10.10.10.15 :
127.11.12.0/24


with a mysql type command..
example: select ipblock from blacklist
would return every entry in table { one per line }

here is one that did not work
deny hosts = 100.100.105.219 : mysql;SELECT ipblock
FROM blacklist

and another
deny hosts = mysql;select ipblock from blacklist

Here is one that did work.. BUT it will not work
well with blocks, but will work with IP's

deny hosts = ${lookup mysql {select ipblock from
blackserver where ipblock like
'${quote_mysql:$sender_host_address}' } }


any help will be great..
Terry


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com