using ippol

[Randeep]

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




-- 
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>