Sql Counter reads only the first 4 digits

[Ivan Kalik]

> Mauro Iorio - Smart Soft s.r.l. wrote:
>> I’ve a strange problem with sql counter on freeradius both 1.1.7 and
>> 2.1.5 versions.
>>
>> Actually executing
>>
>> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro'
>
>   What happens when you replace that SELECT statement with a hard-coded
> number, like 123456?  Does it still truncate the result?
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

I can't replicate this. 2.1.6 prerelease on Slackware.

sqlcounter_expand:  '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='kaliki'}'
[noresetcounter] sql_xlat
[noresetcounter]        expand: %{Stripped-User-Name} ->
[noresetcounter]        expand: %{User-Name} -> kaliki
[noresetcounter]        expand: %{%{User-Name}:-DEFAULT} -> kaliki
[noresetcounter]        expand:
%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> kaliki
[noresetcounter] sql_set_user escaped user --> 'kaliki'
[noresetcounter]        expand: SELECT SUM(AcctSessionTime) FROM radacct
WHERE UserName='kaliki' -> SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='kaliki'
rlm_sql (sql): Reserving sql socket id: 2
[noresetcounter] sql_xlat finished
rlm_sql (sql): Released sql socket id: 2
[noresetcounter]        expand: %{sql:SELECT SUM(AcctSessionTime) FROM
radacct WHERE UserName='kaliki'} -> 1289790
rlm_sqlcounter: (Check item - counter) is less than zero
rlm_sqlcounter: Rejected user kaliki, check_item=3600, counter=1289790
++[noresetcounter] returns reject


Ivan Kalik
Kalik Informatika ISP