[00:26:17] addshore, things are getting very peachy around here. :p [00:29:12] Coren, will there be a phpMyAdmin for labs to access the databases with? [00:31:45] Cyberpower678, no, phpmyadmin is banned due to a history of security problems, including with the latest package in our Ubuntu release. [00:32:00] -.- [00:32:13] Then what can I access the replication database with? [00:32:42] Cyberpower678: 'mysql' [00:32:53] on the interface? [00:33:01] no, the command mysql ;p [00:33:20] where do I use the command? [00:33:30] from -login [00:33:53] Ok, so on the interface. [00:34:21] once youve sshed in [00:34:32] * Cyberpower678 goes to get the noose. [00:35:16] It doesn't work. [00:35:18] take a look at http://www.jveweb.net/en/archives/2011/03/managing-mysql-from-the-command-line.html < it has lots of the usefull commands [00:35:45] such as "show tables;" and basicly how to do everything to some degree [00:36:28] Why does labs have to be so damn complicated? [00:39:51] I'm already hating this. >:( [00:40:01] mysql sucks [00:40:32] What's wrong with phpMyAdmin? [00:41:28] Cyberpower678: What do you want to do? [00:43:26] Look at tables. [00:43:37] and different databases. [00:43:41] like on toolserver. [00:44:17] without all the interface crap. [00:44:42] scfc_de, ^ [00:47:46] Cyberpower678: Bad security: http://permalink.gmane.org/gmane.org.wikimedia.labs/901 http://permalink.gmane.org/gmane.org.wikimedia.labs/905 [00:49:09] scfc_de, is there an alternative? [00:51:17] Cyberpower678: Not that I know of. For inspecting databases and tables, I usually look at the documentation on mediawiki.org, and maybe "SELECT * FROM table LIMIT 5;" on the command line. (I don't find MediaWiki column names very self-explanatory :-).) [00:51:58] great. -.- [00:52:10] I hate command lines. [02:46:58] Warning: There is 1 user waiting for shell: Grv99 (waiting 0 minutes) [03:00:18] Warning: There is 1 user waiting for shell: Grv99 (waiting 13 minutes) [03:13:39] Warning: There is 1 user waiting for shell: Grv99 (waiting 26 minutes) [03:27:00] Warning: There is 1 user waiting for shell: Grv99 (waiting 40 minutes) [03:40:21] Warning: There is 1 user waiting for shell: Grv99 (waiting 53 minutes) [03:53:41] Warning: There is 1 user waiting for shell: Grv99 (waiting 66 minutes) [04:07:02] Warning: There is 1 user waiting for shell: Grv99 (waiting 80 minutes) [04:20:23] Warning: There is 1 user waiting for shell: Grv99 (waiting 93 minutes) [04:33:44] Warning: There is 1 user waiting for shell: Grv99 (waiting 107 minutes) [04:47:04] Warning: There is 1 user waiting for shell: Grv99 (waiting 120 minutes) [05:00:25] Warning: There is 1 user waiting for shell: Grv99 (waiting 133 minutes) [05:13:46] Warning: There is 1 user waiting for shell: Grv99 (waiting 147 minutes) [05:27:07] Warning: There is 1 user waiting for shell: Grv99 (waiting 160 minutes) [05:40:28] Warning: There is 1 user waiting for shell: Grv99 (waiting 173 minutes) [05:47:46] [bz] (NEW - created by: Adam Wight, priority: Unprioritized - enhancement) [Bug 48348] SVG upload on wikitech.wikimedia.org - https://bugzilla.wikimedia.org/show_bug.cgi?id=48348 [05:53:48] Warning: There is 1 user waiting for shell: Grv99 (waiting 187 minutes) [06:07:09] Warning: There is 1 user waiting for shell: Grv99 (waiting 200 minutes) [06:20:30] Warning: There is 1 user waiting for shell: Grv99 (waiting 213 minutes) [06:33:51] Warning: There is 1 user waiting for shell: Grv99 (waiting 227 minutes) [06:47:12] Warning: There is 1 user waiting for shell: Grv99 (waiting 240 minutes) [07:00:33] Warning: There is 1 user waiting for shell: Grv99 (waiting 253 minutes) [07:13:53] Warning: There is 1 user waiting for shell: Grv99 (waiting 267 minutes) [07:27:14] Warning: There is 1 user waiting for shell: Grv99 (waiting 280 minutes) [07:35:16] Warning: There is 1 user waiting for shell: Grv99 (waiting 1 minutes) [07:37:39] thx [07:37:42] >.< [07:38:07] XD [07:38:47] !ping [07:38:47] pong [07:38:47] !sh [07:38:48] http://bit.ly/10eZZoa [09:02:34] [bz] (NEW - created by: Tim Landscheidt, priority: Unprioritized - normal) [Bug 48338] Show grid status in Ganglia - https://bugzilla.wikimedia.org/show_bug.cgi?id=48338 [11:01:29] fuck gerrit [11:01:56] !topic ^^ [11:14:21] Coren need you to merge https://gerrit.wikimedia.org/r/#/c/63271/1/modules/toollabs/manifests/init.pp [11:15:50] 2 minutes writing code / 3 hours pushing to gerrit = 3 hours and 2 minutes spent "developing new features" [11:54:06] petan: gotta love it :D [11:54:15] ? [11:54:19] wut [13:24:02] [bz] (NEW - created by: Nemo, priority: Unprioritized - normal) [Bug 48358] Set up Arab wiki in beta - https://bugzilla.wikimedia.org/show_bug.cgi?id=48358 [13:51:05] can someone tell me how to access my databses? [13:51:12] sure [13:51:14] That is look at them. [13:51:22] 1. become [13:51:26] 2. mysql [13:51:30] that's all [13:52:09] Then what? [13:52:18] then do use [13:52:22] show tables [13:52:26] etc [13:52:33] read manual for mysql client [13:52:40] I do I see the databases? [13:53:18] huh? [13:53:39] I don't remember the database name. [13:53:40] show databases; [13:55:21] petan, I'm using the peachy database to help me to navigate through what will be the replacation databases. [13:55:37] ok [13:55:59] How can I view a table? [13:56:19] contents? [13:56:24] yes. [13:56:27] select * from table; [13:57:01] ugh. [13:57:19] I wish the formatting of the table looked a little better. :/ [13:57:30] it can be changed [13:57:38] ooh [13:57:38] see manual for mysql client [13:57:50] petan, you're my manual. :p [13:57:53] Cyberpower678: https://dev.mysql.com/doc/refman/5.5/en/index.html may be helpful [13:58:03] I don't know it :P [13:58:24] anomie, I'm teaching myself mySQL [13:58:38] (are the databases in tool labs still mysql, or did they move to mariadb?) [13:58:59] anomie, I'm using mySQL [13:59:48] maria [14:04:23] Hey it's actually kind of easy once you know it. [14:05:02] anomie, the advantage of my Peachy wiki is that I have an unrestricted testing fiels. [14:08:15] Cyberpower678: You're running MW under your tool labs tool? [14:08:28] Yes. [14:08:56] The tool is Peachy though. [14:09:10] It's designated for Peachy. [14:09:50] Gotta go. [14:13:17] Coren: on tools project, is there a process to request that resources be made available for use by multiple tools? In particular, I'm looking for a way to install pywikipediabot (both trunk and rewrite) so that they are available to all tools. [14:15:50] russblau which resources you mean? [14:16:03] there is a shared nfs server, you can save it there [14:16:05] Pywikipediabot framework [14:16:17] try /data/project/.shared [14:16:32] OK, will try that [14:17:32] Warning: There is 1 user waiting for shell: Inkowik (waiting 0 minutes) [14:18:44] petan, [14:18:46] local-russbot@tools-login:~$ mkdir /data/project/.shared/pywikipedia [14:18:47] mkdir: cannot create directory `/data/project/.shared/pywikipedia': Permission denied [14:18:58] uh, let me fix it... [14:19:48] try now... [14:20:04] worked, thanks! [14:20:14] !log tools petrb: fixed the permissions to shared folder [14:21:38] petan: could you do me a favor? I need libyaml-dev on tools-dev [14:21:49] ok [14:22:11] I also need the locales nb_NO.utf8 and fi_FI.utf8 [14:23:03] locales for what [14:23:15] lib is there [14:23:26] for dates [14:23:34] what package is it in? [14:24:16] no package, it's locale-gen nb_NO.utf8 I guess [14:25:21] !log tools petrb: ran sudo locale-gen nb_NO.utf8 on -dev [14:25:42] and fi_FI.utf8 [14:25:52] done too [14:25:56] !log tools petrb: sudo locale-gen fi_FI.utf8 [14:26:04] thx! [14:26:14] ye [14:26:16] yw [14:27:11] The program 'jstat' can be found in the following packages: [14:27:11] * openjdk-6-jdk [14:27:11] * openjdk-7-jdk [14:27:11] Ask your administrator to install one of them [14:27:25] (it might be a good idea to setup more languages as well before the requests starts coming, to make non-english users feel at home immediately ;)) [14:28:19] danmichaelo you needed that on -dev or grid widely? [14:28:42] on grid [14:28:51] the locales, that is [14:28:57] aha [14:29:01] well... [14:29:36] JackPotte: where do you need that jdk? [14:29:42] and which version you need? 6 or 7? [14:30:27] petan: I'm just trying to repair my crons, they don't work with jsub, so I've entered jstat to list them [14:30:33] my bot works with norwegian and finnish wikipedia, so I need to output dates in norwegian and finnish :) [14:30:48] like qsub / qstat on the Toolserver [14:30:58] Warning: There is 1 user waiting for shell: Inkowik (waiting 13 minutes) [14:31:16] ah [14:31:28] JackPotte I don't think there is any jstat, use qstat [14:31:37] thks [14:31:43] JackPotte qsub is here as well [14:32:00] !log tools petrb: ongrid sudo locale-gen fi_FI.utf8 [14:32:37] !log tools petrb: ran ongrid sudo locale-gen nb_NO.utf8 - this needs to be added to puppet [14:33:01] Coren ^ [14:36:49] JackPotte: I just put together an annotated job script, feel free to have a look: /data/project/ukbot/update_no.job . I submit it with qsub, not jsub [14:37:14] danmichaelo: I'm watching [14:38:54] it's more complex than it need be, but I'm learning about the different options [14:39:13] seems like walltime limit is not supported [14:40:21] don't see any walltime into http://gridscheduler.sourceforge.net/htmlman/htmlman1/qsub.html [14:44:19] Warning: There is 1 user waiting for shell: Inkowik (waiting 27 minutes) [14:54:41] russblau: The basic idea is that if I have a .deb of it, I can deploy it to the grid. :-) [14:55:58] [bz] (NEW - created by: Tim Landscheidt, priority: Unprioritized - normal) [Bug 48338] Show grid status in Ganglia - https://bugzilla.wikimedia.org/show_bug.cgi?id=48338 [14:57:41] Warning: There is 1 user waiting for shell: Inkowik (waiting 40 minutes) [15:02:29] JackPotte: I'd be happy to help you work your cron entries. You say they didn't work, what was in the *.err files? [15:02:47] (BTW, the WT task is currently running) [15:02:57] Coren did u merge these patches? [15:03:25] Haven't looked at gerrit yet this morning. Did you add me as reviewer? [15:03:31] Coren: won't you be present to the Hackathon? [15:03:39] JackPotte: I'll be there [15:03:55] Coren: so I'll prepare my questions [15:04:24] JackPotte: Works for me. Sometimes, a complicated remote problems takes 5 minutes to fix when sitting next to each other. :-) [15:04:45] I'm taking the train from Paris the 23/05 at 14h25 [15:04:55] petan: Add me to reviewers so I can see and find the changesets. [15:05:35] https://gerrit.wikimedia.org/r/#/c/63271/ [15:05:47] JackPotte: I arrive in Bruxelles with the TGV on the 23rd, and drive to AMS from there. [15:06:19] petan: The good practice is still to add me to tool labs changesets so I can see them. :-) [15:06:40] good Coren, according to the .err files my cron problem didn't come from jsub [15:08:39] Coren dunno how, can't you just approve all pathes to that repository since you are the only one who can merge them? [15:09:16] like - you have +2 there so you should get a mail for every patch there? [15:10:50] petan: I do, but you have no idea how *many* of those we get. :-) If you add me as a reviewer on your patches, I see them on my landing page so I knew they need a review and merge. :-) [15:11:21] mhm... [15:16:10] Coren: Do you know about https://www.mediawiki.org/wiki/Git/Reviewers ? [15:16:41] anomie: I did not. Reading it now. :-) [15:19:16] Oooo! [15:28:27] There. I should now be automagically added to reviewers [15:31:36] Coren: The file paths being matched don't have a leading /, so you probably want "^modules/(gridengine|toollabs)/|^role/labs.*\.pp" instead. [15:32:09] !log tools petrb: replacing mysql with maria client on dev [15:32:38] anomie|away: Not for /role/ anyways since that's "manifests/role/.*", but modules /is/ at the top. Fixing. [15:33:35] * greenrosetta is counting the days to a database [15:39:46] greenrosetta: With luck, you can count on your fingers. :-) [15:39:57] I can only count to 21 [15:39:58] :D [15:40:24] sick and tired of waiting for toolserver [15:40:30] requested access almost 2 months ago [15:41:22] greenrosetta: To be fair, the TS is supported by just a few overworked part-time admins. Delays are understandable (although 2 months seems a bit on the high side) [15:41:24] Coren how do I get rid of this [15:41:26] You have more than one commit that you are about to submit. [15:41:27] The outstanding commits are: [15:41:28] 727ce92 (HEAD, production) removed the libxml because it breaks puppet [15:41:29] 2d28949 (origin/production, origin/HEAD) create a link to shared folder [15:41:31] a02bf0b inserted 2 more packages needed to compile [15:41:50] these 2 commits are probably approved, but for some reason it tries to insert them to another push [15:41:59] greenrosetta: Did you contact DaBPunkt as I suggested? [15:41:59] petan: git pull -ff should bring you up to date [15:42:21] Coren still same [15:42:36] petan: But I've yet to master git. The number of times I hosed my repo and had to rm -rf and clone anew is... distressing. [15:42:45] petan: You can also try to git rebase -i [15:42:45] scfc_de: I never got his contact info from you [15:42:51] And remove the changesets you don't want. [15:43:07] still same [15:43:12] git rebase show only 1 change [15:43:18] git-review show 3 [15:43:25] I will just push all 3... sigh [15:43:28] blame gerrit, not me [15:44:25] [2013-05-07 18:30:01] Either here on IRC or per mail. He sends mail to toolserver-l from his personal account, but you could of course also try ts-admins@toolserver.org. [15:47:08] Coren: The nice thing about Git is that it is essentially a giant graph with branches/tags/etc. pointing at some of the nodes. Once you have understood this, it's the most wonderful SCM I know. [15:48:05] scfc_de: I understand it in principle, but the workflow is baroque to someone who has used the more traditional source control systems for nearly three decades. :-) [15:52:30] Coren: I know, the initial transition is usually a bit problematic. But compared to the times when you had to "svn commit" (for eternity!) to see what changes your changeset will actually produce, almost paradise :-). (And "git command --help" gives you a man page! Written by people! With *useful* information!!eleven!) [15:55:48] scfc_de: What was wrong with svn diff? :-) [15:59:28] petan: Where is libxml2-dev included? [16:00:26] Oh, hah! It was already in dev_environ. :-) [16:01:06] Coren: *I* found it often difficult when you added/deleted files and modified them in the same changeset, or branching or squashing changesets, to see what was actually happening. My experience doesn't go back three decades, but on my first repo I felt proudly progressive when I chose CVS over RCS, and yet SVN made my head ache :-). [16:04:12] SGE running very steadily 15 jobs - we need more tools :-). [16:05:58] petan: Do you run labs-logs-bottie? [16:07:48] (Or rather wm-bot, I think.) [16:08:27] petan: Never mind, you're logging #wikimedia-toolserver already. Perfect! [16:09:19] lol :D Coren [16:09:26] didn't notice that [16:09:34] ok you can remove whole line then [16:13:33] petan: BTW, I've been giving some thought about how to structure the experimental/prod workflow, and I think what you want is to use the new puppetmaster:: classes on bots so that you can work off a /branch/, and we cherry pick the good bits to put back on main. [16:16:23] hmm.... that would work as long as we put everything throught experimental, otherwise it would be hard to keep them in sync [16:16:51] if you for example did a minor change directly on prod, it would never was applied on testing [16:17:20] Coren: Which branch feature do you mean, BTW? It doesn't seem to be configurable. [16:18:37] petan: "git pull --rebase"? [16:18:46] scfc_de? [16:19:58] petan: I mean if you puppetmaster::self on bots, you try changes in the local repo, and from time to time you rebase your changes on the production branch. [16:20:14] ah that [16:20:17] hmm [16:20:20] ok [16:21:25] scfc_de: Not puppetmaster::self, the new puppet::self classes which allow you to put a whole project on a branch [16:21:50] scfc_de: You make a clone of prod, and your whole project puppetizes from /that/ [16:24:16] Coren: Which file do you mean? manifests/role/puppet.pp or manifests/puppetmaster.pp? [16:24:24] (I see no magic in either of them.) [16:25:42] scfc_de: Look at puppetmaster.pp for the puppet::self::master / puppet::self::client [16:29:49] Coren: But that just does a snapshot of the production branch in /etc/puppet, and you still have to make it follow a other repo/branch on your own, don't you? There's no configuration variable where you can just set "git://github.com/petan/puppet" as origin and "tools-experimental" as branch, is there? [16:30:29] scfc_de: Ah, no, it still relies on the sysadmin to do whatever they want with the new clone, including replacing it with a branch. [16:30:50] Coren: Ah, okay. [16:30:53] scfc_de: It does set up puppet to work right under that scheme, though. [16:31:34] Coren: You confused me with "the new puppetmaster:: classes" as I believe this was working the exact same way before :-). [16:32:16] scfc_de: No, that's fairly recent. The ancestor is puppetmaster::self which can only configure just the one box locally; I meant puppet::self. :-) [16:33:16] Coren: Ah, so you want other boxes in Bots to use, say, bots-puppetmaster as their puppetmaster?! [16:33:46] scfc_de: Right, and bots-puppetmaster would then work off a branch so the whole project would be configured out of it. [16:34:40] Coren: Now we're on the same page :-). [16:35:05] Give +2 to bots admins, so the cycle can be fast and can't break prod, and cherry-pick the good stuff back onto prod when it matures. [16:35:45] Can you limit +2 to a branch? [16:42:35] petan, How do I specify which server to connect to like toolserver's clusters. [16:42:44] in mySQL [16:42:56] Cyberpower678 mysql -h [16:43:03] ah [16:44:42] scfc_de: I don't know. Also possible it to set up the local clone to /be/ the branch. [16:45:06] (I.e. not go through gerrit at all of experimental changes, then when appropriate squash and submit) [16:46:47] Coren: Of course, I do something similar on Toolserver (not related to Puppet: develop there, pull changes to my personal box, and commit them then to GitHub with my credentials). [16:54:04] Coren I managed to fuck up sql server on tools... I forgot puppet was disabled there and I ran it to test that new patch of share [16:54:15] I suppose you can ssh there are root? [16:54:31] it probably attempted to switch to nfs which failed and now public/keys isn't accessible there [16:54:36] so that it's not possible to ssh [16:54:36] I can, but man this is going to hurt if it managed to apply the NFS class. [16:54:41] otherwise it works... [16:55:00] * petan slaps petan [16:55:19] well, it shouldn't hurt really much... -db doesn't need nfs, neither gluster I suppose [16:55:26] or does it? [16:55:58] next time we disable puppetd somewhere, we need to put a huge DO NOT RUN PUPPET to motd.tail [16:56:15] It shouldn't, but there are so many dependencies around it that I never actually checked since this was a temporary server. [16:56:50] Toolserver seems to be infectious :-). [16:56:52] Phew. No, it didn't. We're okay. :-) In fact, I don't see why you can't log in [16:57:08] let me check maybe it started to work [16:57:10] scfc_de: -db is a temporary hack until we get the real DBs [18:18:18] WTF [18:18:42] WTF, what? [18:18:59] petan, ^ [18:19:00] freenode [18:19:02] chanserv is down, nickserv as well [18:19:04] half of network crashing [18:19:04] : [18:19:05] meh [18:19:07] petan, this is certainly a dilemma. How do you op now? [18:19:17] lol [18:19:18] I don't [18:19:22] I am rather concerned about wm-bot [18:19:22] :o [18:19:27] wm-bot is here. [18:19:29] yes but not cloaked :/ [18:19:29] I will have to restart it later [18:19:29] or... [18:19:29] mm [18:19:51] If half of freenode just went down, then how come we're still here? [18:19:59] we are on lucky half [18:20:30] MemoServ is down as well. [18:21:15] Fuck. All cloaks are disabled. [18:22:31] petan, cloaks are disabled. [18:22:45] What is going on? [18:22:50] they are not lol [18:22:59] just the freenode is borked [18:23:10] petan, log off and log on. [18:23:25] well, there is no nickerv so of course I wouldn't get it [18:23:32] Cloaks are broken to be more correct. [18:23:41] everything is broken! [18:23:51] And when I logged in to my iPad, my cloak vanished. [18:23:56] PANIC! [18:23:58] :P [18:24:10] * Cyberpower678 sets this place on fire. [18:24:25] He's now shout apocolypse on Wikipedia. [18:25:38] Is now using his iPad. [19:29:50] hi, any admins here? I need some help adding locales on the grid [19:30:36] * Damianz pokes Coren [19:30:55] danmichaelo: I'm here-ish. What locales do you need? [19:31:14] nb_NO.utf8 and fi_FI.utf8 [19:34:33] Gimme a minute. [19:40:03] sure [19:42:55] Damianz: It's being pushed now. [19:43:07] * Damianz pats Coren's tab key [19:43:14] thx, appreciate it! [19:43:26] Stop starting with the same letters. :-) [19:43:38] I was here first :P [19:44:08] it's not the same, mine is d, not D ;) [19:44:34] ugaga [19:44:58] it's considered as the same letter most of the time [19:45:29] I might go back to camel casing just to confuse people [19:51:00] danmichaelo: {{done}} [20:45:26] @requests [20:45:26] There are no shell requests waiting [21:32:56] @seenrx chanserv [21:32:57] petan: I have never seen chanserv [21:33:05] @seenrx ChanServ [21:33:05] petan: Last time I saw ChanServ they were quitting the network with reason: shutting down at 5/11/2013 9:27:18 PM (00:05:46.6980090 ago) [21:33:11] :o [23:20:59] petan: FYI, we now have a proper way to install debs we make from a project-local repo. [23:50:00] Hey, on tools the become command is broken... [23:52:00] Matthew_: How? Works for me. [23:52:08] Huh... [23:52:20] matthewrbowker@tools-webproxy:/data/project/matthewrbowker/public_html$ become matthewrbowker [23:52:22] become: command not found [23:52:51] I think it's only on -login. [23:53:05] ... sadness [23:53:10] matthewrbowker@tools-webproxy:/data/project/matthewrbowker/public_html$ ssh tools-login [23:53:19] If you are having access problems, please see: https://wikitech.wikimedia.org/wiki/Access#Accessing_public_and_private_instances [23:53:20] Permission denied (publickey). [23:54:07] Matthew_: Why does that make you sad? [23:54:12] Matthew_: No, log out from tools-webproxy, and then, from your own box, ssh tools-login.wmflabs.org. [23:54:52] Matthew_: Why are you on webproxy? [23:54:52] Oh! [23:54:52] You ssh'ed to tools.wmflabs.org [23:54:52] Coren: BTW, shouldn't login be restricted on proxy, exec nodes & Co.? I believe the webserver is closed as well. [23:55:06] And not to tools-login! [23:55:06] I didn't know there was a difference XD [23:55:06] scfc_de: I am working on it. :-) [23:55:09] Coren: Because I can't do anything :/ [23:55:25] Whoa, unicorn! [23:55:48] scfc_de: exec nodes have to be allowed, though, but they have a different banner now. [23:56:08] Matthew_: If you see the unicorn, it means it's working. :-) [23:56:21] Yay, thanks :) [23:56:30] So I have to do tools-login.wmflabs.org always? [23:56:34] * Coren nods. [23:56:43] OK [23:57:11] Coren: "ssh tools-webserver-01.pmtpa.wmflabs": "Connection closed by UNKNOWN" :-) [23:57:37] scfc_de: Like I said, I'm working on it. It's a coincidence that this is what I was working on, funnily enough. [23:58:43] OK, so how do I use PSFTP? I'm getting the same error. [23:58:45] Coren: Take your time, as long as you don't disable the whole cluster :-). [23:59:50] Matthew_: What error? (Caveat: I don't use Windows.)