[18:43:27] kristenlans: ggellerman jaufrecht_ dstrine meeple27 debrief in remaining time? [18:44:26] kristenlans: ggellerman jaufrecht_ dstrine meeple27 mbinder cool w/me. We also have Tea Time for a longer conversation, potentially [18:44:56] 6Team-Practices, 6Developer-Relations, 6Release-Engineering-Team, 15User-greg: Set up Code Review office hours - https://phabricator.wikimedia.org/T128371#2089287 (10greg) So, my thinking here: A bi-weekly (every two weeks) event scheduled for the -dev(?) IRC channel that is advertised as a "come work on... [18:44:58] I have something right at 11 but I'm free until them [18:45:00] *then [18:45:19] kristenlans: ggellerman jaufrecht_ dstrine meeple27 mbinder: there are other people in the phys room that Joel and I are in, so Tea Time [18:45:35] ggellerman: sounds ok to me [18:46:14] ggellerman jaufrecht_ dstrine meeple27 mbinder in the meantime, ping me if you want to chat [20:59:52] jaufrecht_: should I reschedule our meeting? Its just me and you [21:02:53] Just got back with lunch. 15 min? [21:04:49] jaufrecht_: sure [21:10:20] re: the thread "[teampractices] Use cases for work tracking, sub-projects, etc in Phabricator" - are there any examples of people using the sub-projects feature, yet? (if yes, please send them to the email thread :) [21:18:02] 5 more min, please [21:26:08] ggellerman: I probably won't get back to you until Wednesday. I have invited myself to a meeting to work on it then. [21:27:05] meeple27: thanks for clearly setting expectations [21:30:15] quiddity: from an earlier tpg meeting, I suspect the answer is "no" [21:30:34] nod. ty :) [22:53:03] mbinder: ready to log in to Phlogiston? [22:53:12] jaufrecht_: sure [22:53:23] what's your shell name? [22:53:30] and what's your shell name on your local computer? [22:55:19] jaufrecht_: "mbinder" [22:56:06] in both wmflabs and your local computer? [22:56:09] jaufrecht_: I believe so [22:57:18] okay, add the following to .ssh config: [22:57:51] https://www.irccloud.com/pastebin/P1PmP7rC/ [22:58:11] and then try ssh phlogiston-2.phlogiston.eqiad.wmflabs [22:58:21] jaufrecht_: which config? [22:58:44] on linux, it's the file ~/.ssh/config [23:00:42] jaufrecht_: Permission denied (publickey). [23:00:42] ssh_exchange_identification: Connection closed by remote host [23:01:22] try ssh mbinder@bastion.wmflabs.org [23:01:43] (I added the config info to the mac .ssh config, which is the same as linux) [23:02:13] same error with bastion [23:02:24] talk to brian [23:02:27] or bryan [23:02:29] ok [23:02:35] oh, wait [23:02:41] hmm [23:02:47] it ought to let you try password, maybe [23:02:58] but more importantly, you should upload your public key first [23:03:11] via the website [23:03:28] i'd give you more specifics if I could log in, but go to the ssh help page [23:03:41] it says the name of the link that will ultimately let you upload your public key [23:03:54] until you do that, ssh won't work without password, and I'm not sure they even allow password [23:13:09] jaufrecht_: bryan guided me through it and I can log in [23:13:53] cool, I see your directory [23:13:56] let me set up permissions [23:14:28] can you "psql phab" ? [23:15:41] jaufrecht_: psql: FATAL: role "mbinder" does not exist [23:16:11] 6Team-Practices: Support iOS team retrospective review with data analysis - https://phabricator.wikimedia.org/T128921#2090309 (10JAufrecht) [23:16:28] okay, I think that's what should have happened. granting it now. [23:17:06] try now [23:17:18] ok I have a prompt [23:17:38] okay, that should be everything you need to get all of the data 😏 [23:17:59] https://phabricator.wikimedia.org/T128921 [23:18:12] jaufrecht_: thanks. Ideally I would set this up to access through a GUI like SequelPro [23:18:28] you'll have to ask Bryan for any technical details to that [23:19:09] I think you'll need: 1) access in your tool of choice, 2) knowledge of the tables, 3) knowledge of how to map from what Josh wants to the tables [23:19:16] for 2), do you want to collaborate on a data dictionary? [23:19:35] jaufrecht_: I don't know what the latter means [23:19:46] a list of all tables and what they mean [23:20:04] I can do the first draft, and if you can mark it up with questions etc, that would help a lot [23:20:21] jaufrecht_: does the dump not have the tables defined? [23:21:14] no. And this isn't a dump, this is direct access to the live (dev) database [23:21:28] I mean, they have names and column names, but not definitions [23:21:38] bd808: I'm hoping to get into phlogiston's db via something like SequelPro. jaufrecht_ says you're once again the gatekeeper (keymaster? Zuul?) for technical details [23:22:20] bd808: if this is taking too much of your time, I'd be happy to schedule something [23:22:30] you will need to "tunnel" your access over ssh. let me find a wikitech page about how to do that sort of thing [23:23:06] mbinder: all I ask is that you help fix docs I send you to that are lame (or at least make notes about what was confusing) [23:23:15] bd808: can do [23:24:07] mbinder: MySQL Workbench actually has built in support. Some instructions here -- https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Configuring_MySQL_Workbench [23:24:30] or you can do raw ssh tunneling and use the tool of your choice (still looking for howto on that) [23:24:42] ah -- https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Connecting_to_the_database_replicas_from_your_own_computer [23:25:17] where it says things like "enwiki.labsdb" you would use "phlogiston-2.phlogiston.eqiad.wmflabs" instead [23:25:47] * bd808 isn't sure why that how-to uses a non-standard port [23:26:32] so something like "ssh -L3306:127.0.0.1:3306 phlogiston-2.phlogiston.eqiad.wmflabs" [23:27:02] that would make a tunnel via ssh that connects port 3306 on your laptop with port 3306 on phlogiston-2.phlogiston.eqiad.wmflabs [23:27:06] made a fresh Phab ticket to track this; fallback is for Max to be able to dump and download the Phlogiston database and use local access [23:27:42] then you can point a database tool at 127.0.0.1:3306 on your laptop and it will really connect to the mysql instance on phlogiston-2.phlogiston.eqiad.wmflabs [23:28:00] although if that is postges then the port numbers would be different [23:28:19] for db credentials -- pester jaufrecht_ :) [23:28:46] bd808: noted, thanks for your help! I'll dive in... [23:29:51] db credentials are done [23:30:32] for the record (although this is basic dbadmin: as the postgres user, I did "createuser mbinder" at the command line", and then from psql, "grant phlogiston to mbinder;" [23:30:35] ) [23:36:57] Max: first draft of data dictionary, including the PostgreSQL function you'll need to do all of the "X per epic" calculations [23:43:47] jaufrecht_: I'm cooked, let's continue Monday. Gotta get the data by Tuesday so hoping to resolve ahead of then. [23:51:26] okay