Accounting-Packets from Huawei NAS randomly not being written to the database

[Antônio Modesto]

> On 7 Aug 2020, at 09:33, Alan DeKok <aland at deployingradius.com> wrote:
> 
> 
>  You can set up a test server, and use "radclient".  Take a copy of the detail file entry, and use radclient to send it to the test server.
> 


Hi Alan, thanks for your response.

I tried to resend the same packet using radclient as you suggested (on the same server) and it worked. The record in the database was updated. I will try to store some compressed debug output for a longer period to see if I can find something that explains this behaviour.

radclient -x -f /tmp/record.txt 127.1.1.2 acct testing123
Sent Accounting-Request Id 22 from 127.1.1.2:21530 to 127.1.1.2:1813 length 617
	User-Name = "andersonoliveira"
	NAS-Port = 3162917
	NAS-IP-Address = 177.66.167.254
	Framed-IP-Address = 100.64.218.153
	NAS-Identifier = "TI5-BRAS01"
	Acct-Status-Type = Stop
	Acct-Delay-Time = 0
	Acct-Input-Octets = 0
	Acct-Output-Octets = 0
	Acct-Session-Id = "TI5-BRA00304080500000a598ccAAADbA"
	Acct-Authentic = RADIUS
	Acct-Session-Time = 200
	Acct-Input-Packets = 0
	Acct-Output-Packets = 0
	Acct-Terminate-Cause = Lost-Carrier
	Acct-Input-Gigawords = 0
	Acct-Output-Gigawords = 0
	Event-Timestamp = "Aug  7 2020 08:54:43 -03"
	NAS-Port-Type = Ethernet
	Calling-Station-Id = "58:10:8c:07:48:8f"
	NAS-Port-Id = "slot=0;subslot=3;port=4;vlanid=805;"
	Service-Type = Framed-User
	Framed-Protocol = PPP
	Connect-Info = "1300000/1000000"
	Idle-Timeout = 0
	Session-Timeout = 0
	Huawei-IPHost-Addr = "100.64.218.153 58:10:8c:07:48:8f"
	Huawei-Input-Peak-Rate = 1000000
	Huawei-Input-Peak-Rate = 1000000
	Huawei-Input-Average-Rate = 1000000
	Huawei-Output-Peak-Rate = 1300000
	Huawei-Output-Average-Rate = 1300000
	Huawei-Priority = 15
	Huawei-Connect-ID = 13206
	Huawei-Domain-Name = "provedor_pppoe"
	Huawei-Accounting-Level = 0
	Huawei-Up-Priority = 15
	Huawei-Down-Priority = 15
	Huawei-Acct-IPv6-Input-Octets = 0
	Huawei-Acct-IPv6-Output-Octets = 0
	Huawei-Acct-IPv6-Input-Packets = 0
	Huawei-Acct-IPv6-Output-Packets = 0
	Huawei-Acct-IPv6-Input-Gigawords = 0
	Huawei-Acct-IPv6-Output-Gigawords = 0
	Huawei-User-Mac = "58:10:8c:07:48:8f"
	Huawei-Acct-Update-Address = 0
	Huawei-Input-Burst-Size = 625000
	Huawei-Output-Burst-Size = 812504
	Huawei-Input-Peak-Burst-Size = 625000
	Huawei-Output-Peak-Burst-Size = 812504
Received Accounting-Response Id 22 from 127.1.1.2:1813 to 127.1.1.2:21530 length 20


Acctstoptime and acctlocalupdatetime were correctly updated:

radius=# select username, acctsessionid, acctstarttime, acctstoptime, acctlocalupdatetime from radacct where acctsessionid = 'TI5-BRA00304080500000a598ccAAADbA';
-[ RECORD 1 ]-------+----------------------------------
username            | andersonoliveira
acctsessionid       | TI5-BRA00304080500000a598ccAAADbA
acctstarttime       | 2020-08-07 08:51:23-03
acctstoptime        | 2020-08-07 08:54:43-03
acctlocalupdatetime | 2020-08-07 10:20:35-03



Thanks.