Page MenuHomePhabricator

Dwisehaupt (Dallas Wisehaupt)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Aug 27 2019, 5:42 PM (88 w, 3 d)
Availability
Available
LDAP User
Dwisehaupt
MediaWiki User
Unknown

Recent Activity

Yesterday

Dwisehaupt created T282289: Set up mysql replication for donorwiki/frdata hosts.
Fri, May 7, 10:27 PM · fr-email-preference-center, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt updated the task description for T281111: Fundraising access request for Julia Brungs .
Fri, May 7, 9:46 PM · fundraising-tech-ops
Dwisehaupt added a comment to T281111: Fundraising access request for Julia Brungs .
Date: Fri, 7 May 2021 08:53:34
From: Lisa Gruwell
To: Megan Hernandez
Cc: Dallas Wisehaupt
Subject: Re: Please approve Julia Brungs superset access
----------------------------------------
Fri, May 7, 9:44 PM · fundraising-tech-ops
Dwisehaupt closed T281955: Set up and configure donor_prefs redis instance on FR queue role, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, as Resolved.
Fri, May 7, 9:42 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt closed T281955: Set up and configure donor_prefs redis instance on FR queue role as Resolved.
Fri, May 7, 9:42 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt moved T282286: Deploy pfw policy1620422079 for T268501 and T281320 from Triage to In Progress on the fundraising-tech-ops board.
Fri, May 7, 9:42 PM · netops, SRE, WMF-NDA, fr-email-preference-center, fundraising-tech-ops
Dwisehaupt created T282286: Deploy pfw policy1620422079 for T268501 and T281320.
Fri, May 7, 9:19 PM · netops, SRE, WMF-NDA, fr-email-preference-center, fundraising-tech-ops

Thu, May 6

Dwisehaupt closed T281320: Network configuration for Civiproxy, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, as Resolved.
Thu, May 6, 4:05 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt closed T281320: Network configuration for Civiproxy as Resolved.

All of the iptables and pfw rules have been pushed. Basic connectivity verified. On to testing all the functionality.

Thu, May 6, 4:05 PM · fr-email-preference-center, fundraising-tech-ops

Wed, May 5

Dwisehaupt added a comment to T281111: Fundraising access request for Julia Brungs .

@MeganHernandez_WMF ping to check on the access request. Did you need for me to submit it to Lisa?

Wed, May 5, 9:49 PM · fundraising-tech-ops
Dwisehaupt reopened Restricted Task, a subtask of T281955: Set up and configure donor_prefs redis instance on FR queue role, as Open.
Wed, May 5, 8:44 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt closed Restricted Task, a subtask of T281955: Set up and configure donor_prefs redis instance on FR queue role, as Resolved.
Wed, May 5, 6:38 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt reopened Restricted Task, a subtask of T281955: Set up and configure donor_prefs redis instance on FR queue role, as Open.
Wed, May 5, 6:21 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt closed T281311: Create fundraising_code_update project for civiproxy, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, as Resolved.
Wed, May 5, 5:24 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt closed T281311: Create fundraising_code_update project for civiproxy as Resolved.

This has been verified. Closing.

Wed, May 5, 5:24 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt added a subtask for T281955: Set up and configure donor_prefs redis instance on FR queue role: Unknown Object (Task).
Wed, May 5, 4:39 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt added a comment to T281955: Set up and configure donor_prefs redis instance on FR queue role.

Redis config rolled out. iptables rules updated and pushed. eqiad hosts are running and replicating. codfw hosts are running but waiting on T281942 for replication to be completed.

Wed, May 5, 4:38 PM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt moved T281955: Set up and configure donor_prefs redis instance on FR queue role from Triage to In Progress on the fundraising-tech-ops board.
Wed, May 5, 12:39 AM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt created T281955: Set up and configure donor_prefs redis instance on FR queue role.
Wed, May 5, 12:39 AM · fr-email-preference-center, fundraising-tech-ops, Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt claimed T281320: Network configuration for Civiproxy.
Wed, May 5, 12:32 AM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt claimed T281321: Add Apache/Nginx config to serve Civiproxy.
Wed, May 5, 12:32 AM · fr-email-preference-center, fundraising-tech-ops

