Empty (not ended) session - freeradius 3.0.16

dg dg at poczta.tarman.pl
Tue Feb 27 11:34:18 CET 2018


Hello,

I have strange problem.

>From time to time I have session not ended (and without any user assigned to
that session).

So i have time when session starts but stop time is NULL.

example below:

SELECT radacct.RadAcctId, hotspots.name as hotspot, radacct.UserName,
radacct.FramedIPAddress, radacct.AcctStartTime, radacct.AcctStopTime,
radacct.AcctSessionTime, radacct.AcctInputOctets, radacct.AcctOutputOctets,
radacct.AcctTerminateCause, radacct.NASIPAddress FROM radacct LEFT JOIN
hotspots ON radacct.calledstationid = hotspots.mac WHERE FramedIPAddress=''
ORDER BY radacctid asc LIMIT 0, 1000; 

results

...
|      1438 | NULL    | user1      |                 | 2018-02-27 10:31:04 |
2018-02-27 10:35:33 |             269 |         1414483 |         40634419 |
Admin-Reset        | 192.168.1.110 |
|      1439 | NULL    | user2       |                 | 2018-02-27 10:31:11 |
2018-02-27 10:36:07 |             296 |         1714244 |         27071082 |
Port-Error         | 192.168.1.106 |
|      1445 | NULL    |             |                 | 2018-02-27 09:49:24 |
NULL                |            6215 |        89145682 |          1799384 |   
                | 192.168.1.110 |
|      1446 | NULL    |             |                 | 2018-02-27 09:49:46 |
NULL                |            6242 |        89124192 |          1803157 |   
                | 192.168.1.110 |
|      1447 | NULL    |             |                 | 1993-03-01 01:01:22 |
NULL                |       788783565 |        92045995 |          1920254 |   
                | 192.168.1.110 |
|      1448 | NULL    |             |                 | 1993-03-01 01:01:24 |
NULL                |       788783603 |        93859941 |          1975125 |   
                | 192.168.1.110 |


so you can see that AcctStopTime is sometimes NULL.
Can someone help me ? why its happening ?
i am using cisco switches

best regards




More information about the Freeradius-Users mailing list