Edvin Seferovic a écrit : > > rlm_sqlcounter: Sent Reply-Item for user scott, > Type=Session-Traffic-Limit, value=12792 > > Which part don’t you understand? Sqlcounter returned it. How does the > log part of the RADIUS Packet looks like? It should contain the > “Session-Traffic-Limit” if it can be found in the dictionary, right? >
What i don't understand is that i cannot find this in the sent reply, whereas it seems to be processed correctly by the module. > > > E:S > > > > *From:* > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > *On Behalf Of *Alexandre Chapellon > *Sent:* Samstag, 06. September 2008 01:53 > *To:* FreeRadius users mailing list > *Subject:* sqlcounters for traffic > > > > 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 > ------------------------------------------------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