Tue, May 4

Dwisehaupt moved T281320: Network configuration for Civiproxy from Up Next to In Progress on the fundraising-tech-ops board.
Tue, May 4, 5:36 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt moved T281321: Add Apache/Nginx config to serve Civiproxy from Up Next to In Progress on the fundraising-tech-ops board.
Tue, May 4, 5:36 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt added a comment to T281321: Add Apache/Nginx config to serve Civiproxy.

I have pushed out the apache and nginx configs. nginx is serving on port 442 with the puppet ssl certs and forwarding to a low proxy port for apache. Still researching the possibility of adding rate limiting and how to work that into the overall nginx templates.

Tue, May 4, 5:07 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt updated the task description for T281321: Add Apache/Nginx config to serve Civiproxy.
Tue, May 4, 5:03 PM · fr-email-preference-center, fundraising-tech-ops

Thu, Apr 29

Dwisehaupt claimed T281311: Create fundraising_code_update project for civiproxy.
Thu, Apr 29, 8:22 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@Dwisehaupt is you see this - the file to delete is DatabaseUpdate-20210428101101.csv

Thu, Apr 29, 3:48 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Wed, Apr 28

Dwisehaupt added a comment to T281311: Create fundraising_code_update project for civiproxy.

config.php is now pulled in and deposited in /srv/civiproxy. Please verify everything looks ok.

Wed, Apr 28, 10:52 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt added a comment to T281311: Create fundraising_code_update project for civiproxy.

The repo has been added to frdeploy and the code has been pushed to the fundraising_qa and civicrm roles in /srv/civiproxy. The config.php file from localsettings did not appear to come across so need to find out why that is the case.

Wed, Apr 28, 10:46 PM · fr-email-preference-center, fundraising-tech-ops
Dwisehaupt moved T281177: (Need By: TBD) rack/setup/install frdb2003.frack.codfw.wmnet from Triage to Watching on the fundraising-tech-ops board.
Wed, Apr 28, 10:34 PM · SRE, fundraising-tech-ops, ops-codfw, DC-Ops
Dwisehaupt moved T281311: Create fundraising_code_update project for civiproxy from Triage to In Progress on the fundraising-tech-ops board.
Wed, Apr 28, 10:33 PM · fr-email-preference-center, fundraising-tech-ops

Tue, Apr 27

Dwisehaupt closed T268512: Add new queue settings for email-preferences as Resolved.
Tue, Apr 27, 7:23 PM · fundraising-tech-ops, Fundraising Sprint Humongous bacteria petting zoo, Fundraising Sprint Git Rebase Jump, fr-email-preference-center, FR-Smashpig, Fundraising-Backlog
Dwisehaupt closed T268512: Add new queue settings for email-preferences, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, as Resolved.
Tue, Apr 27, 7:23 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Dwisehaupt added a project to T268512: Add new queue settings for email-preferences: fundraising-tech-ops.
Tue, Apr 27, 7:21 PM · fundraising-tech-ops, Fundraising Sprint Humongous bacteria petting zoo, Fundraising Sprint Git Rebase Jump, fr-email-preference-center, FR-Smashpig, Fundraising-Backlog
Dwisehaupt added a comment to T268512: Add new queue settings for email-preferences.

Added in the config for smashpig/main.yaml.erb and added it to the redis_collector for gathering stats.

commit 209ddd6fef58652e6cdaacbc5c4bab19e86aee1e (HEAD -> master)
Author: Dallas Wisehaupt <dwisehaupt@wikimedia.org>
Date:   Tue Apr 27 19:15:04 2021 +0000
Tue, Apr 27, 7:19 PM · fundraising-tech-ops, Fundraising Sprint Humongous bacteria petting zoo, Fundraising Sprint Git Rebase Jump, fr-email-preference-center, FR-Smashpig, Fundraising-Backlog

