Please give Bartosz (MatmaRex) membership of the "researchers" and "statistics-users" groups so that they can access stat1003 for EventLogging analysis.
It looks like this is the first access request for Bartosz. Please have him go through the steps here https://wikitech.wikimedia.org/wiki/Requesting_shell_access if he hasn't already, and let's get the information on this task (gerrit patch with ssh key, perferred shell user name, link to wikitech page,). He should also sign the L3 statement on Phabricator mentioned on the Requesting shell access page. @Jdforrester-WMF are you his manager? If so I can take manager approval as a given. Thanks!
Full name: Bartosz Dziewoński
Wikitech page: https://wikitech.wikimedia.org/wiki/User:Bartosz_Dziewoński
Labs username: Bartosz Dziewoński (yeah, with a space and a diacritic… hopefully won't be a problem here)
Preferred shell user name: matmarex
I signed L3.
How? researchers just gives access to mysql credentials for the research db. Has it been changed? Or is there no limitation on the mysql GRANT to stat1003 and people just connect from anywhere?
researchers gives access to both stat1003 itself and the mysql credentials. I have the same thing myself to access the EventLogging database (it also provides access to other databases):
krenair@stat1003:~$ ls -l /etc/mysql/conf.d/research-client.cnf -r--r----- 1 root researchers 108 Mar 4 2015 /etc/mysql/conf.d/research-client.cnf krenair@stat1003:~$ groups wikidev researchers krenair@stat1003:~$ mysql --defaults-file=/etc/mysql/conf.d/research-client.cnf -h analytics-store.eqiad.wmnet -A log -s mysql:firstname.lastname@example.org [log]>
You can use the credentials in that file to log in to the DB from any other host that can connect to dbstore1002 on the mysql port (this depends on firewalls etc.). I suspect most people just use stat1003 though.