yupes you are right... it can't stop user from going over the limit,
but i need to kick while the limit reached as time session...
any body success with this ? please tell me how
2007/5/18, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
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" <[EMAIL PROTECTED]> 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
>
>
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
