usage counter....

[tnt at kalik.co.yu]

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 at 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
>
>