IP-Assignment with sqlippool based on nas-ip-address

Alan DeKok aland at deployingradius.com
Thu Jan 29 14:11:45 CET 2009

Sebastian Heil wrote:
>> Hm, does it "see" NULL greater than now()? Replace NULL in expiry_time
>> column with "0000-00-00 00:00:00" (that's what MySQL thinks null
>> datetime is - it will match IS NULL). And in that previous query replace
>> = NULL with = '0000-00-00 00:00:00'.
>> If this is so, sqlippool schema will need to be changed.
> This works. Yes, i think the schema really needs a update.

  As always, patches are welcome.

> i have another question: when does the server free an ip-address? i tested a login with the same username within one minute and the server reserved two different ip-addresses. i thought, that the server will use the same ip-address for the second login, but the server doesn't.
> Which behaviour is the right one?  

  The server frees IP's when accounting stop packets are received.  This
is the correct behavior.

  Alan DeKok.

More information about the Freeradius-Users mailing list