Correction: s1-analytics-slave.eqiad.wmnet is the correct host, we connect there via 1002 when we do it on terminal.
On Fri, Feb 12, 2016 at 8:23 AM, Nuria Ruiz nuria@wikimedia.org wrote:
Sorry, Jon. I do not think any of us in the team use anything but command line but couple things:
- I would try to connect to stat1002.eqiad.wmnet (not sure if
s1-analytics-slave.eqiad.wmnet is a dns alias to this machine)
- the my sql cnf you want to use cannot be edited as it is managed by
puppet and located at /etc/mysql/conf.d/analytics-research-client.cnf on the machine above.
On Thu, Feb 11, 2016 at 5:04 PM, Jon Katz jkatz@wikimedia.org wrote:
Hi Folks, I have no trouble connecting to s1-analytics-slave.eqiad.wmnet via terminal, but when I try to use my favorite GUI (sequel pro), I am suddenly having trouble. I was out for over a month, so there might have been changes during that time--I think I had trouble just before leaving as well.
Here is my setup: [image: Inline image 1]
And here is my error.
MySQL said: Lost connection to MySQL server at 'reading initialcommunication packet', system error: 0*
Could anyone spare some time tomorrow to troubleshoot with me? The FAQ for sequel pro says the following:
"On the server, configure MySQL by editing /etc/my.cnf and comment or remove skip-networking from the [mysqld] section. Then, restart MySQL Server."
Thanks,
J
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
