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