MySQL Forums :: Workbench - SQL Browser, Editor, Refactor :: Ubuntu MySQL Workbench can connect to database but all queries timeout with Error Code 1203: Lost Connection
Ubuntu MySQL Workbench can connect to database but all queries timeout with Error Code 1203: Lost Connection
Date: January 17, 2013 12:09PM
I am having a very peculiar issue with MySQL Workbench on our work network. I am able to connect/query remote databases from command line but in MySQL Workbench I can only connect and queries timeout. I believe the issue has to do with the network/firewall but am looking for some help in diagnosing and troubleshooting it
Within this "work" network MySQL Workbench can connect to all remote databases. When I attempt to run a query that would return in milliseconds the query just spins/hangs until the connection is lost (error 1203). What is even more interesting about this is that in the same "work" network via command line I can connect to these same remote databases and query from them without issue. I can also connect to these same remote databases and successfully run queries from another third party MySQL client called "Emma"
From other networks like my "home" network I can connect to these remote databases and query from them without issue from both command line and MySQL Workbench
Based onthe information above it seems like this issue is specific to this network/firewall. I worked with our IT team and they turned off all firewall settings and even put me out in the DMZ but I still was having same issues. That seems like it should rule out firewall so maybe network issues?
Other things to note:
- To access the remote databases I am VPN'ing into the network first. I am connecting to VPN on all networks so this doesn't seem to be the issue
- These are normal tcp/ip connections to the remote databases
- Other people in the office that use MySQL Workbench on Mac and Windows are not experiencing this issue
Why would MySQL command line work and MySQL workbench not? Why would MySQL Workbench work fine on this network on other OSes? Are there any settings in MySQL workbench that I could alter to fix this? Any ideas of how to troubleshoot this?
OS: Ubuntu 12.10 64-bit
Workbench Version: 5.2.45
VPN: Cisco VPN service
Thanks in advance,
Edited 3 time(s). Last edit at 01/17/2013 12:47PM by Simon Engelbert.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.