Page MenuHomePhabricator
Create Task
Maniphest T159780

Requesting access to researchers group (stat1003 and MySQL) for niharika29
Closed, ResolvedPublic
Actions

Description

Username: niharika29
Full name: Niharika Kohli
Public SSH key:

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDfDN+fYSIem1HA5TFNzLtrkG/+OwvYHlR9rZOF/aISNhVDu/QETNiUKxTiSBtuqeCGsB/rSvE0XEI/Hi3EIQ1SkNOH/mGIRLpI0g5ETMW7FW/z0pSgaXKgNJNMMWZfBgyYnSk+a9OnPGd9ofvX0u8GvSEjLsaS0fZPrd2GZz/jX6GzqbnRSfZbSoPEFhimD1ENQ0CRyjBzlG9g4RKXWQ0Qku1SXXy0EtUxMh7xojKPEdU1Vi7p51m4T7oL2j+4dAOYWLUcBvkezOFp8S3eAt7JYW9Ohj+blOmvbzXBKVSfoSgnstTum4xLXFgyVYDBLCdakW85RWyAe0fIO9MrJiLT nkohli@nkohlis-MacBook-Pro.local

Hi, I work on the Community-Tech team and need this access to look at a bunch of eventlogging data related to the cookie-based blocks project. The data relates to https://meta.wikimedia.org/wiki/Schema:CookieBlock. This would also help with getting any future eventlogging data Community Tech team projects relate to.

checklist

  • - NDA check - this step is taken with legal for volunteers, all staff & WMF direct contractors have an NDA as part of their hiring.
  • - L3 document signed by @Niharika previously on Jul 29 2016, 01:15
  • - Niharika's manager approval (@kaldari ?)
  • - analytics manager approval - given by @Nuria on March 7th, 2017.
  • - patchset for researchers group addition - https://gerrit.wikimedia.org/r/#/c/342278/
  • - 3 business day wait for any objections (ends 2017-03-10)

Details

SubjectRepoBranchLines +/-
add niharika29 to researchers groupoperations/puppetproduction+1 -1
Customize query in gerrit

Event Timeline

• Niharika created this task.Mar 7 2017, 1:10 AM
Restricted Application added a project: SRE. · View Herald TranscriptMar 7 2017, 1:10 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Ottomata added subscribers: • Nuria, Ottomata.Mar 7 2017, 3:46 PM

Hi @Niharika, thanks for the request. You'll need approver from your manager, and @Nuria should approve as well.

FYI, I believe that the researchers group should be sufficient for this access.

Ottomata added a comment.Mar 7 2017, 3:47 PM

Please have your manager post their approval here.

• Nuria added a comment.Mar 7 2017, 3:47 PM

Approved

Ottomata renamed this task from Requesting access to researchers and statistics-users groups for niharika29 to Requesting access to researchers group (stat1003 and MySQL) for niharika29 .Mar 7 2017, 3:47 PM
• Niharika added a subscriber: kaldari.Mar 7 2017, 5:22 PM
RobH subscribed.Mar 8 2017, 5:17 PM

I find it useful to paste in a checklist of the steps that have to be accomplished, just so folks can review and see what has happened:

@Niharika included their ssh pubkey, but it isn't needed since access to the cluster is already enabled, this is just expanding rights.

I'll add these checklist steps to the task description.

  • - NDA check - this step is taken with legal for volunteers, all staff & WMF direct contractors have an NDA as part of their hiring.
  • - L3 document signed by @Niharika previously on Jul 29 2016, 01:15
  • - manager approval of expansion of access rights on task - given by @Nuria on March 7th, 2017.
  • - patchset for researchers group addition
  • - 3 business day wait for any objections (ends 2017-03-10)
RobH updated the task description. (Show Details)Mar 8 2017, 5:17 PM
Ottomata updated the task description. (Show Details)Mar 8 2017, 5:46 PM
Ottomata triaged this task as Medium priority.Mar 8 2017, 6:51 PM
kaldari added a comment.Mar 10 2017, 9:54 PM

I approve!

RobH updated the task description. (Show Details)Mar 10 2017, 9:55 PM
gerritbot subscribed.Mar 10 2017, 9:57 PM

Change 342278 had a related patch set uploaded (by RobH):
[operations/puppet] add niharika29 to researchers group

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

