Packets in Accounting ?

[Edvin Seferovic]

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 ?

Regards,
E:S

-----Original Message-----
From: freeradius-users-bounces+edvin.seferovic=kolp.at at lists.freeradius.org [mailto:freeradius-users-bounces+edvin.seferovic=kolp.at at lists.freeradius.org] On Behalf Of Alan DeKok
Sent: Samstag, 01. Dezember 2007 16:14
To: edvin.seferovic at kolp.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 http://www.freeradius.org/list/users.html