[00:20:41] <Chatman>	 Hello there! Could someone help me with a mediawiki permission settings?
[02:30:18] <enterprisey>	 Is there any way to suppress a group editnotice?
[08:30:00] <ELLIOTTCABLE>	 Is there a way to query the mw api *and force rate-limiting*
[08:30:23] <ELLIOTTCABLE>	 I need to debug the rate-limiting behaviour of my API consumer, but I'm here to double-check if there is a way to do so *without* intentionally spamming the API. :P
[08:34:23] <legoktm>	 ELLIOTTCABLE: not really, we don't rate limit read access.
[08:37:55] <ELLIOTTCABLE>	 hrm, that's strange, because I'm getting messy crashes due to HTTP 429 Too Many Request responses
[08:38:10] <ELLIOTTCABLE>	 (this is on Wikimedia properties, not a default MediaWiki install)
[08:39:01] <legoktm>	 oh yeah, that's a recent thing
[08:39:08] * legoktm looks up rate limit
[08:40:06] <legoktm>	 it's supposed to be 50/s from IP, with a burst of 250
[08:40:14] <legoktm>	 per IP address*
[08:40:29] <legoktm>	 are you making API requests in parallel?
[08:40:32] * ELLIOTTCABLE nods
[08:40:38] <ELLIOTTCABLE>	 yes, many-many. :P
[08:40:56] <ELLIOTTCABLE>	 so I'm currently implementing intelligent backing-off via 429's
[08:40:57] <legoktm>	 ok, please don't
[08:40:59] <legoktm>	 https://www.mediawiki.org/wiki/API:Etiquette
[08:41:08] <legoktm>	 > If you make your requests in series rather than in parallel (i.e. wait for the one request to finish before sending a new request, such that you're never making more than one request at the same time), then you should definitely be fine.
[08:41:09] <ELLIOTTCABLE>	 heh, yep. very aware! hence current work.
[08:44:53] <ELLIOTTCABLE>	 The overall goal: I'm trying to crawl *categories*, finding all categories that are a descendant of a given root category.
[08:45:09] <ELLIOTTCABLE>	 is there a way I can do this with an API ‘generator’, instead of brute-forcing list=categorymembers calls?
[08:45:25] <ori>	 ELLIOTTCABLE: what is your consumer's user-agent, btw?
[08:45:51] <ELLIOTTCABLE>	 currently? https://twitter.com/ELLIOTTCABLE/status/665445884847632384
[08:46:27] <ELLIOTTCABLE>	 usually? let me generate it, hold on
[08:46:33] <ELLIOTTCABLE>	 ori: why do you ask?
[08:46:49] <legoktm>	 ELLIOTTCABLE: so, you can just grab an sql dump of all the category links from https://dumps.wikimedia.org/enwiki/20151102/ (for enwiki for example) and then process the data however you'd like
[08:47:31] <ELLIOTTCABLE>	 legoktm: I *think* I need more up-to-date information than that. If I can't generate it in one API call with a generator, I'll just query it in series over time, probably
[08:47:54] <ori>	 being able to relate a user-agent from the logs to an IRC nickname can be useful if we need to get in touch to ask you to impose stricter limits on your consumer
[08:48:03] <ELLIOTTCABLE>	 ori: *nods*
[08:48:07] <ori>	 don't worry, we don't send black helicopters to your house or anything :)
[08:48:38] <ELLIOTTCABLE>	 'wikipedi.as/0.0.2 (http://wikipedi.as; by ELLIOTTCABLE (http://ell.io/tt)) DisambiguationCrawler'
[08:49:07] <ELLIOTTCABLE>	 it's generated from the deploying user's package.json, it's an open-source thing; could be anything of that forma
[08:49:37] <legoktm>	 ELLIOTTCABLE: you can also get mysql access to sanitized (private info is redacted) database replicas by using our tool labs dev platform - https://wikitech.wikimedia.org/wiki/Help:Tool_Labs
[08:49:53] <ELLIOTTCABLE>	 hmmm, that *might* be faster.
[08:50:29] <ELLIOTTCABLE>	 legoktm: is some sort of sign-up / specific access required for that? because this is a “hit a button and deploy your own copy of this” project, so such a thing wouldn't work for any users cloning the project
[08:51:25] <legoktm>	 You have to sign up for an account and someone does a quick check to make sure you're not a spambot or whatever. You could set up a special API endpoint hosted on tool labs and have people hit it? 
[08:51:31] * ELLIOTTCABLE nods
[08:51:38] <ELLIOTTCABLE>	 that could work; two separate tools
[08:52:18] <ELLIOTTCABLE>	 the only thing I need the API for at the moment is determining if a particular page is a disambiguation page (for a wiki-specific definition thereof, but ...); that might be a useful tool to exist there *anyway*.
[08:52:42] <ELLIOTTCABLE>	 I'll take a look, that sounds cool~
[08:53:22] <ori>	 ELLIOTTCABLE: In the early years Wikimedia's capacity was always just barely enough, and we're still a bit reactive in our approach
[08:53:41] <legoktm>	 ohhh
[08:53:45] <legoktm>	 wait, that's easy
[08:53:49] <ori>	 if you are interested in participating in the design of rate-limits, https://phabricator.wikimedia.org/T97204 is a good starting-point
[08:54:35] <legoktm>	 ELLIOTTCABLE: https://en.wikipedia.org/w/api.php?action=query&titles=ABC&prop=pageprops look for "disambiguation" in the "pageprops" object
[08:55:03] <ELLIOTTCABLE>	 legoktm: … wait,
[08:55:05] <ELLIOTTCABLE>	 w
[08:55:08] <ELLIOTTCABLE>	 what. how does it even know that.
[08:55:21] <ELLIOTTCABLE>	 is “This category is a disambiguation category” first-classed in the data-model in some way that I didn't know about!?
[08:55:35] <ELLIOTTCABLE>	 wow, this saves me so much freaking work, if it's reliable
[08:55:57] <legoktm>	 https://www.mediawiki.org/wiki/Extension:Disambiguator is how we mark disambiguation pages in the database
[08:56:57] <legoktm>	 basically any page that includes "__DISAMBIG__" is marked in the database as a disambiguation page. And that magic word is usually part of some meta template that they all include
[08:57:11] <legoktm>	 it's possible there are some pages without the template, but in that case, they'd probably also be missing the category
[09:01:35] <ELLIOTTCABLE>	 mmmmm.
[09:01:44] <ELLIOTTCABLE>	 is this used across all the major languages?
[09:02:03] <legoktm>	 I believe so
[09:02:11] <ELLIOTTCABLE>	 Is there a quick way I can check?
[09:02:18] <ELLIOTTCABLE>	 oh, obviously, checking the templates for that magic word
[09:02:23] <ELLIOTTCABLE>	 legoktm: thank you so much. :D
[09:02:30] <legoktm>	 find a random disambiguation page on those projects and see if it's marked properly?
[09:02:32] <legoktm>	 you're welcome :)
[09:07:17] <ELLIOTTCABLE>	 unrelated to absolutely anything, ‘hispanoescribas’ is now my new favourite word.
[09:10:19] <ELLIOTTCABLE>	 agh. ja.wikipedia doesn't seem to use it, unless I've mangled navigating the language.
[09:10:27] <ELLIOTTCABLE>	 https://ja.wikipedia.org/w/index.php?title=Template:Aimai&action=view
[09:10:30] <ELLIOTTCABLE>	 er, =edit*
[09:12:54] <legoktm>	 Have you checked a disambiguation page?
[09:13:28] <legoktm>	 https://ja.wikipedia.org/w/index.php?title=ABC&action=info says it is a disambig page
[09:14:09] <legoktm>	 ELLIOTTCABLE: you have to go a level deeper, __DISAMBIG__ is in https://ja.wikipedia.org/w/index.php?title=Template:Dmbox&action=edit
[09:14:19] <ELLIOTTCABLE>	 legoktm: ahhah. I spoke too soon.
[09:14:24] * ELLIOTTCABLE goes back to checking
[09:18:52] <ELLIOTTCABLE>	 it's amazing how differently different languages/communities do some of the same things
[13:17:28] <jaypro>	 hey all
[13:18:09] <Erkan_Yilmaz>	 hi
[13:19:02] <jaypro>	 ...confused here... im installing multiple wikis on the same server, so i'm trying to follow the directions on the manual:wiki_family page...
[13:19:23] <jaypro>	 ... mediawiki.org/wiki/Manual:Wiki_family...
[13:19:47] <jaypro>	 im on step 6, second case, where you install wikis on the same domain but different paths...
[13:20:21] <jaypro>	 ..then it gives example code for what goes in your LocalSettings.php file...
[13:20:47] <jaypro>	 ...where do you put that file?
[13:21:31] <jaypro>	 ...same i'm installing 3 wikis, in /wiki1, /wiki2, and /wiki3... do i put the same file in all 3 directories?
[13:29:36] <jaypro>	 ...are there any issues with just installing 3 different times in 3 different directories, no need to go to step 6?
[13:30:21] <jaypro>	 ..i mean.. any issues with just install it 3x in 3 different directories... not following the wiki family portion of the manual?
[13:32:11] <jaypro>	 hrmm... okie dok
[14:10:44] <krispbacon>	 Hello all. I've written a special page extension called SpecialRandomWanted, which takes the user to a random page that doens't exist, but has references to it (redlinks). I know MySQL and I know PHP, I'm not so familiar with the mediawiki querying methods though. To make sure it only returns pages that don't exist, it does a left join from pagelinks to pages. I'm trying to put a "page_title is null" in to the where clause so 
[14:10:57] <krispbacon>	 returned, but this makes the query error. removing this condition makes the query work, but not as intended.
[14:11:35] <krispbacon>	 I get the impression I'm doing something wrong with regards to Mediawiki's SQL method, since I've tested the query directly on the MediaWiki db and it works. Could someone help?
[14:12:26] <krispbacon>	 Here's a pastebin of some code that might help: http://pastebin.com/XnrJaY17
[14:31:38] <Vulpix>	 'ORDER BY RAND()', that's scary from a DBA point of view :P
[14:41:13] <Vulpix>	 krispbacon: it throws "Error: 1054 Unknown column 'page_title' in 'where clause' (localhost)"
[14:41:34] <Vulpix>	 you need to specify the page table in the "tables" array
[14:56:53] <krispbacon>	 Vulpix: Thanks for the answer. Never worked with randoms in databases before, especially not MySQL, not too sure what to do but I'm not too bothered about performance and this seems to get the job done simply, so i'll leave it. Oh so the tables array acts like an aliasing array, rather than the from clause? Also, now the special page returns "<randomwanted-nopages>". And how did you get that error code? All that happens when I
[14:56:55] <krispbacon>	 error"
[14:57:48] <Vulpix>	 !debug
[14:57:48] <wm-bot>	 For information on debugging (including viewing errors), see http://www.mediawiki.org/wiki/Manual:How_to_debug . A list of related configuration variables is at https://www.mediawiki.org/wiki/Manual:Configuration_settings#Debug.2Flogging
[15:00:17] <Vulpix>	 you can use eval.php to test things and run $dbr->selectSQLText() to see the generated SQL
[15:08:48] <krispbacon>	 Thanks a lot, I'll have a play around
[17:01:25] <softplay>	 hello
[17:01:40] <softplay>	 i've some problems connecting to the db to install mediawiki locally
[17:02:16] <softplay>	 but i can connect from the command line with the same credentials so...
[17:02:35] <softplay>	 it's probabli a problem of how it's mediawiki running
[17:02:45] <softplay>	 can anyone help me out?
[17:05:46] <[PiR2|Bot]>	 softplay, what error messages do you see?
[17:06:21] <softplay>	 DB connection error: Permission denied (127.0.0.1).
[17:06:22] <softplay>	 Check the host, username and password and try again. 
[17:06:30] <softplay>	 in the installation wizrd
[17:08:06] <[PiR2|Bot]>	 did you check the password?
[17:08:11] <softplay>	 yes
[17:08:18] <softplay>	 username and password are fine
[17:08:24] <softplay>	 i doublechecked it
[17:08:55] <softplay>	 and i checked the variables of the db too
[17:09:04] <softplay>	 i really cannot understand
[17:09:19] <softplay>	 in the db channel people says it's a problem of the cms
[17:09:40] <[PiR2|Bot]>	 did you enter the account name anywhere? Was it root?
[17:09:42] <softplay>	 cause from the command line i can use the user without problems
[17:09:51] <softplay>	 no it wasn't root
[17:10:04] <softplay>	 it was a specific account for the wiki usage
[17:10:13] <softplay>	 i granted privileges 
[17:10:37] <softplay>	 wait let me check only onething i'll be back in one minute
[17:11:27] <softplay>	 GRANT USAGE ON *.* TO 'wikiDev'@'localhost.localdomain' IDENTIFIED BY PASSWORD '*DD98640C6870803AEDBDDA36DCCF8E54BC8B9A6D' |
[17:11:27] <softplay>	 +-
[17:11:34] <softplay>	 is this enough?
[17:11:42] <softplay>	 i mean it's usage
[17:12:23] <[PiR2|Bot]>	 maybe? try it. I'm not an SQL expert though.
[17:13:58] <[PiR2|Bot]>	 I found your stackoverflow question when searching for the error
[17:14:26] <softplay>	 :)
[17:16:09] <[PiR2|Bot]>	 try GRANT ALL instead of USAGE
[17:17:32] <[PiR2|Bot]>	 GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%'  IDENTIFIED BY 'password' WITH GRANT OPTION ;
[17:18:30] <[PiR2|Bot]>	 softplay: ping
[17:18:41] <softplay>	 yes i've just tryied
[17:18:55] <softplay>	 the grant table says tha now it has all privileges
[17:19:07] <softplay>	 let's see if the installation wizard works
[17:20:45] <softplay>	 [PiR2|Bot], it doesn't work :(
[17:20:49] <softplay>	 still
[17:20:56] <softplay>	 same error
[17:22:00] <[PiR2|Bot]>	 try following all these steps as closely as possible? https://www.mediawiki.org/wiki/Manual:Installation/Creating_system_accounts
[17:24:21] <[PiR2|Bot]>	 maybe you should start over with the db/user and follow that exactly. Then it /should/ work (but Murphy's Law, of course)
[17:29:45] <softplay>	 [PiR2|Bot], this page is recursive :O
[17:30:53] <softplay>	 i didn't know i had to restart the mysql server is this really needed?
[17:31:52] <Reedy>	 shouldn't be
[17:32:00] <[PiR2|Bot]>	 I honestly don't know.
[17:32:00] <[PiR2|Bot]>	 It wouldn't hurt though, so I guess it's worth a shot.
[17:40:56] <[PiR2|Bot]>	 Reedy: any suggestions for softplay?
[17:43:07] <softplay>	 line 61: ulimit: cpu time: cannot modify limit: Permission denied
[17:43:17] <softplay>	 wow
[17:53:01] <softplay>	 [PiR2|Human], so i have to run the mediawiki installer from root?
[17:53:38] <softplay>	 i mean if this limit.sh is changing something so crucial
[17:54:03] <[PiR2|Human]>	 Reedy what do you think ^
[17:54:49] <softplay>	 but can i do that? the server would be running on www-data anyway...
[17:54:52] <softplay>	 mumble
[17:55:06] <softplay>	 let me read again the tutorial you gave me
[18:02:45] <softplay>	 i found some bug reports
[18:02:50] <softplay>	 old though
[18:07:36] <[PiR2|Human]>	 link?
[18:08:42] <softplay>	 https://www.mediawiki.org/wiki/Project:Support_desk/Archive_10 Error creating thumbnails/galleries
[18:08:54] <softplay>	 https://bugzilla.redhat.com/show_bug.cgi?id=611308
[18:10:06] <[PiR2|Human]>	 are you using RHEL/Fedora?
[18:12:33] <softplay>	 Fedora yes
[18:12:46] <softplay>	 [PiR2|Human], but a newer version
[18:12:49] <softplay>	 it's 20
[18:12:59] <softplay>	 this bugreports is speaking about the 13
[18:13:08] <softplay>	 so it should be already fixed