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

[Sebastian Heil]

> 
> 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.

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?  

-- 
NUR NOCH BIS 31.01.! GMX FreeDSL - Telefonanschluss + DSL 
für nur 16,37 EURO/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a