Re: [exim] Blacklisting IP Ranges Using MySQL

Top Page
Delete this message
Reply to this message
Author: Mike Cardwell
Date:  
To: exim-users
Subject: Re: [exim] Blacklisting IP Ranges Using MySQL
On 08/10/2010 22:59, Jeremy Harris wrote:

>>>> Is there a way to blacklist IP ranges using MySQL?
>>> [...]
>>>> 41.0.0.0/8
>>>> 58.0.0/8
>>>
>>> condition = ${if match_ip{$sender_host_address}\
>>>                            {${lookup mysql.......}}}

>>
>> Every time that condition is called, it would fetch the entire table of
>> data from MySQL and then use Exim to sort through it.
>
> Depending entirely on what lookup you did.....


If you just stored network addresses like 41.0.0.0/8, you'd have to
fetch the entire table, hence my long description of using IP numbers.

-- 
Mike Cardwell - Perl/Java/Web developer, Linux admin, Email admin
Read my tech Blog -              https://secure.grepular.com/
Follow me on Twitter -           http://twitter.com/mickeyc
Hire me - http://cardwellit.com/ http://uk.linkedin.com/in/mikecardwell