[00:29:25] 06Labs, 07Shinken: shinken has many warnings (?) about "UNKNOWN: execution of the check script exited with exception list index out of range" - https://phabricator.wikimedia.org/T95161#1181902 (10Krenair) Currently only appears for these ones: http://shinken.wmflabs.org/service/analytics303/Puppet%20run http:/... [00:38:42] 06Labs, 07Shinken: shinken has many warnings (?) about "UNKNOWN: execution of the check script exited with exception list index out of range" - https://phabricator.wikimedia.org/T95161#2252919 (10Krenair) The first one doesn't exist, the second one doesn't either - but points to an IP is registered to a real i... [00:46:08] 06Labs, 10Labs-Infrastructure, 07LDAP: LDAP contains two incorrect host entries with aRecord=10.68.17.118 - https://phabricator.wikimedia.org/T134025#2252921 (10Krenair) [00:46:11] 06Labs, 10Labs-Infrastructure, 07Upstream: labs instances ntpd fails to create socket / init interface - https://phabricator.wikimedia.org/T62166#2252934 (10scfc) 05Open>03Resolved a:03scfc Revisiting this because https://bugs.launchpad.net/ubuntu/+source/ntp/+bug/569919 got closed, the issue is effect... [00:49:57] 06Labs, 10Labs-Infrastructure, 07LDAP: LDAP contains two extra incorrect host entries with aRecord=10.68.17.118 and one with aRecord=10.68.22.5 - https://phabricator.wikimedia.org/T134025#2252938 (10Krenair) [00:50:32] 06Labs, 07Shinken: shinken has many warnings (?) about "UNKNOWN: execution of the check script exited with exception list index out of range" - https://phabricator.wikimedia.org/T95161#2252942 (10Krenair) First one is explained in a very similar way actually - see the task I just created. [00:52:37] 06Labs, 07Shinken: Shinken timeouts - https://phabricator.wikimedia.org/T134024#2252945 (10Krenair) [01:05:06] 06Labs, 07Shinken: Describe on http://shinken.wmflabs.org/ what it is about and what credentials are honoured - https://phabricator.wikimedia.org/T88142#2252951 (10Krenair) [01:05:26] 10Labs-Other-Projects: Mount dumps to the mlp instance of the math project - https://phabricator.wikimedia.org/T134026#2252952 (10Physikerwelt) [01:08:28] 10Tool-Labs-tools-Other, 07I18n: [[Wikimedia:Pageviews-hosted/ksh]] i18n issue. - https://phabricator.wikimedia.org/T130006#2252968 (10Liuxinyu970226) [01:10:54] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2180822 (10Krenair) Is it possible to downsize an instance or would we have to make a new one and migrate? [01:14:42] 10Tool-Labs-tools-Other, 07I18n: Message [[Wikimedia:Pageviews-select2-max-items/en]] needs PLURAL support. - https://phabricator.wikimedia.org/T130005#2252976 (10Liuxinyu970226) [01:15:09] 10Tool-Labs-tools-Other, 07I18n: PLURAL needed on $1 - https://phabricator.wikimedia.org/T129633#2252978 (10Liuxinyu970226) [01:16:00] 10Tool-Labs-tools-Other, 07I18n: [[Wikimedia:Pageviews-select2-max-chars/en]] needs PLURAL support - https://phabricator.wikimedia.org/T129442#2252980 (10Liuxinyu970226) [01:18:07] 06Labs, 07Shinken: Describe on http://shinken.wmflabs.org/ what it is about and what credentials are honoured - https://phabricator.wikimedia.org/T88142#2252982 (10scfc) 05Resolved>03Open a) Thanks for tracking this down! b) Puppetizing //is// the scope of this ticket; otherwise the issue will reappear wh... [01:20:40] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2252984 (10scfc) Maybe it is technically possible to downsize, but I meant to set up a new instance, test, migrate IP/proxy and delete the old ones. [01:22:52] 06Labs, 10Labs-Infrastructure, 13Patch-For-Review: Prevent breaking puppet on the dnsrecursor host when novaadmin isn't in a project - https://phabricator.wikimedia.org/T133946#2252988 (10Krenair) a:03Krenair [01:24:55] 06Labs, 07Shinken: shinken has many warnings (?) about "UNKNOWN: execution of the check script exited with exception list index out of range" - https://phabricator.wikimedia.org/T95161#2253002 (10scfc) Cf. also T99072 (somewhat of a duplicate) and T127957 (maybe cause). [01:30:27] 06Labs, 07Shinken: Describe on http://shinken.wmflabs.org/ what it is about and what credentials are honoured - https://phabricator.wikimedia.org/T88142#1004837 (10Krenair) a:05Krenair>03None [01:32:19] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2253040 (10Krenair) @yuvipanda: are you okay with us doing that? [01:33:50] 06Labs, 10Labs-Infrastructure: I/O on labmon1001 is very slow - https://phabricator.wikimedia.org/T127957#2253045 (10Krenair) what is the process to get this machine an ssd? [01:39:01] 06Labs, 10Tool-Labs, 07Shinken: Shinken: make sure 'Free space - all mounts' can handle no-longer-existing mounts - https://phabricator.wikimedia.org/T99077#2253062 (10Krenair) Sounds like what I fixed in https://gerrit.wikimedia.org/r/#/c/283779/2 [01:45:42] TParis, hi [01:46:34] 06Labs, 10Tool-Labs: Fix 'unknown's in shinken - https://phabricator.wikimedia.org/T99072#1284673 (10Krenair) http://shinken.wmflabs.org/problems?search=tools shows not much left - just puppet on tools-bastion-01 (which is in state SHUTOFF) and tools-pastion-01 (wat?), with some generic failures that appear to... [01:50:03] 06Labs, 10Labs-Infrastructure, 06Operations: Some labs instances IP have multiple PTR entries in DNS - https://phabricator.wikimedia.org/T115194#2253068 (10Krenair) While looking at {T99072} I found another: ```krenair@tools-bastion-03:~$ host 10.68.16.97 97.16.68.10.in-addr.arpa domain name pointer ci-jessi... [01:52:18] TParis, you wanted to talk? [01:54:19] is laner a WMF Labs Staff member? cause right now they have access to a project with privacy considerations [01:58:07] 06Labs, 10Labs-Infrastructure, 07LDAP: LDAP contains two extra incorrect host entries with aRecord=10.68.17.118 and one with aRecord=10.68.22.5 - https://phabricator.wikimedia.org/T134025#2252921 (10Krenair) There may be a connection with {T115194} here: ```krenair@bastion-01:~$ host 10.68.16.97 97.16.68.10.... [01:59:02] AmandaNP, laner is a former WMF contractor, current root [01:59:20] k, good. as long as they are under an NDA [02:00:00] they are [02:00:07] which project is it that's sensitive? [02:03:28] 14Hi. Is there anyone willing to help me figure out why a script isn't finding the shared pywikibot when submitted with jstart but running python .py on the command line works?01 [02:13:21] Krenair: UTRS [02:13:47] aka CU data exists. [02:27:58] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2253096 (10yuvipanda) Sure if you feel the need to. Given our experience in production where checks max up on CPU / RAM in the icinga host to the point where it OOM'd sometime, I created this to be xlarge. But if t... [02:28:43] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2253097 (10yuvipanda) ah, but I also just realized.... If resources are actually unused they remain available to other instances. So from my pov, this doesn't really give us much useful and is a waste of your time... [02:30:04] 06Labs, 07Shinken: Downsize instances to actual need - https://phabricator.wikimedia.org/T131859#2253099 (10yuvipanda) p:05Triage>03Lowest [03:36:42] TParis, http://tools.wmflabs.org/peachy-docs/master/classes/User.html#method_exists [03:50:56] RECOVERY - Puppet run on tools-webgrid-generic-1401 is OK: OK: Less than 1.00% above the threshold [0.0] [04:12:28] !log wikilabels deployed 0679024 to the staging [04:12:34] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikilabels/SAL, Master [04:20:40] !log wikilabels deploying 0679024 to the deploy branch [04:20:45] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikilabels/SAL, Master [08:34:52] PROBLEM - Host tools-bastion-01 is DOWN: CRITICAL - Host Unreachable (10.68.17.228) [10:33:50] Hello [10:35:05] I am currently working in a project, and I need to get some meta information about wikipedia articles, like contributors, views of a page, contribution per contributor, etc. [10:35:39] I saw some very good tools, like Xtools article infos [10:36:03] Do you know how these tools work ? [10:36:10] I mean, do they have a direct access to DB ? [10:36:19] Can we have a direct access to DB ? [10:36:49] Hello ? Someone there ? :) [10:37:25] DirectAccessPlz, they have access to a replica database. [10:37:45] That would work for me [10:38:00] Do you know the procedure ? [10:38:10] Are you working on labs? Or tool labs, or what? [10:38:11] To get to the replica [10:38:15] DirectAccessPlz: quarry.wmflabs.org / https://wikitech.wikimedia.org/wiki/Help:Tool_Labs [10:38:56] DirectAccessPlz, more specifically, https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Connecting_to_the_database_replicas [10:39:48] That is awesome ! [10:40:01] Thank you very much ! [10:42:11] (I am trying to get the maximum information about a given article to be able to think of a formula to evaluate the impact of a user (in %) on this page. [10:42:48] (new here) [10:42:54] thanks a lot for your help ! [14:15:43] Hello everyone. I am trying to connect to DBs in Labs/Database, but I have no idea how to create a user profile. When I try to connect by SSH, I need to give a password for example to 4711:enwiki.labsdb:3306. [14:15:47] Need help, thank you :) [14:17:00] To give more info, I am talking about this : [14:17:00] https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Connecting_to_the_database_replicas [14:17:36] you'll find your mysql credentials in ~/replica.my.cnf [14:18:11] On my laptop ? [14:18:20] no on the tools server you're SSHing to [14:18:24] (sorry, I am really a noob here) [14:19:02] What I need to do is get information about pages, let's say Cat in enwiki [14:19:24] Like who are the contributors, how much characters have they written etc. [14:19:35] So my need is to connect to a replica DB [14:20:30] yes [14:20:32] you'll find your mysql credentials in ~/replica.my.cnf [14:22:12] In the ssh server ? In this case I need the password for the server when I try to SSH [14:23:25] CreditsForDBConn: https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Getting_started [14:24:27] or, as I mentioned earlier today, use quarry.wmflabs.org [14:26:21] I need to do queries via nodeJs or python, I'm going to check, thanks [14:26:42] right, then you'll need tool labs access. [14:27:25] I thought you already had tools access and just needed to login to mysql [14:28:20] oh there's a shortcut to access replicas [14:28:32] like "sql enwiki" [14:29:50] 18<CreditsForDBConn> I need to do queries via nodeJs or python [14:39:59] I created an account on wikitech, gave my public ssh key. Do you know how much time it needs to be confirmed by an admin ? [14:47:58] CreditsForDBConn: you need to fill in the tools access request form [14:50:44] done [14:52:27] !log ores added precaching role to ores-web-03 [14:52:32] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [14:52:52] Amir1, ready for me to shut down the screen'd precacher? [14:53:02] not yet [14:53:07] let me run some tests [14:53:23] specially I need to run puppet agent rdirectly [14:53:28] *directly [14:53:41] Yeah. Let me know when you are ready to do that and I'll get my screen up. [14:54:03] sure [14:54:42] !log ores running puppet agent manually in ores-web-03 [14:54:46] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [14:57:04] Shouldn't this: https://wikitech.wikimedia.org/wiki/Template:Portal_list_item_noimage be semi-protected, given it's on the main page? [14:57:29] Do we protect things on wikitech? [14:57:48] Yes. [14:57:58] The main page is semi-protected. [14:58:29] The only other template on the main page is this: https://wikitech.wikimedia.org/wiki/Template:Portal_list_item and it's semi-protected too. [14:58:52] Amir1, the precacher was down anyway :S [14:59:04] Oh! I forgot about a hack that I have been using the keep the precacher online. [14:59:21] oh, so the deamon works correctly [14:59:26] https://github.com/wiki-ai/ores/blob/master/ores/utilities/precached.py#L126 [14:59:50] That line sets a max time to wait. [14:59:52] because I was checking logs and there lots of precaching in uwsgi [15:00:12] We should be able to fair for forever, but that breaks this old version of socketIO that we need to use. [15:00:16] but I wasn't sure if it was for my precaching or the screen [15:00:28] Amir1, just kicked the screen precacher and it is still shutting down [15:00:51] ladsgroup@ores-web-03:~$ /srv/ores/venv/bin/python /srv/ores/config/submodules/ores/utility precached stream.wikimedia.org https://ores.wmflabs.org --config /srv/ores/config/config [15:00:52] 2016-04-30 14:58:24,100 INFO:ores.utilities.precached -- Connecting socketIO client to stream.wikimedia.org. [15:01:00] it hangs at this shape [15:01:08] is it expected halfak [15:01:10] Amir1, that looks right to me. [15:01:18] If you set --verbose, you'll see timing logs [15:02:13] hm [15:02:15] nice [15:02:41] yup it's precaching [15:02:42] :) [15:02:47] the daemon is up [15:03:04] halfak: do you want to add the verbose to the daemon as well? [15:03:16] Na. [15:03:45] kk [15:04:10] Goddamn I love our dashboard [15:04:25] It's really nice to see everything like this at once. [15:04:39] Oh yeah... we have a periodic scoring error problem. [15:04:45] yeah [15:04:47] It would be nice to figure out what that error is all about. [15:05:09] I'm skeptical of the timeouts graph too. [15:05:16] That's really a 503 error graph [15:05:20] "Server overloaded" [15:05:28] we should also plot feature extraction timeout errors. [15:20:50] RECOVERY - Puppet run on tools-k8s-etcd-03 is OK: OK: Less than 1.00% above the threshold [0.0] [15:40:24] still no admin to validate my access to lab tools DB ? :( [16:02:46] YuviPanda might be around [16:05:16] CreditsForDBConn: what do you need to validate [16:08:01] I filled in a form to be able to make requests to replicas of DB via sql [16:08:53] Si basically, as I am working on a project to evaluate the impact of a contributor on a wikipedia page, I would like to make some requests to gather information from DB [16:08:55] so* [16:09:18] CreditsForDBConn: let me check but I am on 20kb/s internet now [16:09:35] it would help me if you could link to request [16:09:51] User : Madjaoue [16:09:56] searching wikitech will probably take lot of time with this speed [16:09:59] Shell id : ium [16:10:47] ok [16:11:12] petan, this one: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Madjaoue [16:11:40] ok thanks wikitech main page was still loading :D [16:12:14] Yes, thanks [16:12:21] Special:RecentChanges is rather helpful [16:12:29] what start gam_server on the webgrid and why this thing use permanently 10-15% of cpu time ? [16:12:47] A bot usually posts the access requests in here. [16:13:10] It didn't with yours CreditsForDBConn. [16:13:56] Do I have to make another request ? [16:14:07] it's still loadig but it's submitting [16:14:51] maybe something broke with rcfeed [16:15:31] I have just received a mail of confirmation [16:15:36] Thanks Petan [16:15:38] ok it's done [16:23:19] (03PS1) 10Youni Verciti: Rev 0.2 Gerrit ready for review on branch dev [labs/tools/fr-wikiversity-ns] - 10https://gerrit.wikimedia.org/r/286279 [17:02:23] Do you know where I can find my replica.my.cnf file ? I don't find it in my local folder in ssh server [17:23:15] Could someone help me with the creation of the "replica.my.cnf" file in my local folder on the SSH server please ? [17:24:16] 06Labs, 10Tool-Labs: Creation of replica.my.cnf - https://phabricator.wikimedia.org/T134066#2253845 (10Dereckson) [17:28:05] 06Labs, 10Tool-Labs: Creation of replica.my.cnf - https://phabricator.wikimedia.org/T134066#2253830 (10Dereckson) [17:29:34] 06Labs, 10Tool-Labs: Creation of replica.my.cnf - https://phabricator.wikimedia.org/T134066#2253830 (10Krenair) This happens automatically... [17:29:42] 06Labs, 10Tool-Labs: Creation of replica.my.cnf - https://phabricator.wikimedia.org/T134066#2253851 (10Dereckson) @Madjaoue Okay, thanks for the precision. That needs to be done by a Tools Labs admin. I've added @coren to the task as they've done it before. [17:32:59] Okay thank you [17:33:07] !log ores deploying 30ba552 to the staging [17:33:08] I will be waiting [17:33:12] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [17:36:33] Amir1, looks like we don't have the new models [17:36:38] https://ores-staging.wmflabs.org/v2/scores/wikidatawiki/ [17:36:53] yeah, I'm investigating atm [17:37:51] ok, editquality in ores-staging is up to date [17:39:20] You need to add the models to the config. [17:39:27] 00-main.yaml [17:39:31] in ores-wikimedia-config [17:39:35] oh, okay [17:39:39] doing it right now [17:39:42] thanks [17:39:47] :) no problem [17:49:17] !log ores deploy d4f63a3 to the staging [17:49:23] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [17:49:53] https://ores-staging.wmflabs.org/v1/scores/wikidatawiki/damaging/12345678/ [17:49:56] halfak: ^ [17:50:16] Amir1, you should quick test it out on the revids you have in that table [17:50:33] Otherwise, this looks good. [17:50:39] that's what I'm doing right now [17:50:47] then deploy to the main project [17:50:51] oh! One more thing. how is the precacher going to behave once this goes to "deploy"? [17:50:58] Cool :) [17:54:41] it shows improvements in all false positives [17:54:42] https://ores-staging.wmflabs.org/v1/scores/wikidatawiki/damaging/?revids=210649590|237999679|243937491|251530750|253584599|257856652|269077025|269077027|269086457|269090263|269093456|269186604|269609233|270093221|274775730 [17:55:00] I need to check in more depth later [17:55:05] but this looks really good [17:55:53] halfak: great question. I shouldn't change it's behavior thus we need to add restart "precached" daemon to the fabfile or do it manually [17:56:09] 10Tool-Labs-tools-Other, 07I18n: [[Wikimedia:Pageviews-hosted/ksh]] i18n issue. - https://phabricator.wikimedia.org/T130006#2253871 (10MusikAnimal) @Purodha `$2` in this case is [[ https://tools.wmflabs.org | Tool Labs ]]. I guess we have it set up this way in case we change to a different hosting service. Is... [17:56:28] what do you suggest? [17:58:19] I'm not sure about fabfile since it's being ran only one target [17:58:32] (oh, we need to do the similar for prod) [17:59:05] Yeah... so, I think that adding it to the fabfile makes sense. [17:59:28] It seems like we'll want to have a collection of machines where precaching is running. [17:59:39] And have a set of commands for restarting precaching on those machines. [17:59:40] okay [18:00:06] env.roledefs [18:00:11] Looks like we have one for flower :) [18:00:23] So we can have one for 'precached' [18:02:44] halfak: btw. I tested it on some of stuff that dexbot reported in #wikidata-vandalism [18:03:00] (dexbot reports based on reverted model now) [18:03:39] 1- cases that were false positives now gets around 50% (more than 50% usually but still below 70%) [18:03:55] 2- cases that are bad gets really high score [18:03:58] 50% is good. Well below our base threshold. [18:04:15] 10Tool-Labs-tools-Other, 07I18n: Message [[Wikimedia:Pageviews-select2-max-items/en]] needs PLURAL support. - https://phabricator.wikimedia.org/T130005#2253889 (10MusikAnimal) [18:04:17] 10Tool-Labs-tools-Other, 06Community-Tech, 07I18n: [[Wikimedia:Pageviews-num-languages/en]] needs PLURAL - https://phabricator.wikimedia.org/T133766#2253890 (10MusikAnimal) [18:04:27] so everything looks good [18:04:32] going to deploy [18:05:29] !log deployed d4f63a3 to web and worker nodes [18:05:30] deployed is not a valid project. [18:05:41] !log ores deployed d4f63a3 to web and worker nodes [18:05:46] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [18:06:31] Amir1, you have to merge master into deploy or it doesn't work :) [18:06:35] 'deploy' branch [18:06:42] Make sure you push to the deploy branch too. [18:06:44] oh, I forgot [18:06:50] I did that with wikilabels [18:06:53] but I forgot [18:07:02] * halfak does that too often [18:07:42] One of our major downtime events was because old deploy was broken (version incompatibilities) and I deployed without updating. [18:10:23] * Amir1 writes down [18:12:32] 10Tool-Labs-tools-Other, 06Community-Tech, 07I18n: Add i18n JavaScript API to Pageviews Analysis - https://phabricator.wikimedia.org/T133766#2253891 (10MusikAnimal) p:05Triage>03Normal [18:15:02] deploying workers right now [18:18:59] https://ores.wmflabs.org/scores/wikidatawiki/ [18:19:14] restarting precaching daemon [18:19:33] Boo deprecated path. [18:19:33] https://ores.wmflabs.org/v2/scores/wikidatawiki/?model_info [18:19:35] :P [18:19:44] :) [18:20:36] Amir1, would you write up an announcement for Wikidata? I'd like to share that announcement with putnik and Krinkle so that they can announce to ruwiki and nlwiki. [18:20:40] No rush to do it today [18:20:48] Just thinking out loud [18:21:17] Actually I was thinking about it today [18:21:29] I'm so tired that I can't do it right now [18:22:01] (I labeled 750 edits today, deployed ores and wikilabels, and merged some PRs) [18:22:45] Yeah, you've been amazingly productive :) [18:23:21] Make sure you get all of these things in phab cards so that we can show off at the next revscoring meeting :) [18:23:40] There's a phab card somewhere for "complete wikidata edit quality campaign" [18:23:51] This can also wait for tomorrow ;) [18:26:34] I did it already [18:33:07] Sorry for asking the same thing again, but can someone help me to get the ''replica.my.cnf"file in my local folder in order to have access to DBs with Tool-Labs ? I cannot advance without this :( [18:33:39] your one still hasn't been created? [18:33:45] I thought this was automatic [18:34:38] It sometimes doesn't get created automatically. [18:34:45] Open a phab ticket about it. [18:35:01] I cannot find it ..I have .bash_history, .bash_logout, .bashrc, .cache folder and .profile [18:35:01] they did already [18:35:14] But that's all I have in my folder [18:37:11] I have already created a ticket : https://phabricator.wikimedia.org/T134066#2253830 [18:37:47] CreditsForDBConn: if it's not being created, you'll have to wait for someone with access to the fileserver [18:41:52] Ok, I'll be waiting... [18:42:33] 06Labs, 10Tool-Labs: Creation of replica.my.cnf - https://phabricator.wikimedia.org/T134066#2253830 (10tom29739) Not in all cases... [19:36:13] 06Labs, 10wikitech.wikimedia.org: Create replica.my.cnf for bkeegan on wikitech - https://phabricator.wikimedia.org/T134074#2253983 (10Madcoverboy) [19:43:18] 06Labs: Create replica.my.cnf for bkeegan on wikitech - https://phabricator.wikimedia.org/T134074#2254014 (10Krenair) [19:43:31] 06Labs: Create replica.my.cnf for bkeegan on tools - https://phabricator.wikimedia.org/T134074#2253983 (10Krenair) [19:51:29] Hello, still no admin on tool-labs to help me get a "replica.my.cnf" file ? :( [19:51:58] You'll just have to wait I think. [19:52:06] We need a db admin. [19:53:10] You think it would work if I create another account and get it confirmed ? I mean if this file is supposed to be created "by default" ? [19:54:36] Don't do that. [19:57:08] Ok I'll just keep on waiting, and hope someone will be able to help... It would really be great, I planned to work on this project this week end [19:59:17] Madjaoue, is this your shell account you've talking about here? [19:59:58] Because you could just create a tool. [20:00:13] I have an access to ssh server but I would like to have access to DBases [20:00:28] If I create a tool I can have access to databases ? [20:00:28] Madjaoue, https://wikitech.wikimedia.org/w/index.php?title=Special:NovaServiceGroup&action=addservicegroup&projectname=tools [20:00:41] Think of a name for your tool, no spaces. [20:00:43] Yes. [20:00:58] that's where tools are supposed to be created. [20:01:19] Something like 'pageimpact', or something. [20:02:41] Ok I have just entered a tool name [20:06:42] userimpact [20:09:04] So how do I use the tool to get an access to DBs ? [20:11:05] Madjaoue, log out of any ssh windows with tools. [20:11:14] (if you have any open) [20:11:27] done [20:14:30] Madjaoue, log back into ssh with toollabs. [20:14:49] Ok I'm in [20:14:51] (you have to restart the shell session for some reason) [20:15:11] type 'become ' (without the quotes) [20:15:26] So, in your case, 'become userimpact' [20:15:26] oh [20:15:54] awesome ! [20:16:18] Thank you !!!! [20:17:39] Madjaoue, you can start a webservice with 'webservice start' [20:18:21] yes I can [20:18:24] You can't do that with just your shell account. [20:19:20] I have a question, if I want to connect through a mysql module via ssh, how can I log direcly with the tools profile ? [20:19:38] (avoid the step : "become tool.name) [20:19:43] you can't [20:19:49] (at the moment anyway) [20:21:10] It is impossible for a tool to do direct requests then ? [20:21:21] Without manuel ssh let's say [20:21:25] manual* [20:22:37] they're trying to get it to work. [20:23:32] Ok [20:23:46] Madjaoue, this: https://phabricator.wikimedia.org/T113979 [20:24:21] And do you think of any solution I can put in place ? Like running a while loop, that can receive requests, execute them and then send the results ? [20:24:31] And do you think of any solution I can put in place ? Like running a while loop, that can receive requests, execute them and then send the results ? [20:24:35] For SQL queries? [20:24:40] Yes [20:24:57] What I'm trying to do is to make queries with nodejs [20:25:24] So with the connect module, I can give the parameters to get access to database and then make some queries [20:25:57] Or do everything with the tool and provide an api/server [20:26:11] What are you trying to do? [20:27:56] The main idea of my project is to try to come up with a formula that calculates the % of impact (utility, added value) of a contributor on a web page [20:28:19] I don't know what the formula is, it is the result I am trying to get [20:28:32] But to get it, I need maximum information about a web page [20:28:53] Then I put all these indicators on a web page [20:29:16] And people can suggest formulas to evaluate the impact of a user base on the indicators [20:29:24] Like entering excel formulas [20:29:34] Does nodejs understand JSON? [20:29:38] Yes [20:40:54] How does the web service work when we create a tool ? [20:41:19] Is there a doc somewhere ? to create an api via the tool ? [21:16:58] 10Tool-Labs-tools-Other, 07I18n: [[Wikimedia:Pageviews-hosted/ksh]] i18n issue. - https://phabricator.wikimedia.org/T130006#2254089 (10MusikAnimal) Ah I see, there is also [[ https://translatewiki.net/wiki/Gender | GENDER ]]. Clearly I need to do a little more reading about i18n =P I will add magic word suppo... [21:35:59] Madjaoue, you could use the API. [21:37:07] I tried to use the .php but there is no documentation, sometimes the results are limited (500 users for example for the contributors list) [21:37:38] I am trying to understand how tools work, it's pretty cool [21:37:53] Used another tool's source code to test everything works [21:38:16] https://tools.wmflabs.org/userimpact/ [21:38:56] I'll do the requests in python, return a json, and then link everything to another server that would process the client side [21:40:55] Madjaoue, there's pywikibot that you could use. [21:41:23] It's rather helpful in getting stuff, and querying the API, etc. [21:43:53] Ok I'll go check [22:58:49] 10Tool-Labs-tools-Other, 07I18n: PLURAL needed on $1 - https://phabricator.wikimedia.org/T129633#2254139 (10MusikAnimal) @Purodha `$1` here is a series of links (see Latest 10 20 30 60 90 days). The message should be treated as plural, and I think if you attempt to use `{{PLURAL}}` it will break because `$1` i... [22:59:03] hi is someonw around, who can read the static host configurations. I'm trying to access math.beta.wmflabs.org (the server is not in the beta cluster) on port 8080 but it seems not to work [23:00:17] it should be mapped to 208.80.155.135 [23:01:48] no worries... I think it was my fault. [23:02:07] the ip is configured correctly [23:11:59] no after double checkin I realized that the ip is not correct. the correct ip would be 208.80.155.185 [23:18:03] I'm struggling to understand what you want to do [23:18:14] What hostname are you trying to set up? [23:22:11] physikerwelt1 [23:25:44] hi Krenair [23:25:47] hi [23:26:26] I was updating my vagrant instance and wanted to test if it's still working [23:27:13] during that process I discoverd that the hostname is not associated to the static ip that is associated to the mathosphere instance [23:28:03] I think the hostname math.beta.wmflabs.org might got lost during the move to horizon [23:28:12] | 50a2e4b1-e50a-4410-a0b7-3e392e359305 | mathosphere | math | ACTIVE | - | Running | public=10.68.16.8, 208.80.155.185 | [23:28:25] that's in the math project, you can't have an entry under beta.wmflabs.org [23:28:59] it worked in the past [23:29:51] it should never have worked. [23:30:19] but yes, previously beta.wmflabs.org was open to all labs users. designate has different ownership rules [23:31:20] now you have to have access to the deployment-prep project to set up records under its domain [23:33:53] ok, but how can I associate any new hostname [23:34:10] for example beta.math.wmflabs.org [23:35:39] https://horizon.wikimedia.org/project/dns_domains/ [23:35:50] you may have to change to the math project in the dropdown at the top [23:35:59] fin math.wmflabs.org and click Manage Records [23:36:01] find* [23:36:15] click Create Record [23:36:38] there is no button 'create record' [23:36:48] record type A, name beta, select your IP, I think you can leave TTL blank, click Create Record [23:37:05] You're at "Domains : math.wmflabs.org. → Records" ? [23:37:28] Yes [23:37:47] now I was logged off with message Unauthorized [23:39:39] uhh [23:39:43] that seems broken [23:40:01] horizon is known to log people out when you hit an unauthorised error [23:40:12] but you shouldn't get that as a projectadmin in that project [23:40:29] I have to leave... I'll create a phabricator ticket. I sent you the information that I got with regard to the math.beta.wmflabs.org [23:41:00] krenair@bastion-01:~$ ldapsearch -x "(&(cn=projectadmin)(cn:dn:=math))" | grep physikerwelt [23:41:00] roleOccupant: uid=physikerwelt,ou=people,dc=wikimedia,dc=org [23:41:23] thanks