Thanks Dan!  Was about to reply with the same.

BTW, if you use a mysql client on stat1003 to connect, you can use this file with the --defaults-extra-file ClI option.

  mysql --defaults-extra-file /etc/mysql/conf.d/research-client.cnf -hanalytics-store.eqiad.wmnet

This way you don’t actually have to enter the username and password.

If you connect via some MySQL GUI on your local machine, you can log into stat1003 (let me know if you have trouble doing that), and copy/paste the contents of /etc/mysql/conf.d/research-client.cnf  into your client’s connection settings.

Again, let me know if anyone needs any help.  Thanks all!

-Andrew Otto


On Nov 7, 2014, at 9:25 AM, Dan Andreescu <dandreescu@wikimedia.org> wrote:

Yes the research password was changed.  A lot of people (including me) that thought would keep access, did not.  Here's how you can get to the file that has the new credentials:

1. get added to the researchers group.  Gilles, you, me, and and some other people were already added [1]
2. you'll then have access to /etc/mysql/conf.d/research-client.cnf on stat1003


[1] https://gerrit.wikimedia.org/r/#/c/171828/2/modules/admin/data/data.yaml,cm

On Fri, Nov 7, 2014 at 5:49 AM, Gilles Dubuc <gilles@wikimedia.org> wrote:
Hi,

Ops changed the password for the "research" user on analytics-store (I don't know what the context is, I just saw the commit summary on the Ops ML), which our team was using to generate tsvs for limn. Maybe it wasn't the right user to be using, I'm not sure, but one way or another we're going to need new credentials in order to keep our dashboards working. If someone has the credentials we should be using, I would be grateful to receive them through whatever medium is appropriate :)

Thanks!

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics


_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics