Ssh Tunnel Not Working

[M_W]

Hi all,

I'am trying to connect to a mysql server (version 3.23.58) thats only available through a ssh server. I have set all the nessecary settings. When I press “Test Connection” SQLyog informs me that the test was succesfull. The version number stated in the message is the same as the targetted mysql server. When I press “Connect” SQLyog does nothing. The connect window just stays open. If I try to connect to a local mysql server all goes well. Connecting to the mysql server using putty works fine too.

Using:

SQLyog v4.1

Windows XP Pro SP2 (directly connected to internet via ADSL)

Remote mysql server 3.23.58

Local mysql server 3.23.58

Can you help me get any further?

Thanks alot,

[peterlaursen]

Nobody seems to have the answer.

And Ritesh & Co. are working hard with the last issues with 4.2 I know!

I remember not so long ago (a couple of months) we had a similar issue. I don't think there was any conclusion.

But it must be a network configuration issue at the remote host. Obviously the SSH-server and the MySQL server are able to exchange authentification information. And also obviously SQLyog is able to send that autenfification information too when testing the connection. So I think connection is established too. But after that some data don't reach where they should reach at. Either the queries don't reach the mySQL server or the result of queries dont reach the SSH-server or the SSH-server fails to transmit data.

Actually the SSH client that comes with SQLyog is the same plink-executable as Putty uses. What can you actually do from Putty? It could be that only one line of information is transmitted …

If you wait a VERY long time does still nothing happens? Not even a time-out? Timeout with a standard MySQL installation is very high (several hours or actually days I believe), but most ISP's set it considerably lower!

I think this is an issue for the support/helpdesk personel at the remote host (I suppose it is an ISP ?!).

[M_W]

peterlaursen wrote on Nov 1 2005, 01:03 PM:

Actually the SSH client that comes with SQLyog is the same plink-executable as Putty uses.  What can you actually do from Putty?  It could be that only one line of information is transmitted …

I can upload files, delete my own files etc. Can also start Mysql just fine.

peterlaursen wrote on Nov 1 2005, 01:03 PM:

If you wait a VERY long time does still nothing happens?  Not even a time-out?  Timeout with a standard MySQL installation is very high (several hours or actually days I believe), but most ISP's set it considerably lower!

When I go home at the end of the day I'll try to login again and leave it untill the next day. Maybe I'll see a error message then, I doubt it though, because I can close the program normally. It doesn't seem to be waiting on anything.

[Ritesh]

Just for the sake of completeness, do you see any plink.exe in the windows process list?

I am assuming that you are providing a local port value that is not being used by any other process/app.

[M_W]

Ritesh wrote on Nov 2 2005, 12:07 PM:

Just for the sake of completeness, do you see any plink.exe in the windows process list?

plink.exe isn't in the windows process list at the start and also not after I pressed the connect button.

Ritesh wrote on Nov 2 2005, 12:07 PM:

I am assuming that you are providing a local port value that is not being used by any other process/app.

[post=”7791″]<{POST_SNAPBACK}>[/post]

Yes, the local port value is set at 3310, which should be available.

[peterlaursen]

Quote:

plink.exe isn't in the windows process list

It should be and it is here! If your screen resolution is big enough try open task manager and SQLyog at the same time. When you click 'test connection' plink.exe occurs in task manger. It goes away again when you click 'OK'

Next try 'Connect'. Do you see any 'flickering' in the task manager indicating that plink.exe is started, but then killed immidiately ?

[Ritesh]

Quote:

plink.exe isn't in the windows process list

This means that the tunneler is not up and running. Without plink tunneler, SQLyog will not be able to do SSH Tunneling.

[M_W]

I think I have found the anwser to this puzzle!!!! I'm using the free version of SQLyog and didn't bother reading the message that pops up 😮

Quote:

This edition has all the features of SQLyog Enterprise except the following Power Tools:

• HTTP / SSH Tunneling – Smartly manage MySQL even if your Hosting Provider restricts MySQL access through phpMyAdmin and disallows direct connections.

I am using the free version in order to make a decision on which MySQL admin application we are going to purchase.

Thanks for your help.

[peterlaursen]

… just for your info:

The Enterprise version runs as a demo with full functionality for a month.

[M_W]

peterlaursen wrote on Nov 3 2005, 10:17 AM:

… just for your info:

The Enterprise version runs as a demo with full functionality for a month.

[post=”7811″]<{POST_SNAPBACK}>[/post]

Thanks will try that.

[Author]

Posts