query is been cut short

[Denis Volkov]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131204/41498f69/attachment-0001.html>