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

Header Data

From: Tim <ti***8@gmail.com>
Message Hash: 89896a4ecb0d8860ffa7bbd525a6a5a37bc198745797ba2a02afc97d48ee4c0e
Message ID: <CAESLx0J_o=58120nK=utY_0f+vwUp+2quRapcsoiA=Ge=n+5wQ@mail.gmail.com>
Reply To: <CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA=Y79NY-9dc0g@mail.gmail.com>
UTC Datetime: 2020-02-07 21:38:37 UTC
Raw Date: Sat, 08 Feb 2020 12:38:37 +0800

Raw message 

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

On Sat, 8 Feb 2020 at 04:37, Bob Hunt <bo***2@gmail.com> 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***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>
>> .
>>
> --
> 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/CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA%3DY79NY-9dc0g%40mail.gmail.com
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAA-jMMSsVWxPXbPF1j7YRxmSW6cHEyn8LwELuA%3DY79NY-9dc0g%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

Thread