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
