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

Header Data

From: Bob Hunt <bo***2@gmail.com>
Message Hash: 348bf519d84462a45c7859a21d03efc6b8d15f304af1a96d852cbf89b07a57ff
Message ID: <CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA=Y79NY-9dc0g@mail.gmail.com>
Reply To: <a8c8f252-ab5f-4e8a-b28c-f72d0fe6e7ec@grasehotspot.org>
UTC Datetime: 2020-02-07 13:36:41 UTC
Raw Date: Sat, 08 Feb 2020 07:36:41 +1100

Raw message 

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***n@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***e@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>
> .
>

Thread