<div dir="ltr"><div>Hey,</div>
<div> </div>
<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">No, he wants a data not time counter.</blockquote>
<div> </div>
<div>That's right Evan. Moreover, there is no sense in changing the attribute to be Session-Timeout when Chilli expects something else.</div>
<div>Any thoughts on this issue? </div>
<div> </div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div><br><br>Dana 24/10/2008, "mulianto" <<a href="mailto:mulianto@cni.co.id">mulianto@cni.co.id</a>> piše:<br></div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div></div>
<div class="Wj3C7c"><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>
>[mailto:<a href="mailto:freeradius-users-bounces%2Bmulianto">freeradius-users-bounces+mulianto</a>=<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 + 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 (SUM(AcctInputOctets)+SUM(AcctOutputOctets))<br>>FROM radacct WHERE UserName='%{User-Name}''<br>> radius_xlat: 'SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) 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)) 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 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 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 action?)<br>
><br>> The FreeRADIUS version used is 1.1.7<br><br></div></div></blockquote></div></div>