Brian Spraker <spraker@???> (Mo 10 Feb 2014 19:59:57 CET):
> >
> >I have a wildcard match - "*yahoo.com" in the domains whitelist and it doesn't seem to take effect. Also just tried "yahoo.com" and *.yahoo.com".
> >
> >
> >I used "exim -bh 98.139.213.141" at the command line to do some testing. I see where exim does the SQL lookup and does the test, but none of them match (since the full reverse DNS of 98.139.213.141 is nm23-vm1.bullet.mail.bf1.yahoo.com).
> >
> >In the exim configuration, here is the code used:
> >
> > accept
> > hosts = ${lookup mysql{SELECT domain FROM exim_domain_whitelist }}
${extract{-2}{.}{$sender_host_name}.${extract{-1}{.}{$sender_host_name}}
will give you the 2 rightmosts parts of the host name.
You can construct a SQL query using this expansion. Or if you know
MySQL, you might use the text functions of mysql to get the two right
most parts of $sender_host_name.
But, $sender_host_name might be empty if the lookup didn't succeed for
PTR AND the forward lookup didn't match the address!
Best regards from Dresden/Germany
Viele Grüße aus Dresden
Heiko Schlittermann
--
SCHLITTERMANN.de ---------------------------- internet & unix support -
Heiko Schlittermann, Dipl.-Ing. (TU) - {fon,fax}: +49.351.802998{1,3} -
gnupg encrypted messages are welcome --------------- key ID: 7CBF764A -
gnupg fingerprint: 9288 F17D BBF9 9625 5ABC 285C 26A9 687E 7CBF 764A -
(gnupg fingerprint: 3061 CFBF 2D88 F034 E8D2 7E92 EE4E AC98 48D0 359B)-