2017-07-16 - Purge users from the free access group

Header Data

From: bo***1@gmail.com
Message Hash: 01fff6037981124de053a8f15f41a9b3d89b863023f73598636bfc3e517f566f
Message ID: <13fc831a-620e-4858-ba98-f3470e9f891b@grasehotspot.org>
Reply To: N/A
UTC Datetime: 2017-07-16 03:41:00 UTC
Raw Date: Sun, 16 Jul 2017 03:41:00 -0700

Raw message 

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......

Thread