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