I'm also having the same issue logging in via GUI clients (Sequel Pro, and MySQL Workbench).

I was definitely able to use them successfully earlier this week.

On Fri, Feb 12, 2016 at 11:27 AM, Nuria Ruiz <nuria@wikimedia.org> wrote:

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:

And here is my error. 

     MySQL said: Lost connection to MySQL server at 'reading initial communication 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

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

--

Dmitry Brant
Mobile Apps Team (Android)
Wikimedia Foundation
https://www.mediawiki.org/wiki/Wikimedia_mobile_engineering

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