2020-02-08 - Re: [GRASE-Hotspot] how to reset the account with data usage to Zero

Header Data

From: shrijan pradhan <sh***n@gmail.com>
Message Hash: a7793f6fe11d0ff993bea573590d4118613e6b354eafa1ded68a2a2c07178b37
Message ID: <e41a0249-9c43-47c7-9b48-858a38e980e7@grasehotspot.org>
Reply To: <CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA=Y79NY-9dc0g@mail.gmail.com>
UTC Datetime: 2020-02-08 11:36:55 UTC
Raw Date: Sat, 08 Feb 2020 10:36:55 -0800

Raw message 

Hi Bob,

Thank you for the quick Reply.

well like most of the user says i also have to say the same that I am 
totally new to the system specially php thing..:-)

i went through couple of videos to use the phpmyadmin tool but still i do 
not have that confident to use and apply it..

video i went through to install phymyadmin via cli in ubuntu 12.0.4 
https://www.youtube.com/watch?v=JXR8IdbPxfM

So let say if i have to install the phpmyadmin tool like you have suggested 
and  the video says then do i run and apply the command you suggested for 
those individual user that i want to reset the user to zero usage?

root@ubuntu-T60:/# mysql -u root -p radius;
Enter password:
mysql> UPDATE radacct
          -> SET AcctInputOctets=0 , AcctOutputOctets=0
           -> WHERE UserName="$user";

The reason i was a bit confused was phpmyadmin i found is to login by web 
and the command you have suggested is via cli.. So is it so that to use the 
command i need to install phpmyadmin ?

Please Note: I hope it will not create problem to my current users database 
as there are almost 200 users running through this server.

Thanks.

Regards,
shrijan



On Friday, February 7, 2020 at 11:37:01 PM UTC+3, bob.hunt.52 wrote:
>
> Hi Srijan,
>
> I needed this too.
>
> You have to UPDATE the 'radacct' table in the 'radius' database, using 
> phpMyAdmin or another method.
>
>  "UPDATE radacct  SET AcctOutputOctets=0, AcctInputOctets=0  WHERE 
> UserName=\"$username\""
>
> It breaks data usage tracking for the user but it worked for me.
>
> See 
> https://groups.google.com/a/grasehotspot.org/forum/?utm_medium=email&utm_source=footer#!searchin/grase-hotspot/bob.hunt|sort:date/grase-hotspot/CC-P5Aif6bg/ZUG3HN_HSAUJ
>
> Cheers, 
>
> Bob Hunt
> 20 Clarke Street
> Wyndham, NSW, Australia, 2550
>
> Phone: Landline 0264942030   Mobile 0460681773
>
>
> On Fri, Feb 7, 2020 at 11:16 PM shrijan pradhan <sh***.@gmail.com 
> <javascript:>> wrote:
>
>> Dear All,
>>
>> I am using GRASE (v3.8.0) for the HotSpot.
>>
>> I have created the server with 10 GB usage for a month to the users 
>> account.
>>
>>  So let say there is a user who has used upto 20 GB where his quota was 
>> added by 10GB previously.
>>
>>  Now when i delete his account i.e. mac address of the mobile phone and 
>> re-created it, the total usage of 20 GB still shows there.
>>
>>  Meaning i want to know if there is any option to reset the account to 
>> usage to 0 bandwidth?
>>
>> Thank You.
>>
>> Regards,
>> shrijan
>>
>>
>>
>> -- 
>> This mailing list is for the Grase Hotspot Project 
>> http://grasehotspot.org
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "Grase Hotspot" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to gr***.@grasehotspot.org <javascript:>.
>> To view this discussion on the web visit 
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/a8c8f252-ab5f-4e8a-b28c-f72d0fe6e7ec%40grasehotspot.org 
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/a8c8f252-ab5f-4e8a-b28c-f72d0fe6e7ec%40grasehotspot.org?utm_medium=email&utm_source=footer>
>> .
>>
>

Thread