[00:07:38] Eileen: I will kick that off tomorrow along with the trigger refresh [00:18:56] cwd - thanks [00:36:59] Fundraising Sprint Junebugs prefer July, Fundraising-Backlog, Fr-CiviCRM-dedupe-FY2017/18: Civi dedupe script error? losing email addresses in recent merges - https://phabricator.wikimedia.org/T194662#4206313 (Eileenmcnaughton) Thanks @MBeat33 - sounds like staging will be up tomorrow so I'll do more... [01:24:13] mepps: cwd - am trying to line up a time to talk with Tim re read only db [01:24:23] we were looking at next week when Elliott is back [01:25:03] Tim will be at a sprint then - he has suggested some not-great-options for talking next week [01:25:27] or we could chat briefly with him tomorrow & then follow up more when ejegg is back [09:17:09] Fundraising-Backlog, MediaWiki-Release-Tools: CentralNotice: make-wmf-branch doesn't work for named extension deployment branches - https://phabricator.wikimedia.org/T113428#4206858 (demon) This....should be working with `branch.py` as desired? [09:35:00] Fundraising-Backlog, fundraising-tech-ops, Operations, Traffic: SSL cert for links.email.wikimedia.org - https://phabricator.wikimedia.org/T188561#4206939 (CCogdill_WMF) Thanks Casey! I'm waiting for a reply. Just bumped it, FYI. [14:21:27] Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint Junebugs prefer July, Fundraising-Backlog, Patch-For-Review: Adapt Druid banenr_activity jobs to EventLogging-based impression recording - https://phabricator.wikimedia.org/T186048#4207778 (AndyRussG) As mentioned... [14:25:06] Fundraising Sprint Junebugs prefer July, Fundraising-Backlog, FR-Ingenico: Ingenico audit wobble? iDEAL donations not in Civi May 1-3 - https://phabricator.wikimedia.org/T194296#4194799 (mepps) @MBeat33 My scan of the logs didn't reveal much. Do we have a way to import these donations manually? [14:29:16] Fundraising Sprint Junebugs prefer July, Fundraising-Backlog, FR-Ingenico: Ingenico audit wobble? iDEAL donations not in Civi May 1-3 - https://phabricator.wikimedia.org/T194296#4207802 (MBeat33) Thanks, @mepps If we knew the extent of the donations that are not in Civi, and it was just this small ba... [16:19:21] mepps: Hey, I'm only on for a second, but I wanted to make sure you saw that the files for the uninteded recurring thing are on frdev [16:19:58] thanks XenoRyet! I'll take a lookg [16:20:03] I realized that the GC refunds need more info than is in the database, and ejegg has the script that stitches it all together, so we might need to wait for him to do that end. [16:20:09] The paypal ones should be good to go though. [16:20:51] And with that, I'm off again. See everybody in a day or two. [16:20:59] hmm XenoRyet i'm worried we are going to time out on globalcollect.. [16:21:06] okay talk to you about it when you're back [16:34:23] Fundraising-Backlog: Website field missing for some records - https://phabricator.wikimedia.org/T194779#4208322 (NNichols) [17:12:29] Fundraising-Backlog: Prospect Tab- Reviewed Field - https://phabricator.wikimedia.org/T194784#4208431 (NNichols) [17:14:05] does anyone remember where it says the security requirements for fundraising laptops? [17:16:19] fr-tech: going to start a civi staging db restore now [17:17:43] cwd I can't think of a specific doc, but the gap assessment talks about the AV mandate at least [17:18:28] i remember something that said FDE too [17:18:36] a wiki page [17:19:34] that's mentioned on the OIT standard machine build [17:21:42] there's also some discussion in Data_access_guidelines on officewiki [17:23:07] https://office.wikimedia.org/wiki/Data_access_guidelines#Donor_and_donation_data [17:23:11] :| [17:23:45] yup [17:23:48] i guess we get to make up the rules :) [17:24:18] * cwd prepares decrees [17:24:21] it would be handy if it were broken out into one clear document, and referred to by these other documents [17:24:26] yep [17:24:37] we should probably compile a list of the important points [17:24:59] i guess we could make a document that's basically an outline pointing to relevant sections in all the peripheral ones :-P [17:25:20] a lofty goal [17:25:27] i thought only FR laptops needed FDE [17:25:31] that's org wide? [17:25:49] afaik it's on a team by team basis, driven by what you're doing with them [17:25:52] Subject to Full Disk Encryption (FDE) (which should be on by default for all WMF computers). [17:25:54] huh [17:26:45] going afk for a few minutes... [18:31:38] Fundraising Sprint Ivory and eggshell white are the same color, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike: assess GDPR civi extension and try to export all of a donor's data from Civi - https://phabricator.wikimedia.org/T192677#4208568 (DStrine) Resolved>Open [18:32:50] Fundraising Sprint Ivory and eggshell white are the same color, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike: assess GDPR civi extension and try to export all of a donor's data from Civi - https://phabricator.wikimedia.org/T192677#4146534 (DStrine) Sorry I don't think I meant to close th... [19:05:24] fundraising-tech-ops: encrypt fundraising nfs traffic - https://phabricator.wikimedia.org/T170326#4208711 (Jgreen) a:Jgreen I imported the production strongswan puppet module, tested between hosts in virtualbox, and deployed. While testing I noticed that our existing firewall rules and nfs config were n... [19:17:37] Fundraising Sprint HTTP originally stood for Happy Turtle Transfer Protocol, Fundraising Sprint Ivory and eggshell white are the same color, Fundraising Sprint Junebugs prefer July, Fundraising-Backlog: [Spike] Plan ingress system to use with new Ka... - https://phabricator.wikimedia.org/T192839#4208749 [19:40:47] !log disabled process-control for sql trigger refresh [19:40:50] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:45:18] PROBLEM - check_mysql on frdb2001 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) [19:46:32] Jeff_Green: my bad [19:49:43] is that the reload? [19:50:04] we have exciting weather here, thunder, rain, and tornado watch [19:50:18] RECOVERY - check_mysql on frdb2001 is OK: Uptime: 1879244 Threads: 1 Questions: 44421239 Slow queries: 423845 Opens: 17563 Flush tables: 1 Open tables: 670 Queries per second avg: 23.637 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [19:50:40] Fundraising Sprint Ivory and eggshell white are the same color, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Spike: assess GDPR civi extension and try to export all of a donor's data from Civi - https://phabricator.wikimedia.org/T192677#4208801 (DStrine) Open>Resolved [19:50:43] argh a nice thunderstorm just missed here by about 5 miles [19:50:51] i saw it on the horizon [19:51:08] Jeff_Green: and yeah i've been stopping that one just in case [19:51:51] Fundraising-Backlog, fundraising-tech-ops: Refresh civicrm triggers - https://phabricator.wikimedia.org/T194218#4208802 (cwdent) Open>Resolved [19:52:30] that's one of the nice things about being back in the northeast. in SF thunderstorms were exceedingly rare [19:53:26] !log re-enabled process-control [19:53:28] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [19:53:49] we haven't had a significant precipitation event in 8 months [19:54:43] a couple ~4" snows, a couple ~0.05" rains [19:54:50] nothing enough to soak deep [19:56:07] if the monsoon doesn't hit this year trees are going to start dying [20:10:08] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1439 [20:14:35] my internet connection keeps cutting out [20:15:18] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1739 [20:16:57] hmmm [20:20:18] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2040 [20:25:08] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2339 [20:25:41] fundraising-tech-ops: encrypt fundraising nfs traffic - https://phabricator.wikimedia.org/T170326#4208860 (Jgreen) another change, this time for pfw/srx policy: commit 6dedaa159b6a76a8ce45931411122669b0dc92a6 Author: Jeff Green Date: Tue May 15 20:23:38 2018 +0000 first attempt... [20:26:17] cwd can you attend the Tim mtg? I'm going to try but may lose connection [20:26:29] no prob, and thanks for the reminder [20:30:08] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2639 [20:35:08] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2939 [20:40:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 3239 [20:45:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 3539 [20:45:17] mepps: I would be ok pulling this back out of the sprint if it helps focus on other things: https://phabricator.wikimedia.org/T194543 [20:45:53] let's do that for now dstrine, we're so low on people this week [20:46:15] yup thanks for talking through it earlier [20:50:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 3839 [20:55:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 4139 [21:00:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 4440 [21:05:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 4739 [21:10:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 5039 [21:15:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 5339 [21:20:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 5640 [21:25:12] PROBLEM - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 5939 [21:29:12] ACKNOWLEDGEMENT - check_mysql on frdev1001 is CRITICAL: SLOW_SLAVE CRITICAL: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 5939 Casey Dentinger Slow query, acking because other replicas are not behind so we arent at risk there and it would be a shame to waste all these watts and not the the query result [21:53:25] cwd - did you kick off the staging restore? (https://phabricator.wikimedia.org/T194700) [21:57:41] eileen1: yep it has been running for ~5hrs [21:57:48] and the triggers have been refreshed [21:58:05] cwd great thanks [21:58:13] I wonder how long it will take :-) [21:59:05] yeah...i'll try to make a note of the time [21:59:18] i always forget to add it to the command [22:07:12] lol [22:55:12] RECOVERY - check_mysql on frdev1001 is OK: Uptime: 1029606 Threads: 5 Questions: 20063838 Slow queries: 41497 Opens: 11623 Flush tables: 1 Open tables: 935 Queries per second avg: 19.486 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 [23:51:24] Fundraising Sprint Junebugs prefer July, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Try to get anonymise extension working for civi - https://phabricator.wikimedia.org/T194209#4209206 (Eileenmcnaughton) Anonymiser is working on staging {F18287232} I hit a few bugs https://github.com/systop... [23:59:49] what timezone is awight in at the moment?