usage counter....

[Trio Yulistianto]

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, tnt at kalik.co.yu <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
> >
> >
>
> -
> 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/20070518/80ad1ddd/attachment.html>