840249 - Access to PG + HBase Mango cluster

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[bhavana bajaj [:bajaj]]

Please give David Anderson (:dvander) & William McCloskey( :billm ) access to PG+HBase Mongo Cluster to get access to raw data which will help us in better investigation for JS crashes

Comment 1

[Laura Thomson :laura]

Postgres first up.  

Selena, can you please set up RO access on one of the replicas for these guys?  They need the same kind of access as Kairo.

Once that's done, punt to :dre or :tmary for Mango access.

Comment 2

[Robert Kaiser]

(In reply to Laura Thomson :laura from comment #1)
> Selena, can you please set up RO access on one of the replicas for these
> guys?  They need the same kind of access as Kairo.

Well, none of us has their own users. We're all using the analyst user, and we only can use it from the crash-analysis machine, which has access to the DB. For them to get the same access, they need to get users on that machine, and possibly mpt-vpn access to get into this machine.

Comment 3

[Bill McCloskey [inactive unless it's an emergency] (:billm)]

Any progress on this?

Comment 4

[Selena Deckelmann :selenamarie :selena]

(In reply to Bill McCloskey (:billm) from comment #3)
> Any progress on this?

Users created! Passing passwords along in IRC. 

The users are in the 'analyst' group, so they should have all the same permissions as KaiRo & team. 

Adding :dre/:tmary for giving you access to HBase.

Comment 5

[Robert Kaiser]

Selena, this is cool, thanks! I hope that will help them dig deeper on crash problems in JS.

David and Bill, as a note, from what I understand you should be careful with queries on PG on the reports, reports_clean and possibly some other tables to not go over multiple days where possible, as the tables might be partitioned by day and going over those boundaries slows down the queries from what I understand. Selena can give you better advice, though, she's the DB expert there. :)
Also, to me, the DB schema has been proven useful when looking for what tables and fields do exist: https://github.com/mozilla/socorro/blob/master/sql/schema.sql

Comment 6

[Selena Deckelmann :selenamarie :selena]

The hostname is:  tp-socorro01-ro-zeus.phx1.mozilla.com, port 6432

Your usernames are billm and dvander

Comment 7

[Selena Deckelmann :selenamarie :selena]

Mango is decomm'd. AFAIK people have the access they need now. Reopen if that's not the case.