<div dir="ltr">Hey Ivan<br><br>
<div class="gmail_quote">2008/10/24 <span dir="ltr"><<a href="mailto:tnt@kalik.net">tnt@kalik.net</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">It (daily sqlcounter) does the same in 2.0.5:<br><br>rlm_sqlcounter: Authorized user jagoda, check_item=10000000, counter=2635<br>
rlm_sqlcounter: Sent Reply-Item for user jagoda, Type=Session-Timeout,<br>value=10027850<br><br>Returns value that is greater than the limit. I am using noreset<br>sqlcounter and that one works fine.</blockquote>
<div> </div>
<div>Thanks for confirming this on a more up to date version.</div>
<div>Alan, this smells like a bug (unless we missed something along the way), should I open up a bug ticket?</div>
<div>And what would be the chances it can be backported to 1.1.7?</div>
<div> </div>
<div>Thanks,</div>
<div>Liran.</div>
<div> </div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d"><span id=""></span><br><br> </div>Dana 24/10/2008, "liran tal" <<a href="mailto:liransgarage@gmail.com">liransgarage@gmail.com</a>> piše:<br>
<div class="Ih2E3d"><br>>Hey,<br>><br>>2008/10/24 <<a href="mailto:tnt@kalik.net">tnt@kalik.net</a>><br>><br>>> No, he wants a data not time counter.<br>><br>><br>>That's right Evan. Moreover, there is no sense in changing the attribute to<br>
>be Session-Timeout when Chilli expects something else.<br>>Any thoughts on this issue?<br>><br>><br>>Thanks,<br>><br>><br>><br>>Dana 24/10/2008, "mulianto" <<a href="mailto:mulianto@cni.co.id">mulianto@cni.co.id</a>> piše:<br>
><br>>><br>>> >hi..i think you should fix this one :<br>>> ><br>>> > reply-name = ChilliSpot-Max-Total-Octets to :<br>>> > reply-name = Session-Timeout<br>
>> ><br>>> >try it..<br>>> >rgds,<br>>> >Mulianto<br>>> ><br>>> ><a href="http://www.indohotspot.net/" target="_blank">http://www.indohotspot.net</a><br>>> >Your Hotspot solution<br>
>> > -----Original Message-----<br>>> > From: freeradius-users-bounces+mulianto=<a href="http://cni.co.id/" target="_blank">cni.co.id</a>@<a href="http://lists.freeradius.org/" target="_blank">lists.freeradius.org</a><br>
</div>
<div>
<div></div>
<div class="Wj3C7c">>> >[mailto:<a href="mailto:freeradius-users-bounces%2Bmulianto">freeradius-users-bounces+mulianto</a><freeradius-users-bounces%2Bmulianto><br>>> =<a href="http://cni.co.id/" target="_blank">cni.co.id</a>@<a href="http://lists.freeradius.org/" target="_blank">lists.freeradius.org</a>]On<br>
>> >Behalf Of liran tal<br>>> > Sent: Friday, October 24, 2008 1:07 AM<br>>> > To: FreeRadius users mailing list<br>>> > Subject: sqlcounter returning wrong value?<br>>> ><br>
>> ><br>>> ><br>>> > Hey,<br>>> ><br>>> > I'm experimenting with some sqlcounter directives in radiusd.conf and<br>>> >chilli as the NAS.<br>>> > I've defined the following sqlcounter stanza for a daily traffic limit:<br>
>> ><br>>> > sqlcounter defined in radiusd.conf:<br>>> > (the query was corrected as suggested by tnt on a previous thread on the<br>>> >list, correct me if I got it wrong please)<br>
>> ><br>>> > sqlcounter counterChilliSpotMaxDailyOctets {<br>>> > counter-name = ChilliSpot-Max-Daily-Octets<br>>> > check-name = ChilliSpot-Max-Daily-Octets<br>
>> > reply-name = ChilliSpot-Max-Total-Octets<br>>> > sqlmod-inst = sql<br>>> > key = User-Name<br>>> > reset = daily<br>
>> > error-msg = "Sorry, your maximum traffic usage (download<br>>> >and upload) has exceed the provided limit"<br>>> > query = "SELECT (SUM(AcctInputOctets +<br>
>> AcctOutputOctets))<br>>> >FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) +<br>>> >AcctSessionTime > '%b'"<br>>> > }<br>>> ><br>
>> ><br>>> ><br>>> > In the authorization phase, I'm seeing the following in debug log:<br>>> > rlm_sqlcounter: Entering module authorize code<br>>> > sqlcounter_expand: 'SELECT<br>
>> (SUM(AcctInputOctets)+SUM(AcctOutputOctets))<br>>> >FROM radacct WHERE UserName='%{User-Name}''<br>>> > radius_xlat: 'SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets))<br>>> FROM<br>
>> >radacct WHERE UserName='tester1''<br>>> > sqlcounter_expand: '%{sql:SELECT<br>>> >(SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct WHERE<br>>> >UserName='tester1'}'<br>
>> > radius_xlat: Running registered xlat function of module sql for string<br>>> >'SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct WHERE<br>>> >UserName='tester1''<br>
>> > rlm_sql (sql): - sql_xlat<br>>> > radius_xlat: 'tester1'<br>>> > rlm_sql (sql): sql_set_user escaped user --> 'tester1'<br>>> > radius_xlat: 'SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets))<br>
>> FROM<br>>> >radacct WHERE UserName='tester1''<br>>> > rlm_sql (sql): Reserving sql socket id: 2<br>>> > rlm_sql (sql): - sql_xlat finished<br>>> > rlm_sql (sql): Released sql socket id: 2<br>
>> > radius_xlat: '24004370'<br>>> > rlm_sqlcounter: (Check item - counter) is greater than zero<br>>> > rlm_sqlcounter: Authorized user tester1, check_item=26214400,<br>>> >counter=24004370<br>
>> > rlm_sqlcounter: Sent Reply-Item for user tester1,<br>>> >Type=ChilliSpot-Max-Total-Octets, value=26239950<br>>> > modcall[authorize]: module "counterChilliSpotMaxDailyOctets" returns<br>
>> >ok for request 0<br>>> > The entry in radcheck is as follows:<br>>> ><br>>> > | 346 | tester1 | ChilliSpot-Max-Daily-Octets | := | 26214400 |<br>>> > What happens is that it seems the counter doesn't work as expected. When<br>
>> a<br>>> >user logs in, performs some traffic usage, logs out and logs in again,<br>>> > the replied back attribute for chilli doesn't contain a value which is<br>>> the<br>>> >remainder of the traffic usage, but something else.<br>
>> ><br>>> > According to the radius debug above, if check_item=26214400 and<br>>> >counter=24004370, how come value=26239950?<br>>> > So I'm guessing I'm missing something but I'm too obsessed with the<br>
>> >sqlcounter to notice it. (is the subtractation not a normal decimal<br>>> action?)<br>>> ><br>>> > The FreeRADIUS version used is 1.1.7<br>>><br>>><br>><br><br></div></div>
<div>
<div></div>
<div class="Wj3C7c">-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br></div></div></blockquote></div><br></div>