Re: [exim] reject sender hosts with dynamic ip

>>hostlist domain_reject = ${lookup mysql {SELECT concat(domain, ' : ')
>>from domain_reject order by domain}}
>>
> By default a query-style ${lookup ...} expansion returns all matching records
> separated by *newlines*, not the colons you need. And since you have to
> extract all records and match against each in turn you could simply put all
> patterns in a text file, one pattern per line, and refer to it by filename,
>

Hi, and thanks for the reply!

I'm a bit confused though. It sure does put '\n' there, but this does
not seem to affect all other sql-based lookups, such as virtual hosts,
domains, users, host_reject_rcpt list etc. All works fine except this
one, and the debug output shows that the '\n' is there in every sql
response:

10.0.0.0/8 :
172.16.0.0/12 :
192.168.0.0/16 :
...
which is the beginning of my host_reject_rcpt:

hostlist host_reject_rcpt = ${lookup mysql {SELECT concat(host, ' : ')
from host_reject order by host}}

text file is something i'm trying to avoid, as all of the MX hosts are
using the same sql table, therefore i don't need to distribute the same
text file every time i make a change.

thanks
Adam