sql counter xlat problem

[Malcolm Caldwell]

Hello,

I am trying to use sqlcounter and oracle to implement download
limits/quotas.

I have:
sqlcounter testquota {
              counter-name = Test-Quota-Input-Octets
              check-name = Test-Quota
              sqlmod-inst = sql
              key = User-Name
              reset = daily

              query = "SELECT SUM(acctinputoctets) FROM radacct WHERE UserName='
%{%k}'"
           }

And:
DEFAULT User-Name =~ "^s[0-9]+$", Test-Quota-Input-Octets > 1000, Auth-Type = Reject
         Reply-Message = "You have used up your quota"


Output with -XX I get:
sqlcounter_expand:  'SELECT SUM(acctinputoctets) FROM radacct WHERE 
UserName='%{User-Name}''
radius_xlat:  'SELECT SUM(acctinputoctets) FROM radacct WHERE UserName='s111111''
sqlcounter_expand:  '%{sql:SELECT SUM(acctinputoctets) FROM radacct WHERE 
UserName='s111111'}'
radius_xlat: Running registered xlat function of module sql for string 'SELECT 
SUM(acctinputoctets) FROM radacct WHERE UserName='s111111''
rlm_sql: - sql_xlat
radius_xlat:  'SELECT SUM(acctinputoctets) FROM radacct WHERE UserName='s111111''
rlm_sql: Reserving sql socket id: 4
SELECT SUM(acctinputoctets) FROM radacct WHERE UserName='s111111'
rlm_sql: - sql_xlat finished
rlm_sql: Released sql socket id: 4
radius_xlat:  '?�???�?@�~??�~??��?@��?@��?@��?@��?@��?@��?@��?@x~??x~??��?@��?@�
�?@��?@��?@��?@��?@��?@��?@��?@'

This is then repeated a few times.



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html