On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <ahalfaker(a)wikimedia.org
<javascript:_e(%7B%7D,'cvml','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_La…
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(a)quelltextlich.at
<javascript:_e(%7B%7D,'cvml','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(a)quelltextlich.at
<javascript:_e(%7B%7D,'cvml','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(a)lists.wikimedia.org
<javascript:_e(%7B%7D,'cvml','Analytics@lists.wikimedia.org');>
https://lists.wikimedia.org/mailman/listinfo/analytics
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
<javascript:_e(%7B%7D,'cvml','Analytics@lists.wikimedia.org');>
https://lists.wikimedia.org/mailman/listinfo/analytics
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
<javascript:_e(%7B%7D,'cvml','Analytics@lists.wikimedia.org');>