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 <[email protected]> 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 <[email protected]> > 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 >> <https://phabricator.wikimedia.org/tag/article-translation-metrics/>. >> >> Merry Christmas, >> >> Neta >> [email protected] >> >> On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <[email protected]> >> 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 < >>> [email protected]> 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: [email protected] >>>> 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 >>>> Fax: +43 7946 / 20 5 81 >>>> Homepage: http://quelltextlich.at/ >>>> --------------------------------------------------------------- >>>> >>>> _______________________________________________ >>>> Analytics mailing list >>>> [email protected] >>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>> >>>> >>> _______________________________________________ >>> Analytics mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/analytics >>> >>> >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > > -- > Best regards, > Max Semenik ([[User:MaxSem]]) > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > > -- Oliver Keyes Research Analyst Wikimedia Foundation
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
