Static ippool based on NAS source

[renator at flash.net.br]

I was afraid of using sqlippool because the DB of this server is MySQL and
there is a warning about that in FreeRadius:

 #  WARNING: MySQL has certain limitations that means it can
 #           hand out the same IP address to 2 different users.

Because of this I would like to try via config file before installing Pgsql.

Thanks for your reply!

>> So, trying to be clear, what we need is:
>>
>> IF mobile CONNECTS via NAS1 -> Gets IP from pool1
>>         IF mobile CONNECTS via NAS1 again -> Gets THE same IP from pool1
>> IF mobile CONNECTS via NAS2 -> Gets IP from pool2
>>         IF mobile CONNECTS via NAS2 again -> Gets THE same IP from pool2
>>
>>
>> Everything seems to work, BUT, the mobiles are getting always 2 ips
>> instead of 1. I mean:
>>
>> Mobile CONNECTS via NAS1 -> Gets IP from pool1
>> Mobile CONNECTS again via NAS1 -> Gets ANOTHER IP from pool1
>> Mobile CONNECTS via NAS2 -> Gets IP from pool2
>> Mobile CONNECTS again via NAS2 -> Gets ANOTHER IP from pool2
>>
>> If I keep reconnecting with this mobile several times, I always get 1 of
>> these 4 ips.
>>
>> Is there a better way to do what I need?
>
> Use sqlippool. It has queries to try to assign IP issued the last time.
>
> Ivan Kalik
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>