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.