Page MenuHomePhabricator

Jgreen (Jeff Green)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Nov 25 2014, 1:54 PM (336 w, 4 d)
Availability
Available
IRC Nick
Jeff_Green
LDAP User
Jgreen
MediaWiki User
Jgreen (wmf) [ Global Accounts ]

Recent Activity

Thu, Apr 29

Jgreen changed the status of T268499: Configure CiviProxy vhost and firewall to allow requests from email prefs box from Declined to Resolved.
Thu, Apr 29, 2:14 PM · fr-email-preference-center, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops, Fundraising-Backlog
Jgreen changed the status of T268499: Configure CiviProxy vhost and firewall to allow requests from email prefs box, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, from Declined to Resolved.
Thu, Apr 29, 2:14 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Jgreen updated the task description for T281320: Network configuration for Civiproxy.
Thu, Apr 29, 2:13 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen renamed T281321: Add Apache/Nginx config to serve Civiproxy from Add Apache config to serve Civiproxy to Add Apache/Nginx config to serve Civiproxy.
Thu, Apr 29, 2:07 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen closed T268499: Configure CiviProxy vhost and firewall to allow requests from email prefs box, a subtask of T125272: Epic: Create Preference Center for donors to manage email subscription preferences, as Declined.
Thu, Apr 29, 2:06 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Jgreen closed T268499: Configure CiviProxy vhost and firewall to allow requests from email prefs box as Declined.

Same stuff has been tasked separately as T281320 and T281321, closing this one.

Thu, Apr 29, 2:06 PM · fr-email-preference-center, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops, Fundraising-Backlog
Jgreen moved T277484: Fix duplicate entries in pgehres tables so we can convert them to utf8mb4 from Up Next to Blocked on the fundraising-tech-ops board.
Thu, Apr 29, 2:03 PM · fundraising-tech-ops, Fundraising-Backlog
Jgreen updated the task description for T281321: Add Apache/Nginx config to serve Civiproxy.
Thu, Apr 29, 1:48 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen moved T281320: Network configuration for Civiproxy from Triage to Up Next on the fundraising-tech-ops board.
Thu, Apr 29, 1:47 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen moved T281321: Add Apache/Nginx config to serve Civiproxy from Triage to Up Next on the fundraising-tech-ops board.
Thu, Apr 29, 1:47 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen moved T255435: Reconfigure fundraising public-reporting server role to fundraising-data from Backlog to Up Next on the fundraising-tech-ops board.
Thu, Apr 29, 1:46 PM · Patch-For-Review, fundraising-tech-ops
Jgreen moved T279097: Shut down the new style fundraising kafakatee collection in codfw from Triage to Blocked on the fundraising-tech-ops board.
Thu, Apr 29, 1:46 PM · fundraising-tech-ops, Fundraising-Backlog
Jgreen triaged T280387: investigate adding additional security headers to Fundraising civicrm, superset, etc. sites as Medium priority.
Thu, Apr 29, 1:44 PM · fundraising-tech-ops
Jgreen added a comment to T281320: Network configuration for Civiproxy.

@Ejegg As far as I know the only server/service planned to access civiproxy is donorwiki, which will run on the frdata servers. Is that what this task is about, and not payments servers?

Thu, Apr 29, 1:44 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen updated the task description for T281321: Add Apache/Nginx config to serve Civiproxy.
Thu, Apr 29, 1:38 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen added a subtask for T125272: Epic: Create Preference Center for donors to manage email subscription preferences: T281320: Network configuration for Civiproxy.
Thu, Apr 29, 1:31 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Jgreen added a parent task for T281320: Network configuration for Civiproxy: T125272: Epic: Create Preference Center for donors to manage email subscription preferences.
Thu, Apr 29, 1:31 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen added a parent task for T281321: Add Apache/Nginx config to serve Civiproxy: T125272: Epic: Create Preference Center for donors to manage email subscription preferences.
Thu, Apr 29, 1:27 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen added a parent task for T281311: Create fundraising_code_update project for civiproxy: T125272: Epic: Create Preference Center for donors to manage email subscription preferences.
Thu, Apr 29, 1:27 PM · fr-email-preference-center, fundraising-tech-ops
Jgreen added subtasks for T125272: Epic: Create Preference Center for donors to manage email subscription preferences: T281321: Add Apache/Nginx config to serve Civiproxy, T281311: Create fundraising_code_update project for civiproxy.
Thu, Apr 29, 1:27 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Jgreen moved T268499: Configure CiviProxy vhost and firewall to allow requests from email prefs box from Backlog to Up Next on the fundraising-tech-ops board.
Thu, Apr 29, 1:22 PM · fr-email-preference-center, Wikimedia-Fundraising-CiviCRM, fundraising-tech-ops, Fundraising-Backlog
Jgreen moved T280034: deploy Let's Encrypt certificates for additional fundraising services from Backlog to Up Next on the fundraising-tech-ops board.
Thu, Apr 29, 1:20 PM · fundraising-tech-ops

