We upgraded Radiator back in December to version 4.19. Initially we had no issues with capturing user bandwidth consumption data but we've made no changes but we are not getting data anymore. I have confirmed that the Mikrotik is sending the correct values for Acct-Input-Octets and Account-Output-Octets but when I see the accounting packet I'm trying to send they are gone. Below is an example of what I'm seeing as far as the accounting logfile with the data turned up to trace 4. My concern is that the Gigawords couter is overflowing and I think that's my problem but I'm not sure how to fix it. Any suggestions, as I'm sure it's something silly I'm missing.
*** Received from x.x.x.x port 33009 ....
Code: Accounting-Request
Identifier: 8
Authentic: r<215><3><191><230><231><15>m<22><19><254>tK<26>sG
Attributes:
Acct-Status-Type = Stop
Acct-Terminate-Cause = Lost-Carrier
NAS-Port-Type = Ethernet
Calling-Station-Id = "00:09:0F:F7:83:5A"
Called-Station-Id = "server1"
NAS-Port-Id = "5.7 LAN - VRRP"
User-Name = "00:09:0F:F7:83:5A"
NAS-Port = 2159067051
Acct-Session-Id = "80b0bfab"
Framed-IP-Address = y.y.y.y
Mikrotik-Host-IP = y.y.y.y
Event-Timestamp = 1533051674
Acct-Input-Octets =
Acct-Output-Octets =
Acct-Input-Gigawords = 0
Acct-Output-Gigawords = 0
Acct-Input-Packets = 15018
Acct-Output-Packets = 98758
Acct-Session-Time = 664
NAS-Identifier = "NAS Device"
Acct-Delay-Time = 0
NAS-IP-Address = x.x.x.x
Tue Jul 31 09:41:24 2018: DEBUG: Handling request with Handler 'Client-Identifier=mikrotik', Identifier ''
Tue Jul 31 09:41:24 2018: DEBUG: Handling with Radius::AuthSQL: SQL-goanna1
Tue Jul 31 09:41:24 2018: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jul 31 09:41:24 2018: DEBUG: do query to 'dbi:ODBC:goanna1 Connection id: 0-00000': 'insert into freeradius_service_radacct (ACCTSESSIONID,ACCTSESSIONTIME,AcctStartTime,AcctTerminateCause,AcctUniqueID,FRAMEDIPADDRESS,NASIPADDRESS,NASPORT,USERNAME) values ('80b0bfab',664,'2018-07-31 09:41:24','Lost-Carrier','1533051674','y.y.y.y','x.x.x.x',2159067051,'y.y.y.y')':
Tue Jul 31 09:41:24 2018: DEBUG: AuthBy SQL result: ACCEPT,
Tue Jul 31 09:41:24 2018: DEBUG: Accounting accepted
Tue Jul 31 09:41:24 2018: DEBUG: Packet dump:
*** Sending to 216.67.158.237 port 33009 ....
Code: Accounting-Response
Identifier: 8
Authentic: <18>z<18>O<173><140><199><189><250><31><149><8><176>t<167>B
Attributes:
Tue Jul 31 09:41:24 2018: DEBUG: Acct-Input-Gigawords attribute present,Counter overflowed.
Tue Jul 31 09:41:24 2018: DEBUG: Acct-Input-Gigawords=^@^@^@^@,Acct-Input-Octets =KR^Y�
Tue Jul 31 09:41:24 2018: DEBUG: Calculated and replaced Acct-Input-Octets=0
Tue Jul 31 09:41:24 2018: DEBUG: Acct-Output-Gigawords attribute present,Counter overflowed.
Tue Jul 31 09:41:24 2018: DEBUG: Acct-Output-Gigawords=^@^@^@^G,Acct-Output-Octets=~W�^]~C
Tue Jul 31 09:41:24 2018: DEBUG: Calculated and replaced Acct-Output-Octets = 0
Tue Jul 31 09:41:24 2018: DEBUG: Packet dump:
_______________________________________________ radiator mailing list [email protected] http://lists.open.com.au/mailman/listinfo/radiator
