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