mmm as i khow that WISPr-Max-Bandwidth-Down and WISPr-Max-Bandwidth-up is to limiting user trafic not for quota limitation, what i want is to do limitation for bandwidth usage, for example, i want to allow the user to access the Internet 100mb in a week, when the user reach the limit they cannot log in before one week.

ok friend, i'll try just like told me , but please don't bored if i ask u a question again

yaps it workss......!!! thank you so much.

Hi guys, im also new in chillispot. Nizarjoe i wanna ask some question, do Quota limiting really work for you? I have tried implemented Chillispot-Max-Total-Octets in my freeradius with daily accounting. But some strange behaviour is occured. When the quota is end (for example 10MB a day) then i cant login again another day (it should be resetted daily) except i reset the account manually. I have examined freeradius in debugging mode, it said always rejected because value is low than zero. And another buggy is when using quota limitation together with time limitation, im curious if we can do something like limiting quota and time together, whenever it comes first. I've searching around and have a dead end.. Any clue appreciated..

yes my friend, i have tried it and its not working either. I thought it was only query for invert the counting into reverse order from the beginning. In my case my time limitation is working fine,the issues is only about quota limitation. Im using quota limitiation with reset set to daily. Im not using noresetcounter. But if i put those two counter together (both check about quota and time), my time counter is not working too (sometimes its working sometimes not). Here my counter looks like now:

sqlcounter quotalimit {
                counter-name = Total-Max-Octets
                check-name = Max-Daily-Octets
                reply-name = Chillispot-Max-Total-Octets
                key = User-Name
                reset = daily
                query = "SELECT IFNULL(SUM(acctinputoctets+acctoutputoctets),0) from radacct WHERE UserName='%{%k}'"
                sqlmod-inst = sql
        }
Im wonder why its not working, It will not disconnect if the quota has reached. But if we logout and login again, the counter is working and return message that our daily quota has reached the limit. After a day, the counter still not resetted and the user still cant login because quota has reached the limit. I can login again after i delete radacct record for this user.
Im had checked in debug mode, i dont think there is an error because it say that the counter will be resetted on the next day. I should be working.. strange isnt it?
Please Let me know if you found anything..

Thanks dmkhn for assisting. I still dont know whats wrong with my configuration. Last time i completely uninstall freeradius package and reinstall, and still not showing any working result.
Here is my installed package :freeradius  2.1.0+dfsg-0ubuntu2~hardy, freeradius-common, freeradius-mysql, freeradius-utils, libfreeradius2.
Do i missing something here..?

i am also looking to limit data limit. Can you please share the code as to how did you achieve it?
Thanks