[00:09:03] <PiRSquared>	 Hi.
[00:09:33] <PiRSquared>	 I know it's a weird reques, but can someone set up a tool on wmflabs to redirect to an arbitrary wmflabs subdomain?
[01:04:28] <PiRSquared>	 Anyone?
[01:04:55] <PiRSquared>	 Why don't some wmflabs subdomains work with https?
[01:05:16] <PiRSquared>	 Is there a list of those that do?
[01:28:14] <scfc_de>	 PiRSquared: It depends whether there is a webserver listening on the https port.  What domain do you mean?
[01:28:31] <PiRSquared>	 Any. In general.
[01:28:40] <PiRSquared>	 like https://ganglia.wmflabs.org
[01:53:41] <scfc_de>	 Someone set a https server up for that.
[02:24:33] <scfc_de>	 !log tools chmod g-w ~whym/.forward
[02:24:36] <labs-morebots>	 Logged the message, Master
[02:36:06] <scfc_de>	 !log tools Disabled terminatord on tools-login and tools-dev
[02:36:07] <labs-morebots>	 Logged the message, Master
[04:19:45] <grrrit-wm>	 (03PS2) 10Tim Landscheidt: Simple tool to simplify using the backup snapshots [labs/toollabs] - 10https://gerrit.wikimedia.org/r/76313 (owner: 10Platonides)
[04:21:34] <grrrit-wm>	 (03CR) 10Tim Landscheidt: [C: 04-1] "The man page still needs tweaking; lintian isn't satisfied with it:" [labs/toollabs] - 10https://gerrit.wikimedia.org/r/76313 (owner: 10Platonides)
[06:10:01] <wm-bot>	 [bz] (8RESOLVED - created by: 2Daniel Zahn, priority: 4Low - 6enhancement) [Bug 47906] install Extension:Interwiki on wikitech/labs wiki - https://bugzilla.wikimedia.org/show_bug.cgi?id=47906
[06:20:10] <zhuyifei1999>	 !zhuyifei1999 del
[06:20:11] <wm-bot>	 Successfully removed zhuyifei1999
[06:45:18] <wm-bot>	 [bz] (8NEW - created by: 2Daniel Kinzler, priority: 4Unprioritized - 6normal) [Bug 52693] Allow login using mosh as an alternative to ssh to make labs usable at Wikimania - https://bugzilla.wikimedia.org/show_bug.cgi?id=52693
[06:56:01] <legoktm>	 yuvipanda: ^
[06:58:04] <yuvipanda>	 legoktm: hmm?
[06:58:07] <yuvipanda>	 legoktm: it works for me
[06:58:14] <yuvipanda>	 legoktm: I'm logged into tools-login from mosh *right* now
[06:58:16] <legoktm>	 on tools yes
[06:58:20] <legoktm>	 not on the rest of labs
[06:58:22] <legoktm>	 same for me :P
[06:58:23] <yuvipanda>	 aaah
[06:58:24] <yuvipanda>	 :P
[06:58:25] <yuvipanda>	 right
[06:58:44] <yuvipanda>	 legoktm: yeah, mosh is fucking awesome
[06:58:49] <legoktm>	 <3
[07:16:42] <grrrit-wm>	 (03PS1) 10Yuvipanda: Remove random debugging statement [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78492 
[07:16:43] <grrrit-wm>	 (03PS1) 10Yuvipanda: Open a new MySQL connection for each registration action [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78493 
[07:17:54] <yuvipanda>	 &ping
[07:17:54] <wm-bota>	 Pinging all local filesystems, hold on
[07:17:55] <wm-bota>	 Written and deleted 4 bytes on /tmp in 00:00:00.0008600
[07:18:00] <yuvipanda>	 grr
[07:18:42] <yuvipanda>	 still down
[07:19:18] <grrrit-wm>	 (03CR) 10Yuvipanda: [C: 032 V: 032] Remove random debugging statement [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78492 (owner: 10Yuvipanda)
[07:19:18] <wm-bota>	 Written and deleted 4 bytes on /data/project in 00:01:24.1982080
[07:23:05] <grrrit-wm>	 (03CR) 10Yuvipanda: [C: 032 V: 032] Open a new MySQL connection for each registration action [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78493 (owner: 10Yuvipanda)
[07:26:37] <grrrit-wm>	 (03PS1) 10Yuvipanda: Do not keep redis connections open all the time either [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78494 
[07:28:13] <grrrit-wm>	 (03CR) 10Yuvipanda: [C: 032 V: 032] Do not keep redis connections open all the time either [labs/tools/gerrit-to-redis] - 10https://gerrit.wikimedia.org/r/78494 (owner: 10Yuvipanda)
[09:01:06] <yuvipanda>	 andrewbogott: ping? how hard is it to backport nginx-extras from 13.04 to precise?
[09:01:17] <yuvipanda>	 andrewbogott: I was trying to get someone else to do it but looks like that is not happening
[09:01:37] <andrewbogott>	 I can certainly add the package to the precise repo if it works as is...
[09:01:42] <andrewbogott>	 do you know if it needs tweaking?
[09:01:56] <yuvipanda>	 andrewbogott: It just needs to be a newer versions
[09:01:58] <yuvipanda>	 *version
[09:02:05] <yuvipanda>	 no need to rebuild, or change options
[09:02:19] <andrewbogott>	 Ah, what version is up now and what version do you need?
[09:02:47] <yuvipanda>	 andrewbogott: let me check
[09:03:14] <andrewbogott>	 (and, do you happen to know if the existing package is used by any WMF systems currently?)
[09:03:49] <yuvipanda>	 andrewbogott: nginx-extras is not, but it replaces nginx, which is used
[09:03:53] <yuvipanda>	 so we can't add this to official repo
[09:03:59] <andrewbogott>	 Ooh, I see.  Hm.
[09:04:17] <andrewbogott>	 I'm not positive I know how to handle that, let me think
[09:05:07] <andrewbogott>	 Does it install as apt-get nginx?
[09:07:15] <andrewbogott>	 yuvipanda, looks like the nginx-extras package in production is a custom wmf build.  That's concerning...
[09:07:19] <yuvipanda>	 andrewbogott: apt-get install nginx-extras
[09:07:27] <yuvipanda>	 andrewbogott: oh, we have an nginx-extras in production?
[09:07:33] <andrewbogott>	 1.1.19
[09:07:38] <andrewbogott>	 It should just install in labs if you ask for it
[09:07:54] <yuvipanda>	 andrewbogott: I think I need at least 1.2
[09:08:11] <yuvipanda>	 andrewbogott: it does install 1.1.x now, but it is missing a core feature for my work
[09:09:00] <yuvipanda>	 &ping
[09:09:00] <wm-bota>	 Pinging all local filesystems, hold on
[09:09:01] <wm-bota>	 Written and deleted 4 bytes on /tmp in 00:00:00.0003470
[09:09:02] <wm-bota>	 Written and deleted 4 bytes on /data/project in 00:00:00.0064110
[09:11:26] <yuvipanda>	 andrewbogott: to be more specific, I need at least v0.5.0 of nginx-lua, and it is packaged only as -extras
[09:12:03] <andrewbogott>	 yuvipanda, do you know, was 1.1.9 added for you at your request or has it been there for a while?  I don't know who built/installed the package we have now
[09:12:12] <yuvipanda>	 andrewbogott: no, nothing has been done at my request so far
[09:12:18] <andrewbogott>	 hm, ok
[09:12:31] <yuvipanda>	 andrewbogott: Ryan was talking about how this can be done as a local repo of some sort
[09:13:15] <andrewbogott>	 Hm, I don't know what that means :)  Let's ask him in a minute
[09:13:37] <yuvipanda>	 andrewbogott: alright
[09:18:18] <yuvipanda>	 andrewbogott: hmm, I can't really just compile from source, can I? :)
[09:19:07] <andrewbogott>	 Well, getting the package isn't necessarily hard, is it?  The question is the install path.
[09:20:25] <andrewbogott>	 yuvipanda, just like last time I offered to help with this, I may have to run off before the problem is resolved :(
[09:21:34] <yuvipanda>	 andrewbogott: heh
[09:22:08] <andrewbogott>	 I'm going to send an email to the ops list to try to find out why we have a custom version of that package -- hopefully someone will respond.  There's nothing in the logs about it :/
[09:22:29] <andrewbogott>	 apt doesn't install it as a dependency of nginx does it?
[09:22:43] <yuvipanda>	 andrewbogott: shouldn't
[09:22:51] <yuvipanda>	 nginx-extras conflicts nginx, even
[09:27:06] <andrewbogott>	 yuvipanda: ok, emailed… nag me tomorrow if I haven't followed up, ok?
[09:27:14] <yuvipanda>	 andrewbogott: deal!
[09:27:28] <yuvipanda>	 andrewbogott: I'm wondering if I should just do a manual compile now so I can continue developing
[09:27:36] <andrewbogott>	 (Which, of course, you can ask Ryan in the meantime but he and I will be rushing to the same 6:00 appointment)
[09:27:42] <yuvipanda>	 haha
[09:27:43] <yuvipanda>	 ok
[09:27:57] <andrewbogott>	 Are you working in your own project?  You can just download and dpkg-install on an instance if you're blocked.
[09:28:06] <yuvipanda>	 andrewbogott: oooh, yeah, i should be able to do that
[09:28:09] <yuvipanda>	 yeah, I can do that
[09:28:15] <andrewbogott>	 Obviously that's terrible for a running tool, but seems fine for development/tinkering.
[09:28:29] <yuvipanda>	 andrewbogott: yeah, it is in instance project-proxy on project proxy-project
[09:28:30] <yuvipanda>	 :P
[09:28:39] <andrewbogott>	 'k
[09:28:42] <andrewbogott>	 later!
[09:28:43] <yuvipanda>	 so I can just dpkg
[09:33:50] <wm-bot>	 Change on 12mediawiki a page Wikimedia Labs/status was Sharihareswara (WMF), changed by https://www.mediawiki.org/w/index.php?diff=760768 link latest edit summary: $6
[09:34:53] <wm-bot>	 Change on 12mediawiki a page Wikimedia Labs/status was Sharihareswara (WMF), changed by https://www.mediawiki.org/w/index.php?diff=760771 link /* 2013-07-29 */ details edit summary: $6
[13:26:19] <zhuyifei1999>	 Cyberpower678: Why not -offtopic?
[16:41:00] <Hersfold>	 hey all, I'm trying to find some way to connect to the replicated wikipedia databases, but I'm having trouble finding any documentation on the wiki
[17:26:09] <scfc_de>	 !toolshelp | Hersfold
[17:26:28] <scfc_de>	 !ping
[17:26:28] <wm-bot>	 !pong
[17:26:36] <scfc_de>	 !toolsdoc | Hersfold
[17:26:37] <wm-bot>	 Hersfold: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help
[18:14:11] <Hersfold>	 scfc_de: thanks!
[18:14:18] <scfc_de>	 Hersfold: np
[18:14:55] <scfc_de>	 legoktm: BTW, re Pywikipediabot, "git clone ssh://scfc@gerrit.wikimedia.org:29418/pywikibot/core.git" creates a 25 MB repo for me.  Are there other repos needed for Pywikipediabot as well?
[18:20:54] <scfc_de>	 legoktm: Ah, he said pywikibot/*compat*.  Okay, that solves that mystery.
[18:39:08] <valhallasw>	 scfc_de: another reason to switch to core ;-)
[18:39:33] <valhallasw>	 I actually tried hard to get the size of compat down, but there's just too much history
[18:43:05] <scfc_de>	 valhallasw: I don't think in this day and age 200 MByte is something to be concerned about :-).  Also, if you're on the same filesystem, clones can share history.  But as I said, for 200 MByte I wouldn't scratch my head too often :-).
[18:45:20] <valhallasw>	 it's somewhat annoying for my 8GB-disk-VM
[18:45:32] <valhallasw>	 but mediawiki is a worse offender iirc
[19:00:25] <valhallasw>	 scfc_de: it's only 14M after git gc --aggressive   O_o
[19:06:50] <scfc_de>	 valhallasw: :-)
[19:18:28] <valhallasw>	 and now I'm burning some cycles for mediawiki-core. I'm still wondering whether we couldn't just get the small version from gerrit in the first place...
[19:24:23] <scfc_de>	 IIRC ^d had done something like that?  Although, IIRVC, he almost wiped the repo clean in one of his first tries as Gerrit doesn't store all data in the way "git gc" recognizes as "important, do not delete" :-).
[19:28:50] <valhallasw>	 *grin*
[19:33:12] <addshore>	 valhallasw: small version of mediawiki core? :O
[19:34:11] <valhallasw>	 addshore: pywikibot-compat, but mw-core would also be good
[19:34:20] <addshore>	 I agree
[19:34:22] <addshore>	 <:
[19:34:32] <valhallasw>	 but my computer chokes on git gc
[19:34:47] <valhallasw>	 not enough memory -_-'
[19:35:51] <addshore>	 :<
[20:01:11] <valhallasw>	 addshore, scfc_de - mw-core gets down to 188M from 370M
[20:10:00] <scfc_de>	 valhallasw: Impressive.
[20:29:01] <addshore>	 valhallasw: rather nice
[21:34:40] <wolfgang42>	 Is it possible for someone to do a FLUSH TABLES page, redirect, pagelinks; on enwiki_p ? I'm having problems with a query that's been 'copying to tmp tables' for weeks now, it seems to be related to http://bugs.mysql.com/bug.php?id=14070 or so.
[21:36:27] <Betacommand>	 wolfgang42: you should be able to kill it yourself
[21:37:06] <wolfgang42>	 Betacommand: I killed it, that's not the problem. They still won't run.
[21:37:15] <Betacommand>	 use the terminal, connect to the database and run show processlist
[21:37:44] <wolfgang42>	 Betacommand: I did. They were copying to tmp tables for some five weeks.
[21:38:03] <wolfgang42>	 (Seven for an identical query I tried earlier.)
[21:38:38] <wolfgang42>	 The query simply refuses to run, and the bug report states that flushing the tables fixes the problem temporarily, which is good enough for me.
[21:38:45] <wolfgang42>	 I only need it to work once.
[22:07:07] <scfc_de>	 wolfgang42: Only binasher and Coren have access to the replica DB servers.  Probably best to file a bug at https://bugzilla.wikimedia.org/enter_bug.cgi?product=Wikimedia%20Labs&component=tools.
[22:19:54] <wolfgang42>	 scfc_de: Thanks, I'll do that shortly.