On Mon 09 Jul 2007, Alan DeKok wrote:
Peter Nixon wrote:
In other words, it should only be clearing IP's for which a 'stop' query has gone astray, on the basis that you can't have more than one connection to an individual NAS port. It certainly shouldn't just free up all IP's based on expiry_time.
Exactly..
Will it re-allocate IP's once the expiry time has passed? That seems to be the problem, I think.
Yes. That IS the purpose of the expiry time :-) As long as you are getting accounting updates the expiry time continues to be extended. See: alive-update = "UPDATE ${ippool_table} \ SET expiry_time = 'now'::timestamp(0) + '${lease-duration} seconds'::interval \ WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '${pool-key}' AND username = '%{SQL-User-Name}' \ AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc