Page MenuHomePhabricator

Requesting access to analytics servers for cwdent
Closed, ResolvedPublicRequest

Description

Username: cwdent
Full name: Casey Dentinger

I recently approved the removal of my access during some cleanup but that has proven to have been a bad idea. We have been working with the fundraising kafka/hive pipeline to debug missing records, and the whole system is probably going to get rebuilt after the fundraiser, so it would be advantageous for me to have access to the data.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
RobH subscribed.

@cwdent: This makes sense to me! I'm on clinic duty this week, so I'll be assisting you in getting your access reinstated.

https://wikitech.wikimedia.org/wiki/Analytics/Data_access#Access_Groups

It appears that you need access to hive, which can include private data users, or not.

Do you happen to recall which groups you needed? It seems it is likely analytics-privatedata-users, since that includes:

analytics-privatedata-users

Access to stat1005 and stat1004 to connect to the Analytics/Cluster (Hadoop/Hive) and to query private data hosted there, including webrequest logs. Access to MariaDB slaves in /etc/mysql/conf.d/analytics-research-client.cnf 
If you want Hadoop access you probably want this.

Do you recall which stat server you logged into to do the work?

Change 384991 had a related patch set uploaded (by RobH; owner: RobH):
[operations/puppet@production] cwdent to analytics-privatedata-users

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

@RobH yes that is the correct group, thanks! I only used the login a handful of times before but I am pretty sure it was to stat100[45]

RobH changed the task status from Open to Stalled.Oct 18 2017, 3:19 PM
RobH claimed this task.

I've prepared the patchset above. If no objections are noted, the 3 day wait for group additions will end on Thursday, 2017-10-19, and I'll merge it then.

Change 384991 merged by RobH:
[operations/puppet@production] cwdent to analytics-privatedata-users

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

No objections have been noted after 3 business days, so I've merged this request live. If you need any assistance with accessing the stat system, please let us know!