Mon, Apr 26

Dwisehaupt added a comment to T281111: Fundraising access request for Julia Brungs .

@MeganHernandez_WMF Just wanted to check to see if you had sent on the request for access to Lisa or if you would like for me to do that. Additionally, we will need to get Julia added to the contact list with her information.

Mon, Apr 26, 5:15 PM · fundraising-tech-ops
Dwisehaupt moved T281111: Fundraising access request for Julia Brungs from Triage to Up Next on the fundraising-tech-ops board.
Mon, Apr 26, 4:56 PM · fundraising-tech-ops
Dwisehaupt updated the task description for T281111: Fundraising access request for Julia Brungs .
Mon, Apr 26, 4:56 PM · fundraising-tech-ops

Fri, Apr 23

Dwisehaupt closed T280568: Fundraising access request for Donor Relations Admin Associate, Doris Morgan. as Resolved.

Verified installation is working.

Fri, Apr 23, 7:47 PM · fundraising-tech-ops, fr-donorservices
Dwisehaupt updated the task description for T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Fri, Apr 23, 7:02 PM · Patch-For-Review, fundraising-tech-ops, SRE
Dwisehaupt updated the task description for T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Fri, Apr 23, 5:44 PM · Patch-For-Review, fundraising-tech-ops, SRE
Dwisehaupt moved T280527: payments1006.frack.eqiad.wmnet DRAC no console output from Triage to Done on the fundraising-tech-ops board.
Fri, Apr 23, 5:44 PM · fundraising-tech-ops, SRE, DC-Ops, ops-eqiad

Mon, Apr 19

Dwisehaupt added a project to T280527: payments1006.frack.eqiad.wmnet DRAC no console output : fundraising-tech-ops.
Mon, Apr 19, 7:14 PM · fundraising-tech-ops, SRE, DC-Ops, ops-eqiad
Dwisehaupt removed projects from T266481: (Need By: TBD) rack/setup/install payments100[5-8]: ops-eqiad, DC-Ops.

Backing that out and removing the ops tags as @Jgreen created T280527 this morning specifically about the console issue.

Mon, Apr 19, 7:13 PM · Patch-For-Review, fundraising-tech-ops, SRE
Dwisehaupt added projects to T266481: (Need By: TBD) rack/setup/install payments100[5-8]: DC-Ops, ops-eqiad.

Re-adding the ops tags to get payments1006 back on the radar for the console redirection.

Mon, Apr 19, 7:09 PM · Patch-For-Review, fundraising-tech-ops, SRE
Dwisehaupt updated the task description for T280568: Fundraising access request for Donor Relations Admin Associate, Doris Morgan..
Mon, Apr 19, 6:14 PM · fundraising-tech-ops, fr-donorservices
Dwisehaupt added a comment to T280568: Fundraising access request for Donor Relations Admin Associate, Doris Morgan..

Certificate generated and sent via email. Password sent via SMS.

Mon, Apr 19, 6:14 PM · fundraising-tech-ops, fr-donorservices
Dwisehaupt moved T280568: Fundraising access request for Donor Relations Admin Associate, Doris Morgan. from Triage to In Progress on the fundraising-tech-ops board.
Mon, Apr 19, 6:07 PM · fundraising-tech-ops, fr-donorservices
Dwisehaupt added a project to T280568: Fundraising access request for Donor Relations Admin Associate, Doris Morgan.: fundraising-tech-ops.
Mon, Apr 19, 4:59 PM · fundraising-tech-ops, fr-donorservices

Fri, Apr 16

Dwisehaupt added a comment to T279804: Visits to Wikimedia properties should not be used for Google ad targeting (FLoC).

Header added to fundraising nginx templates and deployed.

