[00:26:34] <ubuntourist>	 Trying to tackle a massive spam attack. I've eliminated over 3000 pages so far, but now I want to eliminate a ridiculous number of users as well. I looked at https://www.mediawiki.org/wiki/Manual:FAQ#%E2%80%A6is_it_a_good_idea_to_keep_user_accounts?
[00:27:37] <ubuntourist>	 but still want to go forward: I don't want to hide all users, and I don't want to spend years merging users with UserMerge one by one (or renaming users)
[00:29:13] <ubuntourist>	 Is there a sane approach to eliminating users?  I'm thinking about, for starters, eliminating all users who have not contributed anything. If I've successfully eliminated most spam pages, then many of the spambots will have no contributions.
[00:32:52] <ubuntourist>	 (I've recently inherited administration of this 10-year-old wiki, and have successfully moved it from 1.20 to 1.27. I cannot go farther because I cannot change to the version of MySQL needed for later versions.)
[03:12:33] <Skizzerz>	 ubuntourist: the easiest way to is to roll back to a db backup from before all the spam hit (this only works if there weren't legit edits during the spam attack that you wish to keep). Otherwise eliminating people with zero contributions is possible via a maintenance script, lemme grab which it is
[03:13:24] <ubuntourist>	 Skizzerz, alas, good stuff was added after the bad.
[03:17:16] <ubuntourist>	 Skizzerz, It's taken about 3 weeks of https://www.mediawiki.org/wiki/Manual:Page_table#Deleting_pages_with_their_relationships_in_text_and_revision_tables but the list of pages is finally looking sane.
[03:20:03] <Skizzerz>	 the cleanupSpam.php maintenance script might have helped with that (assuming the spambots added external links)
[03:20:18] <Skizzerz>	 and the script to blow them off entirely is removeUnusedAccounts.php -- https://www.mediawiki.org/wiki/Manual:RemoveUnusedAccounts.php
[03:22:07] <ubuntourist>	 Skizzerz, Well. That was a nice logical name. I feel foolish for not having skimmed the maintenance script names better. Thanks.
[03:23:03] <Skizzerz>	 it took me a good 5 minutes of looking through the list to find it... I kept trying to find things with "user" in the name
[03:34:41] <ubuntourist>	 Skizzerz, heh.
[03:35:52] <ubuntourist>	 Skizzerz, Now that it's been running for over 3 minutes, I wish I'd thought to make a log. I'd love to know the final count of how many bots its killed.
[03:36:45] <Skizzerz>	 heh
[03:37:46] <ubuntourist>	 Skizzerz, People have been bugging me for 3 weeks saying "When are you going to lift the ReadOnly restriction?" And I keep telling them "When I have a list of pages and users I recognize"
[03:39:24] <ubuntourist>	 Skizzerz, And, if I've somehow managed to screw up, I do have the fully-crap-filled backup that I started with when I locked everything down. But now, no more anonymous posts, no more self-registration. Contact the board of the hackerspace if you want editing privs.
[03:39:35] <Skizzerz>	 do what works :)
[03:39:54] <Skizzerz>	 for my wikis, I tend to have draconian AbuseFilters set up
[03:40:05] <Skizzerz>	 I don't care so much about having spambots in the userlist, so long as they never successfully spam
[03:40:24] <ubuntourist>	 Skizzerz, And... like the Energizer bunny, removeUnusedAccounts is ... still going ...
[03:40:38] <Skizzerz>	 it might take a while if you've accumulated thousands of spambots
[03:41:32] <ubuntourist>	 Skizzerz, Well, I'd like to be able to go to the Special:Users page and get a list of genuine users without having to wade through thousands of pages of crap users.
[03:41:48] <Skizzerz>	 that's fair :)
[03:42:38] <ubuntourist>	 Skizzerz, and with the number of blocked pages and users, that space is getting used somewhere. I want that space freed up again.
[03:42:51] <Skizzerz>	 sorta freed up*
[03:43:22] <p858snake>	 ubuntourist: https://www.mediawiki.org/wiki/Extension:UserMerge
[03:43:43] <Skizzerz>	 bleh, got dc'ed
[03:43:46] <p858snake>	 the space would eb in your mysql db, and unelss you have space constraints, i wouldn't worry about it
[03:43:52] <Skizzerz>	 anyway, depending on what you mean by "freed up" it might not be
[03:44:07] <Skizzerz>	 deleting stuff in mysql won't return that space as free space in your overall filesystem
[03:44:11] <Skizzerz>	 it just lets mysql reuse it for other stuff
[03:44:35] <ubuntourist>	 p858snake, For thousands of users. Nope. Been there done that. Couldn't figure a way to do it except one at a time. (I found a StackOverflow post that suggested a way, to do many, but it didn't work.)
[03:44:39] <Skizzerz>	 (there's queries you can run to actually have it be reclaimed for the filesystem if that's a worry for you)
[03:45:52] <ubuntourist>	 Skizzerz, Well, well, well. It does report back: "...found 25460"
[03:46:09] <Skizzerz>	 now the question, did you run the script with --delete or not?
[03:46:20] <Skizzerz>	 by default it only does a dry-run to identify impacted accounts
[03:46:40] <ubuntourist>	 Skizzerz, not yet. It was the dry run. (And it informs me of such.)
[03:47:05] <Skizzerz>	 also that's a lot of spam accounts
[03:48:26] <ubuntourist>	 Skizzerz, And it took from the time you suggested the script until the time I reported the results to get through all that.
[03:49:12] <ubuntourist>	 25 minutes approx.
[03:52:52] <Skizzerz>	 ubuntourist: I recommend taking a snack/coffee break next time you run it ;)
[03:54:38] <ubuntourist>	 Skizzerz, Heh. Well, I'm pretty obsessive about documenting my adventures. So, between updating my wee markdown file, and IRC and "watching the paint peel" I'm good, sipping on my Diet Coke with Lime. ;-)
[04:08:11] <ubuntourist>	 Skizzerz, And it STILL doesn't get rid of everyone.  The first user in the list shows:
[04:08:15] <ubuntourist>	     04:16, 14 September 2018 (diff | deletion log | view) . . User talk:Abigail (→‎$@*₩ Outlook Phone Number ௹ 1-855-338-0710 ₡Outlook Support Number £ 1.855*338*0710 £: new section)
[04:08:37] <Skizzerz>	 it won't get rid of accounts that have contribs of any sort
[04:08:54] <Skizzerz>	 including deleted contribs (as in, deleted using the wiki delete function, which is reversible)
[04:09:43] <ubuntourist>	 Skizzerz, My hope was to that by using the procedure in https://www.mediawiki.org/wiki/Manual:Page_table#Deleting_pages_with_their_relationships_in_text_and_revision_tables
[04:10:40] <ubuntourist>	 Skizzerz, which has me down and dirty in mysql interactive prompt, issuing actual DELETE...; that I was removing all contributions.
[04:10:45] <Skizzerz>	 that gets rid of pages they created, but won't get rid of edits they made to existing pages or other log actions (like moving pages)
[04:11:10] <ubuntourist>	 Skizzerz, Ah.
[04:11:49] <ubuntourist>	 Skizzerz, Still. I'm down from ridiculous to less than 500 crap accounts.
[04:12:19] <ubuntourist>	 Skizzerz, so. time for bed, and more clean-up tomorrow.
[04:12:24] <Skizzerz>	 good luck!
[04:12:36] <ubuntourist>	 Skizzerz, thanks again for the help.
[04:15:59] <Skizzerz>	 (also a bit of advice, don't copy/paste spam in here. our resident anti-spambot may trigger and ban you)
[04:16:27] <ubuntourist>	 Skizzerz, Oops.
[04:16:54] <Skizzerz>	 it's fine, just something to keep in mind :)
[04:16:59] <Skizzerz>	 obviously it didn't trigger from that previous line
[10:02:48] <Zoranzoki21>	 Hi. Can you delete page https://www.mediawiki.org/wiki/Communication/sr with reason: Author request
[10:03:33] <Zoranzoki21>	 Ohhh.. Noo
[10:03:35] <Zoranzoki21>	 wrong page
[10:03:47] <Zoranzoki21>	 https://www.mediawiki.org/wiki/Commit-message-validator/sr
[10:03:51] <Zoranzoki21>	 I think https://www.mediawiki.org/wiki/Commit-message-validator/sr
[10:03:55] <Zoranzoki21>	 No Communication/sr
[11:26:40] <Zoranzoki21>	 Hi
[11:26:52] <Zoranzoki21>	 Is any administrator of wiki online?
[11:27:18] <p858snake>	 i'm somewhat around
[11:27:55] <Zoranzoki21>	 Ok.
[11:28:31] <Zoranzoki21>	 Delete https://www.mediawiki.org/wiki/Commit-message-validator/sr with reason Author request
[11:29:11] <p858snake>	 why? is there a translation issue?
[11:29:40] <Zoranzoki21>	 Yes
[11:31:48] <Zoranzoki21>	 Then delete https://www.mediawiki.org/wiki/Topic:Ulplnqu0racrvhot
[11:32:48] <Zoranzoki21>	 After that, delete 670 pages listed here https://www.mediawiki.org/w/index.php?search=Translations%3AExtension%3AEducation+Program%2F&title=Special%3ASearch&go=%D0%98%D0%B4%D0%B8
[11:33:13] <Zoranzoki21>	 Reason: Source page is not translatable
[11:34:37] <Zoranzoki21>	 I apologize for these tasks, but I am not an administrator.
[11:43:59] <p858snake>	 if the first one is a translation issue, can't you just keep editing it? is there really a need to delete the whole thing
[11:46:13] <Zoranzoki21>	 Yes
[12:00:11] <p858snake>	 Zoranzoki21: I'm not knowledge in the E:Translate workflow so I won't be doing those deletions
[12:01:06] <Zoranzoki21>	 ok
[12:04:07] <Jackie365>	 I got a question about the Wikitext.
[12:04:25] <Jackie365>	 Where can I find the wikitext of those templates?
[12:05:59] <Jackie365>	 Is the source code of a template stored somewhere in the mediawiki?
[12:06:54] <Jackie365>	 So where can I see the source of a template?
[12:09:39] <Jackie365>	 I'd like to write a Wikicode phraser, so I need to display a wiki page using Wikicode instead of pure HTML
[12:13:15] <p858snake>	 Jackie365: some of the code will be stored in the Template namespace
[12:13:34] <p858snake>	 there could also be some in the module namespace as well
[12:14:45] <Jackie365>	 So is it possible to render a wiki page using wikicode only?
[12:15:14] <Jackie365>	 without being translated to Web Page by MediaWiki
[12:30:54] <Jackie365>	 ?
[13:36:09] <valerio-bozzolan>	 Jackie365 "?action=raw" ?
[14:01:13] <valerio-bozzolan>	 Hello! I'm trying to use the JavaScript function mw.msg() | ms.message() on Wikipedia, but I think they don't work
[14:01:25] <valerio-bozzolan>	 I followed this: https://www.mediawiki.org/wiki/Manual:Messages_API
[14:01:31] <valerio-bozzolan>	 "Using an API query from JavaScript"
[14:02:13] <valerio-bozzolan>	 But when calling e.g. mw.msg('group-interface-admin') I obtain a result with strange encoding
[14:03:07] <valerio-bozzolan>	 Try F12: alert( mw.msg('copyright') );
[14:03:17] <valerio-bozzolan>	 It does not show this message:
[14:03:19] <valerio-bozzolan>	 https://www.mediawiki.org/wiki/MediaWiki:Copyright
[20:09:36] <Platonides>	 hello jack 
[20:10:35] <Platonides>	 which dependencies do you need?
[20:11:23] <Platonides>	 how did you download mediawiki?
[20:12:57] <Platonides>	 hmm
[20:13:07] <Platonides>	 I thought you didn't need to run composer that way
[20:17:52] <Platonides>	 jack: that error triggers when there's no vendor/autoload.php
[20:18:10] <Platonides>	 but it is already included if you downloaded the tgz
[20:18:46] <Platonides>	 it seems you did something wrong
[20:18:53] <Platonides>	 did you download https://releases.wikimedia.org/mediawiki/1.31/mediawiki-1.31.1.tar.gz ?
[20:20:54] <Platonides>	 I think it's better you restart from scratch
[20:21:06] <Platonides>	 and if you still have that issue... not sure
[20:21:18] <Platonides>	 maybe if we can reproduce it we will be able to fix