[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
WordPress User/Subscriber cleanup
- To: "Berkeley Linux Users Group (BerkeleyLUG)" <berkeleylug@googlegroups.com>
- Subject: WordPress User/Subscriber cleanup
- From: "'Michael Paoli' via BerkeleyLUG" <berkeleylug@googlegroups.com>
- Date: Sun, 13 Jul 2025 23:01:27 -0700
- Arc-authentication-results: i=2; gmr-mx.google.com; dkim=pass header.i=@berkeley.edu header.s=google header.b=R9AbIhlQ; spf=pass (google.com: domain of michael.paoli@berkeley.edu designates 2a00:1450:4864:20::530 as permitted sender) smtp.mailfrom=michael.paoli@berkeley.edu; dmarc=pass (p=REJECT sp=REJECT dis=NONE) header.from=berkeley.edu; dara=pass header.i=@googlegroups.com
- Arc-authentication-results: i=1; gmr-mx.google.com; dkim=pass header.i=@berkeley.edu header.s=google header.b=R9AbIhlQ; spf=pass (google.com: domain of michael.paoli@berkeley.edu designates 2a00:1450:4864:20::530 as permitted sender) smtp.mailfrom=michael.paoli@berkeley.edu; dmarc=pass (p=REJECT sp=REJECT dis=NONE) header.from=berkeley.edu; dara=pass header.i=@googlegroups.com
- Arc-message-signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=list-unsubscribe:list-subscribe:list-archive:list-help:list-post :list-id:mailing-list:precedence:reply-to:content-transfer-encoding :to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=ILIZJCu0QuqM+YzKscAP5L4Hmo2/wN4hfrPDoL2z5ws=; fh=KEuHYmN5CYYEi8tPu1/1FdeNeFhhoCkx36vaJJ+6XnY=; b=jlGlswYIib+Ryau+ab4KJqXwXIrgGcWp4xgV/e6AVk/60Dz106F4c6bgOiQ002YtA2 W3N6wMJasWJ8iBT7tAuoyNqpYPakf0DtWmCy7fDLt6/YGXc9bIwr9StcCSAvFEA/Mon1 5VWATLgrvpL6NDvnak8a8+bGzRMjo8RIIJDfubb6fCyNsJ+czvDWFq0OOagFA70nB425 r7QjZm7n2S58jWzX644QZ6ugkRFf92lWsssSE2J249dcZPAa/xkJEBVDwuxyV2kx2nfy TV5U5/oJmC3YZJCzIVo+SeBjeBRAcz+CfeUpaMswNqNlAGcFazoizFVmk3fgVUN7nBFU qCOw==; darn=netisland.net
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=cAfuRyFBURGKgO6FTDOGh4Nkb6+7xD/7U0DB8yOt2xc=; fh=sML/OULlfnWITsGkMh+cjofqEO0XhR1yO0lIVYTCoc4=; b=hrAeCeIQlzRIWE0BwpyNKCIkwbM/4rq4uI747np/hlffw9cMqCOWURpfY7qkh+csxM 18hRRDbWTId4ZaAHt23cODZvoa2OLQK9dkEVa8h9Q2VYMNSYu4NC8qD2RfGmE8/+cE2b Y8lkZKcIEb9tTi+qMkL9Jv/XIfobC1qBQ5Uauze/rUm5Mg9cZo5xhzLwdCl9KOiFnbzD hSWfY+2C5NbUfzthZwms9p8wUhFsWHzVbY72qZNsemGhbz+RdQl4rTH5rE5w3zagsl6e 0U+in9/UeTy0raGcLxjDtCOiCqevsb7qRL4PMDxrUOUysdFIrpbZh9yse5cS1TPk+Q8A D28g==; dara=google.com
- Arc-seal: i=2; a=rsa-sha256; t=1752472930; cv=pass; d=google.com; s=arc-20240605; b=CcgXN4lTBYxTNrD3iKy6O3S7ztY2MuDY1imm7P1yUj5kbE8u4HqCyIvXhOv22/IC90 3cNNkKoEkhHwvzw9dlYZ8DmHagIZqetjHp7el94ZfMvbGC2IhX3mGO81ld1l4ptvbPv/ Gb3Vjn/CkZvgr1Ez6MgwaLMMmwZsy9QU0V1TSNbG6A+mzKiXBUVlEvITTfhXycawGYAO CDvj4iaidGlt4bN9IMOhgRZqUG+He9cWfvpF0ckrLbJ6UmjSo3lzpesv6+W1Cu1pV3/F P5j7QyKlbuf6FeXcd1Ktm6xdMwm1EORbOUpgXlKPH/YMtehiV6Cmw5bMUYZIhLHinE8f Vmng==
- Arc-seal: i=1; a=rsa-sha256; t=1752472925; cv=none; d=google.com; s=arc-20240605; b=KueUKwv2O0EPuOttXfZRb0PumEDmh6GG4uhG5gOKeefw6NINv1x3WEqlYMoEUSoLcf q46TK7x0VvbOK6Vex3UOBbJqFoipOThaMxIELro9Jha8kl42di0/X0OnoMnnKuchBICP hymnnKqPMyvNqwgOkGfaN33EJ2Zg9FnKjQ//N5GaI87wzs1IYRbi8O9WNuyUaMDCEtwN sVxIP8Ft+TxJHHFGM2kDqk+8SNmDLhwOlABZqq+yx5ItRyGXp/pEJwoF5w4Rw5buUDpq aNz/Pus0iROUG1UgGlqrwexS9FD6NDe1h1L0a5M6gigx/ns8fO3LtsBdC9TFnA17eozM CE5A==
- Delivered-to: historian@entropia.netisland.net
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20230601; t=1752472930; x=1753077730; darn=netisland.net; h=list-unsubscribe:list-subscribe:list-archive:list-help:list-post :list-id:mailing-list:precedence:reply-to :x-original-authentication-results:x-original-sender :content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=ILIZJCu0QuqM+YzKscAP5L4Hmo2/wN4hfrPDoL2z5ws=; b=jq0Zo0eO6621Rl6OQLLr/iPk7TUwmoOqmYSncQeGEO/sPFrAGTEzafrgO2vnoEDAX1 bWWgJOQcpDsWGiH+E60e6TbcERgsXcF5u3RUCRYzgbid+LLok9QZblpbv841CaplNNzz HioZSFSJGnpFyHEPDt/wpoI2tjKtJldHaCll/SzLcDtvk9eqGFgGarPJ72yyv6nOACVF omPohv2JpM9neixae9H+MDtfKHPfKbJxzvPivr1qR4ThmIifJwikrQdiEaGy6Q6VK7Zl 1PW/qyxmh4ecILtFR/33uA+v0KNTT/MXhxCpnUVr6WNlOzdfKaDkeMtqTDhV/BhzhmPr nGNg==
- In-reply-to: <CAPU_E+dqHOFD26oa+DjDNMCj5Ph5dsOtr1Z2QUzwsGmgiAtNEA@mail.gmail.com>
- List-archive: <https://groups.google.com/group/berkeleylu>
- List-help: <https://groups.google.com/support/>, <mailto:berkeleylug+help@googlegroups.com>
- List-id: <berkeleylug.googlegroups.com>
- List-post: <https://groups.google.com/group/berkeleylug/post>, <mailto:berkeleylug@googlegroups.com>
- List-subscribe: <https://groups.google.com/group/berkeleylug/subscribe>, <mailto:berkeleylug+subscribe@googlegroups.com>
- List-unsubscribe: <mailto:googlegroups-manage+61884646931+unsubscribe@googlegroups.com>, <https://groups.google.com/group/berkeleylug/subscribe>
- Mailing-list: list berkeleylug@googlegroups.com; contact berkeleylug+owners@googlegroups.com
- References: <20190828065407.10407kf5hvlhjrk8@webmail.rawbw.com> <20190830072521.21241miuqsibqbwg@webmail.rawbw.com> <20190902183537.78777xjklubwg6zk@webmail.rawbw.com> <20190911221004.11961o2kox7xbvwk@webmail.rawbw.com> <20190912080641.GU6980@linuxmafia.com> <20190913081735.1882710zquoywu8f@webmail.rawbw.com> <CAPU_E+dqHOFD26oa+DjDNMCj5Ph5dsOtr1Z2QUzwsGmgiAtNEA@mail.gmail.com>
- Reply-to: Michael Paoli <michael.paoli@berkeley.edu>
And finished the user cleanup, now total of 13 WordPress users:
All (13) | Administrator (3) | Editor (2) | Author (1) | Subscriber (7)
Yeah, if you want to not look like a bot, and
avoid getting removed in such a cleanup, meet one of the
exceptions for those that weren't purged:
o has posted (non-spam) content on the WordPress site
o email matches that of this list (I ignored + extension parts, did case
insensitive checks on the matching, and also remembered to apply
gmail.com's funkiness with . characters in the local part (stripped all
those out before comparing)
o have a role other than Subscriber (the default)
o has name set in the WordPress user configuration
Also posted/updated on the site:
https://berkeleylug.com/2025/07/13/wordpress-user-subscriber-cleanup/
It's also visible as 2nd (most recent unpinned) post on the main page:
https://berkeleylug.com/
---------- Forwarded message ---------
From: Michael Paoli <michael.paoli@berkeley.edu>
Date: Sun, Jul 13, 2025 at 8:29 PM
Subject: Fwd: Simple Math Captcha added to registration: Re:
BerkeleyLUG site anti-spam enabled, comments & registration / sign-up
opened up.
To: Berkeley Linux Users Group (BerkeleyLUG) <berkeleylug@googlegroups.com>
So, at some point along the way, likely some upgrades or the like,
Simple Match Captcha, most notably on the WordPress registration, broke.
Anyway, have now fixed that.
Additionally, I disabled the setting option:
Hide for logged in users
Enable to hide captcha for logged in users.
Would you like to hide captcha for logged in users?
Notably so to avoid having a logged in user (e.g. bot),
massively registering additional users - with no further captcha
to register them, as they were already logged in.
Yeah, we now have 941 users:
All (941) | Administrator (3) | Editor (2) | Author (1) | Subscriber (935)
And likely the vast overwhelming majority not legitimate, but bots.
So, I expect I'll be cleaning that up soonish, as I believe I did
likewise before.
---------- Forwarded message ---------
From: Michael Paoli <Michael.Paoli@cal.berkeley.edu>
Date: Fri, Sep 13, 2019 at 8:17 AM
Subject: Simple Math Captcha added to registration: Re: BerkeleyLUG
site anti-spam enabled, comments & registration / sign-up opened up.
To: BerkeleyLUG <berkeleylug@googlegroups.com>
I added a simple Math Captcha to registration.
That will likely suffice to mostly, if not entirely,
stop spambots from registering.
As for cleaning up (removing) registered accounts of
spambots - no extreme rush on that, but shall do that over the
coming week(s)/month(s). Probably request that users
update their profile to include something for name
(the spam bots don't bother, and generally looks better if
that's set anyway), may likely manually add that (or at least
partially so) to some older accounts (the few that were present
when site was migrated) ... maybe give user some alternative
means if they're legit, and really don't want to fill in
name field(s) at all, ... and, after some while,
remove the users that have nothing set in any of the name fields,
and haven't taken any alternative means to identify themselves
as legitimate - then the rest can mostly be reasonably presumed
to be spam bot sign-ups.
We're at 113 "users" now - the rate seems to have dropped off, as
most of the spam bots figure out they can't get their spam
content posted. "Of course" spam attempts continue - most notably
comment attempts - but the anti-spam in place seems quite to
exceedingly good at dealing with that (thus far of many hundreds
of attempts, no spam has made it through, and no legitimate
comments or attempts have been flagged as spam - though some
(new users or unregistered?) have been held for moderation.
This Captcha also seems minimally intrusive, should be enough (hopefully)
to stop spambots - but if needed, many other Captcha options are
available. Also, this Captcha doesn't feed some for-profit entity
human intelligence information (like training their AI by using
humans - and without those humans being paid for it!).
> From: "Rick Moen" <rick@linuxmafia.com>
> Subject: Re: BerkeleyLUG site anti-spam enabled, comments &
> registration / sign-up opened up.
> Date: Thu, 12 Sep 2019 01:06:42 -0700
> Quoting Michael Paoli (Michael.Paoli@cal.berkeley.edu):
>
>> o add some captcha or the like to raise the bar sufficiently on
>> registration / sign-up
>
> It usually ends up being a CAPTCHA implementation people add for this
> purpose, because it's difficult to find a modest, _simple_ plug-in for
> WordPress, only baroquely complex ones. But a complete solution would
> be anything that asks the user to answer a simple question that isn't
> standard across everyone else's WordPress, like 'What is 4+5?' and
> require a correct answer before the form submission gets processed.
>
> Bruce Schnier on his blog ('Schneier on Security') has a simple hack
> where you are asked to answer the question 'The title of this blog is
> "Schneier on ________". What is that word?' (I paraphrase.) Works
> perfectly -- because it's not necessary to defeat custom attacks, just
> comment-bots aimed at commodity software.
--
You received this message because you are subscribed to the Google Groups "BerkeleyLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to berkeleylug+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/berkeleylug/CAPU_E%2Bc%3DR4nfJQRdzBrFPAot9oeHvTYDfyf-5JwsfpZZRHiAUg%40mail.gmail.com.