I want to se sqlcounters to count bytes transferred from clients so that i manage quota. Aiming this i configured the following counter: sqlcounter bytesQuota { counter-name = traffic_quota check-name = Max-Traffic reply-name = Session-Traffic-Limit sqlmod-inst = mysqldb key = User-Name reset = hourly query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM radacct WHERE UserName='%{%k}'" } My first problem is that the Session-Traffic-Limit (from the redback dictionnary) is not returned. I can't see it neither in the output of radtest nor with radsniff. Yet, looking at the output of radiusd -X i can see it's correctly understood by freeradius: rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user scott, check_item=12000, counter=10891 rlm_sqlcounter: Sent Reply-Item for user scott, Type=Session-Traffic-Limit, value=12792 ++[bytesQuota] returns ok Does anyone has a clue? Alexandre Chapellon a écrit :
You're right, adding the name of my sqlcounter in the instantiate section lake it works. thx :)
Alan DeKok a écrit :
Alexandre Chapellon wrote:
whenever i launch freeradius -X I get the folloawing error: /etc/freeradius/users[205]: Parse error (check) for entry scott: Invalid octet string "101" for attribute name "Max-Traffic"
The modules are initialized in *order*. The sqlcounter module creates the attributes on the fly. But... it can't do this if it hasn't been run yet.
Line 205 is the line where user scott is defined in users files. I have tryed setting up my own dictionnary (which i think shouldn't be needed) with the Max-Traffic attribute defined as interger
VENDOR ME ATTRIBUTE Max-Traffic 1 integer
That isn't the correct dictionary file format, but it's not relevant, either.
But that doesn't help. I have read all over the web that sqlcounter with mysql are considered as stable enough for production , so am quite surprised of this issue... Any idea?
List "sqlcounter" in the "instantiate" section. It will be initialized before the "users" file is read.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html