using ippol

[Tevfik Ceydeliler]

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

--