problem with counter reset In hourly -daily -weekly -monthly

[Jed Gainer]

This is a question for the CoovaChilli mailing list.


On Fri, Jan 10, 2014 at 7:44 AM, SORROW <ulmzcb at yahoo.com> wrote:

> hello friends
>
> I Test freeradius and run in ubuntu+MySql+Mikrotik as NAS .. FreeRADIUS
> Version 2.1.10, for host i686-pc-linux-gnu, built on Sep 24 2012
>
> for limit Download user traffic daily  i user this setting in
> /etc/freeradius/sql/mysql/counter.conf
>
> ====
> sqlcounter counterChilliSpotMaxTotalOctetsDaily {
>             counter-name = ChilliSpot-Max-Total-Octets-Daily
>             check-name = CS-Total-Octets-Daily
>             counter-type = data
>             reply-name = Mikrotik-Xmit-Limit
>             sqlmod-inst = sql
>             key = User-Name
>             reset = daily
>             query = "SELECT (SUM(AcctInputOctets + AcctOutputOctets)) FROM
> radacct WHERE UserName='%{%k}' AND    UNIX_TIMESTAMP(AcctStartTime) +
> AcctSessionTime > '%b'"
>         }
> ====
>
> Now i have problem in reset= hourly - daily - weekly Or monthly . I dont
> know how to fix it  for example i set for user  CS-Total-Octets-Daily check
> attribute 10MB   .. user in first login use 9MB and disconnect and re login
> again can use 10MB !! user must disconnect after 1MB  and user stay connect
> ! in this example sum of two connection usage is 19MB !!!
>
> But if   reset = never    counter working correctly  and user disconnected
> in exact usage ...
>
>
> in freeradius -X   if reset = never  Reply-Item for user is correct value
>
> [counterChilliSpotMaxTotalOctetsDaily]     expand: %{sql:SELECT
> (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE
> UserName='test4' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '0'}
> -> 766328
> rlm_sqlcounter: Check item is greater than query result
> rlm_sqlcounter: Authorized user test4, check_item=1000000, counter=766328
> rlm_sqlcounter: Sent Reply-Item for user test4, Type=Mikrotik-Xmit-Limit,
> value=233672
> ++[counterChilliSpotMaxTotalOctetsDaily] returns ok
>
>
> =====
> In freeradius -X if reset = daily    Reply-Item for user is not correct
> value
>
> [counterChilliSpotMaxTotalOctetsDaily]     expand: %{sql:SELECT
> (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE
> UserName='test4' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
> '1389299400'} -> 727301
> rlm_sqlcounter: Check item is greater than query result
> rlm_sqlcounter: Authorized user test4, check_item=1000000, counter=727301
> rlm_sqlcounter: Sent Reply-Item for user test4, Type=Mikrotik-Xmit-Limit,
> value=1031030
> ++[counterChilliSpotMaxTotalOctetsDaily] returns ok
>
> how can i solve this ??
>
> regards
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140110/846ebb1e/attachment-0001.html>