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: 539c678654e51e263b137d1bdf35efa16ad7fc3b867191c898dd5b3dd6c030b3
Message ID: <CAM-gkwvqK-MiuiL091TapCvWiScSFXdY9TPZ0_RpnNRXyZdC_g@mail.gmail.com>
Reply To: <CAM-gkwvKBsny2Z15ASYmYPwD=kj7M4HkMwwkWzF0fvZ28WG0Dw@mail.gmail.com>
UTC Datetime: 2012-07-30 07:08:37 UTC
Raw Date: Mon, 30 Jul 2012 15:08:37 +0100

Raw message 

Tim I did everything you asked me.And i have a question, now with this
changes the data limit in group will work per day? For test i creat a group
with 1MB data limit, and i used this user at reached the 1MB, tomorrow i
will try login to see this user back to work. Thank's


2012/7/30 Ricardo Sá - www.uteusite.com <ri***o@uteusite.com>

>  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