query is been cut short

Denis Volkov volkov at ufamts.ru
Wed Dec 4 07:37:26 CET 2013


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>


More information about the Freeradius-Users mailing list