[00:23:56] (03PS1) 10Krinkle: Clean up class structure and use PSR-0 autoloader [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323635 [00:25:22] (03CR) 10Krinkle: [C: 032] Clean up class structure and use PSR-0 autoloader [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323635 (owner: 10Krinkle) [00:25:44] (03Merged) 10jenkins-bot: Clean up class structure and use PSR-0 autoloader [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323635 (owner: 10Krinkle) [00:43:15] (03PS1) 10Krinkle: Move per-wiki formatting to a separate class [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323636 [00:43:22] (03CR) 10Krinkle: [C: 032] Move per-wiki formatting to a separate class [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323636 (owner: 10Krinkle) [00:43:42] (03Merged) 10jenkins-bot: Move per-wiki formatting to a separate class [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323636 (owner: 10Krinkle) [00:49:59] PROBLEM - Host tools-secgroup-test-102 is DOWN: CRITICAL - Host Unreachable (10.68.21.170) [01:48:01] (03PS1) 10Krinkle: Move remnant per-wiki formatting in Contribs to PerWikiOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323642 [01:48:13] (03CR) 10Krinkle: [C: 032] Move remnant per-wiki formatting in Contribs to PerWikiOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323642 (owner: 10Krinkle) [01:48:35] (03Merged) 10jenkins-bot: Move remnant per-wiki formatting in Contribs to PerWikiOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323642 (owner: 10Krinkle) [02:04:38] (03PS1) 10Krinkle: Add margin-bottom to footer [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323643 [02:04:46] (03CR) 10Krinkle: [C: 032] Add margin-bottom to footer [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323643 (owner: 10Krinkle) [02:05:22] (03Merged) 10jenkins-bot: Add margin-bottom to footer [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/323643 (owner: 10Krinkle) [03:39:41] RECOVERY - Host secgroup-lag-102 is UP: PING OK - Packet loss = 0%, RTA = 0.77 ms [03:45:38] RECOVERY - Host tools-secgroup-test-103 is UP: PING OK - Packet loss = 0%, RTA = 0.56 ms [05:07:44] PROBLEM - Host tools-secgroup-test-103 is DOWN: CRITICAL - Host Unreachable (10.68.21.22) [05:49:46] PROBLEM - Host secgroup-lag-102 is DOWN: CRITICAL - Host Unreachable (10.68.17.218) [06:28:33] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Ineffyble was created, changed by Ineffyble link https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Ineffyble edit summary: Created page with "{{Tools Access Request |Justification=Contributing to the anon project |Completed=false |User Name=Ineffyble }}" [08:00:11] PROBLEM - Puppet run on tools-webgrid-lighttpd-1207 is CRITICAL: CRITICAL: 44.44% of data above the critical threshold [0.0] [08:08:45] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Ineffyble was modified, changed by Tim Landscheidt link https://wikitech.wikimedia.org/w/index.php?diff=1028382 edit summary: [08:35:14] 06Labs, 10Tool-Labs: Install opencv-data on toollabs - https://phabricator.wikimedia.org/T142321#2824175 (10scfc) p:05Triage>03Normal a:03valhallasw [08:40:10] RECOVERY - Puppet run on tools-webgrid-lighttpd-1207 is OK: OK: Less than 1.00% above the threshold [0.0] [10:06:53] 06Labs: New entries in meta_p.wiki are missing a URL - https://phabricator.wikimedia.org/T142759#2824239 (10jcrespo) > Which API? This is a service that we should provide to all users, not only labs users. Having a wikimedia api, with just one call "which wikis do you host?" integrated on mediawiki will help no... [11:26:38] 06Labs, 10Tool-Labs: Problem with utf-8 on Grid - https://phabricator.wikimedia.org/T143691#2824297 (10scfc) 05Open>03Resolved a:03Vladis13 [11:37:13] 10Tool-Labs-tools-Other: tools.wmflabs.org/wikidata-todo is not working - https://phabricator.wikimedia.org/T143779#2824300 (10scfc) 05Open>03Resolved [12:24:02] PROBLEM - Puppet run on tools-services-02 is CRITICAL: CRITICAL: 40.00% of data above the critical threshold [0.0] [12:39:31] 06Labs, 10Tool-Labs: Test that execution nodes have public IPs assigned - https://phabricator.wikimedia.org/T151675#2824316 (10scfc) [12:49:50] 06Labs, 10Tool-Labs: Restore replica.my.cnf for toolsbeta.admin - https://phabricator.wikimedia.org/T109807#2824331 (10scfc) Where is `create-dbusers` restricted to #Tool-Labs accounts? Why should `/usr/local/sbin/create-dbusers --config /etc/create-dbusers.yaml --once --project toolsbeta` not work? [13:04:02] RECOVERY - Puppet run on tools-services-02 is OK: OK: Less than 1.00% above the threshold [0.0] [13:29:46] 06Labs: Request creation of labs-vpn labs project - https://phabricator.wikimedia.org/T143939#2824380 (10scfc) `plink` is a (rudimentary) VPN, just like `ssh`'s `-W` option in `ProxyCommand`: It needs to run, it will encrypt the session once again and it can end unexpectedly, so these are not arguments against it. [14:20:52] Hi wikimedia-labs! I'm wondering if there is an accepted way to download the output of an sql query run on the database copy in Tool Labs. I can create a database/table with the output, but I'm struggling to figure out how to transfer it to my local computer. The things I've tried after googling around have either failed or resulted in access denied errors. Apologies if this is too basic of a question! Thanks! Nick [14:21:37] sftp? [14:21:48] copy it into your public_html and download over hte web? [14:23:22] hi reedy, thanks for the quick answer! I'm not that knowledgable in this area and a quick google search didn't turn up any obvious results just now. Is there a simple way to copy it into my public_html [14:24:22] hmm, seems there's no public_html on tools [14:24:25] nickbecker: What OS are you using? [14:25:30] I'm on a Mac OS and logged into tools with SSH on my terminal [14:25:57] and have you saved the sql results to a file in your tools home directory? [14:27:08] Unsuccessfully, unfortunately. I've been unable to move the sql results db/table to my home directory on tools [14:28:08] So have you got a file you just want to download then? [14:29:23] I have an sql db and table I created with query results (Example: database name "test", table name "size") which I can access in the interactive mysql. I haven't been able to 1) save it to my home directory; and 2) download it to my local computer [14:30:07] You probably want to just use mysqldump to get it into a file then [14:30:44] Yeah that's what I saw from some googling earlier. I kept running into "access denied" errors though. Is there an accepted way to do that [14:36:08] For example, I ran "mysqldump -p -u nickb500 test > testdb.sql" and then entered my password in the prompt. Which resulted in mysqldump: Got error: 1045: "Access denied for user 'nickb500'@'10...etc' (using password: YES)" when trying to connect [14:40:13] Wrong host, probably [14:41:20] interesting. any quick and dirty advice on which host I might want to try? Appreciate all the help [14:41:46] I wrote a wrapper script for this at some point for production [14:44:42] What command are you running to access your sql db now? [14:47:02] I've connected to tools-login.wmflabs.org, dev.tools.wmflabs.org, and login.tools.wmflabs.org and tried. I created the db by going into interactive with "sql enwiki". after creating the db/table, I can access it with the generic "select * from db.table;" [14:50:56] nickbecker: if you cat replica.my.cnf what username does it say? [14:51:59] interesting. it returns a different username and password than I expected (I expected my wikimedia tools username/password [14:52:10] yeah, it would [14:52:23] Should i be using that one for the mysqldump (probably) [14:52:37] Yeah... Though, if you don't pass -p and -u nickb500... [14:52:43] It should use that file automagically [14:53:40] If i don't pass the commands and just do "mysqldump test > test2.sql" I still get an access denied error "Got error: 1045: "Access denied for user 'nickb500'@'...' (using password: NO)" when trying to connect" [14:53:53] which makes me think its not automatically using the other username/password [14:55:26] Where does 'managednsdomain' comes from? [14:55:31] When I try the username/password from the replica.my.cnf I get a different error: "mysqldump: Got error: 1044: "Access denied for user 'u15960'@'%' to database 'test'" when selecting the database" [14:56:17] nickbecker: yeah, because it's not hitting hte right db [14:56:55] Gotcha. Any advice on how to direct it to the right db? [14:58:22] I kinda can't believe this isn't a solved problem [14:58:47] Makes sense. I've already used a ton of your time. I'll look into on my own time. Thanks a ton for all the help [14:59:23] nickbecker: No, I'm not saying to go away [14:59:39] I'm just saying, I can't believe a wrapper script hasn't been written for mysqldump the same as sql [15:00:21] 06Labs, 10Tool-Labs: Create sqldump script - https://phabricator.wikimedia.org/T151680#2824464 (10Reedy) [15:02:08] 06Labs, 10Tool-Labs: Create sqldump script - https://phabricator.wikimedia.org/T151680#2824478 (10Reedy) [15:02:24] nickbecker: https://phabricator.wikimedia.org/paste/raw/4511/ [15:02:37] If you take the contents of that.. put it into a file called sqldump in your home dir... [15:02:42] chmod +x sqldump [15:10:43] Thanks [15:15:37] Reedy: "I'm getting sqldump.sh: line 101: /dev/null: restricted: cannot redirect output Could not find requested database Make sure to ask for a db in format of _p" [15:16:41] nickbecker: remove the exec from the line near the bottom :P [15:18:34] the entire if/else or just the exec [15:19:33] just the word exec [15:22:16] When I pass the db I made "test" I get a "Could not find requested database" error. If I try passing "enwiki_p" I get ""Access denied for user 'u###'@'%' to database 'enwiki_p'" when using LOCK TABLES" [15:25:35] well, the db isn't just called test... [15:25:45] try using u15960__test [16:52:41] PROBLEM - Free space - all mounts on tools-docker-registry-01 is CRITICAL: CRITICAL: tools.tools-docker-registry-01.diskspace.root.byte_percentfree (<100.00%) [20:46:55] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Armyboy2 was created, changed by Armyboy2 link https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Armyboy2 edit summary: Created page with "{{Tools Access Request |Justification=Development. |Completed=false |User Name=Armyboy2 }}" [23:29:29] 06Labs, 10Tool-Labs, 13Patch-For-Review: Block xtools-articleinfo from scrapers - https://phabricator.wikimedia.org/T122327#2824845 (10scfc) 05Open>03Resolved a:03valhallasw [23:32:52] 06Labs, 10Labs-Kubernetes, 10Tool-Labs: Setup NSS inside containers used in Tool Labs - https://phabricator.wikimedia.org/T134748#2824851 (10scfc) [23:36:57] 06Labs, 10Tool-Labs, 10DBA: Provisioning MySQL replica users fails on tool labs - https://phabricator.wikimedia.org/T151014#2824852 (10scfc) [23:38:13] 06Labs, 10Tool-Labs, 13Patch-For-Review, 15User-bd808: Change Python hashbang to `#! /usr/bin/env python -E -s` for user-facing tools - https://phabricator.wikimedia.org/T147350#2824853 (10scfc) 05Open>03Resolved a:03bd808 [23:39:08] 06Labs, 10Tool-Labs, 13Patch-For-Review, 15User-bd808: Use of uninitialized value in print at /usr/local/sbin/bigbrother line 210 - https://phabricator.wikimedia.org/T144955#2824858 (10scfc) a:03bd808 [23:40:42] 06Labs, 10Labs-Kubernetes, 10Tool-Labs, 07Tracking: Packages to be installed in Tool Labs Kubernetes Images (Tracking) - https://phabricator.wikimedia.org/T140110#2824861 (10scfc) [23:40:45] 06Labs, 10Labs-Kubernetes, 10Tool-Labs, 13Patch-For-Review: Install libenchant1c2a in the toollabs-python2-base docker image - https://phabricator.wikimedia.org/T143449#2824859 (10scfc) 05Open>03Resolved a:03yuvipanda [23:41:45] 06Labs, 10Labs-Kubernetes, 10Tool-Labs: Setup Kubernetes Masters in a HA setup - https://phabricator.wikimedia.org/T142862#2824862 (10scfc) [23:43:39] 06Labs, 10Labs-Kubernetes, 10Tool-Labs: Build replacement for the webservice toolschecker test - https://phabricator.wikimedia.org/T142164#2824863 (10scfc) [23:55:28] 06Labs, 10Labs-Kubernetes, 10Tool-Labs, 13Patch-For-Review, 15User-bd808: Add a easy way to run a ruby webservice on tools - https://phabricator.wikimedia.org/T141388#2824867 (10scfc) p:05Triage>03Normal a:03bd808