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