[01:55:13] (CR) Eileen: [C: +2] "I'm seeing success on staging - eg" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588464 (https://phabricator.wikimedia.org/T248900) (owner: Mepps) [02:03:50] (Merged) jenkins-bot: Change datetime fields to timestamps [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588464 (https://phabricator.wikimedia.org/T248900) (owner: Mepps) [02:10:49] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Missing information on the Engage Receipt - https://phabricator.wikimedia.org/T249771 (MBeat33) Thank you for the info, @LeanneS Do you know, are the DAF donations always marked as Payment Method=EFT in Civi? I'm wondering if there is a way to tell th... [12:31:48] Fundraising-Backlog, Gerrit, Release-Engineering-Team-TODO (2020-04 to 2020-06 (Q4)): Reset fr-tech drush repo, create sub-repo for vendor - https://phabricator.wikimedia.org/T249547 (hashar) a:hashar→None [12:32:35] Fundraising-Backlog, Gerrit, Release-Engineering-Team-TODO (2020-04 to 2020-06 (Q4)): Reset fr-tech drush repo, create sub-repo for vendor - https://phabricator.wikimedia.org/T249547 (hashar) @Ejegg let me know if you need any further assistance :) [14:53:32] Fundraising-Backlog, fundraising-tech-ops: Access to mysql databases - https://phabricator.wikimedia.org/T250117 (DStrine) [15:10:51] (PS1) Mepps: Adding logging for alter table queries [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588716 (https://phabricator.wikimedia.org/T248900) [15:11:37] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL, Patch-For-Review: system status warning on civi production - https://phabricator.wikimedia.org/T248900 (mepps) @Eileenmcnaughton I added one extra patch with some logging. It was a little unclear what was happe... [15:16:11] (CR) Mepps: "Should this become a settings variable? That way we could change it more easily in the future." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588497 (owner: Eileen) [15:21:13] fundraising-tech-ops: fix frack pbuilder repository paths - https://phabricator.wikimedia.org/T249879 (Jgreen) Open→Resolved p:Triage→Medium commit b289aa60820bfbd870656eaaf5b8e1f11b32d8e3 Author: Jeff Green Date: Fri Apr 10 15:42:54 2020 -0400 fix frack repo pat... [15:36:51] Fundraising-Backlog, fundraising-tech-ops: Access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) a:Dwisehaupt [15:55:57] (PS1) Ejegg: Set successful Adyen auth status to PENDING_POKE [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/588728 (https://phabricator.wikimedia.org/T250106) [15:57:46] fr-tech ^^^ should stop us from screwing up more Adyen recurring charges [15:58:04] now I just have to figure out how to get the existing limbo ones captured [16:05:34] turning off the recurring charge job for now [16:06:06] just in case adyen ones come due in the middle of the day [16:06:47] !log disabled new recurring payments charge job [16:06:51] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [16:08:23] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL: Found donors who have previously given in New donors FY1920 list - https://phabricator.wikimedia.org/T249766 (LeanneS) Cool, I'll proceed with this file. Thanks for your help! [16:10:04] Fundraising-Backlog, fundraising Sprint Grep works IRL, Patch-For-Review: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (Ejegg) @EMartin Thanks for bringing this to our attention! It looks like we screwed up when we added the code to charge rec... [16:13:31] hey ejegg your patch looks good to me, but i'm not sure if i should get set up for adyen end to end to put it through it's paces [16:15:35] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Missing information on the Engage Receipt - https://phabricator.wikimedia.org/T249771 (LeanneS) @MBeat33 Engage processes a variety of gift types that come in via EFT, mostly DAF and matching gifts. The best way to tell if it's a DAF is via the Gift Sou... [16:27:52] mepps there's a little more context in the latest comment on the ticket [16:28:52] so with that change, the output from the SmashPig Adyen CardPaymentProvider actually matches the mock PaymentProvider response we're giving in the CRM-layer payment processor test [16:29:16] ejegg mepps is looking good locally for me but is there something different i should have been doing testingwise to catch it in the first place? [16:29:20] that is, even without doing an end to end test you can check that it improves the internal consistency [16:29:56] cstone ahh man, I think you actually might have noticed that the payments at the console weren't showing as captured [16:30:07] and I just brushed that off as sandbox console slowness [16:30:49] yeah the sandbox is slow too though [16:31:02] orrr.... I'm not sure how much testing of card payments any of us did after the iDEAL changes (when this broke) [16:31:21] theres a couple in the test console sitting at authorized that was the issue? [16:31:26] yeah [16:31:57] the iDEAL-related change in the CRM layer was to add a check for PENDING_POKE [16:32:07] before calling approvePayment [16:35:05] alright i can break it with the old code in the test console and see it getting sentforsettle through with the new code [16:39:03] although the in theory broken one just went to sentforsettle so hmm [16:42:03] hmmmmmmmm? [16:42:11] do we have auto-capture set up in sandbox? [16:42:28] Fundraising-Backlog, fundraising-tech-ops: Access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) @jkim_wikimedia It looks like you should already have mysql access on the frdev host. To get there you will need the yubikey and to know the passphrase for your existing ssh key-p... [16:42:36] Fundraising-Backlog, fundraising Sprint Grep works IRL, Patch-For-Review: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (DStrine) Thanks @Ejegg so what do we need to do today to get these working? Are there any blockers to continue working on this? [16:45:18] Fundraising-Backlog, fundraising Sprint Grep works IRL, Patch-For-Review: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (Ejegg) @DStrine I need to deploy a patch (which @mepps and @Cstone are currently reviewing), then I'll turn the recurring ch... [16:47:10] Fundraising-Backlog, FR-Ingenico, Fr-Ingenico-integration_2017-18, Epic: EPIC: Ingenico reintegration internal test - https://phabricator.wikimedia.org/T183289 (DStrine) Open→Resolved [16:49:45] Fundraising-Backlog, fr-contribution-tacking-Q4-2020 : Scope and organize tasks for Contribution Tracking - https://phabricator.wikimedia.org/T250204 (DStrine) [16:50:17] Fundraising-Backlog, fundraising-tech-ops: Access to mysql databases - https://phabricator.wikimedia.org/T250117 (jkim_wikimedia) Thanks @Dwisehaupt ! Does it matter if my yubikey has changed? I think I'll need help with the passphrase! Thanks so much. [16:56:29] Fundraising-Backlog, fundraising Sprint Grep works IRL, Patch-For-Review: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (EMartin) @ejegg. I will confirm but Adyen said this: Adyen can set an automatic capture delay to make the capture on our pa... [16:59:52] Fundraising-Backlog, fundraising-tech-ops: Access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) @jkim_wikimedia We'll get the new information from your yubikey. As far as the passphrase, that is something only you would know and is only kept on your local machine. Since it s... [17:03:08] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) [17:19:18] howdy fr-tech! [17:20:02] hey jgleeson! [17:20:18] jgleeson: mepps: fr-tech: hi! [17:20:39] how goes it mepps AndyRussG :) [17:22:56] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) Instructions sent via email. [17:23:26] hi jgleeson and AndyRussG ! [17:24:06] hey ejegg ~:) [17:24:22] mepps: I noticed you moved the hidecookies task to pending deployment, https://phabricator.wikimedia.org/T244699 is that one wrapped up? [17:24:50] umm i think i might have done that by accident.. [17:25:13] jgleeson: eh not bad... ejegg hi! [17:25:14] ah no worries [17:28:32] delayed hi jgleeson AndyRussG [17:33:51] \ (•◡ •) / [17:42:42] ejegg your patch looks good testing wise but I can't get it to break with the current code in the test console, it always goes to sentforsettle [17:50:07] fr-tech folks, I'm gonna +2 the banner template CN patches pushed up by hallowelt [17:50:17] these ones https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/CentralNotice/+/573520/ [17:50:20] cstone well dang... can you see if the existing code is somehow actually calling capture? [17:50:49] jgleeson: can we first see if the geotargetting ones rebase cleanly around them? [17:51:07] yeah let me do some more testing [17:51:12] I'd rather do the merge conflict resolution with the banner template patches than with geotargeting [17:51:34] jgleeson: can you rebase it on the last geotargeting one? [17:51:44] ah yeah, that would be even better! [17:52:02] though I am about to push up yet another geotargeting one, to fix a banner allocation bug [17:52:20] pretty sure that one won't have any affect... [17:52:34] jgleeson: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralNotice/+/588156 [17:52:53] ejegg: jgleeson ah just seeing backscrooll sorry [17:53:09] ok I'll hold off for now ejegg AndyRussG and then rebase over the latest geo.. ones [17:53:40] ejegg: ah which one was that? [18:09:38] (PS1) Ejegg: Banner Allocation: region dropdown depends on country [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/588765 (https://phabricator.wikimedia.org/T102848) [18:09:49] AndyRussG: ^^^ that one [18:10:33] also jgleeson ^^^ would be a nice one to rebase over [18:11:10] AndyRussG: with that I think I've addressed all the stuff we talked about in that video chat [18:11:22] but still none of your comments on the original patch [18:11:33] sure ejegg I'll try it out! [18:12:05] (CR) jerkins-bot: [V: -1] Banner Allocation: region dropdown depends on country [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/588765 (https://phabricator.wikimedia.org/T102848) (owner: Ejegg) [18:12:44] oops, lemme see what it's complaining about [18:13:11] ahh, another line too long [18:14:39] (PS2) Ejegg: Banner Allocation: region dropdown depends on country [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/588765 (https://phabricator.wikimedia.org/T102848) [18:22:54] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (jkim_wikimedia) @Dwisehaupt I think this is it?! ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQCtYmJvhGpTjuQArdbaSsHfBJzj2pRc/rYvfmrJqvV1IoQAbpYh2h... [18:37:52] hey ejegg|food Evelyn is settling those adyen transactions from https://phabricator.wikimedia.org/T250106. Should they be settled? [18:38:30] ejegg|food: ah okok thanks! [18:39:41] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) @jkim_wikimedia That looks correct. I'll add it into the config. Will just need your new yubikey public side as the last bit. [18:40:09] Wikimedia-Fundraising-Banners: Stacked cc logos on payment options Desktop Large/Safari 9.0 - https://phabricator.wikimedia.org/T250094 (jbolorinos-ctr) p:Triage→Low Setting priority to Low as this is a bug that only impacts Safari 9.0, which is a less frequently used browser [18:41:41] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (jkim_wikimedia) I believe it is: ccccccntbngj [18:43:04] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) New public key updated and pushed out. ` [frack::puppet::private] d6e1722 Updated ssh public key for jkim ` [18:43:26] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) [18:44:14] Wikimedia-Fundraising-Banners: Button Spacing issue on Payment Options - Mobile Small banner - https://phabricator.wikimedia.org/T249662 (jbolorinos-ctr) Screenshot Test Results - Mobile: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/z234e995d23d6b66321c [18:45:53] Wikimedia-Fundraising-Banners: Button Spacing issue on Payment Options - Mobile Small banner - https://phabricator.wikimedia.org/T249662 (jbolorinos-ctr) p:Triage→Low [18:48:26] Fundraising-Backlog, Wikimedia-Fundraising-Banners, Readers-Web-Backlog (Tracking): [Bug] Banner causes misalignment in article - https://phabricator.wikimedia.org/T240641 (jbolorinos-ctr) p:Triage→Low Setting priority to low as this issue currently does not affect banner functionality, and i... [18:53:23] dstrine: yep yep, I hope it's not too much of a pain for her to do! [18:54:35] Wikimedia-Fundraising-Banners: Button Spacing issue on Payment Options - Mobile Small banner - https://phabricator.wikimedia.org/T249662 (jbolorinos-ctr) Open→Resolved a:jbolorinos-ctr Confirmed this issue has now been fixed. Closing task as resolved {F31756703} [19:00:26] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) @jkim_wikimedia Thanks. That looks correct. I've added it into config and pushed out the change. I'll follow up with an email a... [19:00:38] ejegg my earlier statement was user error for me, i was able to get some stuck at authorized with the current code and they are all behaving with the patch [19:01:51] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) [19:01:57] Wikimedia-Fundraising-Banners: Dsk lg: QA enUS control - https://phabricator.wikimedia.org/T250077 (jbolorinos-ctr) [19:02:01] (CR) Cstone: "Looks good, tested all forms of adyen payment with it too, getting correct statuses in the console." [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/588728 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [19:02:35] (CR) Cstone: [C: +2] "Let's try this again" [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/588728 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [19:02:42] Wikimedia-Fundraising-Banners: Dsk lg: QA enUS control - https://phabricator.wikimedia.org/T250077 (jbolorinos-ctr) [19:03:04] (Merged) jenkins-bot: Set successful Adyen auth status to PENDING_POKE [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/588728 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [19:04:28] Wikimedia-Fundraising-Banners: Dsk lg: QA enUS control - https://phabricator.wikimedia.org/T250077 (jbolorinos-ctr) [19:05:30] Wikimedia-Fundraising-Banners: Dsk lg: QA enUS control - https://phabricator.wikimedia.org/T250077 (jbolorinos-ctr) [19:15:24] thanks cstone! [19:15:41] AndyRussG: I'll push that fix out then rebase the cleanup patches over it [19:16:28] And I think add that requiresApproval() fn to some of the unit tests in the patch that introduces it. [19:17:53] (PS7) Jgleeson: Schema changes related to BannerTemplates [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/573520 (owner: ItSpiderman) [19:17:55] (PS22) Jgleeson: Banner templates [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/572672 (owner: ItSpiderman) [19:17:57] (PS4) Jgleeson: Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [19:24:52] (CR) jerkins-bot: [V: -1] Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [19:26:36] (PS23) Jgleeson: Banner templates [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/572672 (owner: ItSpiderman) [19:26:43] (PS1) Ejegg: Update SmashPig for Adyen status fix [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 [19:26:47] (CR) Ejegg: [C: +2] Update SmashPig for Adyen status fix [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (owner: Ejegg) [19:27:23] mepps should I cherry-pick that or can I deploy your 'Change datetime fields to timestamps' at the same time? [19:28:34] oh hmm, those could be some big table alters [19:29:01] you haven't timed it on dev by any chance, have you? [19:29:11] I think I'll just cherry-pick that smashpig version for now [19:30:39] (CR) AndyRussG: Geotargeting: Collapse countries and regions into one column (1 comment) [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/571768 (https://phabricator.wikimedia.org/T243011) (owner: Mepps) [19:30:56] oh drat, I need to change that log_id to invoice_id in the audit parser now :( [19:31:05] fr-tech: Just a couple more mins, I'll be in retro. [19:32:25] Fundraising-Backlog, fundraising Sprint Grep works IRL: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (EMartin) I have captured all of the pending recurring transactions manually in the Adyen portal. Elliott confirmed we will make API adjustments t... [19:33:35] (CR) jerkins-bot: [V: -1] Update SmashPig for Adyen status fix [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (owner: Ejegg) [20:07:25] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 45% free (3394 MB out of 7629 MB) [20:12:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 3% free (204 MB out of 7629 MB) [20:17:24] (PS5) Jgleeson: Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [20:17:26] (PS14) Jgleeson: Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [20:17:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 4% free (228 MB out of 7629 MB) [20:20:31] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL: Found donors who have previously given in New donors FY1920 list - https://phabricator.wikimedia.org/T249766 (DStrine) Open→Resolved [20:20:33] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising-Backlog, fundraising Sprint Grep works IRL: Get setup with HEP for matching gifts V2 and break down tasks - https://phabricator.wikimedia.org/T247878 (Ejegg) Open→Resolved p:Triage→Medium [20:21:27] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Create a job to send automatic matching gifts emails - https://phabricator.wikimedia.org/T249926 (Ejegg) [20:21:31] Fundraising-Backlog, fundraising Sprint Grep works IRL, Fr-planning-ahead: Planning ahead tasks for sprint H 2020 - https://phabricator.wikimedia.org/T249017 (DStrine) [20:21:34] Fundraising Sprint Evil Twins For Everyone, Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice: Prepare CN deploy 2020-03 - https://phabricator.wikimedia.org/T246461 (AndyRussG) Open→... [20:21:38] (CR) jerkins-bot: [V: -1] Rename methods to avoid confusion [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [20:21:42] Fundraising-Backlog: Investigate matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (Ejegg) [20:21:44] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Create template for automated matching gift email - https://phabricator.wikimedia.org/T249925 (Ejegg) [20:21:59] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Make Civi matching gifts extension store data in custom fields - https://phabricator.wikimedia.org/T249924 (Ejegg) [20:22:01] Fundraising-Backlog: Investigate matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (Ejegg) [20:22:06] (CR) jerkins-bot: [V: -1] Cloning Campaign [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [20:22:25] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 4% free (256 MB out of 7629 MB) [20:22:46] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Create a new CiviCRM extension with an API action to fetch data from SSBInfo - https://phabricator.wikimedia.org/T249922 (Ejegg) [20:22:47] Fundraising-Backlog: Investigate matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (Ejegg) [20:23:00] Fundraising-Backlog: Investigate matching gifts HEP integration (was employer field V2) - https://phabricator.wikimedia.org/T228765 (Ejegg) [20:23:03] Fundraising-Backlog, MediaWiki-extensions-DonationInterface: Create employer autocomplete for payments-wiki - https://phabricator.wikimedia.org/T249921 (Ejegg) [20:27:25] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 4% free (298 MB out of 7629 MB) [20:27:40] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi point version update - https://phabricator.wikimedia.org/T250226 (Eileenmcnaughton) [20:27:55] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi point version update - https://phabricator.wikimedia.org/T250226 (Eileenmcnaughton) [20:27:57] Fundraising-Backlog, fr-contribution-tacking-Q4-2020 : Scope and organize tasks for Contribution Tracking - https://phabricator.wikimedia.org/T250204 (DStrine) Open→Resolved [20:32:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 51% free (3832 MB out of 7629 MB) [20:32:38] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi point version update - https://phabricator.wikimedia.org/T250226 (DStrine) [20:32:40] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Civi search adyen % + recurring=yes yields no results - https://phabricator.wikimedia.org/T250123 (DStrine) [20:32:42] Fundraising Sprint H 2020, Fundraising-Backlog, Recurring-Donations: PayPal recurring: cycle of authorization reversals? - https://phabricator.wikimedia.org/T249951 (DStrine) [20:32:44] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Make Civi matching gifts extension store data in custom fields - https://phabricator.wikimedia.org/T249924 (DStrine) [20:32:46] Fundraising Sprint H 2020, Fundraising-Backlog, MediaWiki-extensions-DonationInterface: Create employer autocomplete for payments-wiki - https://phabricator.wikimedia.org/T249921 (DStrine) [20:32:49] Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, Fr-planning-ahead: Planning ahead tasks for sprint H 2020 - https://phabricator.wikimedia.org/T249017 (DStrine) [20:32:51] Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL: Fundraising engineer complete list of chores this week - https://phabricator.wikimedia.org/T249524 (DStrine) [20:32:53] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 2 others: Adyen sending back 'paymentMethod=ideal' in returnURL which is not being mapped - https://phabricator.wikimedia.org/T248712 (DStrine) [20:32:55] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL, Patch-For-Review: system status warning on civi production - https://phabricator.wikimedia.org/T248900 (DStrine) [20:32:57] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, FR-Civi-Prospect: Civi mail To, CC, BCC email additions diffcult - https://phabricator.wikimedia.org/T248199 (DStrine) [20:32:59] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL, Patch-For-Review: Point version upgrade on civi -do early April in prep for security release mid April - - https://phabricator.wikimedia.org/T248432 (DStrine) [20:33:04] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 2 others: When a donor whose initial form was in language=NL cancels an iDEAL donation, the resulting er... - https://phabricator.wikimedia.org/T247885 [20:33:06] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL: Review Banner Templating - https://phabricator.wikimedia.org/T246347 (DStrine) [20:33:08] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL, FR-Civi-Dedupe: Dedupe task inappropriately trying to delete contacts - https://phabricator.wikimedia.org/T247377 (DStrine) [20:33:11] Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, MediaWiki-extensions-CentralNotice: investigate: Find alternative to Special:HideBanners cookies to mitigate the loss of 3rd-party cookie support - https://phabricator.wikimedia.org/T244699 (DStrine) [20:33:14] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Dampness, Fundraising Sprint Evil Twins For Everyone, Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, and 8 others: Show selected countries and regions under tree selector - https://phabricator.wikimedia.org/T243012 (D... [20:33:16] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 3 others: Test migrating old ingencio recurring to new ingencio - https://phabricator.wikimedia.org/T232017 (DStrine) [20:33:19] Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint CAPS LOCK CULTS, Fundraising Sprint Dampness, Fundraising Sprint Evil Twins For Everyone, and 10 others: Collapse countries and regions into one column in the campaign list - https://phabricator.wikimedia.org/T243011 (DStrine) [20:33:21] Fundraising Sprint H 2020, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, fundraising Sprint Grep works IRL: Investigate how to generate generic email for failed recurring donations - https://phabricator.wikimedia.org/T230064 (DStrine) [20:33:22] Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL: Capturing 'contauth' recurring transactions through Adyen - https://phabricator.wikimedia.org/T250106 (DStrine) [20:33:25] Fundraising Sprint Fish Fight Frogs for Free French-Fry Frappées, Fundraising Sprint H 2020, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 3 others: Create script to migrate existing GlobalCollect recurring payments to Connect tokens - https://phabricator.wikimedia.org/T169357 (DStri... [20:37:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 55% free (4189 MB out of 7629 MB) [20:42:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 56% free (4218 MB out of 7629 MB) [20:47:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 56% free (4238 MB out of 7629 MB) [20:52:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 57% free (4316 MB out of 7629 MB) [20:57:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 58% free (4383 MB out of 7629 MB) [21:02:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 59% free (4467 MB out of 7629 MB) [21:06:48] (CR) Jgleeson: [C: +1] "recheck" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/576648 (owner: ItSpiderman) [21:06:55] (CR) Jgleeson: "recheck" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/574667 (owner: AlexPinchuk) [21:07:14] (CR) Eileen: [C: +2] Adding logging for alter table queries [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588716 (https://phabricator.wikimedia.org/T248900) (owner: Mepps) [21:07:25] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 59% free (4495 MB out of 7629 MB) [21:07:39] (PS1) Ejegg: Update SmashPig for Adyen status fix [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/588785 [21:10:25] (PS2) Ejegg: Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) [21:10:27] (CR) Eileen: "it's in drupal setttings - I did change it on the command line with drush vset - which should have worked but I'm not quite sure (see emai" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588497 (owner: Eileen) [21:12:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 60% free (4525 MB out of 7629 MB) [21:17:17] (CR) jerkins-bot: [V: -1] Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [21:17:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 60% free (4554 MB out of 7629 MB) [21:20:39] fr-tech it looks like theres some tests failing after rebasing the banner template stuff over grotargeting to do with the banner category field (maybe?) https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php72-docker/60429/console [21:20:50] I'm gonna dig a little into that tomorrow [21:21:21] geotargeting* [21:22:07] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) Verified access worked for ssh and mysql. All set. [21:22:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 61% free (4581 MB out of 7629 MB) [21:22:49] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) p:Triage→Medium [21:23:03] Fundraising-Backlog, fundraising-tech-ops: Update ssh-keypair, yubikey public key , and verify access to mysql databases - https://phabricator.wikimedia.org/T250117 (Dwisehaupt) Open→Resolved [21:23:06] (PS3) Ejegg: Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) [21:23:24] shoot, there are some PHP parse errors in the latest crm tests! [21:23:34] https://integration.wikimedia.org/ci/job/wikimedia-fundraising-crm-composer-php72-docker/1919/console [21:24:10] bad merge? [21:25:28] huh huh, I'll put up a patch [21:26:36] (PS1) Ejegg: Fix parse error [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/588788 [21:26:55] (CR) Ejegg: [C: +2] Fix parse error [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/588788 (owner: Ejegg) [21:27:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 61% free (4614 MB out of 7629 MB) [21:27:50] (PS4) Ejegg: Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) [21:27:52] (PS1) Ejegg: Fix parse errors [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 [21:32:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 61% free (4646 MB out of 7629 MB) [21:33:04] fr-tech can anyone review https://gerrit.wikimedia.org/r/588771 for me? [21:33:30] I need to deploy a SmashPig update to fix the Adyen recurring [21:33:47] but in the meantime we had merged a SmashPig update that changes the audit parser output slightly [21:34:23] to use the real, stored-in-civi 'invoice_id' instead of our ficticious, just-for-audit-search 'log_id' [21:34:51] anyway, the CRM module audit processors and corresponding tests needed some little tweaks [21:35:53] (Merged) jenkins-bot: Fix parse error [wikimedia/fundraising/crm/civicrm] - https://gerrit.wikimedia.org/r/588788 (owner: Ejegg) [21:37:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 62% free (4672 MB out of 7629 MB) [21:37:46] looking ejegg local civi tests being slow [21:39:03] ejegg: was that deleted function not being called anywhere? [21:42:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 62% free (4702 MB out of 7629 MB) [21:43:58] cstone that deleted fn was overriding the parent class [21:44:08] and just calling the parent class, then unsetting log_id [21:44:18] now we're not even sending log_id [21:44:25] instead sending invoice_id [21:44:32] ah okay i see [21:44:38] and we don't want to unset it, cause it's useful info [21:45:44] (CR) Cstone: [C: +2] Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [21:47:29] PROBLEM - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 62% free (4719 MB out of 7629 MB) [21:47:59] ACKNOWLEDGEMENT - check_swap on frdb1002 is CRITICAL: SWAP CRITICAL - 62% free (4719 MB out of 7629 MB) Dwisehaupt Known from long MySQL query. [21:50:25] thanks cstone [21:50:39] (CR) Ejegg: [C: +2] Fix parse errors [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 (owner: Ejegg) [21:51:11] mepps how do you feel about deploying the datetime -> timestamp change during tech talk? [21:51:22] ah, wait, this tech talk is too late for you, right? [21:52:12] (CR) jerkins-bot: [V: -1] Fix parse errors [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 (owner: Ejegg) [21:52:16] (CR) jerkins-bot: [V: -1] Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [21:53:45] grr [22:02:32] (CR) Ejegg: "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 (owner: Ejegg) [22:02:39] (CR) Ejegg: [C: +2] "recheck" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 (owner: Ejegg) [22:05:19] (CR) Ejegg: [C: +2] Update SmashPig for Adyen status fix [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/588785 (owner: Ejegg) [22:09:29] (Merged) jenkins-bot: Fix parse errors [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588789 (owner: Ejegg) [22:10:30] (Merged) jenkins-bot: Update SmashPig, rename log_id in audits [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/588771 (https://phabricator.wikimedia.org/T250106) (owner: Ejegg) [22:16:22] (Merged) jenkins-bot: Update SmashPig for Adyen status fix [wikimedia/fundraising/crm/vendor] - https://gerrit.wikimedia.org/r/588785 (owner: Ejegg) [22:21:47] (PS1) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/588801 [22:22:36] (PS2) Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/588801 [22:22:56] (CR) Ejegg: [C: +2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - https://gerrit.wikimedia.org/r/588801 (owner: Ejegg) [22:23:25] ejegg yeah, also I’d like the logging patch to be +2ed if it hasn’t yet [22:25:40] mepps looks like eileen merged that one [22:25:57] Great ejegg [22:27:23] did you want to do the honors, or are you off now? [22:59:39] !log fundraising civicrm revision changed from 59e712ce8e to 18d7567cd7 [22:59:45] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [22:59:58] !log disabled thank-you and omnimailing jobs [23:00:03] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [23:17:48] Fundraising-Backlog, fundraising-tech-ops: Tables to compact on frdb hosts - https://phabricator.wikimedia.org/T248609 (Dwisehaupt) Main tables on frdev1001 are done. Will test the dump/restore option on the dev tables to see if there is more to be reclaimed there. ` # sudo compact_innodb_table -d civic... [23:24:04] !log re-enabled thank-you, onimailing and new recurring charge jobs [23:24:08] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log