<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-874"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 1/5/2010 5:58 AM, EasyHorpak.com wrote:
<blockquote cite="mid:4B43459A.6090309@easyhorpak.com" type="cite">
<meta content="text/html; charset=windows-874"
http-equiv="Content-Type">
<title></title>
Charles wrote:
<blockquote cite="mid:004101ca8dfc$8f7c1830$2200fa0a@mordekai"
type="cite">
<meta content="text/html; charset=windows-874"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.18702">
<style></style>
<div><font size="2" face="Arial">I am also facing the same problem
-
Need to blacklist range of IPs</font></div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;">
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">-----
Original
Message ----- </div>
<div
style="background: rgb(228, 228, 228) none repeat scroll 0% 50%; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b>From:</b>
<a moz-do-not-send="true" title="nev@itsnev.co.uk"
href="mailto:nev@itsnev.co.uk">Neville</a> </div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b>
<a moz-do-not-send="true"
title="freeradius-users@lists.freeradius.org"
href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>
</div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b>
Tuesday, January 05, 2010 11:55 AM</div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b>
Reject Calling-Station-Id</div>
<div><br>
</div>
<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>
________________________________________________________________
<div style="border: 0px none ; width: 468px;">
<form method="get" action="http://order.1and1.com/dcjump"
target="_blank">
<p align="center">5 free Domains with Select Hosting Plans. Get
yours!</p>
<center>
<table border="0" width="320">
<tbody>
<tr>
<td class="form"><input value="25085883" name="k_id"
type="hidden"> <input maxlength="500" name="domain"> </td>
<td>
<select style="width: 60px;" name="tld">
<option selected="selected" value="com">com</option>
<option value="net">net</option>
<option value="org">org</option>
<option value="info">info</option>
<option value="us">us</option>
<option value="name">name</option>
<option value="biz">biz</option>
<option value="cc">cc</option>
<option value="tv">tv</option>
<option value="ws">ws</option>
<option value="mobi">mobi</option>
</select>
</td>
<td> </td>
<td><input value="Check Domain" name="Submit"
type="submit"> </td>
</tr>
</tbody>
</table>
</center>
</form>
</div>
<p> </p>
<hr> -<br>
List info/subscribe/unsubscribe? See
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></blockquote>
________________________________________________________________
<div style="border: 0px none ; width: 468px;">
<form method="get" target="_blank"
action="http://order.1and1.com/dcjump">
<p align="center">5 free Domains with Select Hosting Plans. Get
yours!</p>
<center>
<table border="0" width="320">
<tbody>
<tr>
<td class="form"> <input name="k_id" value="25085883"
type="hidden"><input size="20" maxlength="500" name="domain"
type="text"> </td>
<td>
<select style="width: 60px;" name="tld">
<option value="com">com</option>
<option value="net">net</option>
<option value="org">org</option>
<option value="info">info</option>
<option value="us">us</option>
<option value="name">name</option>
<option value="biz">biz</option>
<option value="cc">cc</option>
<option value="tv">tv</option>
<option value="ws">ws</option>
<option value="mobi">mobi</option>
</select>
</td>
<td> </td>
<td> <input name="Submit" value="Check Domain"
type="submit"></td>
</tr>
</tbody>
</table>
</center>
</form>
</div>
<pre wrap=""><hr size="4" width="90%">
-
List info/subscribe/unsubscribe? See <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
if (Calling-Station-Id == "%{sql: SELECT mac FROM `lrc_banlist` WHERE
mac='%{Calling-Station-Id}'}") {<br>
<br>
<br>
update reply {<br>
Reply-Message = "Hello Hello Hello"<br>
}<br>
reject<br>
}<br>
<br>
Read Uncle Alan has replied this.<br>
</blockquote>
<br>
To save the followup exchange:<br>
<br>
update reply {<br>
Reply-Message := "Hello Hello Hello"<br>
}<br>
<br>
Uncle Alan?...<br>
<br>
-Arran<br>
</body>
</html>