Hi, I'm reviewing the "accounting" module in my Freeradius, and in the "radacct" table, I notice that the value 4294967296 has been added to "acctinputoctets" and "acctoutputoctets" for some users, which is affecting the use of the "sqlcounter" module. Can anyone tell me how to fix this?: 1945915 2C3290C0D883AE5F 2cf8f5be595f748853b59cb68b1234ce juan.vinardell6AC6162C01022 Wireless-802.11 2025-06-2117:35:06.000 -0400 2025-06-21 17:41:48.000 -0400 2025-06-21 17:41:48.000 -0400 300 402 RADIUS CONNECT 54Mbps 802.11g CONNECT 54Mbps 802.11g 42949672964294967296
On Jun 21, 2025, at 10:41 PM, Julio Edel Salas Díaz <julio.salas@emincar.com> wrote:
Hi, I'm reviewing the "accounting" module in my Freeradius, and in the "radacct" table, I notice that the value 4294967296 has been added to "acctinputoctets" and "acctoutputoctets" for some users, which is affecting the use of the "sqlcounter" module. Can anyone tell me how to fix this?:
You don't fix it. FreeRADIUS isn't magically adding values to accounting data. That value is there because the Accounting-Request packet says that the user has used more than a Gb of data. i.e. it's real data sent by the NAS. FreeRADIUS is just recording it. If you think that the data is wrong, them find out why the NAS is sending the data. Alan DeKok.
Ok, one question, can you tell me what the common error is when a Netgear WAX6100 AP sends that value (4294967296) in the "accounting"? That doesn't happen to me with all users and devices. -----Mensaje original----- De: Freeradius-Users <freeradius-users-bounces+julio.salas=emincar.com@lists.freeradius.org> En nombre de Alan DeKok via Freeradius-Users Enviado el: domingo, 22 de junio de 2025 7:06 Para: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> CC: Alan DeKok <aland@deployingradius.com> Asunto: Re: Freeradius accounting 4294967296 On Jun 21, 2025, at 10:41 PM, Julio Edel Salas Díaz <julio.salas@emincar.com> wrote:
Hi, I'm reviewing the "accounting" module in my Freeradius, and in the "radacct" table, I notice that the value 4294967296 has been added to "acctinputoctets" and "acctoutputoctets" for some users, which is affecting the use of the "sqlcounter" module. Can anyone tell me how to fix this?:
You don't fix it. FreeRADIUS isn't magically adding values to accounting data. That value is there because the Accounting-Request packet says that the user has used more than a Gb of data. i.e. it's real data sent by the NAS. FreeRADIUS is just recording it. If you think that the data is wrong, them find out why the NAS is sending the data. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Jun 24, 2025, at 12:21 PM, Julio Edel Salas Díaz <julio.salas@emincar.com> wrote:
Ok, one question, can you tell me what the common error is when a Netgear WAX6100 AP sends that value (4294967296) in the "accounting"? That doesn't happen to me with all users and devices.
I don't have documentation on all possible NASes. Ask the vendor how their software behaves. But again... the value isn't magic. The NAS is sending an accounting packet which contains Acct-Input-Gigawords = 1, or Acct-Output-Gigawords = 1. Hint: 4294967296 == 2^32. If you look at the debug output (as ALL of the documentation says to do) you will see this attribute and value in the debug logs. Alan DeKok.
participants (2)
-
Alan DeKok -
Julio Edel Salas Díaz