|
Replies:
6
-
Pages:
1
-
Last Post:
Apr 15, 2013 1:04 PM
by: Scott M. Sanders
|
|
|
Posts:
3
Registered:
8/19/11
|
|
|
|
Cannot connect via SSH
Posted:
Aug 19, 2011 6:55 AM
|
|
|
I've been using Toad for some time now and have a problem. I have a MySQL database on the web that I am trying to connect to but I keep getting 10061 errors. Sometime I get the message "Can't connect to SSH server on 'nnn.nnn.nn.nnn': Server did not respond within the specified timeout interval" (where nnn etc is the IP address of the server)
I can connect via PuTTY and even execute commands on the db server, but when I try and connect using Toad I get nowhere.
This used to work but now it doesn't.
I'm hosting the databases on UK-2
Any help would be very greatly appreciated!
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Cannot connect via SSH
Posted:
Aug 19, 2011 10:30 AM
in response to: Warren G
|
|
|
I would try using the 6.0 beta. I have a couple of servers that I connect to through SSH so I know it works on that one at least for me (It is also very close to release so should be pretty stable).
|
|
|
Posts:
3
Registered:
8/19/11
|
|
|
|
Re: Cannot connect via SSH
Posted:
Aug 19, 2011 11:23 AM
in response to: Mauritz
|
|
|
The thing is that I can connect to other databases on other ISP's platforms. It just doesn't make sense to me.
What's more worrying is that I have a Delphi app that won't connect to the database either, but will to others.
UK-2 tell me that, because I can connect via PuTTY that the problem must be in Toad (and I guess my app as well), but I don't see how that can be as it was working before.
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Cannot connect via SSH
Posted:
Aug 19, 2011 11:51 AM
in response to: Warren G
|
|
|
So just so that I understand it. If you set up the tunnel manually using Putty it works?
Or what exactly is it that works when you are trying to connect to this?
|
|
|
Posts:
3
Registered:
8/19/11
|
|
|
|
Re: Cannot connect via SSH
Posted:
Aug 20, 2011 12:06 AM
in response to: Mauritz
|
|
|
Yes, if I set up the tunnel manually with PuTTY it works. Not if I use Toad.
I have Toad version 4.6.0.531 installed on one computer, version 5.0.0.345 on another.
The MySQL databases that I'm trying to connect to have the following versions:
5.0.92 - this is the one I can connect using PuTTY but not Toad (both Toad versions as above)
5.0.51 - I can connect to this via Toad (version 4.6.0.351, don't have the connection set up for 5.0.0.345)
Does this help at all?
|
|
|
Posts:
1
Registered:
4/15/13
|
|
|
|
Re: Cannot connect via SSH
Posted:
Apr 15, 2013 8:44 AM
in response to: Warren G
|
|
|
I get this in Toad 6.3, as well. It is a Toad issue. It took me some time to come up with a reasonable workaround (e.g. I couldn't use two applications, like PUTTY to tunnel first before using Toad. And, I did not want to open port 3306 to the world to use direct TCP connection).
The quick answer - use the server's IP address instead of 'localhost' or '127.0.0.1'. For whatever reason, TOAD is broken if you try to use 'localhost' or '127.0.0.1' as the mysql server IP address via SSH.
So, just configure your connection using all of the 'correct' SSH and MYSQL information you normally would, but instead of 'localhost' or '127.0.0.1' for the database server name/IP, use the server's IP address (use the internal IP address when using an AWS EC2 instance).
You will have to grant priveleges to the local host IP address, which is not a security issue, at all.
|
|
|
Posts:
40
Registered:
1/27/11
|
|
|
|
Re: Cannot connect via SSH
Posted:
Apr 15, 2013 1:04 PM
in response to: sqladmin
|
|
|
Sometimes localhost does work on SSH, and sometimes you do need to enter the server IP again as you said. Permissions maybe?
I have three SSH remote connections, and one requires the same IP instead of localhost.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
