Max,

I imagine Neta was asking for analytics-store access, so not /really/ the production cluster ;p. But, yes: generally-speaking "I need access to some data for...something", is not likely to lead to access to dbs containing sensitive information.

On 24 December 2014 at 10:28, Max Semenik <maxsem.wiki@gmail.com> wrote:
Access to production cluster, especially to databases that contain all kinds of user information, is an extremely big deal, so it's unlikely that this is going to happen, especially for a small one-time project.

On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <neta.livneh@gmail.com> wrote:
Thanks guys, I filed a request.

I think I will be working constantly with the database so it will require shell access.

Actually, this is a great opportunity to say that I would love to get you guys involved or at least hear insights from the analytics team regarding the project's direction. I will probably check in again in a month or so when we will have better understanding regarding the direction my project is headed. Until then, here is a link to the project in phabricator: article-translation-metrics.

Merry Christmas,

Neta

On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <ahalfaker@wikimedia.org> wrote:
Here's the instructions that Christian gave with some screenshots and discussion: https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Labs

If you're just looking to run a few queries, you might consider http://quarry.wmflabs.org which requires no shell access -- just a Wikimedia sites account.  

-Aaron

On Wed, Dec 24, 2014 at 7:22 AM, Christian Aistleitner <christian@quelltextlich.at> wrote:
Hi Neta,

On Wed, Dec 24, 2014 at 11:28:33AM +0200, Neta Livneh wrote:
> For my project, we will need to sql queries on current wikipedia data
> (mostly revision history table).
>
> I already have a Gerrit account. Can I get SSH access for running such
> queries?

It sounds like the redacted labs databases would nicely fit your use
case. The easiest way to get access there is to apply for Tool Labs [1].

To get access, please file a request through

  https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request

(Many parts around the WMF are currently getting migrated to
phabricator.wikimedia.org, so if someone knows a phabricator procedure
for that please chime in!)


Once you've got Tool Labs [1] access you can ssh to

  tools-login.wmflabs.org

and running

  sql enwiki

on that host connects you to labsdb's enwiki database and you can run
your queries there (similar for other wikis).

Have fun,
Christian



[1] https://wikitech.wikimedia.org/wiki/Help:Tool_Labs
has more information and links about Tool Labs.


--
---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----
                           Companies' registry: 360296y in Linz
Christian Aistleitner
Kefermarkterstrasze 6a/3     Email:  christian@quelltextlich.at
4293 Gutau, Austria          Phone:          +43 7946 / 20 5 81
                             Fax:            +43 7946 / 20 5 81
                             Homepage: http://quelltextlich.at/
---------------------------------------------------------------

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics


_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics



_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics




--
Best regards,
Max Semenik ([[User:MaxSem]])

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics




--
Oliver Keyes
Research Analyst
Wikimedia Foundation