ippool

[Alan DeKok]

Alexandre Chapellon wrote:
> Looking at freeradius online doc, i saw that sqlippool requires
> transmission of interim-updates packets to the accounting server to
> "function correctly"

  It uses the interim-updates to mark the IP address as "still in use".

> (http://wiki.freeradius.org/Rlm_sqlippool#Important_Info).
> I what would like to use sqlippool to manage ip allocation of
> framed-users, but my NASes doesn't send me Interim packets.
> What issue may I face using sqlippool anyway?

  Hmm... it looks like it uses a hard-coded lease duration in
sqlippool.conf.  I suggest changing the "allocate-update" query in
sql/*/ippool.conf from:

	... INTERVAL ${lease-duration} ...
  to

	... INTERVAL %{%{reply:Session-Timeout}:-${lease-duration}} ...

  i.e. set the lease duration to the Session-Timeout in the reply.  At
that point, the lease is allocated until the user logs off, or until the
NAS kicks the user off at the end of their session.

  You'll also need to change the "start-update" query so that it doesn't
update the expiry time.

  That should work.

  The main issue is that if a user logs in and you *don't* get an
accounting Start, then the lease is still allocated.

  Alan DeKok.