Re: [exim] mysql query as hostlist problem

Top Page
Delete this message
Reply to this message
Author: Adam J. Henry
Date:  
To: exim-users
Subject: Re: [exim] mysql query as hostlist problem
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 =)