We are starting with wireless soon, so I planned to adapt monthlycounter sqlcounter: query = "SELECT SUM( AcctInputOctets + AcctOutputOctets) FROM radacct WHERE UserName='%{%k}' AND AcctStartTime > FROM_UNIXTIME('%b')" Remove reply-name, change check-name to Max-Monthly-Octets and check with: Max-Monthly-Octets<numberofbytes I haven't implemented it yet (planning first to install 2.0 for testing next week), but I think it will work. It can't stop user from going over the limit as timed counters can, but it should stop them from connecting next time. Ivan Kalik Kalik Informatika ISP Dana 18/5/2007, "Trio Yulistianto" <trioy99@gmail.com> piše:
next problem... i have read all documentation ebaout sql counter.... and all based on time.. any docoumentation about volume based ? volume based (total of inputoctets and outputoctets) in my case, i want to give user limitation about his byte usage, ie. user heavy : has 10 Gb (total of inputoctets and outputoctets) per month user medium : has 5 Gb (total of inputoctets and outputoctets) per month user light : has 1 Gb (total of inputoctets and outputoctets) per month
how thats can handle by freeradius and mysql ? fyi. my nas is mikrotik v2.9.40 for now i just limiting by *Mikrotik-Recv-Limit *and *Mikrotik-Xmit-Limit * attribute* *any solution to limiting by total of those 2 variables ?
thanks be4 trio