Help Regarding SQL Counter

pushpraj nimbalkar pushpraj4u at
Sat Dec 20 07:56:25 CET 2008

On Fri, Dec 19, 2008 at 8:28 PM,  <tnt at> wrote:
>>sqlcounter_expand:  'SELECT SUM(AcctSessionTime) FROM radacct WHERE
>>[noresetcounter]       expand: SELECT SUM(AcctSessionTime) FROM radacct
>>WHERE UserName='%{User-Name}' -> SELECT SUM(AcctSessionTime) FROM
>>radacct WHERE UserName='jose'
>>sqlcounter_expand:  '%{sql:SELECT SUM(AcctSessionTime) FROM radacct
>>WHERE UserName='jose'}'
>>[noresetcounter] sql_xlat
>>[noresetcounter]       expand: %{User-Name} -> jose
>>[noresetcounter] sql_set_user escaped user --> 'jose'
>>[noresetcounter]       expand: SELECT SUM(AcctSessionTime) FROM radacct
>>WHERE UserName='jose' -> SELECT SUM(AcctSessionTime) FROM radacct
>>WHERE UserName='jose'
>>rlm_sql (sql): Reserving sql socket id: 2
>>[noresetcounter] row[0] returned NULL
>>rlm_sql (sql): Released sql socket id: 2
>>[noresetcounter]       expand: %{sql:SELECT SUM(AcctSessionTime) FROM
>>radacct WHERE UserName='jose'} ->
>>rlm_sqlcounter: No integer found in string ""
>>++[noresetcounter] returns noop
> OK, I see the problem. As first aid change the query to:
> For some reason code doesn't treat null as 0.
> Ivan Kalik
> Kalik Informatika ISP
> -
> List info/subscribe/unsubscribe? See
Thank you sir,
  i tried your query but it's gives me syntax error but from your
reply my senior person told me that try running below query which is
working perfectly for me. query is below:

 "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{%k}'"

but one thing i wanted to ask you why NAS-IP-Addres is always shown as in my case nas ip address is do i need to make
any other configuration.

More information about the Freeradius-Users mailing list