Wed, Apr 28

Jgreen claimed T280387: investigate adding additional security headers to Fundraising civicrm, superset, etc. sites.
Wed, Apr 28, 1:32 PM · fundraising-tech-ops

Tue, Apr 27

Jgreen updated the task description for T280387: investigate adding additional security headers to Fundraising civicrm, superset, etc. sites.
Tue, Apr 27, 3:56 PM · fundraising-tech-ops
Jgreen moved T280387: investigate adding additional security headers to Fundraising civicrm, superset, etc. sites from Triage to In Progress on the fundraising-tech-ops board.
Tue, Apr 27, 3:47 PM · fundraising-tech-ops

Mon, Apr 19

Jgreen created T280527: payments1006.frack.eqiad.wmnet DRAC no console output .
Mon, Apr 19, 1:39 PM · fundraising-tech-ops, SRE, DC-Ops, ops-eqiad

Fri, Apr 16

Jgreen moved T280034: deploy Let's Encrypt certificates for additional fundraising services from In Progress to Backlog on the fundraising-tech-ops board.
Fri, Apr 16, 6:01 PM · fundraising-tech-ops
Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Fri, Apr 16, 6:00 PM · fundraising-tech-ops
Jgreen created T280387: investigate adding additional security headers to Fundraising civicrm, superset, etc. sites.
Fri, Apr 16, 5:48 PM · fundraising-tech-ops

Thu, Apr 15

Jgreen closed T280173: timeboxed description of fr-tech vs WMF security settings and processes as Resolved.
Thu, Apr 15, 7:12 PM · Fundraising-Backlog, fundraising-tech-ops

Wed, Apr 14

Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Wed, Apr 14, 9:07 PM · fundraising-tech-ops
Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Wed, Apr 14, 7:58 PM · fundraising-tech-ops
Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Wed, Apr 14, 7:12 PM · fundraising-tech-ops

Tue, Apr 13

Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Tue, Apr 13, 10:09 PM · fundraising-tech-ops
Jgreen updated the task description for T280034: deploy Let's Encrypt certificates for additional fundraising services.
Tue, Apr 13, 10:07 PM · fundraising-tech-ops
Jgreen claimed T280034: deploy Let's Encrypt certificates for additional fundraising services.
Tue, Apr 13, 7:32 PM · fundraising-tech-ops
Jgreen moved T280034: deploy Let's Encrypt certificates for additional fundraising services from Triage to In Progress on the fundraising-tech-ops board.
Tue, Apr 13, 5:50 PM · fundraising-tech-ops
Jgreen added a subtask for T280034: deploy Let's Encrypt certificates for additional fundraising services: Unknown Object (Task).
Tue, Apr 13, 5:12 PM · fundraising-tech-ops
Jgreen triaged T280034: deploy Let's Encrypt certificates for additional fundraising services as Medium priority.
Tue, Apr 13, 2:53 PM · fundraising-tech-ops
Jgreen created T280034: deploy Let's Encrypt certificates for additional fundraising services.
Tue, Apr 13, 2:51 PM · fundraising-tech-ops
Jgreen removed a parent task for T279292: Enable template processing: Unknown Object (Task).
Tue, Apr 13, 1:59 PM · FR-Tech-Analytics, fundraising-tech-ops, Fundraising-Backlog

Apr 5 2021

Jgreen closed T278967: cross-sync audit files between civicrm servers as Resolved.

Done!

Apr 5 2021, 6:54 PM · fundraising-tech-ops
Jgreen moved T278967: cross-sync audit files between civicrm servers from Up Next to In Progress on the fundraising-tech-ops board.
Apr 5 2021, 3:23 PM · fundraising-tech-ops
Jgreen moved T255435: Reconfigure fundraising public-reporting server role to fundraising-data from In Progress to Backlog on the fundraising-tech-ops board.
Apr 5 2021, 3:22 PM · Patch-For-Review, fundraising-tech-ops
Jgreen moved T279292: Enable template processing from Triage to Backlog on the fundraising-tech-ops board.
Apr 5 2021, 3:22 PM · FR-Tech-Analytics, fundraising-tech-ops, Fundraising-Backlog

Apr 2 2021

Jgreen moved T266481: (Need By: TBD) rack/setup/install payments100[5-8] from In Progress to Blocked on the fundraising-tech-ops board.
Apr 2 2021, 6:38 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen reassigned T266481: (Need By: TBD) rack/setup/install payments100[5-8] from Jgreen to Cmjohnson.
Apr 2 2021, 4:02 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen added a comment to T266481: (Need By: TBD) rack/setup/install payments100[5-8].