gerritbot added a project: Patch-For-Review.Mar 10 2017, 9:57 PM
RobH updated the task description. (Show Details)Mar 10 2017, 9:57 PM
gerritbot added a comment.Mar 10 2017, 9:58 PM

Change 342278 merged by RobH:
[operations/puppet] add niharika29 to researchers group

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

RobH closed this task as Resolved.Mar 10 2017, 9:59 PM

There have been no objections noted, and I noticed that this 3 day wait ended today. I chatted with @kaldari and since he has approved I've merged the change live.

The affected host(s) all call in within 30 minutes, so this change will be live on those hosts shortly. If there are any issues, please don't hesitate to comment on this task, and re-open it.

Ottomata added a comment.Mar 10 2017, 10:18 PM

Thanks @RobH!

• Niharika reopened this task as Open.Sep 13 2017, 11:04 PM

I appear to have lost my access to stat1003. Can I get it back? I use it for looking at eventlogging DB.

RobH closed this task as Resolved.Sep 13 2017, 11:21 PM
RobH claimed this task.

@Niharika:

Stat1003 is being decommissioned. Please see @Ottomata's email to the ops list on July 18th, subject line "[Ops] stat1002 and stat1003 deprecated. Please use new stat boxes"

Hi all!

tl;dr: Stop using stat100[23] by September 1st.

We’re finally replacing stat1002 and stat1003. These boxes are out of warranty, and are running Ubuntu Trusty, while most of the production fleet is already on Debian Jessie or even Debian Stretch.

stat1005 is the new stat1002 replacement. If you have access to stat1002, you also have access to stat1005. I’ve copied over home directories from stat1002.

stat1006 is the new stat1003 replacement. If you have access to stat1003, you also have access to stat1006. I’ve copied over home directories from stat1003.

I have not migrated any personal cron jobs running on stat1002 or stat1003. I need your help for this!

Both of these boxes are running Debian Stretch. As such, packages that your work depends on may have upgraded. Please log into the new boxes and try stuff out! If you find anything that doesn’t work, please let me know by commenting on https://phabricator.wikimedia.org/T152712.

Please be fully migrated to the new nodes by September 1st. This will give us enough time to fully decommission stat1002 and stat1003 by the end of this quarter.

I’ve only done a single rsync of home directories. If there is new data on stat1002 or stat1003 that you want rsynced over, let me know on the ticket.

A few notes:

  • stat1002 used to have /a. This has been removed in favor of /srv. /a no longer exists.
  • Home directories are now much larger. You no longer need to create personal directories in /srv.
  • /tmp is still small, so please be careful. If you are running long jobs that generate temporary data, please have those jobs write into your home directory, rather than /tmp.
  • We might implement user home directory quotas in the future.

Thanks all! I’ll send another email in about a months time to remind you of the impending deadline of Sept 1.

-Andrew Otto

So please use stat1006. =]

• Niharika added a comment.Sep 13 2017, 11:44 PM

@RobH Thanks. I'm not on the Ops mailing list. Maybe Wikitech-l is a better venue for changes as drastic as this one.

RobH added a comment.Sep 13 2017, 11:54 PM

It is recommended (but not required) that all folks with shell access be part of the ops list. (Not disagreeing with you, just advising!)

MaxSem subscribed.Sep 13 2017, 11:57 PM

Also analytics: https://lists.wikimedia.org/pipermail/analytics/2017-August/006004.html

Ottomata added a comment.Sep 14 2017, 3:42 AM

It was emailed to several lists, ops, analytics researchers, etc. You
should get on the analytics list for sure!

:)

• Niharika added a comment.Sep 14 2017, 3:48 AM

I never subscribed to those because they felt like team-specific lists. Wikitech-l is probably the most widely read tech list we have. So that's always a good one to send important technical announcements to.
I joined the Ops list now though.

Ottomata added a comment.Sep 14 2017, 1:46 PM

The Analytics list is used for announcements about analytics specific
services and news. We do send things like this to the ops list, but not
everything. You’ll probably want to be on that Analytics.

The number of people in wikitech-l is large, and most of them probably
don’t know what the stat boxes are :)

• Nuria added a comment.Sep 14 2017, 2:57 PM

@Niharika : second @Ottomata 's comments, you should add yourself to analytics@ where analytics-related information goes, for example outages or releases of new datasets

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL