Page MenuHomePhabricator

Fundraising access request for Panagiotis Penloglu
Closed, ResolvedPublic

Description

This is a new access request for PERSON. 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

New User Procedure / Checklist

When adding a new user to the fundraising / fr-tech ecosystem, we have a set of places where we need to create accounts and access.

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] civicrm
Requires: client_ssl_cert
[x] account_setup: Create user account. This will notify the user via email to update their password.
[x] follow_on: Verify user can log in to https://civicrm.wikimedia.org
[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
[x] archive_access: Add to google drive archive group. https://drive.google.com/drive/folders/0ADWGPlZtksGdUk9PVA

Event Timeline

Access approved for civi and superset. Still determining if ssh access is required.

Date: Wed, 23 Nov 2022 07:00:19
From: Danny Bu
To: Fundraising Tech
Subject: Fwd: Access to Civi and Superset for Panos Penglolu
----------------------------------------


---------- Forwarded message ---------
From: Lisa Seitz Gruwell
Date: Wed, Nov 23, 2022 at 3:59 PM
Subject: Re: Access to Civi and Superset for Panos Penglolu
To: Danny Bu


Approved!

On Wed, Nov 23, 2022 at 6:54 AM Danny Bu wrote:

Hello Lisa,

Panos Penglolu is a contract ssociate Campaign Manager reporting to me. Can you provide authorization for Panos to access Civi and 
Superset?

Thanks,
Danny Bu
Dwisehaupt moved this task from Triage to In Progress on the fundraising-tech-ops board.

SSL client cert created and sent via email. password sent via SMS. CiviCRM account created and set with random password. Superset account created and set with random password. Superset password sent via SMS. Welcome email sent with instructions on how to log in and change passwords where needed.

Verified ssh access is not required at this point.

Date: Wed, 23 Nov 2022 22:40:59
From: Danny Bu
To: Dallas Wisehaupt
Subject: Re: Access to Civi and Superset for Panos Penglolu
----------------------------------------

No it's not necessary at the moment. Apologies
On Wed, Nov 23, 2022, 6:47 PM Dallas Wisehaupt wrote:
      Hi Danny,

I see on the access request you also selected ssh access. This is usually tied to running mysql queries and is not needed for
general civi/superset use. Is there a particular need for ssh access for Panos?
Dwisehaupt updated the task description. (Show Details)
Dwisehaupt moved this task from In Progress to Done on the fundraising-tech-ops board.
Date: Mon, 28 Nov 2022 02:20:50
From: Panagiotis Penloglou
To: Dallas Wisehaupt
Subject: Re: Civi and Superset access
----------------------------------------

Dear Dallas,

Hope you had a lovely weekend! Just informing you that I now have access to both CiviCRM and Superset thanks to your instructions
and help.

Kind regards,