Jeff, I've tried in the maintenance directory (a minute ago):
vmp@tunearch:/var/www/w/maintenance# php cleanupUsersWithNoId.php --dbuser=<user> --dbpass=<pass> --force --prefix=* --conf=../LocalSettings.php vmp@tunearch:/var/www/w/maintenance# php update.php
... and it works, at least for me with: _________________________________________________ MediaWiki 1.33.1 (d35fba2) 15:11, December 17, 2019 PHP 7.2.17-0ubuntu0.18.04.1 (apache2handler) MariaDB 10.1.38-MariaDB-0ubuntu0.18.04.1 __________________________________________________
Valerio Pelliccioni W: https://tunearch.org/
On 19/12/2019, 21:13, "MediaWiki-l on behalf of Jeffrey Walton" <mediawiki-l-bounces@lists.wikimedia.org on behalf of noloader@gmail.com> wrote:
Hi Everyone,
We are getting about 11,000 of these due to a spammer getting in a couple of years ago:
... log_id=4200 ... log_id=4300 ... log_id=4400 User name "Awpgkcm9ly0hjqagqrpl" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation. ...
$ grep -c 'anon' mw.txt 11748
I've tried manually cleaning them, but cleanupUsersWithNoId.php seems to be missing them:
Error: ==========
# php maintenance/cleanupUsersWithNoId.php --dbuser=<user> --dbpass=<passwd> --force --conf=LocalSettings.php
Notice: Undefined index: SERVER_NAME in /var/www/html/w/includes/GlobalFunctions.php on line 1388 Notice: Undefined index: SERVER_NAME in /var/www/html/w/includes/GlobalFunctions.php on line 1388 Param prefix required!
Cleans up tables that have valid usernames with no user ID
Usage: php cleanupUsersWithNoId.php [--assign|--batch-size|--conf|--dbgroupdefault|--dbpass|--dbuser|--force|--globals|--help|--memory-limit|--mwdebug|--prefix|--profiler|--quiet|--server|--table|--wiki] ...
Try again: ==========
# php maintenance/cleanupUsersWithNoId.php --dbuser=<user> --dbpass=<passwd> --prefix=* --force --conf=LocalSettings.php
Notice: Undefined index: SERVER_NAME in /var/www/html/w/includes/GlobalFunctions.php on line 1388 Notice: Undefined index: SERVER_NAME in /var/www/html/w/includes/GlobalFunctions.php on line 1388
But the entries persist.
I think I am not getting the options right. Here are the docs, but they have not been helpful: https://www.mediawiki.org/wiki/Manual:CleanupUsersWithNoId.php .
Does anyone know what switches I should be using to clean the unwanted users?
Jeff
_______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l