using ippol

[Tevfik Ceydeliler]

radius
I think this document  will help u about sqlippool:

http://www.tuxlanding.net/freeradius-style-dhcp-and-high-availability/

regards...

On 06/19/2015 10:28 AM, Randeep wrote:
> Thanks Tevfik.
>
> One question is what name I have to give in db for pool_name.
>
> Should I give main_pool(defined in/etc/raddb/modules/ippool) or the
> sqlippool(defined in /etc/raddb/sqlippool.conf)
>
> Regards,
> Randeep
>
> On Fri, Jun 19, 2015 at 12:40 PM, Tevfik Ceydeliler <
> tevfik.ceydeliler at astron.yasar.com.tr> wrote:
>
>> U have to fill ippool table in sql side
>> mysql> select * from ( select * from radippool order by id desc limit 10)
>> sub order by id ASC;
>>
>> +------+--------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+
>> | id   | pool_name    | framedipaddress | nasipaddress | calledstationid |
>> callingstationid | expiry_time | username | pool_key |
>>
>> +------+--------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+
>> | 5565 | IP_VfoneASOS | 172.30.32.247   | |                 |
>>        | NULL        | |          |
>> | 5566 | IP_VfoneASOS | 172.30.32.248   | |                 |
>>        | NULL        | |          |
>> | 5567 | IP_VfoneASOS | 172.30.32.249   | |                 |
>>        | NULL        | |          |
>> | 5568 | IP_VfoneASOS | 172.30.32.250   | |                 |
>>        | NULL        | |          |
>> | 5569 | IP_VfoneASOS | 172.30.32.251   | |                 |
>>        | NULL        | |          |
>> | 5570 | IP_VfoneASOS | 172.30.32.252   | |                 |
>>        | NULL        | |          |
>> | 5571 | IP_VfoneASOS | 172.30.32.253   | |                 |
>>        | NULL        | |          |
>> | 5572 | IP_VfoneASOS | 172.30.32.254   | |                 |
>>        | NULL        | |          |
>> | 5573 | IP_VfoneASOS | 172.30.32.255   | |                 |
>>        | NULL        | |          |
>> | 5574 | IP_VfoneMEAM | 172.30.97.52    | |                 |
>>      | NULL        |          | 0        |
>>
>> +------+--------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+
>>
>>
>>
>> On 06/19/2015 09:39 AM, Randeep wrote:
>>
>>> Hi all,
>>>
>>> I'm trying to configure freeradius to send the ip for the user.
>>>
>>> In the radiusd.conf i have uncommented  $INCLUDE sqlippool.conf
>>>
>>> in the sqlippool.conf,
>>>
>>> I have enabled mysql ippool.conf
>>>
>>> in the file /etc/raddb/modules/ippool,
>>>
>>> I have defined ippool main_pool.
>>> And specified the range, netmask etc in the block.
>>>
>>> Key I have specified as
>>> key = "%{NAS-IP-Address} %{NAS-Port}"
>>>
>>> But my radippool table is empty. Do I have to specify anything there?
>>>
>>>
>>> I'm testing with radtest. I hope this can be tested with it.
>>>
>>> In the respose i'm getting like this
>>>
>>> [root at localhost ~]# radtest randeep  randeep123 192.168.1.182 0  lukup124
>>> Sent Access-Request Id 110 from 0.0.0.0:49548 to 192.168.1.182:1812
>>> length
>>> 77
>>>           User-Name = 'randeep'
>>>           User-Password = 'randeep123'
>>>           NAS-IP-Address = 127.0.0.1
>>>           NAS-Port = 0
>>>           Message-Authenticator = 0x00
>>>           Cleartext-Password = 'randeep123'
>>> Received Access-Accept Id 110 from 192.168.1.182:1812 to 0.0.0.0:0
>>> length 56
>>>           Framed-Protocol = PPP
>>>           Framed-IP-Netmask = 255.255.255.0
>>>           Framed-MTU = 1500
>>>           Framed-Routing = Broadcast-Listen
>>>           Framed-Compression = Van-Jacobson-TCP-IP
>>>           Service-Type = Framed-User
>>> [root at localhost ~]#
>>>
>>> Do I have to give sqlippool or mainpool in
>>> authenticate/authorize/account/preauth in sites-enabled/default?
>>>
>>> Please advice.
>>>
>>> Regards,
>>> Randeep
>>> -
>>> List info/subscribe/unsubscribe? See
>>> http://www.freeradius.org/list/users.html
>>>
>> --
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
>
>

--