Ssh Tunneling

[dimis]

Hello,

I have been trying to use the SSH Tunneling option but I get the following Error:

Code:

SSH Error: FATAL ERROR: Network error: Connection timeout.

On the remote server I see this in the SSH logs:

Code:

08-04-2009 14:34:21 IP *.*.*.132 SSH SSHusr successfully logged on using password.
08-04-2009 14:34:21 Shell service granted to user SSHusr.
08-04-2009 14:34:22 IP *.*.*.132 SSH SSHusr disconnected.

When I try to connect on the same server with same credentials using Terminal, I can connect with no problems and I am not thrown out after a second.

I am using the same settings to connect to mySQL as the ones I use to connect to the mySQL server normally, not using tunneling.

I suspect its a problem with the port forwarding but I am not sure what to check.

Any help greatly appreciated!

Dimitri

[peterlaursen]

do you have access to read the SSHD configuration file (normally it is something like /etc/ssh/sshd_config)?

[dimis]

Yes..

Code:

[SSH server]
SSHListenAddress=*.*.*.224
SSHListenPort=1908
SSHMaxConnections=2
SSHTimeout=200
SSHBanner=
SSHCMD=C:WINDOWSsystem32cmd.exe
SSHRun=1
SSHNewConsole=1
SSHCiphers=0
SSHMACs=65535
SSHPasswordAuth=0
SSHPublickeyAuth=0
SSHPublickeyPath=C:Program Files (x86)freeSSHd
RSAKeyPath=C:Program Files (x86)freeSSHdRSAKey.cfg
DSAKeyPath=C:Program Files (x86)freeSSHdDSAKey.cfg
[SSH tunneling]
SSHLocalTunnel=1
SSHLocalTunnelOnly=0
SSHRemoteTunnel=0
SSHRemoteTunnelOnly=0

[peterlaursen]

I do not see anything like

Code:

AllowTcpForwarding yes

but 'yes' should be default. But maybe not on your OS(distro. I think you could inserting in the[SSH server] section. Anyway I will ask somebody who knows better to check this.

Btw: what is this OS?

[dimis]

Hello Peter,

OS is Windows Server 2003.

AllowTcpForwarding does not appear in the config file. User account is set with the Shell and Tunnel options enabled.

[peterlaursen]

If it is Windows you must have had installed a third-party SSHD-solution. It does not look like Cygwin. What is it?

[dimis]

Sorry, I forgot to specify. Its freeSSHd (www.freesshd.com).

[navyashree.r]

Hi,

We have implemented 'reconnects' in latest 8.13 RC,

“SQLyog reconnects are now coded differently. The new code means that with SSH-tunnel it will now not be necessary to re-instantiate PLINK (the running PLINK instance will be used).”

We are looking into this issue and update once done.

BTW please tell us which SQLyog version you are using and try with latest 8.13 RC from our Downloads and confirm whether issue still persists?

Regards,

Navya

[dimis]

Navya,

I have just installed SQLyog Enterprise version 8.13 RC. The same error occurs.

Thanks,

Dimitri

[Supratik]

Hi,

This is an issue with the the freeSSHD server. We are able to reproduce it and we are working on this issue.

I request you to create a support ticket in http://webyog.com/support/ttx.cgi.

As a temporary workaround you may create a SSH tunnel manually using the plink.exe using the following command.

plink.exe -ssh -l “username” -pw “password” -L 3310:localhost:3306 -P 22 “RemoteHost”

Once you are able to create the SSH tunnel try to connect MySQL server from localhost using the port 3310.

you may refer the screenshot below. Please let me know if you have any questions.

Regards

Supratik

[peterlaursen]

To do as Supratik told you will need to use the PLINK excutable from the PuTTY project download page. The PLINK shipped with SQLyog will not work for this command syntax.

Personally I never heard about this SSH solution before. If you want to try with Cygwin SSHD this is a good guide:

http://www.petri.co.il/setup-ssh-server-vista.htm

.. but I do not say that it should not work with this FreeSSHD thing. Only we will have to study it.

[peterlaursen]

We believe we have solved the problem with SSH-tunnelling and FreeSSHD.

Please download and install from:

REGISTERED version: http://www.webyog.com/downloads/betas/not_…nt-freeSSHd.exe

TRIAL version: http://www.webyog.com/downloads/betas/not_…al-freeSSHd.exe

Any feedback would be appreciated of course.

[dimis]

Peter,

With the latest download you have provided seems to be working! Many thanks for all your help.

Thanks also to Supratik.

Dimitri

[Author]

Posts