Freeradius mysql ippool duplicate IP's

[Alan DeKok]

Wesley wrote:
> After lots of log watching & trying different things to resolve other
> odd messages in the log I can
> confirm that if i drop the pppoe connection it will release it & then
> reassign generally the same IP.

  And *why* does it do that?  You have access to the debug logs.  You've
been told to read them.  Yet you're not reading them.

  The ONLY WAY you will solve this issue is by reading the debug logs.
Everything else you do is a complete and total waste of your time.

> If the NAS looses connectivity/power and then comes back, none of the
> old leases are re-assigned to
> the same users once connectivity/power is restored, they just get
> assigned new IP's.

  That isn't a problem.

> Any help to what setting I should be looking at or what message from
> debug/log file i need to be searching for regarding the above mentioned
> issue..

  Read the debug logs to see what's happening.  I don't know what you've
changed on your system, because you've been careful not to say.  I don't
know what is going on in your system, because you're not looking at the
debug logs.

  Again, the ONLY reason FreeRADIUS assigns an IP is because it thinks
that the IP is free.  If you're getting duplicate IP assignments, it's
because something ELSE in the network isn't telling FreeRADIUS that the
IP is still in use.

  I've said this repeatedly, and you don't seem to be paying attention.

  Is the NAS sending Interim-Update (or Alive) packets?  If not, THAT is
the source of the problem.  Fix it.

  For v2.x, read "raddb/sql/mysql/ippool.conf"  The comments in that
file explain how it works.  They explain what the queries do.  And when
they're run.

  If you're going to only look at the *results* of the IP address
assignment, you will never know *why* an IP was assigned.

  Alan DeKok.