bandwidth and volume limit

[Internet-Wifi Operador]

Hi Mathieu, I'm not an expert but I had the same problem.
You need upgrade freeradius to new version too.
The sqlcounters in your version only reply SessionTimeout, whit new version 
you can reply wathever you want.
You need download de source new version from 
ftp://ftp.freeradius.org/pub/radius/freeradius-1.1.5.tar.gz
after is better if you make a package for Debian and install it.

With new version you can do something like this.

sqlcounter totaloctets {
        counter-name = Octets-Total-Limits
        check-name = Max-Total-Octets
        reply-name = ChilliSpot-Max-Total-Octets (or the attribute that your 
NAS know for that)
        sqlmod-inst = sql
        key = User-Name
        reset = never
        query = "SELECT SUM(AcctOutputOctets+AcctInputOctets) FROM radacct 
WHERE UserName='%{%k}'"
}
Remember when you compile your new freeradius include experimental counters. 
I'm not sure in this versions that is necessary but work for me.

If you don´t know how make a .deb for your debian tell me I can explain 
howto.

Fabián Omar Franzotti





>From: Alan DeKok <aland at deployingradius.com>
>Reply-To: FreeRadius users mailing list 
><freeradius-users at lists.freeradius.org>
>To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
>Subject: Re: bandwidth and volume limit
>Date: Thu, 22 Mar 2007 13:28:00 +0100
>
>Mathieu Lemaitre wrote:
> > HI all,
> >
> > I'm running freeradius 1.0.2 on a debian stable. For new clients, I need
> > to implement 2 functions:
> >
> > * a bandwidth limit on a per-user basis. I mean, I need to be able to
> > set, for a user, a value for his upstream and downstream bw, which is
> > sent by the radius as a reply attribute. Are they predefined attributes
> > to do this?
>
>   No.  See the NAS documentation.  It may do this, but likely not.
>
> > * a volume limit: I'd like to be able to set a maximum amount of data
> > monthly downloadable for each user.
>
>   There is no standard way to do that.  See the NAS documentation.  It
>may do this, but likely not.
>
>   Alan DeKok.
>--
>   http://deployingradius.com       - The web site of the book
>   http://deployingradius.com/blog/ - The blog
>-
>List info/subscribe/unsubscribe? See 
>http://www.freeradius.org/list/users.html

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office 
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/