Page MenuHomePhabricator

Requesting access to Superset for AUgolnikova
Closed, ResolvedPublic

Description

We've built visualization and dashboards for the Structured Data team that requires access to Superset. This appears to involve setting up a Wikitech account, getting added to the wmf LDAP group, and the analytics-privatedata-users POSIX group (ref: https://wikitech.wikimedia.org/wiki/Analytics/Data_access#Dashboards_in_Superset_/_Hive_interfaces_(like_Hue)_that_do_access_private_data). SSH access will not be needed for this.

Requestor provided information and prerequisites

This section is to be completed by the individual requesting access.

  • Wikitech username: AUgolnikova
  • Email address: augolnikova@wikimedia.org
  • SSH public key (must be a separate key from Wikimedia cloud SSH access):
  • Requested group membership: wmf, analytics-privatedata-users
  • Name of approving party (manager for WMF/WMDE staff): Shari Wakiyama
  • Service owner approval: @odimitrijevic / @Ottomata
  • Ensure you have signed the L3 Wikimedia Server Access Responsibilities document:
  • Please coordinate obtaining a comment of approval on this task from the approving party.

SRE Clinic Duty Confirmation Checklist for Access Requests

This checklist should be used on all access requests to ensure that all steps are covered, including expansion to existing access. Please double check the step has been completed before checking it off.

This section is to be confirmed and completed by a member of the SRE team.

  • -User has signed the L3 Acknowledgement of Wikimedia Server Access Responsibilities Document. N/A
  • - User has a valid NDA on file with WMF legal. (All WMF Staff/Contractor hiring are covered by NDA. Other users can be validated via the NDA tracking sheet)
  • - User has provided the following: wikitech username, email address, and full reasoning for access (including what commands and/or tasks they expect to perform)
  • - User has provided a public SSH key. This ssh key pair should only be used for WMF cluster access, and not shared with any other service (this includes not sharing with WMCS access, no shared keys.) N/A
  • - access request (or expansion) has sign off of WMF sponsor/manager (sponsor for volunteers, manager for wmf staff)
  • - access request (or expansion) has sign off of group approver indicated by the approval field in data.yaml

For additional details regarding access request requirements, please see https://wikitech.wikimedia.org/wiki/Requesting_shell_access

Details

Related Changes in Gerrit:

Event Timeline

jcrespo triaged this task as High priority.
jcrespo updated the task description. (Show Details)
jcrespo moved this task from Backlog to Manager Approval Pending on the LDAP-Access-Requests board.
jcrespo added subscribers: odimitrijevic, Ottomata.

Everything seems to be fine, only 2 steps left are approvals from @AUgolnikova-WMF's manager and Data Engineering's ok (updated on the ticket) for analytics-privatedata-users membership.

LDAP WMF group membership can be added right away, but waiting for the other approval to simplify the process (1 patch instead of 2).

Change 759846 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[operations/puppet@production] admin: Adding AUgolnikova

https://gerrit.wikimedia.org/r/759846

Change 759846 merged by Ladsgroup:

[operations/puppet@production] admin: Adding AUgolnikova

https://gerrit.wikimedia.org/r/759846

You should have access now (in thirty minutes), reopen if that's not the case

When trying to access superset with my wikitech account, I get "service access denied due to missing privileges" (See the screenshots below) Not sure why, so re-opening the ticket.

Screenshot 2022-02-10 at 15.53.45.png (1×1 px, 140 KB)

Screenshot 2022-02-10 at 16.03.59.png (1×1 px, 506 KB)

Sorry for that, you needed to be added to wmf ldap group as well which is done now. Can you try and let me know?