[00:18:34] Funny potential bug I could file "Labs is slower than Toolserver". Running a speedtest such as https://github.com/sivel/speedtest-cli from login.toolserver.org and tools-login.eqiad.wmflabs respectively shows a pretty dramatic difference [00:18:57] tried about a dozen different times to account for different servers and fluctuations [00:19:38] from eqiad: Download 200-300 Mbit/s, Upload 25-30 Mbit/s [00:20:00] Krinkle: You mean except for the fact that it's entirely specious by definition? They are, literally, on the same network. :-) [00:20:03] What's your target? [00:20:07] from esams (toolserver): Download 800-900 Mbit/s, Upload: 350-400 Mbit/s [00:20:31] Oh, wait, you're doing test from one point inside to one point /outside/? [00:20:42] * Coren chuckles. [00:20:56] Then that's even worse; it's geographically dependent. :-) [00:21:02] for eqiad it picked Internode (San Jose, CA), SoftLayer Technologies, Inc. (San Jose, CA) and Monkey Brains (San Francisco, CA) [00:21:10] [3km] [00:21:28] from esams it picked Solcon Internetdiensten N.V. (Apeldoorn) [34.77 km] and Solcon (Dronten) [4.33 km] [00:21:30] Krinkle: thats about 100 miles different i think [00:21:38] *1000 [00:21:43] for eqiad [00:21:57] No, It's testing towards the closest server offering speedtest [00:22:06] it's not connecting to the same point from esams and eqiad. [00:22:07] eqiad is in VA [00:22:16] Not CA [00:22:18] Krinkle: Then it sucks; it picked west coast servers for a DC that's on the east coast! [00:22:23] I know it's a pointless test because in all likelihood the target is the bottleneck [00:22:54] or at least in grey area where limits are not relevant [00:22:59] Krinkle: like I said the "closest" server was 1000 miles [00:23:34] I'm not sure if we should optimize for bulk downloads from random servers :-). [00:23:38] Coren: what city is the DC in? [00:23:44] Betacommand: Ashburn, VA [00:24:18] Strangely though, it said those are 4-70km away from eqiad [00:24:27] from tools/eqiad: Hosted by SoftLayer Technologies, Inc. (San Jose, CA) [70.93 km]: 12.716 ms [00:24:30] Krinkle: more like 2,392.93 miles [00:24:35] Betacommand: Look at the Google Maps for Washington Dulles Airport and follow the approach path for runway 18C (IIRC) a mile out :-). [00:24:38] and Monkey Brains (San Francisco, CA) [3km] [00:24:47] Something must be throwing it off [00:25:00] Krinkle: depends on how its geolocating [00:25:13] Monkey Brains is, indeed, about a few blocks away from the WMF office. Which is about 4000 km away from the DC. :-) [00:25:30] Coren: 2.3K [00:25:34] wiat [00:25:42] *wait wrong unit [00:25:48] Yeah, I was about to say. :-) [00:26:12] Coren: so sue me, its been a long week [00:26:18] (In fact, IIRC, Monkey brains is the ISP for the office) :-) [00:26:40] * Krinkle runs the speedtest-cli with a forced ---server to see if it makes a diff [00:26:40] http://www.speedtest.net/speedtest-servers.php [00:26:41] Im in the middle of working out a logistics nightmare [00:26:46] Lets pick one in ashburn [00:27:15] lol [00:27:17] Hosted by RPM WEB SERVICES (Ashburn, VA) [3874.60 km]: 16.292 ms [00:27:17] Testing download speed........................................ [00:27:18] Download: 844.61 Mbit/s [00:27:19] Testing upload speed.................................................. [00:27:21] Upload: 314.69 Mbit/s [00:27:34] 4000 km away, ok, it's clearly just the distance comp that's broken [00:29:09] Hey, so... anyone intimately familiar with privacy policy... and I allowed to collect IPs in replacement of usernames? Like, if I tell users that they can provide a username but if they don't then I will use the IP? [00:29:49] Matthew_: Provided to give the required disclaimer before you do so, yes. [00:30:02] Matthew_: (And also that you aren't on tools) [00:30:08] Coren: Is there a specific wording? [00:30:12] NVM, I'm on tools... [00:31:09] Ah. No, on tools you have to not take IPs at all as we allow hotlinking and transclusion from the projects; the tools must respect the intersection of both policies. [00:31:15] Matthew_: what are you trying to do? [00:32:00] Coren: Ah... That kinda makes sense.. [00:32:20] Betacommand: Build a system that allows users to request articles for [[WP:RA]]. [00:32:33] http://tools.wmflabs.org/articlerequest-dev <-- old working copy. [00:32:49] Except I just got migrated, nvm >.> [00:32:53] Matthew_: That sounds like something suited to OAuth [00:33:03] Coren: OAuth? [00:34:15] Trying to find a link. Basically, a way to get a token to edit on an editor's behalf without having to hold their credentials. [00:34:25] That's what the croptool uses, for instance. [00:34:35] Coren: Huh, that's actually cool. I was just gonna have a bot... [00:35:10] [00:35:14] Yeah, that explains. [00:35:26] It's mapping client IP to ISP, and then ISP to address and address to lat/long [00:35:52] Like everyone lives near their ISPs office yeah? What's this 1985? [00:36:13] we're an isp it says [00:36:15] Matthew_: https://www.mediawiki.org/wiki/Extension:OAuth [00:37:07] Krinkle: Heh. I'm guessing they get confused because we're not a leaf node but actually peering with ISPs. [00:37:16] I think anomie has developed an example app for OAuth, and Magnus has gone through the school of hard knocks for a few of his tools. [00:37:35] Coren: That's actually really cool o.O Can it handle IPs? [00:37:47] Matthew_: There's a flask example there: https://wikitech.wikimedia.org/wiki/Setting_up_Flask_cgi_app_as_a_tool/OAuth [00:38:36] Matthew_: I'm pretty sure it can't; IPs don't have credentials to edit on behalf of. But in a case like this, your tool could edit as itself rather than present a token. [00:39:01] Matthew_: I don't expect that'd be an issue if you rate-limit anonymous requests. [00:40:01] Coren: OK, makes sense. The reason I ask is I wanted to have every request tagged with some sort of username... [00:40:11] Hmmmm... that's really cool actually o.O [00:41:19] Coren: About tool labs mail, is that supposed to be working? [00:41:24] I tried 4 different addresses, but all bounced [00:41:56] tools.delinker@tools.wmflabs.org, delinker@tools.wmflabs.org, delinker.*@tools.wmflabs.org, delinker.foo@tools.wmflabs.org [00:42:14] [(10) mail.tools.wmflabs.org. [208.80.155.162]:25: Connection timed out] [00:42:14] [(10) mail.tools.wmflabs.org. [208.80.155.162]:25: Connection timed out] [00:42:23] Krinkle: Actually, I should be okay to turn that on now. [00:42:46] https://support.google.com/mail/answer/7720 (linked in the delivery notification) [00:42:48] Krinkle: The correct emails would be 'tools.delinker' or 'delinker.anything'. [00:44:43] * Coren turns it on. [00:44:45] Coren: I'll look into this more, thank you very much. I may not be able to do it in v.1.0 but I will be migrating to it probably in the future. [00:44:47] Noice :) [01:17:37] Coren: around? I'm having trouble finding my tool's database on tools-db... [01:29:37] I'll just shoot you an email [01:56:40] what are the troubleshooting steps if i get permission denied when trying to ssh to a labs instance where i am a projectadmin? [01:57:07] i verified that the SSH key i use for bastion gets forwarded to the instance [02:03:58] tgr: When was the instance created? Where is it located (eqiad or pmtpa)? Have you already looked at Help:Access? [02:05:38] uhh, guilty :) [02:05:46] but i did now and it doesn't help [02:06:27] scfc_de: equiad, created about a week ago i think [02:09:53] tgr: Hmmm. Well, in that case /my/ troubleshooting would be to call for andrewbogott or Coren :-). [02:11:38] BTW, you get "permission denied(public key)"? [02:12:52] Are we talking about uploadwizard-osm-equiad.eqiad.wmflabs? That times out on ssh; have you looked at the security groups for your project to allow ssh from 10.0.0.0/8? [02:14:37] scfc_de: no, multimedia-alpha.equiad.wmflabs [02:14:59] apparently my ssh key is not present there [02:15:25] i am not very familiar with labs, but if i am a project member, that should be automatic, right? [02:17:38] *eqiad* (no "u"). multimedia-alpha.eqiad.wmflabs:ssh times out for me from tools-login as well. Which error message do you get? [02:18:26] tgr, the firewall for that project is blocking ssh. Hang on, I'll fix it. [02:19:19] tgr, better now? [02:21:18] andrewbogott: thanks, works now [02:21:24] great [02:21:45] i still dont understand how i ended up with a permission denied error though [02:21:56] shouldnt it just have timed out? [02:22:02] that's what it did for me. [02:22:28] no, i definitely got a permission error [02:22:53] i could evem see with ssh -v that the various keys got offered and refused [02:23:00] weird [02:23:06] anyway, works now, thanks [02:23:20] There's an instance with that name in pmtpa as well, so maybe the wrong one? [02:24:41] scfc_de: probably that's it [02:28:49] (03PS7) 10Tim Landscheidt: Simple tool to simplify using the backup snapshots [labs/toollabs] - 10https://gerrit.wikimedia.org/r/76313 (owner: 10Platonides) [03:14:51] Coren: Still failing [03:14:54] Google tried to deliver your message, but it was rejected by the server for the recipient domain tools.wmflabs.org by mail.tools.wmflabs.org. [208.80.155.162]. [03:14:54] The error that the other server returned was: [03:14:54] 550 Unrouteable address [03:14:57] different error this time ^ [03:15:00] From 20 minutes ago [03:16:19] Yeah, wasn't quite tested yet; moar config needed. I'll probably get the time to work on that tomorrow. [03:51:31] (03PS4) 10Adamw: Reformat using a slightly more yaml-y style [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/112311 [03:51:34] (03CR) 10jenkins-bot: [V: 04-1] Reformat using a slightly more yaml-y style [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/112311 (owner: 10Adamw) [03:57:49] (03PS5) 10Adamw: Reformat using a slightly more yaml-y style [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/112311 [04:03:57] (03CR) 10Adamw: "Which style u like is just a matter of preference--no worries if you want to leave the syntax as it was!" [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/112311 (owner: 10Adamw) [04:09:34] (03PS1) 10Adamw: Make the "blacklist" variable an array [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/119924 [04:09:57] Please help! ! When I run a MySQL query on tools-login.wmflabs.org, I get ERROR 1045 (28000): Access denied for user 'torin8'@'10.68.16.7' (using password: NO) [04:10:23] what do I need to do to solve this? [05:52:38] torin8: did you fix your problem? [06:03:14] nope [06:03:54] hedonil: still have the same issues [06:06:09] torin8: your denied for user 'torin8'@'10.68.16.7 says you are not using your MySQL credentials, but your console credentails [06:06:21] torin8: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Shared_Resources/MySQL_queries#Accessing_the_databases [06:09:28] hedonil: which password do I need when connecting to MySQL? [06:09:43] when I try my password, i get ERROR 1045 (28000): Access denied for user 'torin8'@'10.68.16.7' (using password: YES) [06:10:23] hedonil: do I need to register separately for sql access? [06:10:43] torin8: the MySQL username and password are stored in a file called replica.my.cnf. [06:11:15] torin8: it's registered automatically. this file should be there [06:15:06] torin8: your MySQL username should be like: uXXXXX. it's different from your console username torin8. [06:15:48] hedonil: replica.my.cnf is stored in my tool folder, right? when I try to open that file, it says permission denied [06:16:30] torin8: try this command first: become [06:16:49] torin8: what's your tool? [06:17:00] hedonil: icelab [06:17:50] torin8: ok. first type: become icelab [06:18:38] torin8: then type: sql enwiki_p [07:13:50] hedonil: hi again, sorry, I lost internet connection [07:14:17] torin8: I sent you an email to labs-l [07:21:23] hedonil: i don't think I ran chmod on my directory. Only on my script file because it wouldn't run otherwise [07:22:31] hedonil: when I became my tool, i was able to retreive my password and login for sql. They are assignd once and don't change when I reconnect? [07:23:15] torin8: yep. they will stay untouched. [07:24:20] hedonil: great! how do i use them? [07:24:59] torin8: most simple from console (example): sql enwiki_p [07:25:52] torin8: with this command, the MySQL creds are invoked automatiaclly from replica.my.cnf [07:26:30] torin8: or more in detail https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Shared_Resources/MySQL_queries [07:27:28] hedonil: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0 happened when i entered my sql password [07:28:04] torin8: this can happen sometimes (it shouldn't). try again [07:43:40] hedonil: all servers time out when i try to connect. I can't access anything at the moment, so I will try later. So, when I enter password, i should be able to run Bash scripts, or do I query directly? [07:44:55] torin8: Hmm. right now there seems to be trouble at tools-login. (slow as heck) [07:45:54] torin8: you may want to log out and login to the alternative host: tools-dev.wmflabs.org [07:46:35] torin8: it's almost the same. maybe it works from there. [07:48:34] hedonil: woop, thanks! tools-dev loads fine! I tried running take /home/torin8/ and it said 'you must own the directory' [07:49:26] hedonil: chmod also didn't work. It says operation not permitted [07:49:48] torin8: ah, ok. then you'll need more power to fix this ;) try to contact scfc_de or Coren later. [07:50:39] hedonil: ahh i see. I'll wait till the guys are online =) [07:53:41] hedonil: when i become my tool and run sql enwiki_p, it opens MarinaDB. So MySQL is no more? Is the database schema still the same?? [07:55:09] torin8: So you are in now! congrats. what database are you trying to access? [07:56:30] torin8: to simply browse the database servers and take a look at current schemas you can use this https://tools.wmflabs.org/tools-info/?dblist=s1.labsdb [07:56:44] hedonil: thank you! I need enwiki, precisely, the languaglinks table [07:57:56] torin8: Yeah. then everything should be fine (but the owner issue has to be fixed though) ;) [07:59:00] hedonil: I don't really know how to use MariaDB. Does it understands scripts? [07:59:58] torin8: whats your script? can you paste it http://tools.wmflabs.org/paste/ [08:05:12] hedonil: https://tools.wmflabs.org/paste/view/2c13b7c3 [08:07:10] torin8: looks perfectly fine ; [08:07:47] hedonil: i think the server should be s1.labsdb instead of sql-s1? [08:08:07] torin8: yep . you're right. [08:09:10] torin8: so almost perfectly fine ;) [08:09:10] hedonil: it took me forever to figure it out =) How do I run it now? from under Marina DB? or as my tool? [08:10:56] torin8: it's a bash script. so run it from console. first chmod +x