I want it to work using only the SSH config within the MySQL WB. As I said, it works perfectly fine using Sequel Pro for example!īefore you say - establish a tunnel and then connect on localhost - I already say NO, I don't want to do that because of reasons. If the connection is successful, click OK to save the connection. Click Test Connection to test the connection. Click the + symbol in the MySQL Connections tab to add a new connection. Retry_on_signal(lambda: nnect(addr))įile "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/util.py", line 270, in retry_on_signalįile "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 292, in įile "/System/Library/Frameworks/amework/Versions/2.7/lib/python2.7/socket.py", line 228, in methĮither MySQL Workbench is not smart enough or there's something else that needs to be set up that I'm just not aware of? I tried both MySQL WB for Mac and Windows and no luck. Follow these steps: Launch MySQL Workbench. Look_for_keys=has_key, allow_agent=has_key, timeout=SSH_CONNECTION_TIMEOUT)įile "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py", line 292, in connect I can successfully connect to that DB using Sequel Pro on Mac (using SSH config)īUT I can't connect using MySQL Workbench (using TCP/IP over SSH option).Įven though I specified the ssh config file in MySQL WB properties it seems like it cannot figure out how to make those two hops.Įrror message: Failed to Connect to MySQL at mysql:3306 through SSH tunnel at with user dbuserġ1:06:00 : Existing SSH tunnel not found, opening new oneġ1:06:00 : Opening SSH tunnel to 10.10.10.10ġ1:06:00 : SSH Tunel 17 thread startedġ1:06:00 : tunnel_28908: INFO Connecting to SSH server at 10.10.10.10:22 using key /Users/seb/.ssh/id_rsa.ġ1:06:00 : Waiting on tunnel to connect.ġ1:06:00 : INFO: Connecting to SSH server at 10.10.10.10:22 using key /Users/seb/.ssh/id_rsa.ġ1:06:10 : tunnel_28908: IO_ERROR IO Error: timed out.ġ1:06:10 : returning from wait_connection(28908): IO Error: timed out.ġ1:06:10 : TunnelManager.wait_connection() returned IO Error: timed out.ġ1:06:10 : TunnelManager.wait_connection got IOError: IO Error: timed out.ġ1:06:10 : Traceback (most recent call last):įile "/Applications/MySQLWorkbench.app/Contents/Resources/sshtunnel.py", line 303, in _connect_ssh.I can successfully connect to that DB using an ssh tunnel by exposing remote port locally and connecting to localhost.Only 'machineX' has access to that DB on port 3306. So, I have two hops before I can reach the database (three hops to the database itself). This is how my connection looks like: laptop => bastion:22 => machineX:22 (10.10.10.10) => mysql:3306
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |