2017-07-16 - Re: [GRASE-Hotspot] Purge users from the free access group

Header Data

From: “[KIRA_90]” <ki***0@gmail.com>
Message Hash: 5e5cabf80921af620acae02ba8bf25630613ba3d8242eefb98e943d13b80ed6f
Message ID: <CAATbWPhrF9hCG-TR-ka241+ivAOjzJjJ=nP+VZ3ZJuobAtTbRg@mail.gmail.com>
Reply To: <CAATbWPgk+EwGnQnxdx5Z1912F2zPLD9=1prpaznDKKT+U0AS3g@mail.gmail.com>
UTC Datetime: 2017-07-16 04:27:12 UTC
Raw Date: Sun, 16 Jul 2017 19:27:12 +0800

Raw message 

Btw, 32k user. Wow, that's a lot. I think you need proper hardware to serve
thst much user traffic. 😅

On Jul 16, 2017 7:26 PM, "[KIRA_90]" <ki***0@gmail.com> wrote:

For this, usually i handle directly to the database itself. As addon my
server going along with grase, i installed phpmyadmin. Webmin is a good
addon too.

For extra tools other than above, i did installed ntopng (web base access),
nload, htop, ntop, jnettop and speedtest-cli (remote ssh monitoring tools).

Handy and useful in my opinion. 😀

On Jul 16, 2017 6:41 PM, <bo***1@gmail.com> wrote:

Hi again

I have had the latest version of my raspberry pi based hotspot running for
some time now. It is used entirely as free access so users just hit the
free access button and are online. The problem i have now is that as no
expiry should be set on that group I now have something like 32,000 users
on the system most of which will never bee seen again. If I try and go to
the users page it just hangs up due to the numbers.

I would like to purge the whole user database and start from scratch (the
only account that matters is my computer account for my phone). Obviously
even if I could get the users page to draw there is not a quick way to
delete that many accounts. I do have webmin installed so I was hoping to
use the mysql module to do the job although I realise this could be risky
however I cant access the module to to an account / credentials issue.
When I installed the system I used the same system password for all of the
mysql prompts to make it simple but this wont work with the webmin module.
I tried 'root' and 'ubuntu' as account names.

Can anyone suggest a way forward? and what is the best way to manage the
free access group where most users will never be seen after a few days on
holiday?

thanks in advance......

-- 
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 https://groups.google.com/a/gr
asehotspot.org/group/grase-hotspot/.
To view this discussion on the web visit https://groups.google.com/a/gr
asehotspot.org/d/msgid/grase-hotspot/13fc831a-620e-4858-
ba98-f3470e9f891b%40grasehotspot.org
<https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/13fc831a-620e-4858-ba98-f3470e9f891b%40grasehotspot.org?utm_medium=email&utm_source=footer>
.

Thread