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.*
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.*
On Jan 21, 2016, at 11:33 PM, Andrés Gómez <andres.gomez.ruiz@gmail.com> wrote:
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 cases.
...
As you can see each session takes less to 15 minutes (900 seconds) But its calculated about 93 hours (224800 second).
The NAS sends accounting packets. It also controls the content of the accounting packets. So if the accounting packets are wrong, blame the NAS. Alan DeKok.
participants (2)
-
Alan DeKok -
Andrés Gómez