how to reset the account with data usage to Zero

[shrijan pradhan]

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

[Bob Hunt]

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

--
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 grase-hotspo...@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.

[Tim]

Has Bob has said, currently you need to manually update the radius accounting tables (radacct).

Hi highly encourage one of you that wants this feature (deleting a user including their usage data) to create an issue with a user case ("user story") as to why you want it. I'm sure we can make a flag that changes the delete to include all radius accounting data. https://github.com/GraseHotspot/grase-www-portal/issues

My expectation is that you give users monthly limits (with recurring limits), or top up limits, where they can buy more data as required. It would be good to hear your use cases so we can cater to them as well.

Regards

Tim

To view this discussion on the web visit https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA%3DY79NY-9dc0g%40mail.gmail.com.

[shrijan pradhan]

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

To unsubscribe from this group and stop receiving emails from it, send an email to grase-...@grasehotspot.org.

[Christopher Gregory]

 

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" <shr...@gmail.com>
To: "Grase Hotspot" <grase-...@grasehotspot.org>
Subject: Re: [GRASE-Hotspot] how to reset the account with data usage to Zero

To unsubscribe from this group and stop receiving emails from it, send an email to grase-hotspo...@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.

[shrijan pradhan]

Hi Christopher,

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

Really appreciate it.

regards,

shrijan

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.

--

With Best Regards,

shrijan pradhan