Accounting errors.

[Andrés Gómez]

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 at 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.*