2015-10-29 - Re: [GRASE-Hotspot] Creating again a deleted user, keeps the old data.

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 12ce00f1f361c82499495adebb5b2cf9ec796d266067beef2a7379f1e4c3907e
Message ID: <CAESLx0Jdb_TouT_7LSZ7n1TaW7j6yz1wpfnG0N=gdYfab7_cTw@mail.gmail.com>
Reply To: <CAPz6xh5bWLhG8pOeyfOeuFxX4nrKytoutrB0MWe3Pgv4RpfMHA@mail.gmail.com>
UTC Datetime: 2015-10-29 13:53:16 UTC
Raw Date: Fri, 30 Oct 2015 06:53:16 +1000

Raw message 

Hi Tomas

Unfortunately, the way the Radius DB is structured (It's really tables
within tables, thanks radius), it's really difficult to do this. In a
normalised database this would be easy. Trying to move from radius's
"flexible" and "extensible" schema to a rigid schema is a major job, as it
would involve rewriting a lot of the freeradius queries instead of using
what is provided by upstream.

Potentially a warning when you try and create an account that has data
already existing for it?

Regards

Tim

On Fri, Oct 30, 2015 at 12:32 AM, Tomas213 <to***3@gmail.com> wrote:

> Maybe you could make a unique id for every username so, stats can use the
> userid and not the username.
>
> It's a minor problem, but if by any change, when u create a new username,
> it creates a username that it was created earlier, we might have the same
> problem.
> Thomas
>
>
> On Thu, Oct 29, 2015 at 11:22 AM, Timothy White <ti***8@gmail.com>
> wrote:
>
>> Hi Thomas
>>
>> Unfortunately this is how it's designed. Otherwise the monthly usage
>> reports are inaccurate (delete a user and all their usage disappears). I'm
>> happy for people to give input into how they want this to work, it's like
>> this for historical reasons. Maybe an option when deleting the user to
>> delete usage? And then do we just delete the recent usage, or the archived
>> usage?
>>
>> Regards
>>
>> Tim
>>
>> On Fri, Oct 23, 2015 at 9:15 PM, Tomas213 <to***3@gmail.com> wrote:
>>
>>> Hello Tim.
>>> Some time ago i created a username : 123
>>> I did some test and then i deleted it.
>>> Today i needed to make some more tests, created the username again and i
>>> saw that it kept the old data usage, time usage, etc.
>>> Is this normal?
>>>
>>>
>>> Thomas
>>>
>>> --
>>> 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 post to this group, send email to gr***t@grasehotspot.org.
>>> Visit this group at
>>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>>> To view this discussion on the web visit
>>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5JFzEEaLToOdsEBLMLyC9rN4y40DG6PB7TuY9x_e2VeQ%40mail.gmail.com
>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5JFzEEaLToOdsEBLMLyC9rN4y40DG6PB7TuY9x_e2VeQ%40mail.gmail.com?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 post to this group, send email to gr***t@grasehotspot.org.
>> Visit this group at
>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>> To view this discussion on the web visit
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0Jj1AW7iZNMOCeAxM69jMe4%3DVDgfUqQMvTi4oiyuOV3kA%40mail.gmail.com
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0Jj1AW7iZNMOCeAxM69jMe4%3DVDgfUqQMvTi4oiyuOV3kA%40mail.gmail.com?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 post to this group, send email to gr***t@grasehotspot.org.
> Visit this group at
> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5bWLhG8pOeyfOeuFxX4nrKytoutrB0MWe3Pgv4RpfMHA%40mail.gmail.com
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAPz6xh5bWLhG8pOeyfOeuFxX4nrKytoutrB0MWe3Pgv4RpfMHA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>

Thread