But there seems to be a problem with this statement now:
------------- SELECT framedipaddress FROM radippool WHERE pool_name = 'poolDE' AND expiry_time < NOW() ORDER BY (username <> 'peter2'), (callingstationid <> ''), expiry_time LIMIT 1 FOR UPDATE ------------
This statement should receive a free ip-adress, i think, but it doesn't.
There is also a clue:
[sqlippool] SQL query did not return any results
Your IP pool is used up.
I think the problem is the part "expiry_time < NOW()". This is not working in mysql. Does anyone know how to fix this?
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. Ivan Kalik Kalik Informatika ISP