[00:00:04] the user db connections that pick up the default my.cnf will already pick up the ssl flag. [00:00:36] just as a warning if you see it working from testing on the mysql cli. [00:02:29] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10Patch-For-Review: Update acoustic export to include new segment fields - https://phabricator.wikimedia.org/T339296 (10Eileenmcnaughton) @KHaggard no - they are both numeric & both hav... [00:04:46] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Reduce the year fields for WMF donor - https://phabricator.wikimedia.org/T339314 (10Eileenmcnaughton) ALso noting that Acoustic doesn't actually use the calendar year fields it turns out - https://phabricator.wikimedia.org/T33929... [00:08:57] (03PS3) 10Eileen: Update Silverpop export to include new fields [wikimedia/fundraising/tools] - 10https://gerrit.wikimedia.org/r/935182 (https://phabricator.wikimedia.org/T339296) [00:10:30] looking at https://phabricator.wikimedia.org/T280080 i'm not 100% sure that the ssl config in civi was finished. [00:11:01] i have a feeling that it was but there is nothing in the task confirming that. [00:12:22] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10Patch-For-Review: Update acoustic export to include new segment fields - https://phabricator.wikimedia.org/T339296 (10KHaggard) Ohh ok thanks for clarifying @Eileenmcnaughton I have C... [00:14:37] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Install `coworker` and `cv` on prod - https://phabricator.wikimedia.org/T324611 (10Eileenmcnaughton) Per the call we had - can we just run composer install? If not then maybe we can add the vendor repo just checked in - the whole... [00:17:56] (03PS1) 10Eileen: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/935820 [00:18:51] (03CR) 10Eileen: [C: 03+2] Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/935820 (owner: 10Eileen) [00:19:54] (03Merged) 10jenkins-bot: Merge branch 'master' of ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm into deployment [wikimedia/fundraising/crm] (deployment) - 10https://gerrit.wikimedia.org/r/935820 (owner: 10Eileen) [00:22:47] !log civicrm upgraded from 4ca2008d to 0ddd1a51 [00:22:48] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [00:39:32] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Install `coworker` and `cv` on prod - https://phabricator.wikimedia.org/T324611 (10Dwisehaupt) I just verified that we don't have composer on the frdev host. So it would probably be best to run composer locally on your host to cr... [01:03:49] cstone: wfan that deploy did change the translations despite my matching - I think the fr_CA thank you needs an update - I fixed the subject & just trying to slow my brain down enough to do the html properly rather than make a mistake. The Latin American Spanish seemed to only be a trival change [01:05:01] Do you need more eyes on it eileen ? [01:05:29] maybe just a quick hangout for moral support? [01:06:08] https://meet.google.com/odz-juym-nog?authuser=0 [01:30:41] (03PS1) 10Eileen: Update our french candian thank you text [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/935825 [01:32:55] (03PS2) 10Eileen: Update our french candian thank you text [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/935825 [01:48:27] (03CR) 10Cstone: [C: 03+2] Update our french candian thank you text [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/935825 (owner: 10Eileen) [02:01:27] (03Merged) 10jenkins-bot: Update our french candian thank you text [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/935825 (owner: 10Eileen) [02:29:07] (03PS1) 10Eileen: Run composer - create vendor [wikimedia/fundraising/coworker] - 10https://gerrit.wikimedia.org/r/935145 [02:30:27] (03CR) 10Eileen: [V: 03+2 C: 03+2] Run composer - create vendor [wikimedia/fundraising/coworker] - 10https://gerrit.wikimedia.org/r/935145 (owner: 10Eileen) [02:31:09] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Install `coworker` and `cv` on prod - https://phabricator.wikimedia.org/T324611 (10Eileenmcnaughton) @Dwisehaupt I just committed the vendor dir to the master branch [02:31:35] (03PS2) 10Eileen: Run composer - create vendor [wikimedia/fundraising/coworker] - 10https://gerrit.wikimedia.org/r/935145 (https://phabricator.wikimedia.org/T324611) [02:31:39] (03CR) 10Eileen: [V: 03+2] Run composer - create vendor [wikimedia/fundraising/coworker] - 10https://gerrit.wikimedia.org/r/935145 (https://phabricator.wikimedia.org/T324611) (owner: 10Eileen) [02:35:53] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10Patch-For-Review: Update acoustic export to include new segment fields - https://phabricator.wikimedia.org/T339296 (10Eileenmcnaughton) @KHaggard Yes - I think Deep Lapsed etc are lik... [02:40:30] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10fr-donorservices: Unable to reach server error in Civi - https://phabricator.wikimedia.org/T339971 (10Eileenmcnaughton) We have a patch in review for this (not sure why it isn't linked here). The issue affects anyone behind the times (well behind GMT... [03:00:43] 10Fundraising-Backlog: Add GC failure "Remarks" data to contribution tracking - https://phabricator.wikimedia.org/T107960 (10Eileenmcnaughton) 05Open→03Declined Hmm - it is probably not something that would go in contribution tracking. A lot of stuff has changed since this & there is a current project as wel... [05:42:02] (03PS4) 10Eileen: Update code references to contribution_tracking: Wmffraud/form/report/* [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/931265 (https://phabricator.wikimedia.org/T339381) (owner: 10Damilare Adedoyin) [05:42:04] (03PS1) 10Eileen: Follow up fix on fredge report [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/935834 (https://phabricator.wikimedia.org/T339381) [05:43:56] (03CR) 10Eileen: "Dami I gave this a spin & it needs some tweaks to the way the aliases are referenced or it throws sql errors. I put those changes in a fol" [wikimedia/fundraising/crm] - 10https://gerrit.wikimedia.org/r/931265 (https://phabricator.wikimedia.org/T339381) (owner: 10Damilare Adedoyin) [09:00:59] 10Fundraising Sprint Go Your Own Pay, 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Juggalology 2022, 10Fundraising Sprint Kermit hopping principle, and 7 others: Currency code/currency symbol in Thank You emails received by Donors issu... - https://phabricator.wikimedia.org/T309349 [12:52:05] 10fundraising-tech-ops, 10Infrastructure Security, 10Infrastructure-Foundations: Migrate jgreen out of the ops group and into the fr-tech-admins group - https://phabricator.wikimedia.org/T336231 (10Jgreen) Mailing lists have been migrated. I think that was the last thing to do before migrating me out of the... [13:56:13] PROBLEM - check_mysql on payments1006 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments1006&service=check_mysql [13:56:13] PROBLEM - check_mysql on payments2002 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [13:58:13] PROBLEM - check_mysql on payments2003 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2003&service=check_mysql [13:58:13] PROBLEM - check_mysql on payments2001 is CRITICAL: Slave IO: Connecting Slave SQL: Yes Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2001&service=check_mysql [14:01:13] PROBLEM - check_mysql on payments1006 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments1006&service=check_mysql [14:01:13] RECOVERY - check_mysql on payments2002 is OK: Uptime: 4217324 Threads: 5 Questions: 7365852 Slow queries: 0 Opens: 100 Open tables: 94 Queries per second avg: 1.746 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [14:03:13] RECOVERY - check_mysql on payments2003 is OK: Uptime: 4217960 Threads: 5 Questions: 7366927 Slow queries: 0 Opens: 100 Open tables: 94 Queries per second avg: 1.746 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2003&service=check_mysql [14:03:15] RECOVERY - check_mysql on payments2001 is OK: Uptime: 4217163 Threads: 5 Questions: 7365656 Slow queries: 0 Opens: 100 Open tables: 94 Queries per second avg: 1.746 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2001&service=check_mysql [14:06:13] RECOVERY - check_mysql on payments1006 is OK: Uptime: 146 Threads: 5 Questions: 349 Slow queries: 0 Opens: 98 Open tables: 92 Queries per second avg: 2.390 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments1006&service=check_mysql [14:29:00] 10Fundraising-Backlog, 10Patch-For-Review: Pass additional params from Payments to thank you page URL - https://phabricator.wikimedia.org/T340058 (10AKanji-WMF) Have checked in with @HNordeenWMF on relative priority, here's her response: * *Asterisks are must-haves for logic in survey **Bolded ** are nice to... [16:02:04] 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM, 10fundraising-tech-ops: Install `coworker` and `cv` on prod - https://phabricator.wikimedia.org/T324611 (10Dwisehaupt) @Eileenmcnaughton Thanks, we have made progress. coworker now attempts to start but if failing with the following errors: ` systemd[1]... [16:03:15] PROBLEM - check_mysql on payments2003 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2003&service=check_mysql [16:03:15] PROBLEM - check_mysql on payments2001 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2001&service=check_mysql [16:06:13] PROBLEM - check_mysql on payments2002 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [16:07:54] 10Fundraising-Backlog, 10Recurring-Donations, 10fr-donorservices: Enable drop-down menu for DR to indicate recurring cancel reason - https://phabricator.wikimedia.org/T341247 (10AKanji-WMF) [16:08:17] RECOVERY - check_mysql on payments2003 is OK: Uptime: 154 Threads: 5 Questions: 323 Slow queries: 0 Opens: 100 Open tables: 94 Queries per second avg: 2.097 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2003&service=check_mysql [16:08:17] RECOVERY - check_mysql on payments2001 is OK: Uptime: 209 Threads: 5 Questions: 392 Slow queries: 0 Opens: 97 Open tables: 91 Queries per second avg: 1.875 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2001&service=check_mysql [16:11:13] PROBLEM - check_mysql on payments2002 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [16:16:13] PROBLEM - check_mysql on payments2002 is CRITICAL: Slave IO: No Slave SQL: No Seconds Behind Master: (null) https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [16:18:13] 10Fundraising-Backlog, 10Recurring-Donations, 10fr-donorservices: Enable drop-down menu for DR to indicate recurring cancel reason - https://phabricator.wikimedia.org/T341247 (10AKanji-WMF) [16:21:13] RECOVERY - check_mysql on payments2002 is OK: Uptime: 271 Threads: 5 Questions: 500 Slow queries: 0 Opens: 99 Open tables: 93 Queries per second avg: 1.845 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 0 https://icinga.wikimedia.org/cgi-bin/icinga/extinfo.cgi?type=2&host=payments2002&service=check_mysql [16:27:47] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching gift import - Catching duplicates where cannot be confirmed - https://phabricator.wikimedia.org/T339976 (10MDemosWMF) @Eileenmcnaughton We had discussed during the offsite that a solution for this could be to add a CID column to the import file f... [16:29:59] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching gift import - Catching duplicates where cannot be confirmed - https://phabricator.wikimedia.org/T339976 (10MDemosWMF) I can save the example file with the new CID column to the server: smb://filesrv1/Fundraising/Tech/Fr-Ops/Matching Import/Real d... [16:46:43] 10Fundraising-Backlog: Major Gifts team update - no auto Civi TYL suppression - https://phabricator.wikimedia.org/T341263 (10MDemosWMF) [17:06:02] !log SmashPig upgraded from db23b998 to 95181a1b [17:06:03] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:12:40] (03PS1) 10Jgleeson: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/936077 [17:22:41] 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog: Browser info needs to be sent on initial recurring transactions to improve credit card approval rates - https://phabricator.wikimedia.org/T340168 (10EMartin) @Cstone Is there any reason we can't send the browser info in all markets in the EU w... [17:28:47] (03CR) 10Jgleeson: [C: 03+2] Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/936077 (owner: 10Jgleeson) [17:29:44] (03Merged) 10jenkins-bot: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - 10https://gerrit.wikimedia.org/r/936077 (owner: 10Jgleeson) [17:33:01] !log tools upgraded from 2ca83336 to 10972e59 [17:33:02] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [17:33:09] dwisehaupt: tools update just went out ^ [17:33:23] cool thanks! [17:54:52] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10FR-dlocal, 10Recurring-Donations: dLocal recurring INR success rates for 2nd month, post on-demand switch - https://phabricator.wikimedia.org/T338351 (10EMartin) @Cstone I see the following reject rate. I think we go back to Dlocal with this as thi... [18:00:25] cstone: ok. i'm ready to run the audit downloader to verify it is working. [18:02:08] nice dwisehaupt [18:02:11] looks like it's pulling files. woot! [18:02:34] woo! [18:02:56] we see the "Welcome! Please login." banner for each file. which is annoying, but i don't think it will mess anything up. [18:04:21] Successfully completed ingenico_audit_download. [18:04:23] looks good. [18:04:53] files look good on disk. [18:05:10] ok. i'm going to get this dog out for a walk and then i'll update the task when i'm back. [18:05:16] thanks for your help here. [18:08:39] thanks dwisehaupt ! [18:29:55] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog: Matching import - duplicate contribution error - https://phabricator.wikimedia.org/T339050 (10MDemosWMF) Got 3 more of these after import here: https://civicrm.wikimedia.org/civicrm/search#/display/Import_603/Import_603?_status=ERROR Row 9-11 [18:33:29] 10Fundraising-Backlog: Cannot merge records with almost exact same information - https://phabricator.wikimedia.org/T341276 (10MDemosWMF) [18:48:31] 10Fundraising-Backlog: We need to list of canceled recurrings in India to send to dLocal for them to stop sending pre-notification texts to donors - https://phabricator.wikimedia.org/T340242 (10Cstone) Ok this will be for the recurring donors that were created with the monthly flow [18:52:28] 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10fundraising-tech-ops: Ingenico Audit not downloading files on new Ingenico system - https://phabricator.wikimedia.org/T340798 (10Dwisehaupt) Tools repo and process-control changes were deployed today. A test of the download was successful. [20:22:49] 10Fundraising Sprint Istanbool (not Constantidouble), 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10Patch-For-Review: Update acoustic export to include new segment fields - https://phabricator.wikimedia.org/T339296 (10DBu-WMF) I am concerned that Katie would need to do QA on this du... [23:01:10] 10Fundraising-Backlog: Send browser data to Adyen on CC transactions so we can optionally toggle on/off 3DS on demand - https://phabricator.wikimedia.org/T341299 (10EMartin) [23:03:33] 10Fundraising-Backlog: India Recurring - Handle Wallet disabled status in IPNs - https://phabricator.wikimedia.org/T341300 (10Cstone) [23:03:55] 10Fundraising-Backlog: India Recurring - Handle Wallet disabled status in IPNs - https://phabricator.wikimedia.org/T341300 (10Cstone) [23:03:57] 10Fundraising Sprint Message in a JSON blob, 10Fundraising-Backlog, 10Epic: India Recurring - Post launch issues epic - https://phabricator.wikimedia.org/T339180 (10Cstone) [23:12:58] 10Fundraising-Backlog: India Recurring - Figure out when to actually cancel donations - https://phabricator.wikimedia.org/T339181 (10EMartin) Please note dlocal advises the following code has been enabled and we should NOT retry when we receive it. I am confirming on reject codes 300 and 321. //From Dlocal 6 J... [23:50:15] (03PS1) 10Jgleeson: Add config for new fundraising-tools service container [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/936103 (https://phabricator.wikimedia.org/T341017) [23:51:43] (03Abandoned) 10Jgleeson: [WIP] jobs service [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/841441 (https://phabricator.wikimedia.org/T301905) (owner: 10AndyRussG) [23:53:52] (03PS2) 10Jgleeson: Add config for new fundraising-tools service container [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/936103 (https://phabricator.wikimedia.org/T341017)