SSH based connection fails

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

SSH based connection fails

Postby sunshine » Thu Feb 20, 2014 5:12 pm

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!
sunshine
 
Posts: 2
Joined: Thu Feb 20, 2014 4:55 pm

Postby Brian Donahue » Mon Feb 24, 2014 11:30 am

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby sunshine » Mon Feb 24, 2014 12:08 pm

Hi,

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

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!
sunshine
 
Posts: 2
Joined: Thu Feb 20, 2014 4:55 pm

Postby Brian Donahue » Thu Feb 27, 2014 9:26 am

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Feb 27, 2014 9:37 am

I put a topic on Devart's forums about this. Maybe they have an answer.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue Mar 04, 2014 9:39 am

I did get a reply from Devart:
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?
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests