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

tnt at kalik.net tnt at kalik.net
Wed Jan 28 15:07:43 CET 2009

>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

More information about the Freeradius-Users mailing list