@Cmjohnson @Jclark-ctr Can you take a look at the serial settings for payments1006? Console redirection isn't working at all. I tried to fix it using racadm but although it seems to accept the settings there's still no DRAC access on com2. Maybe there's something else going on?

Apr 2 2021, 2:20 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen updated the task description for T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Apr 2 2021, 2:16 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen updated the task description for T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Apr 2 2021, 2:14 PM · Patch-For-Review, fundraising-tech-ops, SRE

Apr 1 2021

Jgreen closed T279058: enable SSL database connection for fundraising superset, a subtask of T170321: encrypt fundraising database client->server communication, as Resolved.
Apr 1 2021, 8:52 PM · Patch-For-Review, fundraising-tech-ops
Jgreen closed T279058: enable SSL database connection for fundraising superset as Resolved.
Apr 1 2021, 8:52 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 8:51 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 6:59 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 6:47 PM · fundraising-tech-ops
Jgreen claimed T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 6:02 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 6:01 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 3:24 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 3:12 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 3:06 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 3:01 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 2:59 PM · fundraising-tech-ops
Jgreen updated the task description for T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 2:57 PM · fundraising-tech-ops
Jgreen created T279058: enable SSL database connection for fundraising superset.
Apr 1 2021, 1:39 PM · fundraising-tech-ops

Mar 31 2021

Jgreen moved T278967: cross-sync audit files between civicrm servers from Triage to Up Next on the fundraising-tech-ops board.
Mar 31 2021, 6:50 PM · fundraising-tech-ops
Jgreen added a parent task for T278250: (Need By: TBD) install second SSD into payments100[5-8]: T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Mar 31 2021, 6:45 PM · SRE, ops-eqiad, fundraising-tech-ops, DC-Ops
Jgreen added subtasks for T266481: (Need By: TBD) rack/setup/install payments100[5-8]: Unknown Object (Task), T278250: (Need By: TBD) install second SSD into payments100[5-8].
Mar 31 2021, 6:45 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen added a subtask for T278967: cross-sync audit files between civicrm servers: Unknown Object (Task).
Mar 31 2021, 2:11 PM · fundraising-tech-ops
Jgreen created T278967: cross-sync audit files between civicrm servers.
Mar 31 2021, 2:03 PM · fundraising-tech-ops

Mar 26 2021

Jgreen closed T277899: Move away from rssh in fundraising environment as Resolved.

Done!

Mar 26 2021, 7:59 PM · fundraising-tech-ops

Mar 25 2021

Jgreen claimed T277899: Move away from rssh in fundraising environment.
Mar 25 2021, 7:28 PM · fundraising-tech-ops
Jgreen added a comment to T277899: Move away from rssh in fundraising environment.

We already use openssh's built in sftp server and chroot where applicable. For rsync, after a whole bunch of research and testing a reasonable way to handle this is with script that runs via openssh's ForceCommand. This is similar to rrsync which is bundled with rsync, but without it's additional layer of filesystem access controls. We would also like to support unison. To that end I wrote nopeshell.

Mar 25 2021, 7:28 PM · fundraising-tech-ops

Mar 22 2021

Jgreen reassigned T277171: decommission frqueue1001.frack.eqiad.wmnet from Papaul to Cmjohnson.
Mar 22 2021, 2:30 PM · ops-eqiad, SRE, decommission-hardware
Jgreen added a comment to T277171: decommission frqueue1001.frack.eqiad.wmnet.

Is it frqueue2001 or 1001?

Mar 22 2021, 2:29 PM · ops-eqiad, SRE, decommission-hardware
Jgreen renamed T277171: decommission frqueue1001.frack.eqiad.wmnet from decommission frqueue1001.frack.codfw.wmnet to decommission frqueue1001.frack.eqiad.wmnet.
Mar 22 2021, 2:28 PM · ops-eqiad, SRE, decommission-hardware

Mar 19 2021

Jgreen moved T277884: Cross-site redundancy for fundraising analytics platform from Triage to Backlog on the fundraising-tech-ops board.
Mar 19 2021, 5:39 PM · fundraising-tech-ops
Jgreen added parent tasks for T277884: Cross-site redundancy for fundraising analytics platform: Unknown Object (Task), Unknown Object (Task).
Mar 19 2021, 5:20 PM · fundraising-tech-ops
Jgreen created T277884: Cross-site redundancy for fundraising analytics platform.
Mar 19 2021, 4:47 PM · fundraising-tech-ops
Jgreen added a parent task for T277815: Separate out FR mariadb::conf from it's ties to mariadb::server: Unknown Object (Task).
Mar 19 2021, 4:37 PM · fundraising-tech-ops
Jgreen closed T277815: Separate out FR mariadb::conf from it's ties to mariadb::server as Resolved.

