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@deployingradius.com>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/