This is a question for the CoovaChilli mailing list. On Fri, Jan 10, 2014 at 7:44 AM, SORROW <ulmzcb@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