[00:02:06] Warning: There is 1 user waiting for shell: Nobushigex (waiting 84 minutes) [00:02:07] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 497 minutes) CristianCantoro (waiting 442 minutes) Dapete (waiting 253 minutes) [00:15:27] Warning: There is 1 user waiting for shell: Nobushigex (waiting 97 minutes) [00:15:28] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 510 minutes) CristianCantoro (waiting 455 minutes) Dapete (waiting 266 minutes) [00:28:53] Warning: There is 1 user waiting for shell: Nobushigex (waiting 110 minutes) [00:28:54] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 524 minutes) CristianCantoro (waiting 469 minutes) Dapete (waiting 279 minutes) [00:42:14] Warning: There is 1 user waiting for shell: Nobushigex (waiting 124 minutes) [00:42:15] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 537 minutes) CristianCantoro (waiting 482 minutes) Dapete (waiting 293 minutes) [00:55:37] New patchset: Tim Landscheidt; "Add option -quiet to jsub." [labs/toollabs] (master) - https://gerrit.wikimedia.org/r/65642 [00:55:39] Warning: There is 1 user waiting for shell: Nobushigex (waiting 137 minutes) [00:55:40] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 551 minutes) CristianCantoro (waiting 496 minutes) Dapete (waiting 306 minutes) [01:09:03] Warning: There is 1 user waiting for shell: Nobushigex (waiting 150 minutes) [01:09:04] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 564 minutes) CristianCantoro (waiting 509 minutes) Dapete (waiting 320 minutes) [01:11:10] Can an admin check the authentication logs for bastion1? It's refusing my key even though I put it in openstack. [01:22:24] Warning: There is 1 user waiting for shell: Nobushigex (waiting 164 minutes) [01:22:25] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 577 minutes) CristianCantoro (waiting 522 minutes) Dapete (waiting 333 minutes) [01:22:44] sdamashek: Have you tried "ssh -v bastion1.wmflabs.org"? [01:24:50] scfc_de: I'm using PuTTY [01:25:21] New patchset: Tim Landscheidt; "Fix jstart to start only one job instance." [labs/toollabs] (master) - https://gerrit.wikimedia.org/r/65707 [01:26:44] New patchset: Tim Landscheidt; "Fix jstart to start only one job instance." [labs/toollabs] (master) - https://gerrit.wikimedia.org/r/65707 [01:33:34] sdamashek: Ah, sorry, no Windows here. And all admins seem to be offline (Ryan_Lane, andrewbogott). [01:35:53] Warning: There is 1 user waiting for shell: Nobushigex (waiting 177 minutes) [01:35:54] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 591 minutes) CristianCantoro (waiting 536 minutes) Dapete (waiting 346 minutes) [01:40:34] scfc_de: okay, thanks [01:49:25] Warning: There is 1 user waiting for shell: Nobushigex (waiting 191 minutes) [01:49:26] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 604 minutes) CristianCantoro (waiting 549 minutes) Dapete (waiting 360 minutes) [02:02:50] Warning: There is 1 user waiting for shell: Nobushigex (waiting 204 minutes) [02:02:51] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 618 minutes) CristianCantoro (waiting 563 minutes) Dapete (waiting 373 minutes) [02:16:14] Warning: There is 1 user waiting for shell: Nobushigex (waiting 218 minutes) [02:16:15] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 631 minutes) CristianCantoro (waiting 576 minutes) Dapete (waiting 387 minutes) [02:29:39] Warning: There is 1 user waiting for shell: Nobushigex (waiting 231 minutes) [02:29:40] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 645 minutes) CristianCantoro (waiting 590 minutes) Dapete (waiting 400 minutes) [02:34:14] Any techs available? I need help getting to the replicated databases (which I understand exist...) [02:34:36] Matthew_: On Tools? [02:34:59] scfc_de: Yessir. [02:38:09] Matthew_: What doesn't work for you, what have you tried already? [02:38:56] scfc_de: I can't see the databases at all. "show databases;" shows just my tools database and nothing else. [02:39:13] Do I need to connect to something else? [02:40:19] mysql enwiki_p returns an access denied error. [02:41:15] You probably have a ~/.my.cnf that says to connect to "tools-db". You need to "mysql --defaults-file=~/replica.my.cnf -h enwiki.labsdb enwiki_p". [02:42:13] scfc_de: OK, but what about the access denied error? [02:42:59] Warning: There is 1 user waiting for shell: Nobushigex (waiting 244 minutes) [02:43:00] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 658 minutes) CristianCantoro (waiting 603 minutes) Dapete (waiting 414 minutes) [02:44:22] Matthew_: Doesn't that work for you? [02:44:26] (I'm asking before I type that and lock myself out or something... :P ) [02:45:23] scfc_de: OK, it appears to work. [02:45:37] Well, if you provide the correct credentials to correct server for the correct database, it should work :-). [02:46:04] Hahahaha, OK, that makes sense. And what about for my code, do I just tell it to read the replica.my.cnf for the credentials? [02:50:22] If you're talking about a tool, I would backup the original ~/.my.cnf and copy replica.my.cnf in its place as you can access both the replicas and tools-db with the credentials from replica.my.cnf. [02:51:45] In Perl, you can specify different my.cnfs with ";mysql_read_default_file=/path/to/replica.my.cnf", for example. In other languages, there are probably similar settings. [02:53:49] OK, sounds good. Thanks for the help. [02:56:20] Warning: There is 1 user waiting for shell: Nobushigex (waiting 258 minutes) [02:56:21] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 671 minutes) CristianCantoro (waiting 616 minutes) Dapete (waiting 427 minutes) [03:09:45] Warning: There is 1 user waiting for shell: Nobushigex (waiting 271 minutes) [03:09:46] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 685 minutes) CristianCantoro (waiting 630 minutes) Dapete (waiting 440 minutes) [03:23:06] Warning: There is 1 user waiting for shell: Nobushigex (waiting 284 minutes) [03:23:07] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 698 minutes) CristianCantoro (waiting 643 minutes) Dapete (waiting 454 minutes) [03:36:34] Warning: There is 1 user waiting for shell: Nobushigex (waiting 298 minutes) [03:36:35] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 712 minutes) CristianCantoro (waiting 657 minutes) Dapete (waiting 467 minutes) [03:50:03] Warning: There is 1 user waiting for shell: Nobushigex (waiting 311 minutes) [03:50:04] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 725 minutes) CristianCantoro (waiting 670 minutes) Dapete (waiting 481 minutes) [04:03:24] Warning: There is 1 user waiting for shell: Nobushigex (waiting 325 minutes) [04:03:25] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 738 minutes) CristianCantoro (waiting 683 minutes) Dapete (waiting 494 minutes) [04:16:53] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 338 minutes) Pathoschild (waiting 8 minutes) [04:16:54] Warning: There are 3 users waiting for access to tools project, displaying last 3: Incola (waiting 752 minutes) CristianCantoro (waiting 697 minutes) Dapete (waiting 507 minutes) [04:30:18] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 352 minutes) Pathoschild (waiting 21 minutes) [04:30:19] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 765 minutes) CristianCantoro (waiting 710 minutes) Dapete (waiting 521 minutes) Pathoschild (waiting 8 minutes) [04:43:39] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 365 minutes) Pathoschild (waiting 35 minutes) [04:43:40] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 779 minutes) CristianCantoro (waiting 724 minutes) Dapete (waiting 534 minutes) Pathoschild (waiting 21 minutes) [04:57:00] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 378 minutes) Pathoschild (waiting 48 minutes) [04:57:01] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 792 minutes) CristianCantoro (waiting 737 minutes) Dapete (waiting 548 minutes) Pathoschild (waiting 34 minutes) [05:10:24] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 392 minutes) Pathoschild (waiting 61 minutes) [05:10:25] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 805 minutes) CristianCantoro (waiting 750 minutes) Dapete (waiting 561 minutes) Pathoschild (waiting 48 minutes) [05:23:49] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 405 minutes) Pathoschild (waiting 75 minutes) [05:23:50] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 819 minutes) CristianCantoro (waiting 764 minutes) Dapete (waiting 574 minutes) Pathoschild (waiting 61 minutes) [05:37:17] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 419 minutes) Pathoschild (waiting 88 minutes) [05:37:18] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 832 minutes) CristianCantoro (waiting 777 minutes) Dapete (waiting 588 minutes) Pathoschild (waiting 75 minutes) [05:50:42] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 432 minutes) Pathoschild (waiting 102 minutes) [05:50:43] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 846 minutes) CristianCantoro (waiting 791 minutes) Dapete (waiting 601 minutes) Pathoschild (waiting 88 minutes) [06:04:07] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 446 minutes) Pathoschild (waiting 115 minutes) [06:04:08] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 859 minutes) CristianCantoro (waiting 804 minutes) Dapete (waiting 615 minutes) Pathoschild (waiting 102 minutes) [06:17:31] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 459 minutes) Pathoschild (waiting 128 minutes) [06:17:32] Warning: There are 4 users waiting for access to tools project, displaying last 4: Incola (waiting 873 minutes) CristianCantoro (waiting 818 minutes) Dapete (waiting 628 minutes) Pathoschild (waiting 115 minutes) [06:31:00] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 472 minutes) Pathoschild (waiting 142 minutes) [06:31:01] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 886 minutes) CristianCantoro (waiting 831 minutes) Dapete (waiting 642 minutes) Pathoschild (waiting 128 minutes) Happy5214 (waiting 3 minutes) [06:44:21] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 486 minutes) Pathoschild (waiting 155 minutes) [06:44:22] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 899 minutes) CristianCantoro (waiting 844 minutes) Dapete (waiting 655 minutes) Pathoschild (waiting 142 minutes) Happy5214 (waiting 17 minutes) [06:57:46] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 499 minutes) Pathoschild (waiting 169 minutes) [06:57:47] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 913 minutes) CristianCantoro (waiting 858 minutes) Dapete (waiting 668 minutes) Pathoschild (waiting 155 minutes) Happy5214 (waiting 30 minutes) [07:11:07] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 513 minutes) Pathoschild (waiting 182 minutes) [07:11:08] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 926 minutes) CristianCantoro (waiting 871 minutes) Dapete (waiting 682 minutes) Pathoschild (waiting 169 minutes) Happy5214 (waiting 44 minutes) [07:24:27] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 526 minutes) Pathoschild (waiting 195 minutes) [07:24:28] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 939 minutes) CristianCantoro (waiting 884 minutes) Dapete (waiting 695 minutes) Pathoschild (waiting 182 minutes) Happy5214 (waiting 57 minutes) [07:37:52] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 539 minutes) Pathoschild (waiting 209 minutes) [07:37:53] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 953 minutes) CristianCantoro (waiting 898 minutes) Dapete (waiting 708 minutes) Pathoschild (waiting 195 minutes) Happy5214 (waiting 70 minutes) [07:51:24] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 553 minutes) Pathoschild (waiting 222 minutes) [07:51:25] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 966 minutes) CristianCantoro (waiting 911 minutes) Dapete (waiting 722 minutes) Pathoschild (waiting 209 minutes) Happy5214 (waiting 84 minutes) [08:04:53] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 566 minutes) Pathoschild (waiting 236 minutes) [08:04:54] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 980 minutes) CristianCantoro (waiting 925 minutes) Dapete (waiting 735 minutes) Pathoschild (waiting 222 minutes) Happy5214 (waiting 97 minutes) [08:18:18] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 580 minutes) Pathoschild (waiting 249 minutes) [08:18:19] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 993 minutes) CristianCantoro (waiting 938 minutes) Dapete (waiting 749 minutes) Pathoschild (waiting 236 minutes) Happy5214 (waiting 111 minutes) [08:31:42] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 593 minutes) Pathoschild (waiting 263 minutes) [08:31:43] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 1007 minutes) CristianCantoro (waiting 952 minutes) Dapete (waiting 762 minutes) Pathoschild (waiting 249 minutes) Happy5214 (waiting 124 minutes) [08:45:07] Warning: There are 2 users waiting for shell, displaying last 2: Nobushigex (waiting 607 minutes) Pathoschild (waiting 276 minutes) [08:45:08] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 1020 minutes) CristianCantoro (waiting 965 minutes) Dapete (waiting 776 minutes) Pathoschild (waiting 263 minutes) Happy5214 (waiting 138 minutes) [08:55:23] !rq [08:55:23] https://wikitech.wikimedia.org/wiki/Shell_Request/$url_encoded_1?action=edit https://wikitech.wikimedia.org/wiki/User_talk:$url_encoded_1?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/$url_encoded_1 [08:55:29] * addshore fails [08:55:34] !rq Pathoschild [08:55:34] https://wikitech.wikimedia.org/wiki/Shell_Request/Pathoschild?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Pathoschild?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Pathoschild [08:58:31] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 1034 minutes) CristianCantoro (waiting 979 minutes) Dapete (waiting 789 minutes) Pathoschild (waiting 276 minutes) Happy5214 (waiting 151 minutes) [09:01:20] is there any wiki to cluster mapping info available on tools labs? [09:06:21] petan: is there any wiki to cluster mapping info available on tools labs? i need this info within a shell script [09:07:02] "wiki to cluster mapping info" ?? [09:07:02] what do you mean [09:07:21] enwiki -> s1labsdb , frrwiki -> s3labsdb [09:07:38] hmm [09:07:49] yes [09:07:53] check /etc/hosts [09:10:17] yes, this could help. [09:12:00] Warning: There are 5 users waiting for access to tools project, displaying last 5: Incola (waiting 1047 minutes) CristianCantoro (waiting 992 minutes) Dapete (waiting 803 minutes) Pathoschild (waiting 289 minutes) Happy5214 (waiting 164 minutes) [09:33:57] * addshore points petan towards his tool user creating duties ;p [09:34:11] * addshore notices petan has already done this... [09:34:18] :P [09:39:59] @notify anomie [09:39:59] I'll let you know when I see anomie around here [09:40:15] @seenrx [Aa]nomie [09:40:16] petan: Last time I saw anomie they were quitting the network with reason: Quit: Leaving at 5/26/2013 11:50:12 AM (1.21:50:03.9697960 ago) (multiple results were found: anomie_, anomie|work, anomie|brb, anomie|lunch, anomie|dinner and 1 more results) [09:41:33] addshore: and fail again, you're looking for !tr instead ;-) [09:41:42] valhallasw: shhh :) [09:41:54] oh, he had also a shell request. never mind [09:41:56] your not meant to spot these things! [09:42:12] you're [09:42:20] [/pedantic annoying bastard-mode] [09:42:20] :< [09:42:45] Coren ping [09:42:49] @notify Coren [09:42:50] This user is now online in #wikimedia-labs. I'll let you know when they show some activity (talk, etc.) [09:57:06] has anyone already implemented sth that can detect if a script runs on tool labs or toolserver? [09:59:24] Merlissimo: hostname -f ? [10:00:26] except that breaks on sunOS [10:00:40] valhallasw: not allowed on toolserver willow [10:01:06] python -c "import socket; print socket.getfqdn()" :-) [10:01:44] output of `which take` or `which jsub`? [10:02:28] jsub is not available on tool labs execd [10:02:33] Merlissimo: of course, it's better to not actually rely on 'TS or labs' knowledge, but rather using 'is qcronsub available? is jsub available?' [10:02:54] but taht's also a lot more complicated [10:02:55] hmm? IIRC it was added a couple of days back... [10:02:59] i need it for creating a database [10:03:22] and the database creating shema is different p_mmt_ vs p123123p13123__ [10:06:29] petan: is there any special reason why submitting jobs from execution hosts is not allowed or is this only not implemented yet? [10:08:18] It wasn't there from web hosts until a few days ago, and then it was only an oversight that was corrected soon [10:08:23] so I suppose that might be the same case [10:31:12] I can't access /data/project/ at bots-login [10:31:24] Transport endpoint is not connected [10:31:39] please help ;-) [10:37:49] petan: accepted btw [10:52:23] i cannot run select on replication databases although grants seems to be ok [10:56:13] seems to be a problem on s3 [10:56:16] only [11:00:54] can anybody check if that problem is limited to my account or affects other users, too? [11:18:04] petan, Coren ^^ [11:24:09] addshore? [11:24:29] Pyfisch hi [11:36:25] Merlissimo which problem [11:37:09] Merlissimo I don't know if this is by design, I myself see nothing wrong on submitting jobs from exec nodes as well [11:37:27] petan: MariaDB [frrwiki_p]> select * from page limit 1; [11:37:27] ERROR 1045 (28000): Access denied for user 'p50380g50506'@'%' [11:38:23] hmm [11:38:24] for sge: submitting jobs from execution host would be nice. [11:38:29] I have the same problem [11:38:45] !report [11:38:45] to report new bug open: https://bugzilla.wikimedia.org/enter_bug.cgi [11:38:52] hm [11:38:55] I think you should report it [11:39:00] only s3 [11:39:05] I have no access to replica servers [11:39:11] so I can't fix this [11:39:19] only Coren or binasher can do that [11:53:16] hello petan, didn't saw you [12:00:43] hi [12:18:57] Warning: There is 1 user waiting for shell: Strix (waiting 0 minutes) [12:32:22] Warning: There is 1 user waiting for shell: Strix (waiting 13 minutes) [12:45:55] Warning: There is 1 user waiting for shell: Strix (waiting 27 minutes) [12:46:48] Hello, there is something wrong in my jsub :( when I run this, It works but when I add it to jsub returns this error : [12:46:49] node /data/project/wikitest-rtl/public_html/w/extensions/Parsoid/js/api/server.js [12:47:02] FATAL ERROR: v8::Context::New() V8 is no longer usable [12:47:14] my jsub is jsub -N Parsoid -continuous node /data/project/wikitest-rtl/public_html/w/extensions/Parsoid/js/api/server.js [12:47:25] I don't what is wrong here [12:47:51] I don't know [12:48:11] petan [12:48:23] I bothered you already so much [12:48:59] If i can run it on screen that would be great [12:49:45] Amir1: that sounds like an issue with node.js rather than jsub [12:51:08] Amir1: google suggests it might be a memory issue. Try running it with -mem 512M [12:52:21] valhallasw: ok let me do that [12:52:35] hi [12:53:36] Amir1 this is indeed some error returned by node binary, unless you have more output it's hard to understand why it doesn't work [12:54:08] when i run it on terminal it works [12:54:31] that why I'm saying problem is maybe jsub [12:54:33] that's because you have no memory limit when you run it on a terminal [12:54:43] Amir1 you can try to run this by hand in terminal on tools-dev then check how much virtual memory it uses [12:55:06] if it's more than what you give it, increase the memory in jsub [12:55:55] petan: how much do you think this needs? can I make it unlimited in jusb? [12:56:08] I have no idea but if you start it by hand you will see it [12:56:24] also, can you tell me a number of job after you submit it to grid? [12:56:37] valhallasw: It didn't work let me make it little higher [12:56:55] Amir1 how long does it usually takes for it to execute [12:57:37] petan: the old that i deleted it is 147540, the new one is 147597 and usually takes 30 secs [12:59:24] Warning: There is 1 user waiting for shell: Strix (waiting 40 minutes) [13:00:07] Amir1 I think you should wrap it into a script and load all variables before you start it [13:00:11] anomie hi [13:00:20] hi petan [13:00:56] anomie I would very much like to restart sql server on tools project, it shouldn't take more than 1 minute, and you are the only user who is actually using it. Is your bot able to handle that, or should I schedule some outage? [13:01:16] ok but how [13:01:27] petan: Let's find out! [13:01:44] Amir1 create a shell script and put the command into it, then put something like . ~/.profile into the header [13:02:17] anomie does it mean I can restart it? :P [13:02:17] brb [13:02:35] petan: Yeah. If my bot has issues, I can just restart it. [13:02:42] ok... [13:03:08] !log tools petrb: moving the binary logs on tools-db to new location on vdb [13:04:29] I will first copy the old logs and after that I will just restart the server to apply new settings, it should take no more than 20 seconds [13:08:10] petan: we should really have qacct available to all users [13:08:45] petan: is it ok? [13:08:48] #!/bin/sh [13:08:50] node /data/project/wikitest-rtl/public_html/w/extensions/Parsoid/js/api/server.js [13:09:30] valhallasw are you sure qacct isn't available? [13:10:02] Amir1 it is ok, but first: you should run this by hand only on tools-dev never on -login 2) you should load the profile on top of script [13:10:18] petan: /var/lib/gridengine/default/common/accounting is not shared to -login [13:10:37] valhallasw anyone can ssh to tools-master [13:11:16] I can't [13:11:24] what does it say? o.O [13:11:50] is closes the connection [13:12:21] !log tools petrb: restarting sql so that it takes new config - no users are connected except for anomie bot [13:12:38] petan: but I think /var/lib/gridengine/default/common/accounting should really just be shared over NFS [13:12:53] Warning: There is 1 user waiting for shell: Strix (waiting 54 minutes) [13:20:46] valhallasw how does it close it [13:21:46] petan: http://pastebin.com/8pTyQyL9 [13:23:02] that is weird, can anyone else confirm it doesn't work? I don't know why it happens... [13:23:12] .ssh/id_rsa is my labs-internal private key; connections to tools-login and tools-dev (from tools-login) both use it [13:23:31] I have only 1 account :/ [13:23:34] connections to tools-exec-* use hostbased [13:24:18] petan: you might be whitelisted as admin? [13:24:28] petan: It looks like the restart took longer than you thought, and a few of the bot tasks died because they stopped retrying after about a minute. I suppose I should increase that. [13:25:05] anomie sorry about that :( I forgot to update the .index file that's why it took so long, first attempt to start it failed [13:25:49] anomie I don't expect this to happen often so I don't know if you really need to increase anything [13:26:18] Warning: There is 1 user waiting for shell: Strix (waiting 67 minutes) [13:26:50] petan: No big deal, I got the bot restarted without any issues. [13:27:11] petan: 1- what is the address of tools-dev? 2-what should I name this script? [13:27:44] Amir1 just ssh tools-dev from login OR ssh user@tools-dev.wmflabs.org [13:27:57] Amir1 2) whatever. like start-js.sh [13:28:31] ok [13:29:01] Amir1 the only difference between running it using grid and running it by hand is actually that there is a memory limit and clear environment [13:29:07] I think that is the problem [13:29:18] you don't have any environment loaded and your script needs it [13:30:02] maybe the problem is not environment and (maybe) it's memory usage [13:30:31] Amir1 when you run it on -dev you can check how much memory it uses while it run [13:30:40] how? [13:30:43] top [13:30:45] or htop [13:39:52] Warning: There is 1 user waiting for shell: Strix (waiting 81 minutes) [13:40:01] petan: I used top and it's output: 859 ganglia 20 0 77676 8216 1644 S 3.3 0.4 342:31.90 gmond [13:40:03] 3 root 20 0 0 0 0 S 0.3 0.0 0:38.22 ksoftirqd/0 [13:40:04] 19514 syslog 20 0 183m 4112 932 S 0.3 0.2 1:21.93 rsyslogd [13:40:06] 1 root 20 0 20080 1980 1100 S 0.0 0.1 0:06.21 init [13:40:19] neither of these 4 is your process [13:40:26] Amir1 start it, then tell me I will check it [13:40:28] but It's runnig [13:40:39] I ran it on dev [13:40:42] what user? [13:40:56] wikitest-rtl [13:41:01] I became that [13:41:18] should i become back to ladsgroup [13:41:19] ? [13:41:35] it uses 660mb of virtual memory [13:41:52] that means you need to start it with -mem 680m at least [13:41:56] or more [13:42:08] can i run with 1024mb? [13:42:16] It's round :P [13:42:26] yes [13:42:40] ok [13:42:41] thank [13:44:02] It's working [13:44:07] thanks [13:45:50] yw [13:53:21] Warning: There is 1 user waiting for shell: Strix (waiting 94 minutes) [13:53:22] Warning: There is 1 user waiting for access to tools project: Mormegil (waiting 3 minutes) [13:57:08] !rq Strix [13:57:08] https://wikitech.wikimedia.org/wiki/Shell_Request/Strix?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Strix?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Strix [14:19:56] Warning: There is 1 user waiting for shell: Pecoes (waiting 0 minutes) [14:33:17] Warning: There is 1 user waiting for shell: Pecoes (waiting 13 minutes) [14:46:50] Warning: There is 1 user waiting for shell: Pecoes (waiting 26 minutes) [14:57:25] @notify Coren [14:57:25] This user is now online in #wikimedia-labs. I'll let you know when they show some activity (talk, etc.) [14:57:36] Coren how is mysql server backed up [15:00:19] Warning: There is 1 user waiting for shell: Pecoes (waiting 40 minutes) [15:07:58] @infobot-detail rq [15:07:59] Info for rq: this key was created at 5/14/2013 8:26:20 AM by petan, this key was displayed 68 time(s), last time at 5/28/2013 3:07:49 PM (00:00:09.5497640 ago) this key is normal [15:08:37] Is there a way to updata an instance if the disk has becoe to small, or do I have to recreate it with more disk space... my problem ist that the result of a mysql export can not be written to /tmp Query: SELECT mathindex_page_id,mathindex_anchor,math_mathml,math_inputhash,mathindex_inputhash FROM `mathindex`,`math` WHERE math_inputhash = mathindex_inputhash ORDER BY mathindex_page_id Function: CreateMath::execute Error: 126 Inco [15:09:38] physikerwelt technically it's possible, but it's complicated and you need to ask Ryan or someone with direct access to host [15:10:02] why don't you write it to /data/project instead of /tmp [15:10:24] I would have to configure mysql to write the result of joins to another place [15:11:10] I don't think you would be able to insert a disk or extend existing without reboot or config change either [15:11:33] you can always create a symlink in /tmp that point to /data/project [15:11:45] in that case you don't need to change any config [15:11:57] ok I [15:12:20] 'll delete /tmp and link it to /mnt/mysqltmp [15:12:34] I don't have /data [15:15:30] thank's a lot [15:26:21] Warning: There is 1 user waiting for shell: Auduwage (waiting 0 minutes) [15:28:29] is !Coren here today? [15:39:50] Warning: There are 2 users waiting for shell, displaying last 2: Auduwage (waiting 13 minutes) Nettrom (waiting 12 minutes) [15:39:51] Warning: There is 1 user waiting for access to tools project: Nettrom (waiting 2 minutes) [15:48:22] legoktm what do u need [15:48:42] !rq Auduwage [15:48:43] https://wikitech.wikimedia.org/wiki/Shell_Request/Auduwage?action=edit https://wikitech.wikimedia.org/wiki/User_talk:Auduwage?action=edit§ion=new&preload=Template:ShellGranted https://wikitech.wikimedia.org/wiki/Special:UserRights/Auduwage [15:48:49] https://bugzilla.wikimedia.org/48897 [15:51:41] petan: ^ [15:51:49] I see [15:51:54] no access there... [15:52:56] :/ [15:53:14] oh someone just filed https://bugzilla.wikimedia.org/48899 [15:53:20] Warning: There is 1 user waiting for shell: Nettrom (waiting 26 minutes) [15:56:27] I created a keyword for this, similar to ops [15:56:41] it's called replica - it means it needs to be solved by dba [16:00:04] ah, great [16:03:10] hey Danny_B -- catgraph can do cycle detection now, that should be useful for the czech wiki. look here: http://toolserver.org/~jkroll/catcycle/catcycle.py?lang=cs&parentcat=Kategorie&depth=10&action=find-cycles [16:05:34] i also found that the czech wiki has not a single root category, that means, one without a "parent" category. maybe once some cycles are found&broken, a root category will appear [16:06:42] :o [16:06:52] Warning: There is 1 user waiting for shell: Nettrom (waiting 39 minutes) [16:07:26] why is legoktm a Freebie [16:08:44] I'm watching Arrested Development and someone just said "Well that was a freebie" [16:11:39] Hello, everyone! I was recently given shell access to Wikimedia labs. I have absolutely no experience with this - I'm merely an anti-vandal editor over at en-wp. However, I'm also running the video tutorials project (en:WP:VIDTUT), which needs to operate as an SWF file for full functionality. Someone told me that Wikimedia labs could help with that, and Addshore gave me access. As stated, I have no idea what I'm doi [16:20:22] Warning: There is 1 user waiting for access to tools project: Dschwen (waiting 5 minutes) [16:21:10] !help [16:21:10] !documentation for labs !wm-bot for bot [16:23:50] !documentation [16:23:51] https://labsconsole.wikimedia.org/wiki/Help:Contents [16:27:15] jacksonpeebles: Welcome! I'm available to help with technical questions but not so much with vision questions :) [16:27:34] Do you know what you /want/ to do? [16:27:52] Not exactly. I don't know what Wikimedia labs LETS me do. [16:28:19] I want to host an SWF on Wikimedia servers under a free license. [16:29:12] And commons won't host swf files, I presume? [16:29:26] Correct. [16:29:56] Hm... [16:29:58] Only OGG, and I need the interactivity of the SWF, even though it's propietary. This is funded by a WMF grant. [16:30:24] I can also do HTML5, if that helps... [16:31:00] Do you need hosting for wiki pages as well, or do you have a wiki elsewhere and just want to point it to the file? [16:31:20] Really I just need to point to the file, I suppose. [16:31:38] I have my own host, but WMF has ownership of these files. [16:32:02] Embedding in some way would be nice, too, but I'm not going to get TOO picky ;-) [16:32:14] when you say ownership, do you mean because it involves trademarked stuff? [16:32:45] Yes [16:33:54] Warning: There is 1 user waiting for access to tools project: Dschwen (waiting 18 minutes) [16:35:29] So… we can definitely do what you need in labs. My only reservation is that labs is generally not used to host production-style content. It might be better to use some kind of misc production server. [16:35:45] Have you been working with any engineering staff on this? [16:37:00] No, I have not spoken with engineering, though I am willing to. This is way out of my area of expertise. Labs was recommended to me by another user as the potential solution. [16:37:39] yep, ok. Do you mind sending me an email with a brief sketch of what you need (just one paragraph is fine) and I'll forward it to the operations team for suggestions? [16:37:52] andrewbogott: I would hope Tool Labs is meant for production-style content [16:37:57] It might be that labs is the right solution, I'm just not sure. It doesn't seem right to have you administrate an entire server just to host a file :) [16:38:10] valhallasw: Yes, true. [16:38:23] Hm, actually... [16:38:28] (if it's just hosting, Tool Labs might be actually be the solution here) [16:38:45] Yeah, that's a good point. I think of tool labs as being all about bots but I guess hosting a file is pretty simple, right? [16:38:55] yes, just create a project and you have a public_html [16:39:13] Okay, guide me? :-) [16:39:20] ok! So, jacksonpeebles, that seems like the right thing to do. I'm not sure about hosting a swf file… it's probably ok; html5 is for sure OK. [16:39:44] Okay, I'll try HTML5 first. [16:39:45] I remember there are some issues with ftp/scp'ing to a project's public_html, though. Check with Coren or petan to be sure. [16:39:46] jacksonpeebles: I'm not sure I can issue toollabs accounts. I'm sure that Coren can. [16:40:28] valhallasw, is there a tool labs sign-up page? [16:41:32] Does it help that I have shell access to bastion.wmflabs.org [16:42:05] It does -- that means you're half-way there :) [16:42:47] Haha thank you so much for your help [16:42:57] I apologize for my gross lack of knowledge [16:43:02] jacksonpeebles, visit this page: https://tools.wmflabs.org/ click on 'request access...' [16:43:11] and then hang around here and nag for access if needed :) [16:43:44] Then you will want to 'create a new tool' [16:44:07] And then you should be able to just scp your file up. I'm not sure about access and/or the proper URL though… other folks here will be able to help. [16:44:41] hey [16:44:51] yes I am here now [16:44:52] :D [16:45:04] @requests [16:45:04] Warning: There is 1 user waiting for access to tools project: Dschwen (waiting 29 minutes) [16:45:43] Okay, https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Jackson_Peebles [16:46:23] I wait to request a new tool until after access is given? [16:46:48] yep [16:46:57] Although probably petan can give you access semi-immediately. [16:47:10] jacksonpeebles you already have access ;) [16:47:12] petan, jacksonpeebles just needs to host a file for web access. Can you talk him through that? [16:47:15] Thanks, petan [16:47:19] sure [16:47:25] !toolsdocs | jacksonpeebles [16:47:25] jacksonpeebles: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [16:47:52] basically, you create a new account for your tool, scp your files and that is all [16:48:54] Okay, thank you. That's not so bad. :-) [16:50:41] So I uploaded my SSH key, now I just connect using Filezilla or what? [16:50:55] exactly, but you should wait like 5 minutes [16:51:07] because the daemon that sync the key is running every 5 minutes [16:52:07] Alright, thank you so much. You guys are absolutely fantastic, I really appreciate the help. I hope to talk to you again, soon (but not too soon, lol)! Cheers! [17:05:20] yoohoo! [17:11:41] Does anyone know what's up with /data/projects on bots-login? It just tells me "Transport endpoint not connected" [17:12:11] gluster issue? [17:22:10] dschwen: I looked at that a couple of days ago… gluster looked OK but I can't remount the volume because it is 'busy'. [17:22:16] I'm not sure what to do short of rebooting. [17:22:25] ugh [17:22:38] dschwen, /data/projects is working elsewhere in bots, right? [17:22:40] unfortunately there is data I need to access on there [17:22:46] hold on [17:22:54] where else should I look? [17:23:25] doen't work on bots-gs either [17:23:48] hm, ok. Let me look [17:27:33] andrewbogott ok letś reboot it [17:27:39] if there is no other solution [17:28:04] There may be another solution but I don't know of one :( [17:28:17] Should we try bot-gs first to see if that fixes it there? [17:28:18] :-) [17:28:28] I don't know which will be less disruptive to reboot [17:28:30] fine with me [17:28:40] I have no input to give here [17:28:45] we can but -gs is more important than login [17:28:51] because it is master server of SGE [17:29:07] ok [17:29:24] best try with login then. Want me to do the honors? [17:29:33] ok [17:29:52] !log bots rebooting bots-login in hopes of getting /data/project back on line [17:30:11] :( [17:31:24] !log bots rebooting bots-login in hopes of getting /data/project back on line [17:31:26] Logged the message, dummy [17:33:01] Looks like that worked. [17:33:09] petan, think i should do the same on -gs? [17:54:23] andrewbogott you can [17:55:09] !log bots rebooting bots-gs to fix /data/project mounting problem [17:55:11] Logged the message, dummy [18:09:01] Could I get a project directory in /data/project on Tools? I assume you want this to be application specific rather than per-user? [18:09:52] please "mkdir qicbot vicbot gpsexifbot" [18:09:59] and chown dschwen :-) [18:11:44] dschwen, what you want is a tool group or groups… try the 'create new tool' link here: https://tools.wmflabs.org/ [18:12:27] hey can someone add 'awjrichards' to the tools project? [18:12:40] petan: andrewbogott ^ ? [18:12:52] sure [18:13:06] thank you, petan [18:13:46] dschwen, a tool has a home dir in /data/project as well as a user id. You can change yourself to that user with the 'become' command. [18:14:42] petan, is adding a user to tools the same as adding the to any other project? [18:14:59] andrewbogott yes [18:15:05] 'k [18:15:48] andrewbogott but if they request access using webpage you need to also send them a welcome message and update the request page, or the bot will keep complaining [18:16:16] How do I send them a welcome message? [18:16:25] there is a simple link [18:16:29] !tr andrewbogott [18:16:29] request page: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/andrewbogott?action=edit talk page: https://wikitech.wikimedia.org/wiki/User_talk:andrewbogott?action=edit§ion=new&preload=Template:ToolsGranted link: https://wikitech.wikimedia.org/w/index.php?title=Special:NovaProject&action=addmember&projectname=tools [18:16:36] click the second one [18:16:45] whois petan petan [18:16:56] thx [18:16:56] well, petan, who are you :) [18:17:02] aha :O [18:17:05] !petan [18:17:05] Petr Bena - http://enwp.org/User:Petrb [18:17:12] carl-cbm ^ [18:17:33] petan: nice cat [18:17:45] I got many cats :D [18:17:55] thanks [18:18:04] one of the first things I should do once I get a good enough place [18:18:09] also dammit you are only one year older than me [18:18:51] heh [18:18:58] I have bday soon [18:19:07] like 2 weeks [18:19:18] petan: do you have access to the http error logs on tools.wmflabs.org? [18:19:30] carl-cbm yes but you should have it as well [18:19:43] at least last week they were only available to sysops [18:19:47] carl-cbm: there is a file with error logs in a tool home [18:19:48] just gives me "Failed to create service group." [18:20:07] carl-cbm: since last week many things happened [18:20:13] like hackaton ;) [18:20:26] petan: which file is that? [18:20:34] the one with error in name [18:20:38] I dont remember [18:20:57] sec [18:21:03] I'm looking at the directory, and I cannot see it, just the access log [18:21:26] ok... [18:21:38] sigh, it silently created the "servicegroup" (after logging in to the wmflabs site) [18:21:57] now I cannot delete the superflous group I created [18:22:03] in any case the problem I am having is with the index page for one of my tools - it will run index.php but not index.py nor index.cgi [18:22:42] dschwen@tools-login:/data/project$ become qic [18:22:42] sudo: sorry, a password is required to run sudo [18:23:02] dschwen try relog [18:23:09] carl-cbm what is a tool name? [18:23:17] enwp10 [18:23:41] there is a file php_error.log which is empty :( [18:23:43] there should be a couple very recent 403 errors there [18:23:48] ok let me check then [18:24:04] yeah, it's index.py right now, so the php_error file will be empty [18:24:32] [Tue May 28 18:20:56 2013] [error] [client 10.4.1.89] Directory index forbidden by Options directive: /data/project/enwp10/public_html/ [18:24:40] [Tue May 28 11:15:27 2013] [error] [client 10.4.1.89] File does not exist: /data/project/enwp10/public_html/style/btn_stretch.png, referer: http://tools.wmflabs.org/enwp10/cgi-bin/pindex.fcgi [18:24:57] the directory index is the issue [18:24:58] do you want more of them? [18:25:12] ok [18:25:23] you need to have index page [18:25:35] I do have one: index.py [18:25:44] hmm [18:25:46] sorry, but what a pain in the neck. How can I copy files from my user home into the project home. I cannot even chgrp files to my project user [18:25:53] addshore do you have an idea how to fix it? [18:26:32] carl-cbm unfortunately I dont know much about the apache configs :/ I /think/ this can be fixed by changing .htaccess [18:26:37] but not sure how [18:26:54] petan: I suppose I will need to wait for Coren for it. The help page says there are only a few parameters that can be configured from htaccess [18:27:04] addshore knows more about apache and Damianz knows more about anything else :D [18:27:33] ok [18:28:24] petan: actually, it !does! let me set that parameter [18:28:36] great [18:29:34] now I jsut have to bug Coren about fixing CGI execution and everything will work! in the meantime, I can bootstrap with index.py [18:30:07] carl-cbm make sure to use bugzilla maybe someone else knows [18:32:39] Now that I have the error diagnosis, I'm in a position to actually file the bug. And, I can limp along in the meantime [18:48:58] hello [18:52:08] !log deployment-prep Fixed up the Wikidata wiki http://wikidata.beta.wmflabs.org/wiki/Wikidata:Main_Page {{bug|47827}} [18:52:12] Logged the message, Master [18:53:28] so gluster on bots-login is still down? [19:13:43] I'm unable to "become" my tool. the message says "sudo: sorry, a password is required to run sudo". [19:14:00] is there something i've missed ? [19:16:57] pleclown: Have you just created the tool? IIRC then you need to log out and log in again before you can access it. [19:18:25] I have had to log out and log back in, for reasons unknown, to get into a new tool [19:18:35] ok [19:18:39] i'll try [19:19:15] it worked [19:19:23] thx! [19:22:48] great, good luck with it [19:24:18] carl-cbm, pleclown: Tools have a special user group (the same name as the Unix name of tool, e. g. "local-tool"), but IIRC groups are "given" to Unix users only on login. So after the information "user group local-tool consists of users local-tool, user-a, user-b" is added to the system, user-a and user-b have to re-login to be recognized as group members. [19:29:17] scfc_de: opening a new bash withing your existing shell could solve this, too. [19:45:07] Coren: poke [19:46:50] Betacommand: Coren's on holiday till the weekend (https://wikitech.wikimedia.org/wiki/User_talk:Coren#On_Vacation). [19:47:27] Oh I see how it is [19:47:31] petan: poke [19:47:42] hey [19:48:01] petan: can you install 7zip ? [19:48:53] yes, where [19:49:02] tools [19:49:15] ok your tool needs to use it or you just need to use it? :P [19:49:22] I suppose you just need it to unzip stuff [19:49:24] Betacommand: Didn't you see my reply that p7zip was already installed? [19:49:27] so I will only install it to bastion hosts [19:49:37] aha [19:49:39] here we go [19:49:48] p7zip is indeed on tools [19:50:07] Betacommand: The remaining question was whether you need p7zip-full as well. [19:50:08] * Betacommand goes to check [19:50:08] scfc_de I think we should merge these different sql tools together [19:50:15] scfc_de I noticed your patch [19:50:30] petan: Yep, but I haven't read up on all comments yet. Later. [19:50:38] scfc_de it has some advantages but it also doesn have the replica fix which makes it easier for newbies [19:51:49] petan: Yes. I don't know how/when Coren will fold the DB credentials together, though. It can probably wait till he's back. [19:51:52] andrewbogott can you +2 stuff in puppet? I think I will need to merge stuff later, not now [19:52:05] Yeah, I can merge things. [19:52:11] scfc_de he is not going to do that [19:52:39] scfc_de on hackaton he told me he wants to keep .my.cnf non existing by default to leave the users option to put anything there [19:53:02] scfc_de so by default you need to append --defaults-file option to mysql if you want to access replicas [19:53:56] petan: No, I don't -- my ~/.my.cnf works for replicas :-). [19:54:10] scfc_de ok /your/ does but other people may not have it [19:54:35] that is why sql script I created check if .my.cnf or replica exist and combine them together [19:54:45] like if there is no .my.cnf it uses the replica file [19:54:48] The question is more how and when he folds scfc@tools-db and u1234@replicas. [19:55:00] if there is .my.cnf it uses it for local databases but uses replica for replicas [19:55:16] I dont think he will [19:55:25] very likely it will stay as it is [19:55:54] that tool I made /should/ get you anywhere [19:56:01] sql local is tools-db [19:56:09] petan: The program '7z' is currently not installed. To run '7z' please ask your administrator to install the package 'p7zip-full' [19:56:10] Yep. But apart from the sql script, having no credentials in ~/.my.cnf will cause a headache for many people who don't know how to set get_defaults_file or whatever the MySQL option in their programming language is. [19:56:22] Betacommand sec [19:56:45] scfc_de they /can/ copy it [19:56:51] to .my.cnf [19:57:42] lol. Alcohol abuse -> Addiction psychiatry [19:57:46] Addiction psychiatry -> Substance-related disorders [19:57:50] Substance-related disorders -> Alcohol abuse [19:58:01] sums it up quite well i think xD [19:58:24] petan: To quote a not so good movie: "Assumption is the mother of all fuckups." :-) So I'm pretty fine with waiting for his return and decision (and the reasoning behind it). [20:00:14] !log tools petrb: installing p7zip-full to -dev and -login [20:00:16] Logged the message, Master [20:00:44] JohannesK_WMDE: I don't know whether "Addiction psychiatry" means treating people from addiction, or the "psycholyse" stuff that some "physicians" are into. [20:00:51] scfc_de sure [20:01:37] scfc_de I dont say I prefer this, it is just what I heard from him. What I want is to make sql command user friendly [20:01:50] so that when someone join tool project it just work right away [20:02:22] which in this moment require check if .my.cnf contains proper credentials or not and if not, load them from replica file [20:02:23] petan: co to delas na tech labech? shazujes mi programy... [20:02:44] Danny_B ?? [20:03:02] Danny_B co jsem ti shodil? [20:03:19] Betacommand installed [20:05:17] petan: I agree with the reasoning, but find the solution (compared to just supplying a useful ~/.my.cnf) suboptimal :-). [20:05:27] indeed [20:05:48] but you can never make it use only .my.cnf there are already people with 2 different logins [20:06:02] you cant just rename existing sql accounts [20:08:33] petan: If you are root, you can. [20:08:58] I dont think it is simple :/ [20:09:13] if you rename sql account you will have inconsistent permissions or not? [20:09:26] I am more an oracle guy and I know in oracle renaming a user is pain in the ass [20:10:09] if he find out how to merge these 2 accounts, I dont mind but imho I like more named accounts like petrb rather than u54562462436 [20:11:29] usernames are already unique [20:11:42] I think replicas could use them [20:13:00] scfc_de on other hand - I like your sql version but if we uploaded it as it is now to tools project, most of people would not be able to use it [20:13:03] petan: I prefer named accounts as well, and I think they should be folded onto them. Of course, renaming isn't just one command, but requires a bit more planning, but in the long term I find it much nicer if I could connect as scfc or local-wikilint to tools-db and the replicas without worrying about anything. [20:16:14] petan: Well, they are used to typing "mysql -h HOST --defaults-file replica.something DB", so I think "move replica.my.cnf to ~/.my.cnf" wouldn't hurt their brains too much, but adding "--defaults-file" to "my" sql script is certainly nothing I'm fundamentally opposed to. I'll work on another patchset. g2g. [20:17:33] scfc_de no they are not, more than 20 new people joined tools during hackaton and they have no idea what replica file is... why not just make it user friendly? it is just one check in shell script [21:46:14] Ok. Coren, petan, and addshore: What's the status of replication. [21:46:16] ? [21:48:09] Is anybody here online? [21:48:17] and setting up labs. [21:48:34] I am -- but I think most people are in Europe and/or recovering from travel back from Europe. [21:49:08] So what's the status of replication? [21:49:42] What's working and what's not? [21:50:03] I'm looking for docs... [21:53:17] well… I can't find any concise summary. Probably best to catch Coren when he appears. [21:56:02] * Cyberpower678 bites Coren  [22:12:31] Warning: There is 1 user waiting for shell: Konarak (waiting 0 minutes) [22:25:57] Warning: There is 1 user waiting for shell: Konarak (waiting 13 minutes) [22:32:40] Cyberpower678: As far as I know, replication is working except for s7 (which will be finished soon). Also, as far as I know it's not yet possible to join against Commons or Wikidata (unless you're joining against something on the same shard). And some tables/columns available on the toolserver aren't (yet) available in Tool Labs. More details: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Database_access [22:35:31] anomie|away, how do I access them. What is the host? [22:39:07] Cyberpower678: See the link, it's all documented there [22:39:30] Warning: There is 1 user waiting for shell: Konarak (waiting 27 minutes) [22:52:51] Warning: There is 1 user waiting for shell: Konarak (waiting 40 minutes) [23:06:24] Warning: There is 1 user waiting for shell: Konarak (waiting 54 minutes) [23:19:53] Warning: There is 1 user waiting for shell: Konarak (waiting 67 minutes) [23:33:26] Warning: There is 1 user waiting for shell: Konarak (waiting 81 minutes) [23:46:54] Warning: There is 1 user waiting for shell: Konarak (waiting 94 minutes)