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

Header Data

From: “Ricardo Sá - www.uteusite.com” <ri***o@uteusite.com>
Message Hash: 81ee099c590fd0f2e0d722f3151220063ced4229d3c17f5735ba6fbc62760c47
Message ID: <CAM-gkwvKBsny2Z15ASYmYPwD=kj7M4HkMwwkWzF0fvZ28WG0Dw@mail.gmail.com>
Reply To: <CAESLx0Lkwfqi7hL5JHG_Pam-8xcmxQPpdELbL4oe=rk0Di3Wsg@mail.gmail.com>
UTC Datetime: 2012-07-30 01:16:52 UTC
Raw Date: Mon, 30 Jul 2012 09:16:52 +0100

Raw message 

Sorry for my questions but i'm very confuse with this, I will need change
BD with unix shell right? You can tell me the name of this database ??the
table allready on this mail but the name of BD i'm searching on google but
i can find.

I plan to use these commands ( http://www.nparikh.org/unix/mysql.php
<http://www.nparikh.org/unix/mysql.php>
 ) to make changes in DB,  Please Tell me if this is the right way. Really
thank's bro


2012/7/28 Timothy White <ti***8@gmail.com>

> 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
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Grase-hotspot mailing list
> Gr***t@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>



--

Thread