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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Samstag, 01. Dezember 2007 16:14
To: [EMAIL PROTECTED]; 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
