[00:42:34] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog: Scoping: Supporting SMS campaign functionality in Acoustic - https://phabricator.wikimedia.org/T365826#10201384 (10Eileenmcnaughton) We had a helpful call with Brian & Eric & some updates 1) It seems we only need to update the addRecipient, and select Recip... [01:28:06] (03PS10) 10Jgleeson: Setup Venmo frontend on Gravy [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1077074 (https://phabricator.wikimedia.org/T376182) (owner: 10Damilare Adedoyin) [01:31:06] (03CR) 10Ejegg: [C:03+2] "Works locally, code changes look pretty good. Though for later: I wish we could maintain a clearer distinction between when the payment_me" [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1077074 (https://phabricator.wikimedia.org/T376182) (owner: 10Damilare Adedoyin) [01:32:36] (03PS1) 10Ejegg: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1077819 [01:32:41] (03CR) 10Ejegg: [C:03+2] Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1077819 (owner: 10Ejegg) [01:32:56] (03Merged) 10jenkins-bot: Setup Venmo frontend on Gravy [extensions/DonationInterface] - 10https://gerrit.wikimedia.org/r/1077074 (https://phabricator.wikimedia.org/T376182) (owner: 10Damilare Adedoyin) [01:34:15] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [extensions/DonationInterface] (deployment) - 10https://gerrit.wikimedia.org/r/1077819 (owner: 10Ejegg) [01:36:44] (03PS1) 10Ejegg: Update composer.lock [core] (fundraising/REL1_39) - 10https://gerrit.wikimedia.org/r/1077821 [01:37:17] (03CR) 10Ejegg: [C:03+2] Update composer.lock [core] (fundraising/REL1_39) - 10https://gerrit.wikimedia.org/r/1077821 (owner: 10Ejegg) [01:45:33] !log payments-wiki upgraded from e88750e6 to ed2d78b3 [01:45:34] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [01:45:54] (03Merged) 10jenkins-bot: Update composer.lock [core] (fundraising/REL1_39) - 10https://gerrit.wikimedia.org/r/1077821 (owner: 10Ejegg) [02:41:46] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog: Scoping: Supporting SMS campaign functionality in Acoustic - https://phabricator.wikimedia.org/T365826#10201436 (10EWilfong_WMF) Regarding #2, we have confirmed we will need to update the existing Acoustic RML forms to match existing records using the email f... [13:26:20] (03CR) 10Jgleeson: [C:03+2] "LGTM! I was a lil confused about the scenario we were testing here, but after digging into the code, I can see we're making sure the code " [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077033 (https://phabricator.wikimedia.org/T376122) (owner: 10Damilare Adedoyin) [13:27:24] (03Merged) 10jenkins-bot: Add tests to ensure recurring token is sent for recurring charges [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077033 (https://phabricator.wikimedia.org/T376122) (owner: 10Damilare Adedoyin) [13:36:46] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Setup Paypal Sandbox REST API instance for Gravy - https://phabricator.wikimedia.org/T376468 (10jgleeson) 03NEW [13:38:40] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy Paypal Payments (one-time) - https://phabricator.wikimedia.org/T375378#10202446 (10jgleeson) [13:39:37] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Paypal - https://phabricator.wikimedia.org/T376469 (10jgleeson) 03NEW [13:40:08] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy Paypal Payments (one-time) - https://phabricator.wikimedia.org/T375378#10202458 (10jgleeson) [13:40:09] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Paypal - https://phabricator.wikimedia.org/T376469#10202459 (10jgleeson) [13:40:15] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Setup Paypal Sandbox REST API instance for Gravy - https://phabricator.wikimedia.org/T376468#10202461 (10jgleeson) [13:40:17] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 13Patch-For-Review, 07payments-orchestration: Gravy Paypal Payments (one-time) - https://phabricator.wikimedia.org/T375378#10202460 (10jgleeson) [13:40:38] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Setup Paypal Sandbox REST API instance for Gravy - https://phabricator.wikimedia.org/T376468#10202462 (10jgleeson) [13:40:42] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Paypal - https://phabricator.wikimedia.org/T376469#10202463 (10jgleeson) [13:41:08] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Paypal - https://phabricator.wikimedia.org/T376469#10202466 (10jgleeson) [13:41:09] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Integration - https://phabricator.wikimedia.org/T364501#10202467 (10jgleeson) [13:42:30] 06Fundraising-Backlog, 07payments-orchestration: Gravy Paypal Payments (recurring) - https://phabricator.wikimedia.org/T376470 (10jgleeson) 03NEW [13:45:27] 06Fundraising-Backlog, 07payments-orchestration: Gravy PayPal Webhooks - https://phabricator.wikimedia.org/T376473 (10jgleeson) 03NEW [13:46:31] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Set up production Gravy Adyen 3DSecure Scheme config - https://phabricator.wikimedia.org/T375214#10202526 (10jgleeson) a:05jgleeson→03None [13:46:47] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Set up production Gravy Adyen 3DSecure Scheme config - https://phabricator.wikimedia.org/T375214#10202527 (10jgleeson) a:03jgleeson [13:47:44] 06Fundraising-Backlog, 07Epic, 07payments-orchestration: Gravy Braintree implementation: Venmo - https://phabricator.wikimedia.org/T375267#10202531 (10jgleeson) [13:50:42] 10fundraising-tech-ops, 06DC-Ops, 06Infrastructure-Foundations, 10netops, and 2 others: codfw:frack:servers migration task - https://phabricator.wikimedia.org/T375151#10202535 (10Papaul) [14:03:23] 10fundraising-tech-ops: Investigate metabase packaging, install, security monitoring. - https://phabricator.wikimedia.org/T375030#10202570 (10Jgreen) p:05Triage→03Medium a:03Jgreen [14:03:32] 10fundraising-tech-ops: Investigate Metabase packaging, install, security monitoring. - https://phabricator.wikimedia.org/T375030#10202572 (10Jgreen) [14:06:09] 10fundraising-tech-ops: Investigate Metabase packaging, install, security monitoring. - https://phabricator.wikimedia.org/T375030#10202575 (10Jgreen) Changelog review, fetching, and packaging has been automated into a new FR admin tool called package_getter. Still to do: vulnerability and update tracking. [14:07:20] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate minio packaging, install, security monitoring. - https://phabricator.wikimedia.org/T367123#10202580 (10Jgreen) [14:08:06] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate MinIO packaging, install, security monitoring. - https://phabricator.wikimedia.org/T367123#10202583 (10Jgreen) [14:08:10] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate MinIO packaging, install, security monitoring. - https://phabricator.wikimedia.org/T367123#10202581 (10Jgreen) p:05Triage→03Medium [14:13:23] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate Trino install, operation and maintenance, and security monitoring. - https://phabricator.wikimedia.org/T367818#10202594 (10Jgreen) [15:09:41] (03PS1) 10Ejegg: Update SmashPig [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1077971 [15:09:49] (03CR) 10Ejegg: [C:03+2] Update SmashPig [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1077971 (owner: 10Ejegg) [15:10:30] (03PS1) 10Ejegg: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1077972 [15:28:08] 06Fundraising-Backlog: Update import code (inc upstream) to permit importing last 4 digits of CC number (to financial_trxn.pan_truncation) - https://phabricator.wikimedia.org/T373061#10202784 (10MDemosWMF) Talked with @Eileenmcnaughton on this one - I think we need to bump this up because our larger mailing goe... [15:29:25] 06Fundraising-Backlog: Update import code (inc upstream) to permit importing last 4 digits of CC number (to financial_trxn.pan_truncation) - https://phabricator.wikimedia.org/T373061#10202788 (10AKanji-WMF) Thanks @MDemosWMF, I'll add it into our next sprint starting Tuesday. [15:30:27] (03Merged) 10jenkins-bot: Update SmashPig [wikimedia/fundraising/crm/vendor] - 10https://gerrit.wikimedia.org/r/1077971 (owner: 10Ejegg) [15:31:00] 06Fundraising-Backlog: Update import code (inc upstream) to permit importing last 4 digits of CC number (to financial_trxn.pan_truncation) - https://phabricator.wikimedia.org/T373061#10202796 (10MDemosWMF) @AKanji-WMF Thanks! Since I will be out I'm adding @Elbar53 so she can see when this field is available to... [15:45:39] (03CR) 10Ejegg: [C:03+2] Adjust donor_segment and donor_status calculations for annual donor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1075665 (https://phabricator.wikimedia.org/T372378) (owner: 10Eileen) [15:45:55] (03CR) 10Ejegg: [C:03+2] Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1077972 (owner: 10Ejegg) [15:46:55] oops, removed that C+2 - meant to C+2 the merge to deployment [15:47:04] (basically just a SmashPig update) [16:02:13] (03PS1) 10Jgleeson: Gravy Refactor: tweak output variable name to clarify purpose [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077979 [16:02:14] (03PS1) 10Jgleeson: Gravy Refactor: extract payments response error checks to function [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077981 [16:04:09] (03Merged) 10jenkins-bot: Merge branch 'master' into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/1077972 (owner: 10Ejegg) [16:09:08] 03Fundraising Sprint: Sssss, 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Duplicate contributions after import - https://phabricator.wikimedia.org/T376068#10202952 (10SHust) @MDemosWMF the admin team can support this group dedupe, how often do imports happen? [16:25:48] 10fundraising-tech-ops: Fundraising access request for dbooke - https://phabricator.wikimedia.org/T375916#10203027 (10Dwisehaupt) Extended access to include mysql approved. ` Date: Fri, 4 Oct 2024 09:04:00 From: Lisa Seitz Gruwell To: Dallas Wisehaupt Cc: Greg Grossmeier, Runjini Murthy Subject: Re: Access req... [16:25:51] 10fundraising-tech-ops: Fundraising access request for adizdari - https://phabricator.wikimedia.org/T375915#10203028 (10Dwisehaupt) Extended access to include mysql approved. ` Date: Fri, 4 Oct 2024 09:04:00 From: Lisa Seitz Gruwell To: Dallas Wisehaupt Cc: Greg Grossmeier, Runjini Murthy Subject: Re: Access r... [17:01:02] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog, 07payments-orchestration: Set up production Gravy Adyen 3DSecure Scheme config - https://phabricator.wikimedia.org/T375214#10203148 (10jgleeson) Slack [[ https://wikimedia.slack.com/archives/C070F1DVBRN/p1726760158715049 | thread ]] [17:34:36] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate Trino install, operation and maintenance, and security monitoring. - https://phabricator.wikimedia.org/T367818#10203277 (10Jgreen) [17:48:02] !log fundraising civicrm upgraded from 90199f62 to 45855ff4 [17:48:03] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [18:12:05] 10fundraising-tech-ops, 06Privacy Engineering, 10Security Preview, 07SecTeam-Processed: Investigate Trino install, operation and maintenance, and security monitoring. - https://phabricator.wikimedia.org/T367818#10203404 (10Jgreen) [18:12:59] 03Fundraising Sprint: Sssss, 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Duplicate contributions after import - https://phabricator.wikimedia.org/T376068#10203405 (10MDemosWMF) @SHust Amazing! Thank you DR admin team. There are various weekly imports happening throughout the week based on when da... [19:02:57] 06Fundraising-Backlog: Matching import: Unknown DB error - https://phabricator.wikimedia.org/T376504 (10MDemosWMF) 03NEW [19:03:07] 06Fundraising-Backlog: Matching import: Unknown DB error - https://phabricator.wikimedia.org/T376504#10203573 (10MDemosWMF) p:05Triage→03High [19:21:12] (03CR) 10Ejegg: [C:03+2] "This looks great - just needs a patch to add the OptionValues to see the labels - I'll add one now." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1075665 (https://phabricator.wikimedia.org/T372378) (owner: 10Eileen) [19:42:52] 03Fundraising Sprint: Sssss, 06Fundraising-Backlog: Look at renaming fields in Acoustic export csv - https://phabricator.wikimedia.org/T376360#10203673 (10NNgu-WMF) Sounds great! To be clear, my action items would be: During no-email week, do the following: - For Acoustic field "endowment_last_donation_date"... [19:45:08] (03Merged) 10jenkins-bot: Adjust donor_segment and donor_status calculations for annual donor [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1075665 (https://phabricator.wikimedia.org/T372378) (owner: 10Eileen) [19:50:27] (03PS1) 10Ejegg: Add labels for new Annual recurring segments [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1078005 (https://phabricator.wikimedia.org/T372378) [19:56:13] (03CR) 10Ejegg: [C:03+2] "Follow-up for labels submitted as I4b8f1925ca0532b2cb75e1bcb9579fd4b285f773" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1075665 (https://phabricator.wikimedia.org/T372378) (owner: 10Eileen) [19:56:54] (03PS3) 10Eileen: Minor preliminary composer updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077133 [19:57:06] (03CR) 10Ejegg: [C:03+2] Minor preliminary composer updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077133 (owner: 10Eileen) [20:08:52] (03PS4) 10Eileen: composer update wikimedia/omnimail-silverpop [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077135 (https://phabricator.wikimedia.org/T368470) [20:08:55] (03CR) 10Ejegg: [C:03+2] composer update wikimedia/omnimail-silverpop [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077135 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [20:09:26] (03PS4) 10Eileen: Update silverphp-php-connector [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077134 (https://phabricator.wikimedia.org/T368470) [20:11:30] (03CR) 10Ejegg: [C:03+2] "Well that's annoying, but I'm glad you found a workaround!" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077134 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [20:17:50] (03Merged) 10jenkins-bot: Minor preliminary composer updates [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077133 (owner: 10Eileen) [20:27:41] (03Merged) 10jenkins-bot: composer update wikimedia/omnimail-silverpop [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077135 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [20:30:02] (03Merged) 10jenkins-bot: Update silverphp-php-connector [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077134 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [20:38:59] (03PS5) 10Eileen: Add omnimail upload action [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077136 (https://phabricator.wikimedia.org/T368470) [20:39:38] (03CR) 10Ejegg: [C:03+2] "Code looks fine, I agree it makes sense to deploy this and try it with the production credentials." [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077136 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [20:45:20] (03CR) 10Ejegg: [C:03+2] "Thank you - much better that way!" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077979 (owner: 10Jgleeson) [20:45:49] (03CR) 10Ejegg: [C:03+2] Gravy Refactor: use verbose variable names to improve readability [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077980 (owner: 10Jgleeson) [20:47:22] (03CR) 10Ejegg: [C:03+2] Gravy Refactor: extract payments response error checks to function [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077981 (owner: 10Jgleeson) [20:50:17] need to relocate, but I'll be back online in a bit [21:01:52] (03Merged) 10jenkins-bot: Add omnimail upload action [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/1077136 (https://phabricator.wikimedia.org/T368470) (owner: 10Eileen) [21:01:53] (03Merged) 10jenkins-bot: Gravy Refactor: tweak output variable name to clarify purpose [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077979 (owner: 10Jgleeson) [21:01:54] (03Merged) 10jenkins-bot: Gravy Refactor: use verbose variable names to improve readability [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077980 (owner: 10Jgleeson) [21:01:54] (03Merged) 10jenkins-bot: Gravy Refactor: extract payments response error checks to function [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1077981 (owner: 10Jgleeson) [21:07:30] 06Fundraising-Backlog: Placeholder - Figure out how translations will work - https://phabricator.wikimedia.org/T376514 (10Cstone) 03NEW [21:14:56] 10fundraising-tech-ops: Fundraising access request for dbooke - https://phabricator.wikimedia.org/T375916#10203940 (10Dwisehaupt) [21:15:34] 10fundraising-tech-ops: Fundraising access request for adizdari - https://phabricator.wikimedia.org/T375915#10203941 (10Dwisehaupt) [21:21:45] 10fundraising-tech-ops: Fundraising access request for adizdari - https://phabricator.wikimedia.org/T375915#10203967 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt Added account to mysql grants for frdb_analytics. Granted same access as tburrington. Allowed access from frdev and fran hosts. Set with r... [21:21:47] 10fundraising-tech-ops: Fundraising access request for dbooke - https://phabricator.wikimedia.org/T375916#10203963 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt Added account to mysql grants for frdb_analytics. Granted same access as tburrington. Allowed access from frdev and fran hosts. Set with ran... [21:53:26] (03PS1) 10Cstone: Switch proxy ports to config [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/1078011 (https://phabricator.wikimedia.org/T375492) [21:54:08] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog, 10fundraising-tech-ops, 13Patch-For-Review: Civi1002 can't access Gravy Audit files hosted at storage.googleapis.com - https://phabricator.wikimedia.org/T375492#10204051 (10Cstone) New proxies work, reports are appearing in the /incoming folder [21:55:06] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Dlocal timeouts - https://phabricator.wikimedia.org/T376095#10204056 (10Cstone) Dlocal asked for examples, sent some over and waiting for response [22:01:47] 06Fundraising Tech - Chaos Crew, 06Fundraising-Backlog: Check that Adyen supports countries we had available on Ingenico - https://phabricator.wikimedia.org/T349667#10204062 (10Cstone) a:03Cstone [22:52:38] 06Fundraising-Backlog, 10fundraising-tech-ops: Restore civicrm DBs on the frack staging db host - https://phabricator.wikimedia.org/T375578#10204158 (10Dwisehaupt) 05Open→03Resolved This finished on the 29th. ` LOAD: fredge.20240923-152316.frdb1004.sql.gz Tue 24 Sep 2024 11:12:31 PM UTC FINISHED: Wed...