using ippol

[Randeep]

Thanks a lot Tevfik. I was able to make it work.

But I had to give the following in the "/etc/raddb/users".

randeep Pool-Name := "main_pool"

Where randeep is username.

But for each user we cannot give this right. This user is a part of a
group. can we specify the ip pool for a group?


Regards,
Randeep

On Fri, Jun 19, 2015 at 1:12 PM, Tevfik Ceydeliler <
tevfik.ceydeliler at astron.yasar.com.tr> wrote:

> 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
>>>
>>
>>
>>
>>
> --
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>



-- 
Randeep
Mob: +919447831699[kerala]
Mob: +919880050349[B'lore]
http://twitter.com/Randeeppr
http://in.linkedin.com/in/randeeppr

[image: --]
Randeep Raman
[image: http://]about.me/Randeeppr
<http://about.me/Randeeppr>