using ippol
Randeep
randeep123 at gmail.com
Sat Jun 20 08:54:32 CEST 2015
Thanks Tevfik.
It worked.
Regards,
Randeep
On Fri, Jun 19, 2015 at 11:11 PM, Randeep <randeep123 at gmail.com> wrote:
> 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>
>
>
--
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