[01:36:10] 3Wikimedia Labs / 3(other): (Tracking) Database replication services - 10https://bugzilla.wikimedia.org/48930 (10Tim Landscheidt) [01:36:13] 3Wikimedia Labs / 3Infrastructure: Queries of commonswiki_p.filearchive for fa_sha1 are slow - 10https://bugzilla.wikimedia.org/69088 (10Tim Landscheidt) 3NEW p:3Unprio s:3normal a:3Sean Pringle Cloned from bug #57697, comment #10: | MariaDB [commonswiki_p]> SELECT * FROM image WHERE img_sha1 = 'qte... [02:23:33] OK… is there an accepted method that’s Tool Labs complient for generating a captcha? [02:33:33] Matthew_, the built-in ones that are used on wmf cluster should be fine [02:33:41] or "what is 1+12?" [02:33:47] otherwise you have to do more research :) [02:33:59] jeremyb: I don’t know how to use those sorry, I didn’t even know they existed o.O [02:34:12] Are there docs? [02:35:46] ok, maybe not exactly builtin. but in use by wmf for a long time and part of a published extension [02:36:58] Huh, but I could still use them on tool labs? [02:38:27] well you could generate your own [02:38:30] https://bugzilla.wikimedia.org/5309 [02:40:17] Huh… [02:45:28] https://git.wikimedia.org/commit/mediawiki%2Fextensions%2FConfirmEdit/67d43b5df31100fab2525301d4f7945c83fe1488 [02:45:29] https://git.wikimedia.org/blob/operations%2Fmediawiki-config.git/4b39b8223800f87100d38c3c434380878eb3fc6d/wmf-config%2FCommonSettings.php#L1143 [02:47:02] good luck :) [02:47:06] Matthew_, ^ [02:47:33] Ok, thank you. I will look into it. [02:47:49] hint: you could even improve the docs too if you want! :) [02:48:04] Heh, I shall try :) [02:49:22] 3Wikimedia Labs / 3Infrastructure: WMFLabs: "service diamond help" incorrectly says init.d is invoked and suggests itself as alternative - 10https://bugzilla.wikimedia.org/68442#c1 (10Tim Landscheidt) AFAICS, this only happens for "service diamond help": | scfc@tools-login:~$ service diamond help | Rather t... [02:51:08] 3Wikimedia Labs: Migrate dynamicproxy module to work with the nginx module - 10https://bugzilla.wikimedia.org/67188 (10Tim Landscheidt) 5PATC>3RESO/FIX a:3Yuvi Panda [09:00:54] 3Wikimedia Labs: Beta commons not working - 10https://bugzilla.wikimedia.org/69096 (10Gilles Dubuc) 3NEW p:3Unprio s:3normal a:3None http://commons.wikipedia.beta.wmflabs.org/ turns into an infinite redirect [09:02:22] 3Wikimedia Labs: Beta commons not working - 10https://bugzilla.wikimedia.org/69096#c1 (10Gilles Dubuc) It started happening on August 1st: https://integration.wikimedia.org/ci/job/UploadWizard-api-commons.wikimedia.beta.wmflabs.org/477/consoleFull [09:48:19] Hello [09:50:02] Sorry, to bother you. But I've followed all the instructions to login in tools-login.wmflabs.org listed here: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [09:50:20] However, I get this message: [09:50:22] diego@tochi:~/.ssh$ ssh -A baku@tools-login.wmflabs.org [09:50:22] If you are having access problems, please see: https://wikitech.wikimedia.org/wiki/Access#Accessing_public_and_private_instances [09:50:22] Permission denied (publickey,hostbased). [09:50:43] I've already checked the solutions in the suggested link, but without success. [09:50:57] anyone can give any tip? [09:51:00] thanks [09:57:52] 3Wikimedia Labs / 3deployment-prep (beta): cannot create account on beta wikidata - 10https://bugzilla.wikimedia.org/68031#c4 (10Andre Klapper) 5NEW>3RESO/WOR Currently not reproducible, hence closing as WORKSFORME... [10:09:52] 3Wikimedia Labs / 3deployment-prep (beta): Cannot log in to Beta commons: Infinite redirect - 10https://bugzilla.wikimedia.org/69096#c2 (10Andre Klapper) p:5Unprio>3Highes s:5normal>3major (In reply to Gilles Dubuc from comment #0) > http://commons.wikipedia.beta.wmflabs.org/ turns into an infinite r... [10:33:06] 3Wikimedia Labs / 3tools: Unable to explain queries on replicated databases - 10https://bugzilla.wikimedia.org/48875#c16 (10metatron) Yes. With MariaDB 10 it is now possible to run > SHOW EXPLAIN with same permission as running SHOW PROCESSLIST (ergo everyone can) As posted on labs-l, I've created a tool to... [11:13:52] 3Wikimedia Labs / 3deployment-prep (beta): Cannot log in to Beta commons: Infinite redirect - 10https://bugzilla.wikimedia.org/69096#c3 (10Gilles Dubuc) Indeed the situation has evolved and I see that same problems as you do now. [11:34:24] 3Wikimedia Labs / 3Infrastructure: Move LabsDB aliases and NAT to DNS and LabsDB servers - 10https://bugzilla.wikimedia.org/61897 (10christian) [14:10:25] 3Wikimedia Labs / 3tools: Is it possible to install w3c-markup-validator? - 10https://bugzilla.wikimedia.org/69105 (10Rainer Rillke @commons.wikimedia) 3NEW p:3Unprio s:3normal a:3Marc A. Pelletier I don't need the Apaches but the Parser, Perl and W3C stuff. It would be for a SVG validator running ov... [14:11:07] 3Wikimedia Labs / 3tools: Is it possible to install w3c-markup-validator? - 10https://bugzilla.wikimedia.org/69105#c1 (10Rainer Rillke @commons.wikimedia) http://packages.ubuntu.com/trusty/w3c-markup-validator http://validator.w3.org/docs/install.html [14:25:37] 3Wikimedia Labs / 3deployment-prep (beta): Cannot log in to Beta commons: Infinite redirect - 10https://bugzilla.wikimedia.org/69096#c4 (10Antoine "hashar" Musso) I can see a bunch of 302 redirects on deployment.wikimedia.beta.wmflabs.org with a sequence such as: http://deployment.wikimedia.beta.wmflabs.or... [14:28:41] hello all. Do you know if it's possible to filter out pages which are protected when making an API query? [14:40:51] YuviPanda: It seems our completed vs outstanding request links were broken so they were only showing the default value. I fixed them now but I wonder how long requests have been waiting. [15:35:59] anomie, i need your help. [15:36:05] regarding OAuth [15:36:13] Cyberpower678: What do you need help with? [15:37:21] I can get a request token, and an access token, but identify always returns mwoauth-oauth-exception. What could that mean. [15:37:44] anomie, I used your hello world as an example when constructing mine, so I don't see what's going on. [15:38:22] Cyberpower678: Could mean you're not signing it right somehow. I assume the script is on toollabs? [15:38:57] anomie, not yet. I'm still testing it before deploying. The identify function is the same as the hello world one. [15:40:06] I would like to test it on Wikipedia with my account. Could you spare a few minutes to approve my consumer proposal? [15:40:38] Cyberpower678: Link to the proposal? [15:40:48] anomie, https://en.wikipedia.org/w/index.php?title=Special:OAuthListConsumers/view/a4563d977d889ea88bb07c9ead7e747f&name=&publisher=&stage=0 [15:41:13] I'm running a service on labs and it's gone down 3 times in the last 3 hours- any tips on diagnosing why? [15:41:32] up until now has been very stable :( [15:43:55] Cyberpower678: Why does the tool need to edit, create, and move pages? [15:44:38] mvolz: Labs = your own Labs project or a tool in Tools? [15:44:46] It's a new feature. A report generator that can post to Wikipedia automatically. [15:45:05] Under development. [15:45:29] scfc_de: my own, just wondering if there were any labs features that would help diagnose [15:45:43] my own logging hasn't shown anything in particular [15:46:10] anomie, for example, if someone wants to post edit stats to the RfA talk, they can click a button on the edit counter, and it compiles a wiki markup of the stats and posts it to the specified page. [15:46:16] mvolz: Depends on what you mean by "service" and "gone down" :-). [15:46:18] last time it went down my pipe broke. [15:46:37] Cyberpower678: ok [15:46:47] err, sadly nothing that's puppet managed. yeah I don't think there's anything you can do :) [15:47:05] it's just a bash script. [15:47:22] that runs xpcshell [15:47:31] either one of those dying would kill it. [15:48:00] Ah! Clean conscience :-). As I don't know what xpcshell is, I truly can't help you. [15:48:33] thanks for trying :) [15:48:53] anomie, thanks a lot. :-) [15:49:16] anomie, I'll try identify on Wikipedia to see if I can get something else. [15:55:11] hello all. Do you know if it's possible to filter out pages which are protected when making an API query? [16:00:53] Arnaugir: list=allpages&apprtype=edit [16:03:45] Glaisher|away: what if I want pages that are NOT protected [16:03:53] can this be achieved easily with the query? [16:04:05] also is this possible with recentchanges or categorymembers lists? [16:04:19] can't see it in https://www.mediawiki.org/wiki/API:Categorymembers [16:14:48] !log integration rebased puppet repo on puppetmaster [16:14:50] Logged the message, Master [16:37:55] argh I don't know how to puppet. [16:38:04] are there any docs besides https://wikitech.wikimedia.org/wiki/Puppet_coding#labs ? [16:39:46] mvolz: You probably need to start with https://wikitech.wikimedia.org/wiki/Help:Self-hosted_puppetmaster to get your own Puppet environment going. [16:40:16] thanks! [17:28:09] 3Wikimedia Labs / 3Infrastructure: Database upgrade MariaDB 10: 600 seconds timeout - 10https://bugzilla.wikimedia.org/69110 (10Incola) 3NEW p:3Unprio s:3normal a:3None I'm one of the maintainers of the Lists tool: http://tools.wmflabs.org/lists/ This tool executes a series of queries every day: aft... [18:35:33] YuviPanda: ping [18:47:21] Does anyone know why project request forms have "[[Project Justification::" appended to the justification? [18:47:44] It doesn't show up on the form or in the edit dialogs. [18:47:56] and breaks the outstanding request form [18:48:13] e.g. https://wikitech.wikimedia.org/wiki/New_Project_Request/Performance [18:53:07] 3Wikimedia Labs / 3Infrastructure: Database upgrade MariaDB 10: 600 seconds timeout - 10https://bugzilla.wikimedia.org/69110#c1 (10Andre Klapper) Duplicate of bug 68753? [18:55:24] Negative24, it's because you have link in the justification: ,[[Wikipedia:WP:Twinkle]], look like the template doesn't allow that [18:56:36] Should I change that? [18:56:43] yeps [18:56:52] Will do. Thanks. [18:57:04] Do you think we can allow links? [18:57:16] at some time? [18:57:36] Negative24, I mean remove the link, not change the template, the template do some sort of voodoo ;( [18:58:06] I could take a look at the source but I have quite a few things on my plate as it is. [18:59:00] Negative24: I don't know if you changed the request since, but it shows up under the link at https://wikitech.wikimedia.org/wiki/Help:Contents#Requesting_A_New_Project [18:59:56] I just changed it. It does show up. Isn't that the way it should. I actually fixed those links this mourning. [19:00:34] It hasn't been looked at yet. [19:01:47] scfc_de, expansion of https://wikitech.wikimedia.org/w/index.php?title=Template:New_Project_Request&action=edit break if the justification contains a [[wiki link]], given the code of the template that make sense [19:07:36] phe: I know, but that's just the visual, isn't it? As long as it is listed in the outstanding requests, the main part works. I don't think anyone with the rights to create new projects puts particular emphasis on the layout. [19:11:14] The only thing broken on Semantic search it the column that contains the link. [19:11:19] *is [19:12:41] Did anyone realize that the outstanding links were broken until I fixed them. They were checking for yes and no rather than the Boolean values. [19:14:52] I don't know if anyone uses them. At least for shell and Tools access, I personally have my own script. [19:19:42] How long does it usually take to approve a project? [19:25:01] Negative24: depends; if there is an admin around it's typically pretty quick, otherwise it can take a business day or so (US hours) [19:25:29] Alright. Still got some time. [19:25:43] if it needs quicker attention, poke abogott [19:31:57] Nah. I'm still trying to figure out what's up with tools (why its not liking MW). [20:09:35] scfc_de, valhallasw`cloud, phe: I'm at a dead end with the problem the TL is having with hosting MW. Any ideas that I can checkout? [20:09:57] I mean investigate [20:11:31] Negative24: not immediately, but I also have not really followed the issue (and I'm not too familiar with php issues) [20:15:14] Negative24: Nope. I'm pretty sure that liagent (sp?) has a working MW setup, but he's not online at the moment. [20:17:19] What's his wiki username or toolname? [20:17:35] scfc_de: ^ [20:18:59] anomie, I can't seem to identify. Maybe you can help me fix the code? [20:19:11] I looked and looked, but I can't find the cause. [20:19:19] Cyberpower678: I can try to take a look, if the airport wifi holds up [20:20:10] anomie, give me a sec. [20:21:11] scfc_de: I guess your talking about the tool liangent [20:23:44] scfc_de: Well I can't read his project dir so I can't really learn. I'll send him a message on his talk. [20:54:07] 3Wikimedia Labs / 3Infrastructure: Database upgrade MariaDB 10: 600 seconds timeout - 10https://bugzilla.wikimedia.org/69110#c2 (10Incola) I've found that the problem is related with the primary queries: some of them now are slower then before and exceeds the 600 seconds limit. For example the query [1] run... [20:56:01] warn: Too many attempts to restart job 'lighttpd-sigma'; throttling [20:56:13] How do I make my code not take 4 gigabytes :x [20:57:08] 3Wikimedia Labs / 3Infrastructure: Wikidata dump not available - out of space for dump - 10https://bugzilla.wikimedia.org/66362#c11 (10bgwhite) Sorry, I don't know how to do all the fancy bugzilla text stuff. I too reported the problem and was told my bug was a duplicate of #48894 Dumps have been dead for... [21:26:25] you're all in London [21:26:28] * SigmaWP storms out [21:30:22] SigmaWP: I'm not and I noticed that a few hours ago as well. [21:39:24] 3Wikimedia Labs / 3Infrastructure: Database upgrade MariaDB 10: Discrepancies with logging table on different wikis - 10https://bugzilla.wikimedia.org/69127 (10metatron) 3UNCO p:3Unprio s:3normal a:3None Queries on logging-table perform different on different wikis. Atm there are different key def... [21:42:01] hi? [22:03:21] baku: Check you talk page. [22:03:25] *your [22:07:46] scfc_de: Ping [23:09:47] akoopal: You have a sec? [23:10:50] Negative24: hmmm? [23:11:16] Can you take a look at my request? https://wikitech.wikimedia.org/wiki/New_Project_Request/Performance [23:11:58] what about it? [23:12:33] Can you approve/disapprove. [23:13:32] I am not an admin on labs [23:14:11] Hmm. Someone told me to ping you if I needed a request to be processed. [23:14:54] maybe mistaken with a different andre? [23:15:18] I guess. [23:15:30] Never mind then. [23:20:55] Negative24: they might have mend andre klapper