[00:02:16] Warning: There is 1 user waiting for access to tools project: Whym (waiting 80 minutes) [00:15:41] Warning: There is 1 user waiting for access to tools project: Whym (waiting 94 minutes) [00:29:05] Warning: There is 1 user waiting for access to tools project: Whym (waiting 107 minutes) [00:42:25] Warning: There is 1 user waiting for access to tools project: Whym (waiting 121 minutes) [00:55:46] Warning: There is 1 user waiting for access to tools project: Whym (waiting 134 minutes) [01:09:07] Warning: There is 1 user waiting for access to tools project: Whym (waiting 147 minutes) [01:22:28] Warning: There is 1 user waiting for access to tools project: Whym (waiting 161 minutes) [01:35:48] Warning: There is 1 user waiting for access to tools project: Whym (waiting 174 minutes) [01:49:09] Warning: There is 1 user waiting for access to tools project: Whym (waiting 187 minutes) [02:02:29] Warning: There is 1 user waiting for access to tools project: Whym (waiting 201 minutes) [02:15:50] Warning: There is 1 user waiting for access to tools project: Whym (waiting 214 minutes) [02:29:11] Warning: There is 1 user waiting for access to tools project: Whym (waiting 227 minutes) [02:42:31] Warning: There is 1 user waiting for access to tools project: Whym (waiting 241 minutes) [02:55:52] Warning: There is 1 user waiting for access to tools project: Whym (waiting 254 minutes) [03:09:17] Warning: There is 1 user waiting for access to tools project: Whym (waiting 267 minutes) [03:22:37] Warning: There is 1 user waiting for access to tools project: Whym (waiting 281 minutes) [03:35:58] Warning: There is 1 user waiting for access to tools project: Whym (waiting 294 minutes) [03:49:23] Warning: There is 1 user waiting for access to tools project: Whym (waiting 307 minutes) [04:02:51] Warning: There is 1 user waiting for access to tools project: Whym (waiting 321 minutes) [04:16:12] Warning: There is 1 user waiting for access to tools project: Whym (waiting 334 minutes) [04:29:37] Warning: There is 1 user waiting for access to tools project: Whym (waiting 348 minutes) [04:43:06] Warning: There is 1 user waiting for access to tools project: Whym (waiting 361 minutes) [04:56:34] Warning: There is 1 user waiting for access to tools project: Whym (waiting 375 minutes) [05:09:58] Warning: There is 1 user waiting for access to tools project: Whym (waiting 388 minutes) [05:23:19] Warning: There is 1 user waiting for access to tools project: Whym (waiting 401 minutes) [05:36:40] Warning: There is 1 user waiting for access to tools project: Whym (waiting 415 minutes) [05:50:01] Warning: There is 1 user waiting for access to tools project: Whym (waiting 428 minutes) [06:03:21] Warning: There is 1 user waiting for access to tools project: Whym (waiting 441 minutes) [06:16:42] Warning: There is 1 user waiting for access to tools project: Whym (waiting 455 minutes) [06:30:06] Warning: There is 1 user waiting for access to tools project: Whym (waiting 468 minutes) [06:43:27] Warning: There is 1 user waiting for shell: Jackson Peebles (waiting 11 minutes) [06:43:28] Warning: There is 1 user waiting for access to tools project: Whym (waiting 482 minutes) [06:56:47] Warning: There is 1 user waiting for shell: Jackson Peebles (waiting 24 minutes) [06:56:48] Warning: There is 1 user waiting for access to tools project: Whym (waiting 495 minutes) [07:10:12] Warning: There is 1 user waiting for shell: Jackson Peebles (waiting 38 minutes) [07:10:13] Warning: There is 1 user waiting for access to tools project: Whym (waiting 508 minutes) [07:18:35] Hi! So now we should use bots-login instead of bots-gs, right? [07:23:36] Warning: There is 1 user waiting for shell: Jackson Peebles (waiting 51 minutes) [07:23:37] Warning: There is 1 user waiting for access to tools project: Whym (waiting 522 minutes) [07:28:05] can we have svn installed on bots-login? [07:36:57] Warning: There is 1 user waiting for shell: Jackson Peebles (waiting 64 minutes) [07:36:58] Warning: There is 1 user waiting for access to tools project: Whym (waiting 535 minutes) [07:50:22] Warning: There are 2 users waiting for shell, displaying last 2: Jackson Peebles (waiting 78 minutes) CristianCantoro (waiting 0 minutes) [07:50:23] Warning: There is 1 user waiting for access to tools project: Whym (waiting 548 minutes) [07:56:07] how can I upload a file to a project's dir? [07:56:18] i.e., I can scp a file to my home dir [07:56:25] I can become a tool's user [07:56:47] but I can't copy to a tool's /data/project/ folder, and I can't scp to a toolname@ [08:01:24] dMaggot: I got stuck here before. my solution was to make that file public, then use the tool account to copy it [08:02:01] liangent: thanks, sounds good [08:03:50] Warning: There are 4 users waiting for shell, displaying last 4: Jackson Peebles (waiting 91 minutes) CristianCantoro (waiting 13 minutes) Psychoslave (waiting 6 minutes) Deskana (waiting 4 minutes) [08:03:51] Warning: There is 1 user waiting for access to tools project: Whym (waiting 562 minutes) [08:08:14] @requests [08:08:14] Warning: There are 4 users waiting for shell, displaying last 4: Jackson Peebles (waiting 96 minutes) CristianCantoro (waiting 18 minutes) Psychoslave (waiting 10 minutes) Deskana (waiting 8 minutes) [08:08:15] Warning: There is 1 user waiting for access to tools project: Whym (waiting 566 minutes) [08:10:05] !log bots petrb: installed subversion on login wheeeeeeeee [08:10:07] Logged the message, Master [08:10:30] DixonD1 installed [08:10:31] :P [08:11:14] Coren https://gerrit.wikimedia.org/r/#/c/65341/ [08:11:15] Thanks [08:11:58] But I'm just curious. Was the switch to bots-login announced on the mailing list? [08:12:09] It seems I've missed it [08:12:40] not sure, but the -gs was never shut down, so you don't need to worry [08:12:51] if your bot was cronned on -gs it did work [08:13:06] I am just making it more like on tools [08:13:28] The things is it didn't work [08:13:29] valhallasw: let me know when you are free :) [08:13:58] that's how I found out about the switch [08:14:02] addshore: I am. And just behind you. [08:14:11] :O [08:17:16] Warning: There are 5 users waiting for shell, displaying last 5: Jackson Peebles (waiting 105 minutes) CristianCantoro (waiting 27 minutes) Psychoslave (waiting 19 minutes) Deskana (waiting 17 minutes) Magioladitis (waiting 5 minutes) [08:17:17] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 575 minutes) Jalexander (waiting 8 minutes) [08:17:18] Coren what is wrong with these 2 exec nodes? I was on them and they seem fine to me [08:30:49] Warning: There are 5 users waiting for shell, displaying last 5: Jackson Peebles (waiting 118 minutes) CristianCantoro (waiting 40 minutes) Psychoslave (waiting 33 minutes) Deskana (waiting 31 minutes) Magioladitis (waiting 19 minutes) [08:30:50] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 589 minutes) Jalexander (waiting 22 minutes) [08:44:18] Warning: There are 2 users waiting for shell, displaying last 2: Jackson Peebles (waiting 132 minutes) Magioladitis (waiting 32 minutes) [08:44:19] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 602 minutes) Jalexander (waiting 35 minutes) [08:57:52] Warning: There are 2 users waiting for shell, displaying last 2: Jackson Peebles (waiting 145 minutes) Magioladitis (waiting 46 minutes) [08:57:53] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 616 minutes) Jalexander (waiting 49 minutes) [09:02:32] allo [09:02:33] is there a way to get the job number [09:02:34] err [09:02:35] job id [09:02:44] in a script that is being run as the job? [09:02:57] to be more exact, being able to get the job id in the job program itself? [09:10:24] petan: hey, about https://gerrit.wikimedia.org/r/#/c/65341/ [09:10:30] petan: already installed, or waiting on cr? [09:11:21] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 629 minutes) Jalexander (waiting 62 minutes) [09:11:24] merged [09:14:24] YuviPanda: $JOB_ID [09:16:32] ah, so JOB_ID in the os environment [09:16:33] ok [09:24:50] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 643 minutes) Jalexander (waiting 76 minutes) [09:32:07] petan, Coren: seems phpunit is broken... [09:33:50] need hashar :) [09:35:23] hi ppl [09:35:58] Merlissimo: You are somewhere here already? [09:38:19] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 656 minutes) Jalexander (waiting 89 minutes) [09:51:52] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 670 minutes) Jalexander (waiting 103 minutes) [10:03:59] legoktm: wb_ tables? [10:05:21] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 683 minutes) Jalexander (waiting 116 minutes) [10:05:32] I just migrated a tool. :) [10:07:30] Coren: so, phpunit is old/broken in precise [10:07:44] and needs to be backported from raring [10:08:59] Shouldn't be too hard, but I fear that it'll have dependencies on a more recent version of PHP [10:09:12] Ryan_Lane: ^^ [10:09:49] it may [10:09:59] I took a quick look. it has a decent number of dependencies [10:10:23] And PHP starts a dependency chain from Hell [10:10:41] yep [10:10:57] (This is actually what disqualified apache 2.4 builds) [10:10:58] we have custom php packages anywat [10:11:03] *anyway [10:11:21] I have doubts it will need a newer version of php [10:11:30] it's being installed via pear for jenkins [10:11:41] which is cringe worthy [10:12:58] Eeew. [10:13:36] Ryan_Lane: remind me to talk to you about the add/remove users interface in labs [10:13:50] valhallasw: heh. yeah. it's a really bad one :) [10:13:56] it needs some love [10:14:03] Ryan_Lane: I think we could also maybe integrate it with the current !tr stuff [10:14:10] !tr [10:14:10] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/$url_encoded_1?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:$url_encoded_1?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [10:14:19] yeah, would be nice [10:14:21] where you just have one page where everything is in one place [10:14:29] that would be ideal, yeah [10:16:04] I think we need a more directed Special:ServiceGroup too [10:16:57] we need a designer [10:17:00] honestly [10:17:34] Ryan_Lane: Danny_B volunteered [10:17:53] Danny_B: you do interface design? [10:18:50] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 697 minutes) Jalexander (waiting 130 minutes) [10:19:46] we can definitely split the interfaces apart. that's more clicks, though [10:20:09] we can also hide most of the interface nastiness with JS [10:24:47] Ryan_Lane: yup, where are you? [10:32:23] Warning: There are 2 users waiting for access to tools project, displaying last 2: Whym (waiting 710 minutes) Jalexander (waiting 143 minutes) [10:32:26] Coren: There someone here with questions! are you busy right now? [10:41:38] Coren ping [10:41:47] Coren if you have a time can we look on these 2 exec [10:42:42] !tr Whym [10:42:43] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Whym?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Whym?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [10:42:49] !tr Jalexander [10:42:49] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Jalexander?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Jalexander?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [11:17:25] Warning: There is 1 user waiting for shell: Spider (waiting 0 minutes) [11:30:55] Warning: There is 1 user waiting for shell: Spider (waiting 13 minutes) [11:30:56] Warning: There is 1 user waiting for access to tools project: Spider (waiting 5 minutes) [11:39:18] !tr Spider [11:39:18] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Spider?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Spider?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [11:43:24] Hey, we need a tool labs admin here the table! Where are Coren and petan ? [11:43:42] here [11:43:49] Silke_WMDE: coren is outside [11:44:22] thx Ryan_Lane [11:44:33] !tr Purodha [11:44:33] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Purodha?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Purodha?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [11:44:40] yw [11:45:36] seems to be sorted out [11:47:11] Hey Ryan_Lane [11:47:32] Do you have a moment to help me deal with a minor problem on wikitech-test? [11:47:51] Krenair: yep. what's up? [11:48:17] I was creating an 'added to project' echo notification for Sumana [11:48:24] But I needed an extra account to test it [11:48:35] How do I reset the password to the 'TEST Alex Monk' account? [11:48:45] ah. via ldap. [11:49:03] want me to do so, or show you how? [11:50:03] can you show me how please? [11:50:10] yep [11:50:53] Krenair: ldapsearch -LLL -x -H ldap://localhost 'cn=TEST Alex Monk' dn > test.ldif [11:51:11] -LLL says "I want a very terse return format" [11:51:52] -x uses simple authentication rather than SASL [11:52:01] -H is required because you want the local ldap [11:52:04] so... [11:52:24] etherpad light dead [11:52:26] 503 errs [11:52:33] wait it's coming back [11:52:34] maybe [11:53:07] ok we're just switching to http://etherpad.wikimedia.org/ArchDoc ;) [11:53:09] Krenair: it'll output the dn for you [11:53:16] Krenair: then you need to make the ldif [11:53:20] dn: uid=testkrenair,ou=people,dc=wikimedia,dc=org [11:53:20] changetype: modify [11:53:20] replace: userpassword [11:53:20] userpassword: a-password [11:53:44] Krenair: then you can apply the ldif [11:54:18] How do I apply it? [11:54:30] ldapmodify -x -D 'uid=novaadmin,ou=people,dc=wikimedia,dc=org' -W -f test.ldif [11:54:39] -W makes it prompt for a password [11:54:55] the password for that user is in /srv/org/wikimedia/controller/wikis/config/Settings.php [11:55:34] Is that the wgLDAPWriterPassword? [11:55:39] yep [11:56:06] ldap_bind: Invalid credentials (49) [11:56:59] o.O [11:57:06] oh [11:57:07] heh [11:57:08] whoops [11:57:21] ldapmodify -x -H ldap://localhost -D 'uid=novaadmin,ou=people,dc=wikimedia,dc=org' -W -f test.ldif [11:57:29] need to tell it to talk to the local ldap [11:57:46] lol, so what ldap would I have been trying to get into? [11:57:52] production ;) [11:58:06] oops :P [11:58:20] no worries. it's obviously not the right password :) [11:58:58] I tried to ssh into gerrit without the -p 29418 once [11:59:10] I have since made that default port in my ssh config [11:59:58] Warning: There is 1 user waiting for access to tools project: Lbenedix (waiting 0 minutes) [12:00:34] Who's using the OSM repo on nova-precise2? [12:01:02] # deleted: api/ApiNovaAddress.php [12:01:02] # modified: api/ApiNovaInstance.php [12:01:22] Ryan_Lane: can you take a look on keys on bastion? some people here are having troubles to ssh to bastion while the tools login servers are fine to them. I can't debug this because it requires root and I guess it's not really easily possible for me to get that on bastions... [12:01:46] basically, new users on labs can ssh to tools, but they can't ssh to bastion [12:01:53] that sounds like a gluster issue to me [12:01:56] I believe it's gluste [12:01:58] :P [12:02:00] yeah [12:02:31] petan: who's trying? [12:02:33] can they try now [12:02:36] I'm tailing the auth log [12:02:54] Cristiancantoro [12:03:39] it worked to him now [12:03:49] heh [12:03:50] no clue, then :) [12:03:53] no gluster issues [12:03:53] weird [12:03:59] In fact [12:04:02] you could have seen the reason if you grep the log [12:04:11] his name [12:04:15] Every OSM repo on nova-precise2 has uncommitted changes [12:04:23] it was "permission denied (ssh key) [12:05:33] Krenair: marktraceur is using /w [12:05:41] Krenair: I was using /w2, you can kill any changes in there [12:05:45] okay, thanks [12:05:48] yw [12:06:29] Krenair: if it isn't working for some reason, I'll fix it for you [12:06:46] permissions are such a mess on these [12:07:27] Krenair: yep [12:07:28] sorry [12:08:14] disabling puppet on nova-precise2 for a bit [12:10:48] [Sat May 25 12:09:18 2013] [error] [client redacted] PHP Fatal error: require_once(): Failed opening required '/srv/org/wikimedia/controller/wikis/w2/extensions/Collection/Collection.php' (include_path='.:/usr/share/php:/usr/share/pear') in /srv/org/wikimedia/controller/wikis/config/Settings.php on line 161 [12:11:00] getting error 500 when I try to access /wiki2, I think it's this [12:13:23] Warning: There is 1 user waiting for access to tools project: Lbenedix (waiting 13 minutes) [12:14:20] !tr Lbenedix [12:14:20] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Lbenedix?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Lbenedix?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [12:29:51] Coren when you have a minute I found something we need to sort out tools [12:32:31] Could someone grant shell access for Psychoslave? [12:33:07] I forgot to say "please" [12:35:11] Darkdadaah they already got it afaik [12:38:04] Coren petan Waaah! What is this? ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [12:38:23] Silke_WMDE you need to append -h parameter with server name [12:38:38] ah [12:38:42] petan: He got the error: "Permission denied (public key)" [12:38:50] for example mysql -h enwikilabsdb [12:38:56] petan: What would be a valid server name? [12:39:01] for example mysql -h enwiki.labsdb [12:39:11] thx petan I'll try [12:39:24] hold on [12:39:34] yes it's this [12:41:05] mysql --defaults-file=~/replica.my.cnf -h enwiki.labsdb [12:41:35] petan: cool, thanks! [12:41:36] Silke_WMDE try that ^ [12:41:40] yw [12:43:13] petan: I don't see any directory in the /home/ for Psychoslave, maybe that's the problem. [12:43:32] Darkdadaah he requested shell access he isn't member of tools project [12:43:39] that is a separate request should I add him? [12:43:58] Yes, but I was only talking about the /home in bastion. [12:44:29] bastion is IMHO fucked a bit, I talked to Ryan_Lane he said he will take a look on that [12:44:46] what's broken? [12:44:49] I'll take a look now [12:44:52] someone else can't login [12:45:26] deskana? [12:46:18] I'm not seeing an issue [12:46:28] is this person at the hackathon? [12:46:33] petan: ^^ ? [12:46:42] Ryan_Lane: yes. [12:46:45] Ryan_Lane I don't know but Darkdadaah asked not Deskana :) [12:47:01] Ryan_Lane: We are at the Wiktionary table [12:47:10] Darkdadaah: what's your shell account name? [12:47:48] I see a successful login in the auth.log [12:47:49] Ryan_Lane: I'm not the one having an issue: it is "psychoslave". [12:48:16] it creates the homedir fine [12:48:31] ah [12:48:37] there's no ssh key on this user's account [12:48:48] psychoslave needs to go into wikitech and add the ssh key [12:50:21] Ryan_Lane: let me check. [12:50:52] Ryan_Lane: Psychoslave adde his key on gerrit but not on wikitech. [12:50:57] added* [12:53:36] 30 instances created during the hackathon, eh? [12:54:40] Ryan_Lane: Psychoslave added his key on Wikitech, but still no access (to bastion via ssh). [12:54:57] it takes about 5 minutes to sync to the filesystem [12:55:05] Ok :) [12:55:17] it's sync'd now [12:55:27] can he try now? [12:55:47] Yes, it works now :D Thanks [12:55:50] :) [12:55:54] petan: see? not broken ;) [12:56:28] But it means that we should always add a key to Wikitech, even after having given it to gerrit. [12:56:43] yeah. we have an open bug on this [12:56:49] gerrit should fetch its keys from ldap [12:57:01] then the key would only need to be uploaded to wikitech [12:57:14] Ryan_Lane idk I am forwarding the complaint to you only :P [12:57:21] :) [12:57:31] I wish it wasn't so hot in the main room [12:57:40] Not complaints, "requests for improvement" [12:57:51] yep [12:58:00] complaints are fine too :) [12:58:11] http://www.mediawiki.org/wiki/Wikimedia_Labs/Account_creation_improvement_project#SSH_key_management [12:58:21] http://code.google.com/p/gerrit/issues/detail?id=1124 [12:58:34] should get a bunch of people to +1 that :) [12:58:39] I only complain when I'm angry. [12:58:49] labs hasn't made you angry yet? [12:59:03] :D [12:59:17] I'm very patient. [12:59:36] I guess it's quite a bit better now than before. less to get angry about [13:01:55] Ryan_Lane we are here in the room2 sorting out some labs migration and it's quite cold in here [13:02:08] ah. nice [13:02:17] I'm in the ops room [13:02:22] aha [13:02:27] there is some ops cabal in here? :D [13:02:33] There is an ops room? [13:02:33] heh. nah [13:02:43] it's where the ops folks are hanging out, anyway [13:02:51] we're having meetings in here and sprints and such [13:03:57] Ryan_Lane: You're just hiding from the plebs [13:04:08] :D [13:04:22] I'll be back in the main room when the A/C is fixed [13:04:59] petan: room2 is borneo2? Maybe I'll join you. [13:05:06] yes [13:05:14] I am in front with coren [13:09:03] does the labs-version of SGE have this bug? https://jira.toolserver.org/browse/TS-1479 [13:09:27] if it doesn't I'll move those related bots to labs [13:10:03] Warning: There is 1 user waiting for access to tools project: Psychoslave (waiting 0 minutes) [13:11:23] DanielK_WMDE__: Where are you? [13:18:15] !tr Psychoslave [13:18:15] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Psychoslave?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Psychoslave?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [13:23:14] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695164 edit summary: [-32] /* Webtools */ has been replaced by "Tools" quite some time ago [13:23:16] it's too cold there lol [13:23:25] I <3 hot weather [13:23:32] Warning: There is 1 user waiting for access to tools project: Ash Crow (waiting 9 minutes) [13:24:02] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695165 edit summary: [-1] /* How will Toolserver tools work on WikiLabs? */ changed order of projects [13:24:17] !tr Ash_Crow [13:24:17] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Ash_Crow?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Ash_Crow?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [13:26:14] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695169 edit summary: [-257] /* When can I migrate my software to Labs? */ updated [13:40:18] Is there any easy way to set up a bare minimum MWMultiVersion install so that production config vars can easily be found? [13:42:11] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695194 edit summary: [+670] /* List of important questions/FAQ */ added section for accessing db replicas [13:44:02] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695195 edit summary: [+68] /* How do I access the database replicas? */ [13:45:36] ^^ Anyone else up for writing down some stuff? [13:51:24] Petr? I'm trying to put data in sql. Seems to get stuck at some point [13:51:26] #wikipedia-en-help [13:51:35] Coren: ^ [13:52:49] Oren_Bochman? [13:54:50] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695207 edit summary: [+266] /* List of important questions/FAQ */ License must be specified [13:58:01] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695209 edit summary: [-22] /* Wikimedia Germany */update of minor detail [14:04:30] Coren if someone deleted their replica file is there a backup for it? [14:04:38] I suppose in nfs? [14:05:07] multichill: where are you [14:05:11] multichill still at room2? [14:06:45] petan: Sorry, meeting, maybe you can look with me [14:06:51] Dbinsert seems to get stukc [14:07:22] petan: It will reappear "magically" eventually (I think 20 mins) [14:11:06] petan: You'll see some db connections now [14:11:08] Warning: There is 1 user waiting for shell: FatJagm (waiting 0 minutes) [14:11:55] petan: https://jira.toolserver.org/browse/TS-1479 <- this still fails on labs [14:12:19] let's see whether things get fixed faster on labs than toolserver :p [14:13:42] here's my test code:http://pastebin.com/GgR5ytTj [14:18:52] liangent: It probably will, but you almost certainly want to look into using "jsub" instead, which is the official Tool Labs mechanism. qcronsub is just a hack atm [14:20:04] Coren: jsub has the same issue. [14:20:17] Coren: http://pastebin.com/GgR5ytTj these are my test commands on labs [14:20:21] https://bugzilla.wikimedia.org/show_bug.cgi?id=48811 [14:20:56] Huh. [14:21:03] Will be fixed soon fer sure. [14:24:38] Warning: There are 3 users waiting for shell, displaying last 3: FatJagm (waiting 13 minutes) MarianneH (waiting 3 minutes) AlanT (waiting 0 minutes) [14:25:02] Coren guys from heritage has some problems with production replica, and I suppose there is no chance for me to get any kind of access there which would allow me to debug it, so you will probably need to have a look [14:25:21] I think their "query hang up" [14:25:29] no idea, show processlist doesn't work to me there [14:38:06] Warning: There are 4 users waiting for shell, displaying last 4: JoffreyQ (waiting 12 minutes) ZeroK (waiting 12 minutes) Gretal (waiting 9 minutes) Florenth (waiting 6 minutes) [14:38:20] addshore where u? [14:38:26] here :) [14:38:31] by the bar [14:39:14] they say "time to go out for a dinner" at 17:00 [14:39:18] that is like in 20 min [14:39:57] addshore do something, we need a monkey like you to sort out the shells [14:40:59] * petan pats addshore... good monkey [14:41:14] :DD [14:41:32] Can someone help me? I got an error for my webpage at http://tools.wmflabs.org/wikt-mwtest/index.html [14:41:46] sure [14:48:13] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695222 edit summary: [+132] /* Where is documentation? */ added link to Tool Labs docs [14:49:09] libgcc_s.so.1 must be installed for pthread_cancel to work << what does this mean? [14:49:33] command: jsub -once -N php_cleanupILH_zhwiki php $HOME/mw/maintenance/cleanupILH.php --wiki=zhwiki --maxlag=15 [14:50:42] error seen in ~/php_cleanupILH_zhwiki.err [14:51:40] Warning: There are 3 users waiting for access to tools project, displaying last 3: Florenth (waiting 7 minutes) MarianneH (waiting 7 minutes) ZeroK (waiting 7 minutes) [14:52:55] liangent: I think either a memory prob or there is some library missing [14:53:07] liangent if you are out of mem php is showing random errors [14:54:34] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695224 edit summary: [+480] /* How can I delete a tool? */ Tools can't be deleted [14:56:00] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695225 edit summary: [+119] /* List of important questions/FAQ */ No renaming of tools possible [14:57:04] petan: I'm trying jsub -once -N php_cleanupILH_zhwiki -mem 256g php $HOME/mw/maintenance/cleanupILH.php --wiki=zhwiki --maxlag=15 [14:57:04] then it waits there forever :( [14:57:29] liangent I recommend you to wrap this into a shell script and jsub the script [14:58:09] liangent there are 0 waiting jobs now [14:58:14] no idea [15:01:19] petan: I qdel'ed it [15:01:24] and with -mem 1g it works [15:01:26] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695226 edit summary: [+188] /* Information about design, functionality and structure of Tool Labs for existing and new devs */ [15:01:37] liangent 256g memory [15:01:41] that is too much [15:01:52] max is around 24g [15:04:00] petan: is it possible to just say "no memory limit please" [15:05:09] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 10 minutes) [15:05:40] liangent unfortunately not, for that you need to run the task on bots project [15:05:50] there are no limits at all [15:10:38] petan: then any suggested value for a "large enough limit"? [15:11:30] which doesn't stick my job randomly [15:11:49] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695233 edit summary: [+252] /* Information about design, functionality and structure of Tool Labs for existing and new devs */ Difference between "Tools" and "Bots" project [15:17:04] Change on 12mediawiki a page Wikimedia Labs/Migration of Toolserver tools was modified, changed by Silke WMDE link https://www.mediawiki.org/w/index.php?diff=695236 edit summary: [+199] /* Schedule for the transition */ added roadmap essentials [15:18:38] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 23 minutes) [15:24:49] why is 'interwiki' table empty on replica? [15:25:29] Does WMF use interwiki? :/ [15:27:37] Krenair: ok so I found https://noc.wikimedia.org/conf/interwiki.cdb so is this their alternative? [15:29:28] no idea [15:31:37] liangent petan If you do that I believe the grid will wait until there is 256G free before starting the job [15:32:13] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 37 minutes) [15:45:41] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 50 minutes) [15:59:14] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 64 minutes) [16:00:22] petan: Would be nice if wm-bot could issue these "warnings" under a different user, so that it is easier to ignore. [16:03:54] * Betacommand agrees with that [16:12:43] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 77 minutes) [16:26:12] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 91 minutes) [16:39:37] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 104 minutes) [16:50:40] scfc_de: hi [16:51:20] | ts_replag | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `ts_replag` AS select `ts_rc_age`() AS `ts_replag` | latin1 | latin1_swedish_ci | [16:51:38] it doesn't look like a simple rc_timestamp calculation? [16:53:02] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 118 minutes) [16:53:57] liangent: The current definition of ts_rc_age() is at http://pastebin.com/TmbhDbuz. It *is* a simple rc_timestamp calculation :-). [16:57:30] scfc_de: ok btw how can I copy a database table? [16:58:01] besides create table then insert .. select [16:59:09] liangent: I'm not sure if there is a better solution in MySQL. In PostgreSQL, there is "CREATE TABLE xyz AS SELECT * FROM abc;", but I don't know if this works. [17:02:51] hello. I'm having trouble creating the proxy to chippy@bastion.wmflabs.org - it says "bind: Cannot assign requested address" [17:03:30] chippy: What proxy? [17:03:40] https://wikitech.wikimedia.org/wiki/Help:Access#Accessing_services_using_port_forwarding [17:04:29] basically creating a socks proxy to access service on the machine, but whilst I can ssh and connect to the machine, I can't seem to be able to set up that proxy [17:05:02] I wonder if it could be my router that's in the way? [17:05:03] chippy: So you mean https://wikitech.wikimedia.org/wiki/Help:Access#Accessing_web_services_using_a_SOCKS_proxy? [17:05:28] scfc_de, ahh yes, sorry. That's the one [17:05:51] chippy: Can you try a different port than 8080? [17:06:00] scfc_de, yes I have tried a few [17:06:26] chippy: Hmmm. Works for me. BTW, which operating system do you use? [17:06:27] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 131 minutes) [17:06:55] scfc_de, linux (ubuntu 10.04) [17:08:02] scfc_de: it sounds like you're an sql expert :) [17:08:14] so what's wrong with this line? : update objectcache2 set keyname=replace(keyname,'zhwiki_p:Wikipedia:','zhwiki:Wikipedia:'); [17:08:48] chippy: What does "ssh -v @bastion.wmflabs.org -D 8080" say? [17:09:12] liangent: What's not working? [17:10:16] scfc_de, here's a snippet: https://gist.github.com/timwaters/0ff85e8e0c96de035e8e [17:10:34] scfc_de: sorry it's working :D I typed a wrong table name in the second query [17:11:06] liangent: :-) [17:12:22] chippy: Dumb question: Could it be that it is working? I'm no ssh guy, but it seems to try to bind to 127.0.0.1 (IP4) and ::1 (IP6). If only the latter failed, the former might work?! [17:12:24] do we have memcached on tool lab now? [17:12:54] liangent: I don't think so that there is a site-wide installation. [17:12:57] scfc_de, the -4 flag can be used to force ipv4 apparently, and that doesn't help though [17:13:41] chippy: And "netstat -ant | fgrep 8080" on your machine is empty? [17:14:43] scfc_de, yes (if I close firefox) [17:15:17] hmm, so using -4 gives a somewhat more encouraging debug1: Local connections to LOCALHOST:8080 forwarded to remote address socks:0 debug1: Local forwarding listening on 127.0.0.1 port 8080. [17:16:12] So no error message with -4? Does the proxy work then? [17:16:23] nope :( [17:17:24] Hmmm. [17:17:46] scfc_de, it does work now! [17:17:53] used another browser [17:18:25] :-) [17:18:27] chromium is showing the correct ip address [17:19:03] firefox still isn't showing anything... [17:20:00] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 145 minutes) [17:20:39] thanks scfc_de :) [17:33:28] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 158 minutes) [17:45:54] what are those *index tables? [17:45:56] like revision_userindex ? [17:46:53] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 171 minutes) [17:56:42] liangent, different views for the same tables, have indexes on the user fields so queries against users can be fast [17:59:30] Krenair: so is something else missing in it? [17:59:49] what if I always use it for `revision` [17:59:56] Coren, ^ [18:00:18] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 185 minutes) [18:01:00] Honestly I've never dealt with an SQL setup like this before. just the basic commands and concepts with full root access on my own box, so... [18:04:27] scfc_de: ^ or you may know it ;D [18:13:38] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 198 minutes) [18:27:07] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 212 minutes) [18:28:18] liangent: I think Coren said that the tables are identical except for the indexes. But you would have to ask him. [18:32:57] scfc_de: they're there because we can't FORCE INDEX on views? [18:37:56] liangent: I /believe/ that Coren said that revision is a view where some rows are hidden, while revision_userindex is an actual table of just the non-hidden rows. But so far he spent more time setting up replication than documenting it :-), so it's probably best if he answers that. [18:40:32] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 225 minutes) [18:53:57] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 238 minutes) [19:07:29] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 252 minutes) [19:20:54] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 265 minutes) [19:34:19] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 279 minutes) [19:47:53] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 292 minutes) [20:01:22] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 306 minutes) [20:14:54] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 319 minutes) [20:28:23] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 333 minutes) [20:41:48] Warning: There is 1 user waiting for access to tools project: Gretal (waiting 346 minutes) [20:54:42] !tr Gretal [20:54:42] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Gretal?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:Gretal?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [21:18:22] @requests [21:18:22] There are no shell requests waiting [21:44:05] @seenrx /PETA/i [21:44:05] petan: I have never seen /PETA/i [21:44:10] nope [21:57:09] @seenrx /.+/ [21:57:09] Damianz: I have never seen /.+/ [21:57:13] LOL [21:57:46] @seenrx .+ [21:57:46] petan: Last time I saw petan they were talking in the channel, they are still in the channel. It was in #wikimedia-labs at 5/25/2013 9:57:46 PM (00:00:00.2121010 ago) (multiple results were found: KuboF, jarry1250, gerrit-wm, Danny_B|backup, Tlusta and 8878 more results) [21:57:51] aha [21:58:38] No pcre syntax love? [21:58:53] consult with microsoft [21:58:58] they invented this [21:59:01] eww [21:59:09] XD [21:59:19] I am using it because it's easy to use [21:59:29] Python is easy to use [21:59:36] I can even make a code while drunked [21:59:45] this is easier than python [21:59:58] visual studio can actually write a code for you. all you need to do is hit a random keys [22:00:13] SublimeText2 can too [23:54:22] Warning: There is 1 user waiting for shell: Danilo (waiting 0 minutes)