Assign Static IP address on Freeradius with SQL

Tevfik Ceydeliler tevfik.ceydeliler at astron.yasar.com.tr
Thu Feb 26 14:07:47 CET 2015


Hi,
I can assign IP address to user  from  sql ip  pool
But Cant assign static IP address  to user

mysql> select * from radcheck where username like 'kivanccepel1' ;
+-----+--------------+--------------------+----+---------+
| id  | username     | attribute          | op | value   |
+-----+--------------+--------------------+----+---------+
| 211 | kivanccepel1 | Cleartext-Password | := | test    |
| 212 | kivanccepel1 | Proxy-to-Realm     | := | secovid |
+-----+--------------+--------------------+----+---------+

and
mysql> select *from radreply;
+----+--------------+-------------------+----+--------------+
| id | username     | attribute         | op | value        |
+----+--------------+-------------------+----+--------------+
|  1 | kivanccepel1 | Framed-IP-Address | := | 172.30.80.50 |
|  2 | kivanccepel1 | Service-Type      | := | Framed-User  |
+----+--------------+-------------------+----+--------------+

and log is like that:

[sql]     expand: SELECT id, username, attribute, value, op           
FROM radreply           WHERE username = '%{SQL-User-Name}'           
ORDER BY id -> SELECT id, username, attribute, value, op           FROM 
radreply           WHERE username = 'kivanccepel1'           ORDER BY id
[sql]     expand: SELECT groupname           FROM radusergroup           
WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT 
groupname           FROM radusergroup           WHERE username = 
'kivanccepel1' ORDER BY priority
rlm_sql (sql): Released sql socket id: 2
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
++[pap] returns noop
   WARNING: Empty pre-proxy section.  Using default return values.
Sending Access-Request of id 184 to 10.1.1.51 port 1812
     User-Name = "kivanccepel1"
     User-Password = "475210071074"
     NAS-IP-Address = 10.65.8.117
     Proxy-State = 0x30
Proxying request 2 to home server 10.1.1.51 port 1812
Sending Access-Request of id 184 to 10.1.1.51 port 1812
     User-Name = "kivanccepel1"
     User-Password = "475210071074"
     NAS-IP-Address = 10.65.8.117
     Proxy-State = 0x30
Going to the next request
Waking up in 0.9 seconds.
rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=184, 
length=23
     Proxy-State = 0x30
# Executing section post-proxy from file 
/etc/freeradius/sites-enabled/default
+- entering group post-proxy {...}
[eap] No pre-existing handler found
++[eap] returns noop
Found Auth-Type = Accept
Auth-Type = Accept, accepting the user
# Executing section post-auth from file 
/etc/freeradius/sites-enabled/default
+- entering group post-auth {...}
[sqlippool] No Pool-Name defined.
[sqlippool]     expand: No Pool-Name defined   (did %{Called-Station-Id} 
cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> No 
Pool-Name defined   (did  cli  port  user kivanccepel1)
No Pool-Name defined   (did  cli  port  user kivanccepel1)
++[sqlippool] returns noop
++[exec] returns noop
Sending Access-Accept of id 0 to 10.65.8.117 port 54732
Finished request 2.
Going to the next request
Waking up in 4.9 seconds.
Cleaning up request 2 ID 0 with timestamp +230
Ready to process requests.


What is missing?


Regards...

<br>
<img src="http://www.yasar.com.tr/banner/yhbanner.jpg"> </img>
<br><br>
Bu elektronik postada bulunan tum fikir ve gorusler ve ekindeki dosyalar sadece adres sahip/sahiplerine ait olup, Yasar Toplulugu Sirketleri bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. Eger gonderilmesi dusunulen kisi veya kurulus degilseniz, lutfen gonderen kisiyi derhal haberdar ediniz ve mesaji sisteminizden siliniz.The information contained in this e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and Yasar Group Companies do not accept legal responsibility for the contents. If you are not the intended recipient, please immediately notify the sender and delete it from your system.


More information about the Freeradius-Users mailing list