First, if the sql query actually ended in "AN" there would be sql error. Second, you can try enabling sqltrace and check trace file to see full requests. On 04.12.2013 12:25, Sanity Computers wrote:
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Best regards, Denis Volkov