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
