IP lease time mysql IP pool

[Alan DeKok]

On Apr 20, 2016, at 7:10 AM, Tevfik Ceydeliler <tevfik.ceydeliler at astron.yasar.com.tr> wrote:
> I have an IP pool  (near 30 IP) and some  client comes over GSM APN
> But altough clients disconnect and reconnect often, same client gets always different IP address.

  That's what happens if there's more users than IP addresses.

> As show  debug log below, altough same NAS IP and Calling station ID,  User gebzewm19 connected 2 times and got 2 diffrent IP addresses in shot time  It occurs till IP pool is full. Then  I get error thatIP ALLOCATION FAILED.
> I check  sqlippool.conf  the lease duration is :
> lease-duration = 7200
> and
> pool-key= "%{NAS-IP-Address}-%{Calling-Station-Id}"
> 
> Have you any suggestion to pass this problem?

  Check that the requests from the user are the same.  Run the SQL queries manually to see what they're doing.

  Alan DeKok.