On Thu, Dec 15, 2011 at 1:19 PM, Hitesh Vinzoda <hiteshvinzoda@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