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" <[email protected] on behalf of [email protected]> 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 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
