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 <[EMAIL PROTECTED]>
Reply-To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
To: FreeRadius users mailing list <freeradius-users@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/

List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to