using ippol

Randeep randeep123 at gmail.com
Fri Jun 19 19:41:38 CEST 2015


Thanks Tevfik.

I'll try this.

Regards,
Randeep

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

> yes u can do this.
> in sql database there is a table called "radgroupcheck"
> mysql> select * from ( select * from radgroupcheck order by id desc limit
> 10) sub order by id ASC;
>
> and "radusergroup"
>
> those two tables are related between them
> check those tables..
>
>
> On 06/19/2015 01:56 PM, Randeep wrote:
>
>> 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
>>>
>>>
>>
>>
> --
> -
> 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>


More information about the Freeradius-Users mailing list