[00:00:29] * Hasteur raises his eyebrow at the boucncer idea. [00:02:35] Is that a "hmm interesting" eyebrow or a "wtf punk" eyebrow? [00:03:43] * anomie|away raises an eyebrow in a "I should figure out why I would want a bouncer" sort of way [00:04:16] I'm interested mostly for scrollback. [00:07:05] bd808: Interesting [00:15:45] [bz] (8NEW - created by: 2Chris McMahon, priority: 4Unprioritized - 6major) [Bug 53061] support Flow on beta cluster - https://bugzilla.wikimedia.org/show_bug.cgi?id=53061 [01:14:01] Hi, I'm having problems with a web tool in Tool Labs, written in python, the traceback says that there is no 'oursql' module. Have the oursql module been uninstalled? [01:16:34] seems that python's oursql module isn't reachable in web servers [01:19:33] danilo: No, we set up a new webserver today, and not all packages were automatically installed. Let me see why. [01:22:46] Coren|Dinner: Around? You set -webserver-03 to be role::labs::tools::execnode instead of ::webserver, oversight? Not related to danilo's problem, though. [01:23:44] ... because python-oursql isn't a requirement for execnode either. [01:24:30] !log tools tools-webserver-03: Installed python-oursql [01:24:33] Logged the message, Master [01:24:36] danilo: Try again, please. [01:25:09] already working [01:25:10] Fixed! thank you! [03:05:51] scfc_de: Yeah, it's an oversight. [03:06:11] Actually, that explains why I had set -exec-08 as a webserver. :-) [04:28:28] YES (to bd808's request) [04:32:20] can I like, +1 labs requests? [04:41:21] I just got shell access, uploaded my public keys, but I still can't ssh to bastion.. [04:45:24] oh, it did not like my dsa key. rsa key worked. [06:26:11] hi i want to get a query from database and it shows this error : ERROR 1356 (HY000): View 'fawiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them [06:26:19] what should I do? [07:29:05] {{Guy}}: fixed [07:29:05] http://enwp.org/Template:Guy [09:57:55] YuviPanda: how to configure mediawiki to use redis? [09:58:05] no idea :P [09:58:07] there is no manual on mw.org [09:58:09] lol [09:58:17] having food [09:58:18] you removed memcache and provided no alternative for mediawiki? [09:58:19] brb [10:11:15] petan: back [10:11:43] petan: so, I don't know if mediawiki supports redis for cache. Also I don't think mediawiki should run on tools, at all. So, *shrug* [10:11:52] it /should/ [10:12:03] that's one of purposes of tool project [10:12:30] I don't think so. [10:12:35] if mediawiki doesn't support redis, we should probably reincarnate memcache because mediawiki without cache is almost unusable [10:12:38] to re-emphasize, *I* don't think so [10:12:46] mediawiki on tools will be unusable, and that's okay by me. [10:13:12] it's not okay by me, nor other users who want to use mediawiki there [10:31:35] YuviPanda: btw, it seems G2G is not working for e.g https://github.com/wikimedia/qa-browsertests/pull/9 [10:31:57] valhallasw: yeah, I made some robustness fixes in wikimania but... went on vacation before I could deploy them [10:32:02] should be all up in order by today [10:32:24] ah, cool. [11:44:13] YuviPanda: you mean running mediawiki as a wiki? [11:44:32] I'm running mediawiki on tool-lab as a framework to access data in replicated db [11:44:58] running mediawiki as a wiki, I meant [11:44:59] though I disabled everything related to cache because no one clears cache on db data change [11:45:02] running wikis on toollabs [11:45:04] rather [11:45:39] liangent: hmm, so you're using the DB stuff from mediawiki, etc? that's brilliant :) [11:45:48] liangent: but I was referring to people running a wiki on toollabs. [11:47:27] YuviPanda: not just db stuff actually [11:47:42] WikiPage, Title, etc? [11:47:43] I'm using almost everything except for db writes to data tables [11:47:52] for what, exactly, btw? [11:47:55] still brilliant :P [11:48:18] YuviPanda: you can see a wiki at http://tools.wmflabs.org/liangent-php/index.php/zhwiki?title=Wikipedia:%E9%A6%96%E9%A1%B5 [11:48:37] I know it's extremely slow [11:48:42] do we have APC on? [11:49:11] I don't know. I haven't had a look at it [11:49:13] hmm, still loading [11:51:09] liangent: hmm, what's that wiki for? [11:51:18] is it just loading stuff from the replicated dbs? [11:51:22] YuviPanda: right [11:51:32] you know you can access those from outside toollabs, right? [11:51:36] right [11:51:39] I run maintenance scripts on it [11:51:45] as bots [11:52:01] so your bots are maintenance scripts to this mediawiki instance? [11:52:04] that are run on teh grid? [11:52:12] YuviPanda: yeah [11:52:31] liangent: is that actually easier than... doing API / raw db calls? [11:53:37] I have some other bots in python using api too [11:53:46] api calls are more expensive than db calls [11:54:43] for raw db calls, there're always little things to fix to make it work in the same way as mediawiki [11:55:08] hmm, might not be a bad idea to try to extract just those [11:55:09] out [11:55:11] especially for chinese language conversion stuff I shoud say [11:55:18] liangent: btw, I guess you don't really care about memcached for this? [11:55:24] this isn't really run as a wiki [11:55:40] YuviPanda: I don't care [11:55:41] it just looks like a brilliant hacked up bot framework :) [11:55:57] liangent: okay! :) [11:56:38] I haven't thought of any place on that wiki where memcached can boost the speed [11:58:40] well, if it's you writign code you could just use redis [11:59:18] memcached's upstream seems to be... not doing much. and we can't guarantee key secrecy with memcached without resorting to patching the code ourselves, which is nuh uh. so I'd like to keep memcached as dead as it is now :) [12:30:07] YuviPanda: the problem is, there isn't much I can cache [12:30:37] I can't cache anything that is calculated from database, even if the calculation process is expensive [13:48:24] Bah. Something is effing crawling tools. [13:50:14] Hm. Email scraping bot I'm guessing; doesn't obey robots.txt and has a false UA. [13:51:27] Chinese IP. *plonk* [15:09:30] Coren: Where did you set up the filter? Or is it hot-fixed, i. e. not something permanent in /etc? [15:10:03] hot fix. The list is in ~root/reject.iptables [15:15:06] Impressive, but looking at access.log very reasonable :-). Don't know why someone uses (for example) "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;)" as a User-Agent though; they can't really expect to assume that someone considers that human interaction. [15:17:16] lol [15:19:36] scfc_de: Because the people who write those things tend to... not be meticulous. [15:22:32] Also, those beasts tend to be heavily patched scripts once written by someone competent then plastered with copypasta "upgrades" over the course of years; that UA might even have been sensical when the original version was written. [15:25:25] scfc_de: because that's the default IE6 user agent? Who knows, maybe they are using the VB6 WebBrowser control ;-) [15:27:32] I wasn't even picking so much on the Windows version, but the rapid fire accesses that look very non-human :-). [15:27:40] bawolff isn't online, is he? [15:28:04] scfc_de: I've disabled account creation on his two wikis and left him an talkpage message. [15:28:06] scfc_de: well, sure, but grabbing the nearest browser for the user-agent is something fairly common in web scraper world ;-) [15:28:27] a* [16:42:23] bd808: btw, to be explicit since you missed it last night: [16:42:25] 00:28 < greg-g> YES (to bd808's request) [16:42:30] 00:32 < greg-g> can I like, +1 labs requests? [16:43:34] greg-g: sweet. I started poking at ZNC on a box at home to see if that would work [16:43:46] http://wiki.znc.in/ZNC [16:44:27] cool [16:44:34] I never got past reading the wiki on that one [16:45:23] it looks like it has lots of goodness. http config interface, ldap auth plugin, SASL support for freenode auth... [16:45:44] I haven't quite gotten it to work for me yet but it's close [16:52:41] Just went looking for a puppet znc module on teh interwebz and found one with recent pull requests from YuviPanda. [16:59:26] Ryan_Lane: hi, are you there? [17:03:27] Amir1: yes. what's up? [17:03:41] Ryan_Lane: Just want to tell you login.wikimedia.org is out of reach in Iran but wikitech.wikimedia.org is available [17:03:56] a little weird [17:03:57] * Ryan_Lane nods [17:04:00] not really [17:04:07] login.wikimedia.org is on wikimedia-lb [17:04:30] from what I know Iran has blocks in place mostly due to commons [17:04:43] and commons is on wikimedia-lb [17:04:54] yeah [17:05:09] wikitech.wikimedia.org isn't even on the main cluster ;) [17:05:30] oh i thought it's in the main cluster [17:05:36] nope. purposely not [17:05:39] so ok [17:06:09] Ryan_Lane: we have some issues about certificate in the pywikibot [17:06:20] which certificate? [17:06:35] SSL connection certificate [17:06:41] let me show you [17:06:41] to which site? [17:07:42] for WMF projects [17:07:43] pywikibot is the main framework of running bots [17:09:04] * Amir1 is digging in archive of pywikipedia-l [17:09:25] hm. I can't see why [17:09:31] we're serving the entire chain [17:09:39] minus the CA root [17:09:45] does this occur on labs? [17:09:54] maybe your system is missing the ca certificate trusts? [17:10:38] http://lists.wikimedia.org/pipermail/pywikipedia-l/2013-August/008214.html [17:10:58] I don't have any issues at all in labs [17:11:20] but we're working on compatibility [17:11:23] yeah, this is likely because the system is missing certificate trusts [17:11:44] some systems doesn't have certificate [17:12:06] if it's ubuntu they need to install ca-certificates [17:12:12] Amir1: there's nothing we can do about that [17:12:30] if the system doesn't trust the root it's going to fail [17:12:36] I know it's not your side [17:12:47] I'd add some documentation about how to install the roots [17:12:54] but do you have some suggestion [17:12:55] windows systems have them installed at the system level by defaul [17:12:58] default* [17:13:14] ubuntu server does not, but I'd imagine desktop does [17:13:28] ca-certificates <-- that package adds them [17:13:36] I don't know which package it is on fedora/rhel [17:14:36] is there a way to store the list of signatures in the codes? [17:14:39] Ryan_Lane: kubuntu, at least, has ca-certificate in the virtual kubuntu-desktop package. [17:14:46] (codes = Pywikipedia) [17:14:59] Amir1: that won't help anything [17:15:32] in my opinion a system that doesn't have trusts installed is misconfigured [17:15:43] unless they were purposely removed [17:16:19] I'll be back [17:18:24] Amir1: You wouldn't want to include the root cas in the app anyways; they need to be kept up to date religiously and your system update is the best way to do this. [17:28:44] Coren: as I said before I don't have problem at all [17:28:55] my concern is compatibility [17:29:10] running bots [17:29:33] people are using various system and they want to run bots [17:32:18] people should run bots on labs :) [17:33:54] agree [18:04:44] Coren: https://gerrit.wikimedia.org/r/#/c/73790/ [18:05:01] Coren: https://gerrit.wikimedia.org/r/#/c/77854/ [18:05:11] Ryan_Lane: Is this running on a testbed somewhere I can look at? [18:05:17] nope :) [18:05:21] let me do that [18:05:23] one sec [18:05:23] Booo! [18:05:33] it's on my local vagrant [18:05:58] Dispenser: ping [18:06:12] Coren: you'll need to update links and docs after it's deployed [18:06:38] Ryan_Lane: That's the good kind of "work to do"; the current interface is horrid. [18:06:43] heh [18:06:54] yeah, this one should be better [18:08:14] Coren: With tools-exec-01 running again, could you please jot down what you did at https://bugzilla.wikimedia.org/show_bug.cgi?id=52917 and then close the bug? [18:08:30] scfc_de: I could. :-) [18:08:45] Coren: Do! Do! Do! :-) [18:10:19] [bz] (8RESOLVED - created by: 2Tim Landscheidt, priority: 4Unprioritized - 6major) [Bug 52917] tools-exec-01 is not responding - https://bugzilla.wikimedia.org/show_bug.cgi?id=52917 [18:10:57] Coren: Merci. [18:12:08] yes jarry1250 [18:12:28] Dispenser: Hey :) Are you still the lead maintainer of geohack? [18:12:37] Yes [18:12:55] And there's an unmaintained copy on labs I'd like to see closed [18:13:30] Dispenser: What's the canonical URL? [18:14:35] http://toolserver.org/~geohack/LANGCODE/COORD_PARAMS?pagename=PAGENAME [18:15:36] Dispenser: Cool. Well I daresay my query is the same, but I'll check with the TS version, one sec [18:19:34] http://toolserver.org/~geohack/geohack.php Also works [18:19:54] Coren: question is, which sidebar should this go in? :D [18:20:02] Dispenser: Consider http://ur1.ca/f60tq , a place in the UK. The UK specific files are linked via a Ordnance Survey grid reference (no problem with that) but the grid reference -- TA1169832974 -- is incorrect [18:20:58] So if you use the Streetmap link, for example, it is slightly out. [18:21:16] Dispenser: Not sure I get what you're asking. You mean the geohack on tool labs isn't maintained by you? [18:21:34] Nope and its a shoddy copy as well [18:21:37] Ryan_Lane: Hm. Perhaps a "Tool Labs" section? [18:21:53] [bz] (8NEW - created by: 2Marc A. Pelletier, priority: 4Unprioritized - 6normal) [Bug 53159] Disable recordfail on labs instances - https://bugzilla.wikimedia.org/show_bug.cgi?id=53159 [18:21:56] it should probably be all users [18:22:09] since technically you can create one in any project [18:22:15] Ah, right. [18:22:18] Dispenser: Now, Rhaworth seems to have forked geohack and fixed this problem. But before I ask him, I wondered if you'd heard something about this before [18:22:40] I'll add "Manage Service Groups" to Group:* [18:23:04] hm. that would be anons [18:23:21] Dispenser: Well, you need to move to labs eventually, but I agree that you should really do so with the "geohack" tool name. Have you tried talking to the local peeps working on it? [18:23:44] Dispenser: (fixed this problem in the context of his UK-specific tool) [18:23:49] Its a known issue. The math in the code base is improperly derived, it all by eyeball. [18:23:49] Dispenser: IIRC, Magnus Manske and Kolossos [18:24:10] Expect I'm the only one who touches the codebase and fixes bugs [18:26:06] Coren: https://wikitech-test.wmflabs.org [18:26:29] that wiki is incredibly slow [18:26:38] I wonder if it's on the host that needs to be rebooted [18:27:31] The worst is scaling, it all done pixel based. So Manhattan would fit entirely on a 24" monitor while you'd see only see the southern tip on an iPhone. [18:27:40] nope. on virt6 [18:28:59] Dispenser: Do you need assistance in moving geohack to tool labs? [18:29:25] I have my reasons for not being on Labs [18:29:56] Dispenser: mind letting us know what they are? maybe we can help [18:29:58] Dispenser: From the looks of things it's just using the wrong datum. Indeed, Rhaworth's code is open-source and freely licensed [18:30:23] Dispenser: So it might be possible to borrow his fix (just a datum conversion I think) [18:30:32] jarry1250: Link? I'll look into today [18:31:33] Dispenser: https://toolserver.org/~rhaworth/showphp.php?php=os/mapsources.php -- I haven't looked at geohack's to compare but [18:32:01] ...lines 136 to 157 look like a fix. [18:33:12] I think Geohack applies a OSGB36->grid reference conversion, but the input isn't OSGB36, it's WGS84 [18:33:15] Dispenser: It'd suck if you were stuck having to move in a rush at the last minute; the sooner we get you started the less pressure there will be and the easier it'll be to get things right. [18:34:43] Dispenser: http://ur1.ca/f60y9 is his GB-only fork [18:35:09] Its UK-specific output is correct, whereas canonical geohack's is very slightly out [18:35:24] Coren: can't get in? [18:36:10] Coren: You'll be losing lots of stuff when shutdown the Tooslerver, what another half dozen tool going to do? [18:36:13] Ryan_Lane: Stuck trying to remember the password I used for TEST Coren. :-) [18:36:32] Dispenser: you assume we're the ones turning off toolserver [18:36:40] Dispenser: ... hence trying to help as many as possible to move. [18:36:48] Coren: I can reset it, if you'd like [18:36:54] Ryan_Lane: That'd help. :-) [18:37:46] WMF could've bought the Toolserver outright. But they have a horrible case of Not Invented Here. [18:38:46] to be fair, I built Labs without TS in mind at all [18:38:58] TS features were added to Labs scope [18:39:10] because Labs is built on a more modern architecture [18:40:17] Dispenser: The technical debt was unsurmountable. Besides, it's not like we could have kept using Solaris, or the broken replication system that's in use there -- if you're stuck having to fix 80% of the infrastructure, you're generally better off starting anew. And it's also less disruptive overall; it's much easier to move and adapt a tool while the TS is still limping along than [18:40:28] try to fix a running system and breaking tools. [18:41:04] Coren: oh, we have some more compute nodes to add to the cluster, btw :) [18:41:12] apparently we had a bunch of unused ciscos in pmtpa [18:41:14] Ryan_Lane: Yeay! MOAR!!1! [18:41:15] And change policies in the process [18:41:23] Dispenser: which policies did we change? [18:41:32] excluding the one that allows closed source software [18:41:39] Dispenser: For the most part, policies were /relaxed/ [18:41:50] indeed. and it's easier and faster to get an account [18:42:13] and we have more staff and volunteer admins [18:42:28] No more questionably private data. All open source, all the time. Tools must be broken up. [18:42:31] Dispenser: But yeah, if you're not moving for political reasons then I can't help you. If you change your mind and want technical assistance, just look me up and I'll be glad to help. [18:42:40] "broken up"? [18:43:04] nothing really changed in regards to tools, except that multi-maintainer is required [18:43:17] and multiple tools can run under a single tool account [18:43:19] I have several completely unrelated tools that interact with eachother [18:43:34] And, honestly, "No more questionably private data. All open source, all the time. " == strictly positive. [18:43:49] you can also add tool accounts to other tool's groups [18:44:20] Dispenser: There's nothing that prevents that. There are a number of tools like that right now; like Hersfold's stuff that's split into three components all of which talk to each other and share code. [18:44:27] and unlike TS, you can create tool accounts yourself [18:44:46] and manage membership yourself [18:45:59] Is user_email authenticated exposed? [18:46:29] also tools can talk to each other via redis, which is very wonderful! [18:47:49] Is Google Analytics allowed? [18:47:59] definitely not [18:49:42] Will I have to stop follow stupid EU data protection requirements? [18:49:49] no. US ones [18:50:19] but realistically you won't have access to private info, for the most part [18:50:44] Dispenser: user_email_authenticated is nulled atm (we default to "can be viewed by regular users on wiki") but we can ask legal to okay it if there is a use case for it. [18:52:47] http://en.wikipedia.org/wiki/Special:AbuseLog/2609524 user_email_authenticated is exposed by the edit filter system for anyone caught by it [18:53:35] https://jira.toolserver.org/browse/TS-1108 [18:54:26] Dispenser: It should probably be okay to expose, then. I'll bubble the request up if you want. [18:55:16] Without EU data protection, can we finally have a activity graph revealing sleeping patterns with no opt out? [18:59:21] Dispenser: Well, the tool labs rules do not prohibit it, but you still have to obey the rules of the projects you interact with (obviously). I know that very question has been the subject of at least one or two RfC's recently in re X!'s edit counter. [19:01:41] There over 200 projects. Are you seriously saying Labs should be generally limit to a single major wiki? [19:02:24] Dispenser: in my opinion, no [19:02:36] Dispenser: No. [19:02:47] but that's honestly up to you [19:04:13] (we have no policy for this) [19:06:35] Dispenser: https://www.mediawiki.org/wiki/Wikimedia_Labs/Terms_of_use [19:06:58] oh. good. these are out of draft [19:07:03] Coren: we should move these to wikitech [19:07:10] and have links to them from mediawiki.org [19:08:57] Yes we should. [19:09:03] bah. the new user creation form doesn't link to the damn terms of service [19:09:08] * Coren does that now. [19:09:11] the old one did [19:09:35] 5) Using Wikimedia Labs as a network proxy. Yup, a few more tools lost. [19:09:44] Dispenser: such as? [19:10:03] Checklinks, Wiki dashboard [19:10:11] how are those network proxies? [19:10:24] Dispenser: They are not network proxies in any sense of the term. [19:10:44] a network proxy would be something like tor, or an http forward proxy [19:10:49] Wikidashboard proxies Wikipedia as to inject its scripts [19:11:05] in which way does it proxy it? [19:11:44] Well it looks like they're using their own server now http://wikidashboard.appspot.com/enwiki/wiki/Main_Page [19:12:17] that site is a massive trademark violation anyway [19:12:19] Dispenser: There is no interpretation of that rule that could possibly cover wikidashboard. It does not allow you to connect to some server through it; it fetches something, alters it, and serves it. [19:12:21] Checklinks (my tool) proxies the WayBack Machine (also to inject code) [19:12:51] Dispenser: Your definition of 'proxy' is overly wide. [19:13:43] wikidashboard is fucking evil [19:14:11] why isn't that a gadget on the projects? [19:14:15] That's the kind of Tools I'm interested in building and the community interested in using [19:14:23] that loads from TS or labs? [19:14:38] what that tool is doing is seriously not ok [19:14:43] TS [19:15:54] Actually, wikidashboard would have been against the TS rules. [19:16:01] I have a strong feeling that wikidashboard violates the wikipedia ToU [19:16:27] it absolutely violates the trademark policy [19:16:34] * Coren nods. [19:16:56] They're using their own servers to proxy the content [19:16:58] and there's really no reason it needs to work this way. it can be loaded from a gadget [19:17:14] that's a silly way to do things [19:17:29] and again, it violates a number of policies the way it's being done currently [19:17:47] Dispenser: That's neither here nor there. You're giving as an example of a tool that can't be moved to labs something that would have been forbidden on the TS too. [19:17:48] oh holy fuck: http://wikidashboard.appspot.com/enwiki/w/index.php?title=Special:UserLogin&returnto=South+Park+%28season+13%29 [19:18:16] (!) [19:18:19] It allows logins? [19:18:22] yes [19:18:53] that is indeed a proxy of sorts [19:18:57] and it's 100% evil [19:19:16] This needs to be killed with fire. [19:19:43] yep [19:21:59] Ah, hum, yes so... bad example Dispenser. :-) [19:22:02] hey scfc_de [19:22:12] scfc_de: managed to look at building that package? :) [19:22:12] Checklinks, OTOH, is both okay and very cool. [19:25:46] YuviPanda: Yes and no. How's your ear, BTW? [19:26:12] scfc_de: I couldn't find a clinic yesterday, so just came home and tried to sleep it off. I woke up with it fine, but then it happened again this evening [19:26:20] scfc_de: docs couldn't find anything, but put me on painkillers [19:26:38] scfc_de: I tried sleeping, but couldn't really, so am trying to do something productive before the painkillers wear off [19:28:47] YuviPanda: Sad to hear. Re nginx, I looked into it and juggling with the WMF version & Co. seems complicated. So before I went down that hole, I wanted to ask why you need the lua module? Is the functionality that you need not available with other plugins? Or does nginx in the WMF version not support that plugin structure at all? [19:29:34] YuviPanda: BTW, the ssh problems turned out to be me confusing project-proxy and proxy-project. *Argl*. [19:29:50] scfc_de: the proxy service does *dynamic* routing, which reads from redis on every hit. this 'read from redis' is done by lua, and is very fast - because the lua plugin uses coroutines that co-operate with the rest of nginx eventloop [19:30:11] scfc_de: so that is why I need the lua module, since the code is in lua :P and the version of it that is packaged does not support coroutines, so is useless. [19:30:17] scfc_de: hehe, mission accomplished :P [19:37:13] YuviPanda: Damn, I had hoped for "Well, now that you've said it, there is a much simpler solution." :-). "The code" = /usr/local/nginx/lua/proxy.lua? This looks so tiny :-). [19:37:35] scfc_de: hehe, yeah it is tiny. but the red: stuff are all coroutines [19:37:43] and the code for *that* is in redis.lua, which isn't that tiny :P [19:37:46] Coren: https://toolserver.org/~dispenser/cgi-bin/useractivity.py?page=Wikipedia:WikiProject_Disambiguation [19:38:09] the code for the *actual* coroutines is in the lua module that was compiled in [19:38:42] YuviPanda: "compiled in" = in the WMF package or your compilation? [19:38:46] Dispenser: You clearly like analytics. :-) [19:38:49] scfc_de: mine [19:41:02] scfc_de: mine was pretty much following the 'installation instructions' bit of the HttpLuaModule page on nginxwiki [19:45:31] YuviPanda: And you need the coroutine so that the DB lookups don't block? [19:45:49] scfc_de: so that they work at all, yes :P [19:50:02] Coren: I used the TS to purge ~50,000 image pages since they weren't getting updated in 2 years. Tim was... upset that the imagescaler were effected. What would've happened to my account if it was a Labs account? [19:50:32] I expect Tim would have been just as upset. [19:50:48] YuviPanda: You don't like Perl? I see something about that :-). Okay, back to business. I'll download the current Ubuntu package in a moment, kitchen first. [19:50:59] Related: What would happened to MZMcBride's account when ArbCom want to revoke his [19:51:08] scfc_de: perl has no coroutines :P [19:53:14] Dispenser: The same that happened with the TS, I expect. Last I checked, ArbCom doesn't have jurisdiction outside of enwp (and I'm in a pretty damn good position to know that) :-) [19:53:34] YuviPanda: Are they needed in all cases? NB: I'm okay with Lua, and the work in packaging will not be lost. [19:53:35] good [19:53:51] scfc_de: 'they' -> coroutines? if I am to do IO, then yes. [19:54:20] scfc_de: we already use Lua in 1. Mediawiki, 2. Redis. Adding them here is okay :) [19:55:42] YuviPanda: Yeah, yeah, as I said. But you need coroutines (in a theoretical Perl module for example) only not to block on the DB access? [19:56:01] scfc_de: I'd think so (haven't looked at the perl stuff yet0 [19:56:01] ) [19:56:17] scfc_de: I can't think of anything else I'd need those for. [19:56:46] scfc_de: to be more specific, I am using the nginx redis lua library, which uses a feature called cosockets, which is sockets via coroutines. So I'm not using coroutines directly, but depend on them [20:05:18] YuviPanda: Okay. I'll try packaging on project-proxy-3, let's see what I come up with. I'll ping you when I hit something. [20:05:26] scfc_de: super! :D [20:05:29] Change on 12mediawiki a page Wikimedia Labs/Terms of use was modified, changed by MPelletier (WMF) link https://www.mediawiki.org/w/index.php?diff=768994 edit summary: Moved to its new home. [20:06:55] Ryan_Lane: Moved to [[Wikitech:Labs Terms of use]] [20:06:55] http://enwp.org/Wikitech:Labs_Terms_of_use [20:07:02] No, silly bot. [20:07:20] can we turn off the 'linking'? [20:07:30] better yet, have it link to wikitech? :) [20:08:43] It does eventually end there :-). [20:14:06] @linkie-off [20:14:06] Links will not be automatically translated in this channel now [20:14:57] It is "set" to wikitech... but it doesn't know what wikitech is yet... on the list to fix... [20:16:08] Ryan_Lane: +2'ed [20:16:26] ty, Technical_13 [20:16:35] Coren: tools-proxy? [20:16:38] Yep. :) [20:17:27] YuviPanda: Sorry, been a bit overly busy. Can you put the new role in puppet? Once that's done, adding the instance is simple. [20:17:51] Coren: hmm, I can't yet because the patches aren't merged yet because there is no new enough nginx package :) [20:19:18] Coren: so I was asking for this mainly to play within toollabs itself (with puppetmaster::self) tools-proxying [20:19:28] bd808: heh. I am currently on a ZNC managed by puppet. [20:19:32] bd808: protip: DON'T DO IT! [20:19:57] YuviPanda: Just make a role without the package that you don't have yet. :-) [20:19:59] bd808: just install ZNC and have everyone use the web interface. ZNC's config files sortof kinda only sometimes work, and the reccomended way is to *not* use the config files. [20:20:05] Coren: hehe, okay :) [20:20:21] YuviPanda: good to know, thanks [20:20:36] that module looks like it's for <1.0 as well [20:20:48] bd808: yes, and the docs sortof... suck [20:20:58] bd808: the module works with a new version of ZNC too [20:21:01] just... doesn't use it right [20:21:39] Is ZNC a pretty good bouncer otherwise? I picked semi-randomly [20:21:46] bd808: oh yeah, it is pretty awesome otherwise [20:22:01] bd808: just use the IRC or web interface to do config stuff, and you're good to go [20:22:57] YuviPanda: This is my use-case: https://wikitech.wikimedia.org/wiki/New_Project_Request/WMF_Bouncer [20:23:09] bd808: yeah, saw that. I think it'll work perfectly :) [20:23:32] awesome [20:23:39] bd808: only problem I see is who has access to logs, so sysadmins, etc need to be vetted. [20:24:15] bd808: and logs in general need policy on who can access when and how. other than that... [20:25:52] Dispenser: labs is not the projects. blocks there don't equal blocks here [20:26:28] we may temporarily disable something if it is harming the cluster, but I don't expect that to occur often [20:26:32] Details don't stop the threats [20:26:51] we threatened to kill Mz's account on labs? [20:27:06] no [20:27:17] Dispenser: what do you mean? [20:28:46] Tim threatened to revoke my TS account after that image purge [20:29:02] * Ryan_Lane nods [20:29:13] YuviPanda: good input. I'll look to you for review before we open it up to the group [assuming I get the account :)] [20:29:23] bd808: heh, you should, I'd think. [20:29:28] And ArbCom really wanted to kill MZMcBride's account after creating the watchlist tool [20:29:58] ArbCom has no power here [20:30:50] so good luck to them on that [20:37:47] [bz] (8NEW - created by: 2Andrew "FastLizard4" Adams, priority: 4Unprioritized - 6enhancement) [Bug 53175] SSL certificate for ACC project (acc.wmflabs.org) - https://bugzilla.wikimedia.org/show_bug.cgi?id=53175 [20:45:18] Coren: so, I can't deploy that OpenStackManager change until the core changes I just had merge land in the release branches [20:46:12] Coren: also: https://gerrit.wikimedia.org/r/#/c/68126/ [20:46:18] not sure if you want to review that one or not [20:46:22] andrewbogott_afk: https://gerrit.wikimedia.org/r/#/c/68126/ [20:47:02] we probably want to make sure that all of the 160G and 80G raw base images are gone before we enable that, too [20:47:07] or at least the 160G [20:47:39] hm. maybe it doesn't matter if I get up the two new nodes [20:47:43] * Ryan_Lane looks at that [20:53:40] MariaDB [fawiki_p]> describe page; [20:53:40] ERROR 1356 (HY000): View 'fawiki_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them [20:53:40] really? [20:54:51] * bd808 applauds Ryan_Lane for making it to 2pm without a nap [20:55:01] :D [20:55:12] I did wake up at 5:30 am [20:55:20] I heard that. [20:55:34] hmm, seems enwiki_p has not same problem, so why I can not access page on fawiki_p? [20:55:46] I got up at 7 and am already sleepy [20:55:55] And I'm only 1 hr from home [20:56:07] this is okay on toolserver... [21:01:09] Coren: Is ebraminio's problem the "lost" column cat_hidden? [21:10:24] scfc_de: It may be. [21:10:26] !log stackfarm deleting all instances. It eats up a large amount of resources and isn't being used yet. Additionally, this project is not being used for its stated purpose. [21:10:27] Logged the message, Master [21:10:50] ebraminio: There may have been schema changes in fawiki; lemme check. [21:13:12] Ah, fun. There are, in fact, two fawiki databases. One working, one broken. [21:13:28] ebraminio: Give me a minute to fix the one I point to. [21:15:11] ebraminio: Try again? [21:30:27] Coren|Away: Thank you! :)