[frack::puppet] 58ed92cf Add Permissions-Policy header (Google FLoC)
Fri, Apr 16, 5:31 PM · fundraising-tech-ops, Patch-For-Review, SRE, Traffic, Privacy Engineering, Privacy
Dwisehaupt moved T279804: Visits to Wikimedia properties should not be used for Google ad targeting (FLoC) from Triage to Watching on the fundraising-tech-ops board.
Fri, Apr 16, 5:23 PM · fundraising-tech-ops, Patch-For-Review, SRE, Traffic, Privacy Engineering, Privacy
Dwisehaupt added a project to T279804: Visits to Wikimedia properties should not be used for Google ad targeting (FLoC): fundraising-tech-ops.
Fri, Apr 16, 5:23 PM · fundraising-tech-ops, Patch-For-Review, SRE, Traffic, Privacy Engineering, Privacy

Thu, Apr 15

Dwisehaupt closed T279287: Fundraising access request for Donor Services agent Lindsay as Resolved.
Thu, Apr 15, 10:45 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog

Wed, Apr 14

Dwisehaupt moved T280080: Enable SSL for CiviCRM DB connections from Backlog to Watching on the fundraising-tech-ops board.
Wed, Apr 14, 11:09 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T170321: encrypt fundraising database client->server communication.

Note: Can't roll forward on require ssl for the fr_stats db user until we sort out the older python2 DjangoBannerStats code and its connections.

Wed, Apr 14, 7:17 PM · Patch-For-Review, fundraising-tech-ops

Tue, Apr 13

Dwisehaupt moved T280080: Enable SSL for CiviCRM DB connections from Triage to Backlog on the fundraising-tech-ops board.
Tue, Apr 13, 9:14 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt created T280080: Enable SSL for CiviCRM DB connections.
Tue, Apr 13, 9:14 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T170321: encrypt fundraising database client->server communication.

Grant scripts updated to use 'create user or replace' (available since 10.1.3) which will allow us to run the scripts and just update the user accounts without the need to drop and recreate grants if we so desire. Tested with my user account and runsgood.

Tue, Apr 13, 7:10 PM · Patch-For-Review, fundraising-tech-ops

Thu, Apr 8

Dwisehaupt moved T279287: Fundraising access request for Donor Services agent Lindsay from Up Next to In Progress on the fundraising-tech-ops board.
Thu, Apr 8, 9:08 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt updated the task description for T279287: Fundraising access request for Donor Services agent Lindsay.
Thu, Apr 8, 9:02 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T279287: Fundraising access request for Donor Services agent Lindsay.

civicrm and superset accounts created. Passwords and instructions sent to Lindsay so she can initiate password changes and resets.

Thu, Apr 8, 9:00 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T279287: Fundraising access request for Donor Services agent Lindsay.

SSL client cert created and sent via email. Password sent via SMS.

Thu, Apr 8, 8:41 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt closed T279611: New ssh key for rmurthy as Resolved.

Key file updated. Pushed to hosts and rmurthy verified access is working as expected. closing.

Thu, Apr 8, 7:44 PM · fundraising-tech-ops
Dwisehaupt renamed T279287: Fundraising access request for Donor Services agent Lindsay from Civi access for Donor Services agent Lindsay to Fundraising access request for Donor Services agent Lindsay.
Thu, Apr 8, 4:44 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog

Apr 7 2021

Dwisehaupt updated subscribers of T279611: New ssh key for rmurthy.
Apr 7 2021, 11:39 PM · fundraising-tech-ops
Dwisehaupt created T279611: New ssh key for rmurthy.
Apr 7 2021, 11:39 PM · fundraising-tech-ops
Dwisehaupt moved T279576: Adjust namings in code/config/documentation in FR-tech land from Triage to Backlog on the fundraising-tech-ops board.
Apr 7 2021, 9:03 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T279576: Adjust namings in code/config/documentation in FR-tech land.
[frack::puppet] 7eb60640 Renaming of kmod blacklist to blocklist
Apr 7 2021, 8:56 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt created T279576: Adjust namings in code/config/documentation in FR-tech land.
Apr 7 2021, 7:25 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt closed T279561: Deactivate FR Tech account for seddon as Resolved.

