looking at freeradius log, I can see an example of the error: Wed Jan 20 18:08:54 2016 Acct-Status-Type = Start User-Name = "44:D4:E0:9F:DC:FE" Calling-Station-Id = "44-D4-E0-9F-DC-FE" NAS-Port-Type = Wireless-802.11 NAS-Port = 4 NAS-Port-Id = "00000004" Framed-IP-Address = 192.168.70.51 Acct-Session-Id = "569af05500000004" Event-Timestamp = "Jan 17 2016 01:38:25 UTC" Acct-Interim-Interval = 600 NAS-IP-Address = 10.1.0.1 Called-Station-Id = "38-FF-36-0A-42-10:BUS Wi-Fi GRATIS" NAS-Identifier = "A022" Acct-Unique-Session-Id = "32915b3b1846c43c" Timestamp = 1453313334 Wed Jan 20 18:18:54 2016 Acct-Status-Type = Interim-Update User-Name = "44:D4:E0:9F:DC:FE" Calling-Station-Id = "44-D4-E0-9F-DC-FE" NAS-Port-Type = Wireless-802.11 NAS-Port = 4 NAS-Port-Id = "00000004" Framed-IP-Address = 192.168.70.51 Acct-Session-Id = "569af05500000004" Event-Timestamp = "Jan 17 2016 01:48:26 UTC" Acct-Interim-Interval = 600 NAS-IP-Address = 10.1.0.1 Called-Station-Id = "38-FF-36-0A-42-10:BUS Wi-Fi GRATIS" NAS-Identifier = "A022" Acct-Input-Octets = 13243963 Acct-Output-Octets = 873097 Acct-Input-Gigawords = 0 Acct-Output-Gigawords = 0 Acct-Input-Packets = 11414 Acct-Output-Packets = 9372 Acct-Session-Time = 601 Acct-Unique-Session-Id = "32915b3b1846c43c" Wed Jan 20 18:19:00 2016 Acct-Status-Type = Interim-Update User-Name = "44:D4:E0:9F:DC:FE" Calling-Station-Id = "44-D4-E0-9F-DC-FE" NAS-Port-Type = Wireless-802.11 NAS-Port = 4 NAS-Port-Id = "00000004" Framed-IP-Address = 192.168.70.51 Acct-Session-Id = "569af05500000004" Event-Timestamp = "Jan 17 2016 01:48:26 UTC" Acct-Interim-Interval = 600 NAS-IP-Address = 10.1.0.1 Called-Station-Id = "38-FF-36-0A-42-10:BUS Wi-Fi GRATIS" NAS-Identifier = "A022" Acct-Input-Octets = 13243963 Acct-Output-Octets = 873097 Acct-Input-Gigawords = 0 Acct-Output-Gigawords = 0 Acct-Input-Packets = 11414 Acct-Output-Packets = 9372 Acct-Session-Time = 601 Acct-Unique-Session-Id = "32915b3b1846c43c" Wed Jan 20 18:22:10 2016 Acct-Status-Type = Stop User-Name = "44:D4:E0:9F:DC:FE" Calling-Station-Id = "44-D4-E0-9F-DC-FE" NAS-Port-Type = Wireless-802.11 NAS-Port = 4 NAS-Port-Id = "00000004" Framed-IP-Address = 192.168.70.51 Acct-Session-Id = "569af05500000004" Event-Timestamp = "Jan 20 2016 23:22:29 UTC" Acct-Interim-Interval = 600 NAS-IP-Address = 10.1.0.1 Called-Station-Id = "38-FF-36-0A-42-10:BUS Wi-Fi GRATIS" NAS-Identifier = "A022" Acct-Input-Octets = 13680143 Acct-Output-Octets = 1003980 Acct-Input-Gigawords = 0 Acct-Output-Gigawords = 0 Acct-Input-Packets = 12082 Acct-Output-Packets = 10109 Acct-Session-Time = 337444 Acct-Terminate-Cause = Session-Timeout Whan Can be wrong? 2016-01-21 23:33 GMT-05:00 Andrés Gómez <andres.gomez.ruiz@gmail.com>:
Dear List.
I have a Freeradius 2 installed, using a MySQL database to store all accounting data. Usually It works fine, but now I can see that the count of AcctSessionTime is being wrong calculated in SOME cases, not all caases.
Check it out these records.
"AcctStartTime";"AcctStopTime";"AcctSessionTime" "2016-01-20 18:08:54";"2016-01-20 18:22:10";"337444" "2016-01-20 18:13:26";"2016-01-20 18:22:25";"337172" ""2016-01-20 18:15:24";"2016-01-20 18:22:10";"337054" "2016-01-20 18:15:44";"2016-01-20 18:22:10";"337034" "2016-01-20 18:16:00";"2016-01-20 18:22:10";"337018" "2016-01-20 18:16:34";"2016-01-20 18:22:10";"336984"
As you can see each session takes less to 15 minutes (900 seconds) But its calculated about 93 hours (224800 second).
What Can I do? My statistics are being damaged!!
Regards
-- *C. Andrés Gómez R.*
-- *C. Andrés Gómez R.*