Hi, the default accounting_update_query in sql.conf makes no update for input and output octets and session-time. Is this correct, or shoud the query look like the following:
accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime IS NULL" Thanks for any clarification Didi -- ------------------------- Didi Rieder [EMAIL PROTECTED] PGPKey ID: 3431D0B0 -------------------------
pgp00000.pgp
Description: PGP Digital Signature