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..?

Yup, im already initialize quotalimit in the authorize section. But i dont use noresetcounter so i didnt put it into my config. Had tested it for downloading files bigger than the quota and i still connected when quota had reached (both tested using browser and download manager). The counter working after second login, and daily quota never resetted except if i delete it manually. Is this issue is about Access Point problem? Im using Linksys WRT54GL DDWRT..

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, i think its for time accounting. But its a good idea to make time counting on the first login, i'll make note on this.
In my case, have you found solution to mix time limitation together with quota limitation whenever which reached first?

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.. sad Any clue appreciated..