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
