2012-07-27 - Re: [GRASE-Hotspot] 1GB per day, reset data usage

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 2a9c850db93165c185f63c7c8535b67e8fd4d572d49f77c78180840fa2e92446
Message ID: <CAESLx0Lkwfqi7hL5JHG_Pam-8xcmxQPpdELbL4oe=rk0Di3Wsg@mail.gmail.com>
Reply To: <CAM-gkwsxM46z=CYu58o2t3veH7iMrZ0DpdEP_OjeS7ibinD24g@mail.gmail.com>
UTC Datetime: 2012-07-27 16:31:47 UTC
Raw Date: Sat, 28 Jul 2012 09:31:47 +1000

Raw message 

On Fri, Jul 27, 2012 at 10:39 PM, Ricardo Varão Sá <ri***a@gmail.com> wrote:
> Tim sorry for my questions but i'm really need one way to fix. You have any
> line code to reset "data usage T" valeu, for all users(maybe update the
> valeu of data usage in database).
>
> This valeu are save in mysql database???

Your best fix is going to be using SQL to edit the database. You'll
want to remove the data limit values from the radcheck table, and add
a Max-Daily-Session ether to the radcheck tables (for each user), or
the radgroupcheck (to apply a group limit, easier than updating each
user).

Then find the file in /etc/freeradius/sql/mysql/counter.conf (or
counter.conf.grase) and find the line that is commented out that is
#sqlcounter dailyBytecounter {

Then uncomment that and all the lines until the next }

That /should/ give you a daily limit if done correctly. That's all I
can help for now, I'll look at whether I re-enable it in a future
releae.

Tim

Thread