This has been completed and pushed.

Apr 7 2021, 6:02 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt updated the task description for T279561: Deactivate FR Tech account for seddon.
Apr 7 2021, 5:55 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt moved T279561: Deactivate FR Tech account for seddon from Triage to In Progress on the fundraising-tech-ops board.
Apr 7 2021, 5:13 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt created T279561: Deactivate FR Tech account for seddon.
Apr 7 2021, 3:56 PM · fundraising-tech-ops, Fundraising-Backlog

Apr 6 2021

Dwisehaupt moved T170321: encrypt fundraising database client->server communication from Up Next to In Progress on the fundraising-tech-ops board.
Apr 6 2021, 9:53 PM · Patch-For-Review, fundraising-tech-ops

Apr 5 2021

Dwisehaupt claimed T279287: Fundraising access request for Donor Services agent Lindsay.
Apr 5 2021, 4:26 PM · fr-donorservices, fundraising-tech-ops, Fundraising-Backlog

Apr 2 2021

Dwisehaupt added a comment to T277184: Fundraising environment support for Debian 11 (Bullseye).

Changes of note at this point: https://www.debian.org/releases/bullseye/amd64/release-notes/ch-information.en.html

Apr 2 2021, 6:05 PM · fundraising-tech-ops
Dwisehaupt closed T243342: Audit mysql grants and ensure the grant scripts reflect the current reality as Resolved.

This has been completed and is in the regular review cycle.

Apr 2 2021, 5:51 PM · fundraising-tech-ops
Dwisehaupt added a comment to T170321: encrypt fundraising database client->server communication.

Replication user on fundraising db set to require ssl. Grants script pushed and run on frdb1004. Replication stopped and restarted on a set of hosts and the connection succeeded and replication continues. mysql.user table shows updated ssl_type value.

Apr 2 2021, 3:54 AM · Patch-For-Review, fundraising-tech-ops
Dwisehaupt added a comment to T170321: encrypt fundraising database client->server communication.

Replication user on payments db set to require ssl. Grants script pushed and run on payments1001. Replication stopped and started on a subset of hosts and the connection continues. At the mysql.user table level, the change is seen in the ssl_type value.

Before:
+-------------+----------+
| User        | ssl_type |
+-------------+----------+
| replication |          |
| replication |          |
+-------------+----------+
After:
+-------------+----------+
| User        | ssl_type |
+-------------+----------+
| replication | ANY      |
| replication | ANY      |
+-------------+----------+
Apr 2 2021, 3:16 AM · Patch-For-Review, fundraising-tech-ops

Apr 1 2021

Dwisehaupt closed T277710: Enable GTID for payments-wiki mariadb as Resolved.

This is complete. All hosts using GTID for replication.

Apr 1 2021, 8:47 PM · fundraising-tech-ops
Dwisehaupt created T279097: Shut down the new style fundraising kafakatee collection in codfw.
Apr 1 2021, 7:51 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T170321: encrypt fundraising database client->server communication.

Pushed this for make_grants to allow the ability to require ssl on user db connections. Not currently enabled for any accounts yet.

[frack::puppet::private] e69d624 Add requires option to user definitions
Apr 1 2021, 6:01 PM · Patch-For-Review, fundraising-tech-ops

Mar 31 2021

Dwisehaupt closed T278593: Remove fundraising stretch repos as Resolved.

All clear and good.

Mar 31 2021, 5:47 PM · fundraising-tech-ops
Dwisehaupt closed T278593: Remove fundraising stretch repos, a subtask of T277215: Remove fundraising puppet stretch exceptions, as Resolved.
Mar 31 2021, 5:47 PM · fundraising-tech-ops

