[00:15:24] (PS1) Eileen: Fix typo & declare dependency (latter was an PR submitted to us) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549672 [00:15:43] (PS1) Eileen: Update Readme [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549673 [00:15:45] (PS1) Eileen: Regenerated boilerplate [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549674 [02:55:30] (PS1) Eileen: Add name_pairs table and resolver to choose to avoid misspellings [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549693 [03:01:41] (CR) jerkins-bot: [V: -1] Add name_pairs table and resolver to choose to avoid misspellings [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549693 (owner: Eileen) [03:03:55] (PS2) Eileen: Add name_pairs table and resolver to choose to avoid misspellings [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549693 [03:04:59] (PS3) Eileen: Add name_pairs table and resolver to choose to avoid misspellings [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549693 [03:15:44] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Readonly DB connection available to turn on - https://phabricator.wikimedia.org/T237350 (Eileenmcnaughton) I discovered an issue with turning logging on & off https://github.com/totten/rpow/issues/6 Also this https://gerrit.wikimedia.org/r/#/c/wikimedi... [07:36:39] (PS4) Eileen: Add name_pairs table and resolvers [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549693 [08:04:21] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Opt in - maybe create activities so we don't lose history? - https://phabricator.wikimedia.org/T237714 (Eileenmcnaughton) [08:06:44] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Opt in - remove from suppression list - https://phabricator.wikimedia.org/T237715 (Eileenmcnaughton) [13:18:29] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: Need to reset password for user silverpop-upload@wikimedia.org in IBM - https://phabricator.wikimedia.org/T237100 (KHaggard) False alarm, the import this morning is back to normal and pulling the correct date file. Sorry for flagging that too... [13:19:03] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: Need to reset password for user silverpop-upload@wikimedia.org in IBM - https://phabricator.wikimedia.org/T237100 (KHaggard) Open→Resolved [15:04:06] (PS1) Pcoombe: Add elements to monthly convert thank you email [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549865 (https://phabricator.wikimedia.org/T237578) [15:12:13] fr-tech can someone review the above please :) [15:14:17] looking pcoombe :) [15:16:27] thanks [15:21:54] (CR) Mepps: [C: +2] "+2ing but I was curious if the tag or a class was best practice for bold text. I see a class used elsewhere but no css attached." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549865 (https://phabricator.wikimedia.org/T237578) (owner: Pcoombe) [15:27:01] (Merged) jenkins-bot: Add elements to monthly convert thank you email [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549865 (https://phabricator.wikimedia.org/T237578) (owner: Pcoombe) [15:28:50] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Opt in - remove from suppression list - https://phabricator.wikimedia.org/T237715 (CCogdill_WMF) Thanks for opening the ticket! If there's an API call to IBM to remove people on the suppression list, that would be our best bet, though I don't know if th... [15:29:24] (CR) Pcoombe: "> Patch Set 1: Code-Review+2" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549865 (https://phabricator.wikimedia.org/T237578) (owner: Pcoombe) [15:41:12] Fundraising-Backlog: change monthly convert (up sell) logic - https://phabricator.wikimedia.org/T237735 (DStrine) [15:47:03] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: FRUEC: Raise error when no timestamp in filename - https://phabricator.wikimedia.org/T237736 (AndyRussG) [15:47:11] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: FRUEC: Raise error when no timestamp in filename - https://phabricator.wikimedia.org/T237736 (AndyRussG) [15:48:00] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog: FRUEC: Raise error when timestamp not found in filename - https://phabricator.wikimedia.org/T237736 (AndyRussG) [15:48:22] (PS1) AndyRussG: Raise error when timestamp not found in filename [wikimedia/fundraising/FRUEC] - https://gerrit.wikimedia.org/r/549873 (https://phabricator.wikimedia.org/T237736) [16:14:26] (CR) Mepps: "Ah got it, I looked at that template but missed it. :)" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549865 (https://phabricator.wikimedia.org/T237578) (owner: Pcoombe) [16:31:41] Fundraising-Backlog: erroneous Paypal subscription termination messaging impacting donor services - https://phabricator.wikimedia.org/T234988 (EMartin) This task has been moved to Phab tasks: T236506 T230064 [16:31:53] Fundraising-Backlog: erroneous Paypal subscription termination messaging impacting donor services - https://phabricator.wikimedia.org/T234988 (EMartin) Open→Resolved [16:36:40] Wikimedia-Fundraising-Banners: IE11 dsk lg & sm: Selecting monthly still gives "monthly convert" option - https://phabricator.wikimedia.org/T235706 (Pcoombe) a:Pcoombe→None [16:53:18] PROBLEM - check_puppetrun on payments2001 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 6 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [16:53:18] PROBLEM - check_puppetrun on payments2003 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 6 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [16:55:07] ah shoot, somewhere between upgrading php 7.2 and upgrading phpstorm xdebug now no longer works :( [16:58:21] RECOVERY - check_puppetrun on payments2001 is OK: OK: Puppet is currently enabled, last run 1 minute ago with 0 failures [16:58:21] PROBLEM - check_puppetrun on payments2003 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 11 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:03:21] RECOVERY - check_puppetrun on payments2003 is OK: OK: Puppet is currently enabled, last run 2 minutes ago with 0 failures [17:07:11] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 6 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:12:11] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 22 seconds ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:17:12] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 1 minute ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:22:14] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 6 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:24:17] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (LeanneS) @Cstone Awesome thanks! And on the contribution record, how does the thank you get... [17:27:14] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 11 minutes ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:29:16] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (Cstone) @LeanneS You need to clear out the No Thank-You Reason under the Contibution Extra... [17:31:20] eyener: jkumalah: Here's the Hive query code currently used for the Druid ingress job: https://gerrit.wikimedia.org/r/plugins/gitiles/analytics/refinery/+/master/oozie/banner_activity/druid/daily/generate_daily_druid_banner_activity.hql#40 [17:32:14] PROBLEM - check_puppetrun on frav1002 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 52 seconds ago with 1 failures. Failed resources (up to 3 shown): Package[percona-xtrabackup] [17:32:58] thanks AndyRussG! also found the page you were referencing for partition fields: https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Mediawiki_history [17:34:45] Wikimedia-Fundraising-Banners: Suggested monthly amount won't update after first change - https://phabricator.wikimedia.org/T230439 (Pcoombe) Open→Resolved a:Pcoombe This is fixed in the latest banners. [17:37:14] RECOVERY - check_puppetrun on frav1002 is OK: OK: Puppet is currently enabled, last run 1 minute ago with 0 failures [17:42:42] eyener: ah cool thanks! [17:55:05] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (LeanneS) @Cstone Thanks! I see now what the issue was now. I was clearing out the field, bu... [17:59:32] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (Cstone) @LeanneS oh good to know! Glad you were able to figure it out [18:12:06] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Automatic DAF thank you email - https://phabricator.wikimedia.org/T233374 (LeanneS) @Cstone Same! And just to confirm, if there is no email address, the Thank-You Sen... [18:17:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:22:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:27:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:32:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:35:43] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe: Civi dedupe: request to Move Related prospect tab data by default - https://phabricator.wikimedia.org/T232625 (LeanneS) @Eileenmcnaughton When merging, I found that many of the prospect f... [18:37:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:38:06] (PS2) Ejegg: Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) [18:40:30] cstone: hmm, now I'm wondering if that original_gross field really exists on the subscr_signup that comes from payments-wiki [18:41:12] ok, lemme do a real end to end test on that [18:42:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:43:23] (CR) jerkins-bot: [V: -1] Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) (owner: Ejegg) [18:47:14] PROBLEM - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) [18:49:39] ACKNOWLEDGEMENT - check_mysql on frdb1001 is CRITICAL: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2 No such file or directory) Dwisehaupt working on rebuild [19:37:34] (PS3) Ejegg: Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) [19:41:23] ok, the original_gross is added reliably during message normalization [19:41:50] ejegg I think thats what threw me off it wasnt on the initial msg but on the one sent to the thank you [19:43:34] yeah, 'normalize' is a bit of an understatement for that fn [19:44:01] converting donations to USD could be in another fn [19:46:51] (PS4) Ejegg: Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) [19:49:54] ok, ^^^ should be ready for review [19:52:46] (PS7) Ejegg: Fix payment method update fn to add account relationship [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/548823 (https://phabricator.wikimedia.org/T235212) [19:53:19] (CR) Ejegg: "Thanks! Just for ease of review, I updated my own patch with this fix." [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549239 (owner: Eileen) [20:07:45] (CR) Eileen: [C: +2] Fix payment method update fn to add account relationship [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/548823 (https://phabricator.wikimedia.org/T235212) (owner: Ejegg) [20:09:01] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Opt in - remove from suppression list - https://phabricator.wikimedia.org/T237715 (Eileenmcnaughton) Yes - might as well ask the question! [20:10:49] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, FR-Civi-Dedupe: Civi dedupe: request to Move Related prospect tab data by default - https://phabricator.wikimedia.org/T232625 (Eileenmcnaughton) @LeanneS so the checkbox should be checked by default if... [20:17:41] Fundraising-Backlog: make continue button (not credit card selection) default on cc forms - https://phabricator.wikimedia.org/T237761 (DStrine) [20:43:47] (PS5) Ejegg: Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) [21:07:13] (PS1) Ejegg: EOY summary: use Hawaii time zone [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549931 (https://phabricator.wikimedia.org/T195907) [21:12:20] PROBLEM - check_procs on frdb1002 is CRITICAL: PROCS CRITICAL: 1001 processes [21:14:05] (PS3) Ejegg: Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 (owner: Eileen) [21:14:10] (CR) Ejegg: [C: +2] Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 (owner: Eileen) [21:15:00] thanks ejegg - one minor annoyance down ! [21:16:53] thank you! [21:17:20] RECOVERY - check_procs on frdb1002 is OK: PROCS OK: 223 processes [21:19:37] (Merged) jenkins-bot: Fix oddness of middle name (this is why it shows as a link unlike the others) [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549644 (owner: Eileen) [21:49:32] (CR) Cstone: [C: +2] "Looks good!" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) (owner: Ejegg) [21:55:11] (Merged) jenkins-bot: Use amount to match currency in recur notification [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/549209 (https://phabricator.wikimedia.org/T235105) (owner: Ejegg) [22:06:16] Fundraising-Backlog: Monthly convert: min/max logic - https://phabricator.wikimedia.org/T237775 (spatton) [22:11:43] Fundraising-Backlog: Monthly convert: min/max logic - https://phabricator.wikimedia.org/T237775 (spatton) Hang on a minute, @ejegg - I am thinking about this and realizing it might be much easier to just set this check in the banners, and only send CC donors to the upsell variant if their one-time gift meets... [22:20:29] Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26): New iframe failure issues (confirmed modern browsers) - https://phabricator.wikimedia.org/T235126 (MBeat33) thanks, @XenoRyet [22:27:42] Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, Fr-cross-training, MediaWiki-extensions-CentralNotice: Rebase and finish Geotargeting (sub national targeting) - https://phabricator.wikimedia.org/T226438 (Ejegg) p:Triage→Normal a:Ejegg [22:34:21] Fundraising-Backlog, fundraising-tech-ops, DC-Ops: frdb1001 has suffered a raid event resulting in /dev/sda going read only - https://phabricator.wikimedia.org/T236739 (Dwisehaupt) Open→Resolved [22:38:35] Fundraising-Backlog, fundraising-tech-ops: Issue new SSL Client Certificate for msaloky - https://phabricator.wikimedia.org/T237776 (Dwisehaupt) [22:39:41] Fundraising Sprint Sysadmin Kane, Fundraising Sprint Trojan Horse Wisperer, Fundraising Sprint Usual Subscripts, Fundraising Sprint Visual Basic Instinct, and 5 others: Annual totals receipt thank you email for recurring donors - https://phabricator.wikimedia.org/T195907 (MBeat33) > report all th... [22:43:39] Fundraising-Backlog: Monthly convert pwk modal variant 001 (no diff amt option) - https://phabricator.wikimedia.org/T237777 (spatton) [22:47:38] Fundraising-Backlog: Monthly convert pwk modal variant 002 (alt paragraph text) - https://phabricator.wikimedia.org/T237778 (spatton) [22:48:26] Fundraising-Backlog: Civi: how to exclude recent Stripe donors from fundraising email sends? - https://phabricator.wikimedia.org/T237338 (CCogdill_WMF) Fwiw, I don't think the problem is the filtering scan, I think it's the timing of when this stripe donation got added to Civi. If I'm reading their contribut... [22:51:26] Fundraising-Backlog: Monthly convert pwk modal variant 003 (alt headline text) - https://phabricator.wikimedia.org/T237779 (spatton)