Red Gate forums :: View topic - SSH based connection fails
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

SSH based connection fails

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
sunshine



Joined: 20 Feb 2014
Posts: 2

PostPosted: Thu Feb 20, 2014 5:12 pm    Post subject: SSH based connection fails Reply with quote

Hi there.

I've got a problem.

I'm using SSH mode to connect to a remote server. SSH itself works, but MySQL Compare is not able to connect to MySQL afterwards.

Error Message:

"Error Connecting to Database
Can't connect to MySQL server on '127.0.0.1' (10061): Server did not respond within the specified timeout interval"

But when I ssh to the server manually, using the same user as MySQL Compare does, and run...

$ mysql --host=127.0.0.1 --port=3306 --user=$USER --password=$PW

... it works.

Question:
Does MySQL Compare rely on any other settings on the server, or is it basically running just a command like the one I've posted above?


(I'm using MySQL Compare 1.0.0.425)

Thanks a lot!
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Mon Feb 24, 2014 11:30 am    Post subject: Reply with quote

Hello,

MySql Compare can connect using SSH. You can see the settings in the "SSH" tab on the connect window. It can accept either a keyfile or a username/password combination.

The connection is managed using a third-party component from another company so I don't have detailed information about how it works, but if you can provide any further information about the connection failure, I can take it up with them.
Back to top
View user's profile Send private message
sunshine



Joined: 20 Feb 2014
Posts: 2

PostPosted: Mon Feb 24, 2014 12:08 pm    Post subject: Reply with quote

Hi,

thanks for your reply, but I guess there is a little misunderstanding. Smile

I'm already using the SSH functionality of MySQL Compare to login to a remote server and to a database afterwards. No third-party component involved here.

Again, my problem is: MySQL compare succeeds doing the first step (ssh login to the defined server), but then no connection to the local mysql server can be established. But since the login to mysql works if you do it manually (see my last post), my hunch is that MySQL Compare relies on some system configuration instead of "just" sending the respective command. Could you comment on this, please?

Thanks!
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Thu Feb 27, 2014 9:26 am    Post subject: Reply with quote

I can't comment. I cannot reproduce the problem and the component that makes the connection is made by a third-party company named "Devart" so I have no idea how the component works because I don't have access to the source for it.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Thu Feb 27, 2014 9:37 am    Post subject: Reply with quote

I put a topic on Devart's forums about this. Maybe they have an answer.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Tue Mar 04, 2014 9:39 am    Post subject: Reply with quote

I did get a reply from Devart:
Quote:
If we understood you correctly, you want to connect to the MySQL server, installed on your computer, via the SSH server, that is installed on other computer.

When you specify host=127.0.0.1, after connecting to the SSH server it looks for the MySQL server from its own location, i.e. 127.0.0.1 for the SSH server means the computer, where the SSH server is installed. You need to specify the real IP address of your computer, in order for SSH server to connect to it.


Does that help?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group