Solved my problem; details below.
On Fri, Oct 29, 2004 at 02:51:08PM -0400, Adam J. Henry wrote:
> I'm having a rough time getting a mysql query in a hostlist to work
> the way I expect. Running exim in '-bh 1.2.3.4' mode suggests that
> while the mysql lookup returned '1.1.1.1' for the hostlist, '1.2.3.4'
> somehow matches, thus [open] relaying is allowed. Can anyone please
> help me understand what I may be doing wrong?
>
>
> exim.conf contains:
>
> hostlist popb4smtp = mysql;SELECT DISTINCT ip FROM exim.popb4smtp
>
> accept hosts = +popb4smtp
> endpass
> verify = recipient
> verify = sender
The correct hostlist is:
hostlist popb4smtp = mysql;SELECT DISTINCT ip FROM exim.popb4smtp \
WHERE ip = '$sender_host_address'
Thanks for hearing me out =)