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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html