Hi all, I’m getting some odd behaviour
where a counter is not replying with session-timeout. You can
see in the debug below that this accounting update query seems
to stop at “AN” rather than “AND
nasipaddress = 'NAS-IP-Address’". Sometimes it ends like
this also:
AND username = 'tes
It seems to be cutting off the end of the
query. Is this just a debug display/ouput error or an actual
problem?
----------------------------
[sql] expand: UPDATE
radacct SET framedipaddress =
'%{Framed-IP-Address}', acctsessiontime =
'%{Acct-Session-Time}', acctinputoctets =
'%{%{Acct-Input-Gigawords}:-0}' << 32
|
'%{%{Acct-Input-Octets}:-0}', acctoutputoctets
= '%{%{Acct-Output-Gigawords}:-0}' << 32
|
'%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid =
'%{Acct-Session-Id}' AND username =
'%{SQL-User-Name}' AND nasipaddress =
'%{NAS-IP-Address}' -> UPDATE radacct
SET framedipaddress =
'101.144.24.2', acctsessiontime =
'301', acctinputoctets = '0' << 32
| '65806',
acctoutputoctets = '0' << 32
| '110397' WHERE
acctsessionid = '529e87e100000001' AND
username = 'test' AN
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql (sql): Released sql socket id: 0
Regards
Carl