query is been cut short
Sanity Computers
sales at sanitycomputers.com.au
Wed Dec 4 07:25:25 CET 2013
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131204/db8a3abd/attachment.html>
More information about the Freeradius-Users
mailing list