Hoping to understand a little more on mysql table radippool ( ippool.conf )

Sophie Loewenthal sophie.loewenthal at trimbletl.com
Fri Nov 20 15:57:50 CET 2015


Hi,

     I am interested to know under what circumstances would an IP 
address have a username assigned and with most other attributes empty or 
NULL?

e.g
*mysql> select * from radippool where username = '10000078e' ;
id    pool_name    framedipaddress    nasipaddress calledstationid    
callingstationid    expiry_time    username pool_key    3GPP_Imsi
392053,    vodafone,    10.26.7.134,,,,  NULL,  10000078e,    0,
*

*mysql> select * from radippool where username = '10000078e' ;*

id 	pool_name 	framedipaddress 	nasipaddress 	calledstationid 
callingstationid 	expiry_time 	username 	pool_key 	3GPP_Imsi
392053 	vodafone 	10.26.7.134 				NULL 	10000078e 	0 	




mysql>  select count(*) from radippool where expiry_time is NULL and 
username != '' ;
+----------+
| count(*) |
+----------+
|    12797 |
+----------+


Kind regards,
Sophie





More information about the Freeradius-Users mailing list