<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18865">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>First, please let me wish everyone a Happy New Year in the list. I've
learned a lot in the past 12 months and have a fairly stable installation of
2.1.6 on CentOS 5.4.</DIV>
<DIV> </DIV>
<DIV>The question, I would like to ask is how can I improve on this and use a DB
List/Table to Blacklist certain IP addresses.</DIV>
<DIV> </DIV>
<DIV>if(Calling-Station-Id ==
218.18.XX.XX){<BR>
reject<BR>}<BR>if(Calling-Station-Id ==
113.237.XX.XX){<BR> reject<BR>}</DIV>
<DIV> </DIV>
<DIV>The reason I'm having to do this is that we offer a 1hr Free Trial of our
services and use the Email Address and IP address at the point of
registration to ensure that the same person does not keep requesting more and
more free trials. Obviously this not perfect and manages to address most
of our requirements.</DIV>
<DIV> </DIV>
<DIV>However, there are a view people out there, that registered with a spoof IP
Address and another free hotmail account etc, thus getting another Free Trial
over and over again. The way I'm stop this currently, is manually check
the record we had at the point of request for the Free Trial, and the IP address
used to access the Service, if these are different then I block the IP address
using the unlang above.</DIV>
<DIV> </DIV>
<DIV>There is only a few currently, but should this increase and I would like a
more fool proof way to manage this and register the fact that someone has abused
our free trial service and BLOCK there IP from accessing our service, even if
they have been given a Username/Password via the Free Trial Page.</DIV>
<DIV> </DIV>
<DIV>Thanks in advance,</DIV>
<DIV> </DIV>
<DIV>Nev</DIV></BODY></HTML>