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

Header Data

From: shrijan pradhan <sh***n@gmail.com>
Message Hash: 7ece065b654f59988aac198fa6641efe692393caa084ca82cdd8c4173903f122
Message ID: <CAP6SgTAuouAmTxuNN6qSewpFrNC4Zh=+6Ym+bYCyw14SADh29Q@mail.gmail.com>
Reply To: <trinity-fca5789f-476c-4191-b096-2faf3e2bc258-1581224895292@3c-app-mailcom-lxa10>
UTC Datetime: 2020-02-10 00:53:27 UTC
Raw Date: Mon, 10 Feb 2020 10:53:27 +0300

Raw message 

Hi Christopher,

Thank you for the advice and link you have provided. It was really helpful.

Really appreciate it.

regards,
shrijan

On Sun, Feb 9, 2020 at 8:08 AM Christopher Gregory <
ch***y@mail.com> wrote:

>
> Hello,
>
> To install phpmyadmin in either Ubuntu or debian:
>
> sudo apt-get update
> sudo apt-get upgrade
>
>
> You do both of those commands, so that you make sure that the repositories
> are up to date (the first command) and that you have the most up to date
> packages from the security repository, and the second command makes sure
> that your local system is upgraded.
>
> Then to install phpmyadmin:
>
> sudo apt-get install phpmyadmin
>
> You will of course need to answer Y to the above commands.
>
> The easiest step by step guide for setting up phpmyadmin is here:
>
> https://www.hostingadvice.com/how-to/install-phpmyadmin-on-ubuntu/
>
> You will then need to apply the provided command for each of the users
> that you wish to zero the usage data for.
>
> Regards,
>
> Christopher.
> *Sent:* Sunday, February 09, 2020 at 7:36 AM
> *From:* "shrijan pradhan" <sh***n@gmail.com>
> *To:* "Grase Hotspot" <gr***t@grasehotspot.org>
> *Subject:* Re: [GRASE-Hotspot] how to reset the account with data usage
> to Zero
> 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> 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.
>>> 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>
>>> .
>>
>>
> --
> 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***e@grasehotspot.org.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/e41a0249-9c43-47c7-9b48-858a38e980e7%40grasehotspot.org
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/e41a0249-9c43-47c7-9b48-858a38e980e7%40grasehotspot.org?utm_medium=email&utm_source=footer>
> .
>
> --
> 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***e@grasehotspot.org.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/trinity-fca5789f-476c-4191-b096-2faf3e2bc258-1581224895292%403c-app-mailcom-lxa10
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/trinity-fca5789f-476c-4191-b096-2faf3e2bc258-1581224895292%403c-app-mailcom-lxa10?utm_medium=email&utm_source=footer>
> .
>


-- 
With Best Regards,
shrijan pradhan

Thread