Mar 30 2021

Dwisehaupt moved T278171: Investigation: General architectural directions for FR-Tech stack from Triage to Watching on the fundraising-tech-ops board.
Mar 30 2021, 10:23 PM · fundraising-tech-ops, Epic, Fundraising-Backlog
Dwisehaupt closed T250441: Move from phantomJS to grafana-image-renderer for frack grafana, a subtask of T246119: Upgrade fundraising grafana to v6.6, as Declined.
Mar 30 2021, 10:16 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt closed T250441: Move from phantomJS to grafana-image-renderer for frack grafana as Declined.

This is not needed for our use cases. If it comes up as needed in the future we can revisit it.

Mar 30 2021, 10:16 PM · fundraising-tech-ops
Dwisehaupt moved T243342: Audit mysql grants and ensure the grant scripts reflect the current reality from Backlog to Up Next on the fundraising-tech-ops board.
Mar 30 2021, 10:15 PM · fundraising-tech-ops
Dwisehaupt moved T170321: encrypt fundraising database client->server communication from Backlog to Up Next on the fundraising-tech-ops board.
Mar 30 2021, 10:15 PM · Patch-For-Review, fundraising-tech-ops
Dwisehaupt added a comment to T278388: Paypal Payflow IP changes.

This may be from the 'original' paypal integration and may not be of concern. We have time to research before May 1.

Mar 30 2021, 10:14 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt moved T278593: Remove fundraising stretch repos from Triage to In Progress on the fundraising-tech-ops board.
Mar 30 2021, 10:13 PM · fundraising-tech-ops
Dwisehaupt added a comment to T278593: Remove fundraising stretch repos.

The stretch repos have been pulled from config, /var/www/reprepro/stretch removed, and puppet hosts sync'd.

Mar 30 2021, 10:00 PM · fundraising-tech-ops
Dwisehaupt moved T273699: Paypal IP address change from Backlog to Done on the Fundraising Sprint File Systems Stage Show board.
Mar 30 2021, 8:12 PM · Fundraising Sprint File Systems Stage Show, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt closed T273699: Paypal IP address change as Resolved.

There is a new task to track the failures to pull since they are not transport related. (T278878) Closing this task.

Mar 30 2021, 8:12 PM · Fundraising Sprint File Systems Stage Show, fundraising-tech-ops, Fundraising-Backlog

Mar 26 2021

Dwisehaupt created T278593: Remove fundraising stretch repos.
Mar 26 2021, 10:41 PM · fundraising-tech-ops
Dwisehaupt moved T278508: Sort out replication error on frdb2002 from Triage to FR-Ops on the Fundraising-Backlog board.
Mar 26 2021, 7:07 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt closed T278508: Sort out replication error on frdb2002 as Resolved.

DB is recloned. It and the source db (frdb2001) are back in action.

Mar 26 2021, 7:07 PM · fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T273699: Paypal IP address change.

Ok, today's run failed in the same manner:

Mar 26 2021, 5:59 PM · Fundraising Sprint File Systems Stage Show, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt added a comment to T273699: Paypal IP address change.

The date for this has come and gone. The ssh host key has not changed. There were 2 failmails related to the audit process but they were about failures to handle a corrupted file. Awaiting the run today to see if that has been sorted.

Mar 26 2021, 4:58 PM · Fundraising Sprint File Systems Stage Show, fundraising-tech-ops, Fundraising-Backlog
Dwisehaupt claimed T278508: Sort out replication error on frdb2002.

After digging in, I found the issue. There was one transaction that was skipped during the utf8mb4 testing and other work on frdb2002. When trying to reapply that transaction, I hit a snag with dupe keys on the log tables. This prompted the thought that the log tables may be 'off by one' on this host and could thus cause issues in the future. The cleanest and safest route is to reclone from frdb2001. This recloning has started.

Mar 26 2021, 4:55 PM · fundraising-tech-ops, Fundraising-Backlog