Autor: Jeremy Harris Data: A: Exim users mailing list Assumpte: Re: [exim] Generate hostlist from MySQL
Alexander Shikoff wrote: > On Tue, Jan 23, 2007 at 12:19:38PM +0000, Jeremy Harris wrote:
>> Alexander Shikoff wrote:
>>> Is there a way to generate a hostlist from SQL database?
>>> I wish to make a hostlist from SQL like from file and then use it
>>> in RCPT ACL to match sender's IP address with 'hosts' condition.
>> http://exim.org/exim-html-4.66/doc/html/spec_html/ch10.html#id2590239 >
> Thanks a lot. I've read that chapter a lot of times before wrote to this
> mailing list. What about the case if database field contains not a single
> IP-address but a network address? In MySQL there is no way to write
> WHERE condition which will match IP-address against address of network.
Well, you only said SQL (not MySQL). postgreSQL certainly does;
I can't help with MySQL.