Page MenuHomePhabricator

Fundraising access request for Randy from Trilogy
Closed, ResolvedPublic

Description

This is a new access request for Randy from Trilogy. They require the following access: (mark each box with an x)

  • civicrm web access
    • standard access
    • donor services access
  • ssh access - if specific hosts: list here
  • mysql - if specific hosts or databases: list here
  • superset
  • other: please explain

Prerequisites

Before we can take any action to add a user, we need to verify that they are authorized to have such access. This requires confirmation from their manager and approval from the C level that access is approved.

[x] user_verification
Requires: user request
[x] access_rights: letter to C level (currently Lisa) verifying grant of access
[x] account name/contact info: verify on https://collab.wikimedia.org/wiki/Fundraising#Contact_List

Accounts and Services

[x] client_ssl_cert
Requires: user_verification
[x] cert_setup: generate cert on frpm1001 using ssl_user_admin
[x] account_setup: sms the user the password for the key
[x] follow_on: assist with certificate installation
[x] superset
Requires: client_ssl_cert
[x] account_setup: Create user account. Notify the user of their account name and password.
[x] follow_on: Verify user can log in to https://analytics.frdev.wikimedia.org

Event Timeline

Approval.

Date: Mon, 5 Oct 2020 07:45:20
From: Samuel Patton
To: Lisa Gruwell
Cc: Fundraising Tech Ops
Subject: Re: Civi / SSL access for Eric and Randy from Trilogy
----------------------------------------

Thank you very much, Lisa. CC'ing fr-tech-ops for visibility re: your permission.

On Thu, Sep 24, 2020 at 7:09 PM Lisa Gruwell wrote:
      Yes, I approve. 

On Thu, Sep 24, 2020 at 10:55 AM Samuel Patton wrote:
      Hi Lisa, we're moving more of our reporting to our Superset dashboards, and Erin
      has recommended we get access for key people, like Eric and Randy from Trilogy.
Could you please approve this so I can forward your permission to fr-tech?

Thank you!
Sam

SSL client certificate created and sent via email. Password sent via sms.
Superset account created with ChangeOwnPasswd, Data Consumer rights. Password sent via sms.
Welcome email sent with SSL certificate installation instructions and information on how to change password in superset. @spatton cc'd on welcome email.

Notified eyener of superset account setup so she can modify permissions as needed if more access is required.

Dwisehaupt moved this task from In Progress to Done on the fundraising-tech-ops board.

Verified in logs that Randy has access to superset. Closing.