Packets in Accounting ?

Edvin Seferovic edvin.seferovic at
Sat Dec 1 16:20:52 CET 2007

I found this in an older sql.conf file of mine :

accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Ses
sion-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctOutputPackets ='%{Acct-Output
-Packets}', AcctInputPackets = '%{Acct-Input-Packets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime = 0 AND NASPortId= '%{NAS-Port}'

I suppose, the packets were in the schema, but I cannot confirm that for version < 1.0 since the FTP server of freeradius doesn't respond :(

Packets are also defined in the dictionary, why not have them in the accounting DB ?


-----Original Message-----
From: at [ at] On Behalf Of Alan DeKok
Sent: Samstag, 01. Dezember 2007 16:14
To: edvin.seferovic at; FreeRadius users mailing list
Subject: Re: Packets in Accounting ?

Edvin Seferovic wrote:
> what happened to the Acct-Input/Output-Packets in Accounting. MySQL
> schema doesn’t have those fields anymore. Any special reason ?

  Were they ever in the schema?  I don't see them in 1.1.x.

  Alan DeKok.
List info/subscribe/unsubscribe? See

More information about the Freeradius-Users mailing list