SQL IP Pool maximum timeout.

[Peter Nixon]

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