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

Header Data

From: emre erdoğan <po***e@gmail.com>
Message Hash: ddff44e71bd1987dfd55c74a01d31853fd4a4951b38085b66ea0a17524f2d52f
Message ID: <CADDedMG+-qJQ0TjH4H=kh+ZpjmWU8NjvjJHbc5R9sbuE=OK-gA@mail.gmail.com>
Reply To: <13fc831a-620e-4858-ba98-f3470e9f891b@grasehotspot.org>
UTC Datetime: 2017-07-16 08:59:14 UTC
Raw Date: Sun, 16 Jul 2017 18:59:14 +0300

Raw message 

Hi.

If you are sure about the password, then you may use a php script to delete
old accounts. First you should install PhpMyAdmin. (sudo apt-get install
phpmyadmin)

In radius DB, there is two tables named "radcheck" and "radusergroup".
These are storing all users login information and groups.

In radcheck table, users' names and expiration infos are stored. Mac users
doesn't have expiration so it is hard to find / delete the old accounts. If
you add an extra timestamp field to the radcheck table, then you may easily
delete them by determining their register date. ( ALTER TABLE `radcheck`
ADD `registerdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; )

A php script or a SQL script from PhpMyAdmin can handle the job. ( DELETE
FROM radcheck WHERE datediff(NOW()-registerdate)>30 ) => This sample query
will delete all accounts older than 30 days.

If you only want to delete the mac user then you you may use something like
this: ( DELETE FROM radcheck WHERE datediff(NOW()-registerdate)>30 AND
UserName LIKE '%-%' AND Value='password' )

Raspberry is very important for me. Easy implementation, cheap and easy to
find. My high score was 104 users using grase simultaneously.

​Thanks to Tim for everything...​





2017-07-16 13:41 GMT+03:00 <bo***1@gmail.com>:

> 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/
> grasehotspot.org/group/grase-hotspot/.
> To view this discussion on the web visit https://groups.google.com/a/
> grasehotspot.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