<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span>Hi Fajar,</span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><br></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span>We have uncommented the pool-key for NAS-PORT & CALLING-STATION-ID under sqlippool.conf and hence want the calling-station-id to be used when the lease expires/new session such that user has more chances of getting the same ip address again.</span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; "><br></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span
class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; ">pool-key = "%{NAS-Port}"</span><br></div><div><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; ">pool-key = "%{Calling-Station-Id}"</span><br></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; "><br></span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; ">As i said earlier, the CALLING_STATION-ID sent by LAC is so long that the first 30 characters are always unique and we end up in users competing for the same IP address i.e. duplicate IP address. so that is the
reason we want to modify the schema for RADIPPOOL where field CALLING-STATION-ID is varchar(30) and we would modify is to varchar(100)</span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; "><br></span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; ">Please advise.</span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; "><br></span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span><span class="Apple-style-span" style="font-family: 'times
new roman', 'new york', times, serif; font-size: 16px; ">TIA</span></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "> </div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt; "><span style="font-family: garamond, 'new york', times, serif; "><font size="3"><span style="color:rgb(0, 0, 255);font-weight:bold;">Hitesh Vinzoda</span><br><span style="font-weight:bold;color:rgb(0, 0, 0);">Network Administrator</span><br style="font-weight:bold;color:rgb(0, 0, 0);"><span style="font-weight:bold;color:rgb(0, 0, 0);">+91-9924117399<br><span style="color:rgb(0, 0, 255);text-decoration:underline;">www.vinzoda.in</span><br></span><br>"There are 10 types of people in this world.<br>One who can understand binary and other's can't."</font><br><br><br></span><br></div> <div style="font-size: 10pt; font-family: verdana, helvetica, sans-serif; "> <div style="font-size: 12pt; font-family: 'times new
roman', 'new york', times, serif; "> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Fajar A. Nugraha <list@fajar.net><br> <b><span style="font-weight: bold;">To:</span></b> Hitesh Vinzoda <hiteshvinzoda@yahoo.com>; FreeRadius users mailing list <freeradius-users@lists.freeradius.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, 15 December 2011 12:25 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Changing Schema for radippool<br> </font> <br>On Thu, Dec 15, 2011 at 1:19 PM, Hitesh Vinzoda <<a ymailto="mailto:hiteshvinzoda@yahoo.com" href="mailto:hiteshvinzoda@yahoo.com">hiteshvinzoda@yahoo.com</a>> wrote:<br>> Hi,<br>><br>> Our provider is sending the calling-station-id usually larger than 50<br>> characters while the schema for RADIPPOOL table in MYSQL has defined this<br>> field for 30 CHARACTERS. because of this we are
seeing unusual behaviour in<br>> IP address assignment as first 35 characters are same for all users and last<br>> part varies.<br><br>AFAIK the column you need to change is pool-key. But before you do<br>that, take a look at the comment on sqlippool.conf<br><br> ## Attribute which should be considered unique per NAS<br> ## Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS)<br> ## Using Calling-Station-Id works for NAS that send fixed NAS-Port<br> ## ONLY change this if you know what you are doing!<br> pool-key = "%{NAS-Port}"<br> # pool-key = "%{Calling-Station-Id}"<br><br>if NAS-Port is unique, better just use that.<br><br>> I want to change it to 100. Is it advisable to change the field<br>> schema in RADIPPOOL?<br><br>It shouldn't be a problem, although I'd recommend just use NAS-Port as pool-key.<br><br>-- <br>Fajar<br><br><br> </div> </div> </div></body></html>