On Thu, Dec 15, 2011 at 1:19 PM, Hitesh Vinzoda <hiteshvinz...@yahoo.com> wrote: > Hi, > > Our provider is sending the calling-station-id usually larger than 50 > characters while the schema for RADIPPOOL table in MYSQL has defined this > field for 30 CHARACTERS. because of this we are seeing unusual behaviour in > IP address assignment as first 35 characters are same for all users and last > part varies.
AFAIK the column you need to change is pool-key. But before you do that, take a look at the comment on sqlippool.conf ## Attribute which should be considered unique per NAS ## Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS) ## Using Calling-Station-Id works for NAS that send fixed NAS-Port ## ONLY change this if you know what you are doing! pool-key = "%{NAS-Port}" # pool-key = "%{Calling-Station-Id}" if NAS-Port is unique, better just use that. > I want to change it to 100. Is it advisable to change the field > schema in RADIPPOOL? It shouldn't be a problem, although I'd recommend just use NAS-Port as pool-key. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html