This is done. mariadb::conf has been modified to simply mariadb, with a boolean class variable $mariadb_server to differentiate client-only vs client+server install.

Mar 19 2021, 4:36 PM · fundraising-tech-ops

Mar 18 2021

Jgreen updated the task description for T266481: (Need By: TBD) rack/setup/install payments100[5-8].
Mar 18 2021, 7:21 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen moved T266481: (Need By: TBD) rack/setup/install payments100[5-8] from Triage to In Progress on the fundraising-tech-ops board.
Mar 18 2021, 7:06 PM · Patch-For-Review, fundraising-tech-ops, SRE
Jgreen added a parent task for T268683: Create civiproxy on docker: T125272: Epic: Create Preference Center for donors to manage email subscription preferences.
Mar 18 2021, 6:16 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, Fundraising Sprint Git Rebase Jump, Fundraising Sprint File Systems Stage Show, Fundraising Sprint Esperantoland, Fundraising Sprint Downed power line jump rope, Fundraising Sprint Corrugated super slide, FR-Docker, Fundraising-Backlog
Jgreen added a subtask for T125272: Epic: Create Preference Center for donors to manage email subscription preferences: T268683: Create civiproxy on docker.
Mar 18 2021, 6:16 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog
Jgreen moved T277185: repurpose frack server formerly known as frdata1001.frack.eqiad.wmnet from Triage to Up Next on the fundraising-tech-ops board.
Mar 18 2021, 5:27 PM · fundraising-tech-ops
Jgreen moved T277484: Fix duplicate entries in pgehres tables so we can convert them to utf8mb4 from Triage to Up Next on the fundraising-tech-ops board.
Mar 18 2021, 5:27 PM · fundraising-tech-ops, Fundraising-Backlog
Jgreen moved T277710: Enable GTID for payments-wiki mariadb from Triage to Up Next on the fundraising-tech-ops board.
Mar 18 2021, 5:26 PM · fundraising-tech-ops
Jgreen moved T257232: map out a civicrm.log_% table data expiration/delete strategy from Backlog to Blocked on the fundraising-tech-ops board.
Mar 18 2021, 5:24 PM · Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising-tech-ops
Jgreen moved T277184: Fundraising environment support for Debian 11 (Bullseye) from Triage to Up Next on the fundraising-tech-ops board.
Mar 18 2021, 5:24 PM · fundraising-tech-ops
Jgreen closed T276100: improve civicrm dump/restore strategy as Resolved.
Mar 18 2021, 4:45 PM · fundraising-tech-ops
Jgreen updated the task description for T276100: improve civicrm dump/restore strategy .
Mar 18 2021, 4:44 PM · fundraising-tech-ops
Jgreen added a comment to T276100: improve civicrm dump/restore strategy .

Testing a two-step restore, it takes about 13H to restore everything but the log table data versus to >48H with log table data included.

Mar 18 2021, 4:33 PM · fundraising-tech-ops

Mar 17 2021

Jgreen moved T174203: Investigate decommissioning two eqiad-frack vlans from In Progress to Done on the fundraising-tech-ops board.
Mar 17 2021, 1:22 PM · fundraising-tech-ops

Mar 16 2021

Jgreen updated the task description for T277185: repurpose frack server formerly known as frdata1001.frack.eqiad.wmnet .
Mar 16 2021, 8:33 PM · fundraising-tech-ops
Jgreen claimed T276100: improve civicrm dump/restore strategy .

Testing a two-step restore, it takes about 13H to restore everything but the log table data versus to >48H with log table data included.

Mar 16 2021, 1:45 PM · fundraising-tech-ops
Jgreen moved T276100: improve civicrm dump/restore strategy from Up Next to In Progress on the fundraising-tech-ops board.
Mar 16 2021, 1:43 PM · fundraising-tech-ops
Jgreen added a comment to T277338: Civi: Find Matches Using Fishing Net is hanging.

It seems that the db update changed the strictness of our mysql config in some way (@Dwisehaupt @Jgreen )

Mar 16 2021, 1:22 PM · Fundraising Sprint Git Rebase Jump, Fundraising Sprint File Systems Stage Show, Patch-For-Review, Fundraising Sprint Esperantoland, fr-donorservices, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
Jgreen added a comment to T273065: Setup Fundraising team in VO/splunk oncall.

@fgiunchedi We don't have any separate documentation relevant to on-call, and would just follow the regular SRE docs/procedures.

Mar 16 2021, 1:02 PM · User-fgiunchedi, observability

Mar 15 2021

Jgreen updated the task description for T276100: improve civicrm dump/restore strategy .
Mar 15 2021, 7:14 PM · fundraising-tech-ops

Mar 12 2021

Jgreen updated the task description for T268056: FY2020-21 Q3 maintenance window.
Mar 12 2021, 7:54 PM · fundraising-tech-ops