distal-attribute
distal-attribute
distal-attribute
distal-attribute

SSH-Tunnel-Connection trying to connect to "localhost"

User, date Message
Written by mmarsching
4 years ago
Category: Creating a connection
12 posts since Wed, 19 Jul 06
It seems I have a lot of trouble connecting to my development server... I try to use a SSH-Tunnel-Conn with the following parameters

[Settings]
Network typ: SSH tunnel
IP: 192.168.178.37 (server!)
User: (mysql-user root for testing purposes)
Password: (mysql-root-pw)
Port: 3306

[SSH tunnel]
plink.exe location: c:\plink.exe
SSH host+port: 192.168.178.37 / 22
Username: root (SSH-user)
Password: root-pw (SSH)
Private key file: (empty)
Local Port: 3307

and always get the following error message:
"SQL Error (2003): Can't connect to MySQL server on 'localhost' (10061)"

Why localhost? What have I done wrong, am I too dumb to use SHH-tunneling without using pure Putty? :D

Thanks for all your help in advance!

Michele
Written by ansgar
4 years ago
5023 posts since Fri, 07 Apr 06
SSH host+port: 192.168.178.37 / 22
I guess this IP was not entered manually and it's greyed out? Try to do so, otherwise HeidiSQL uses "localhost" for the MySQL connection.
Written by mmarsching
4 years ago
12 posts since Wed, 19 Jul 06
No I had seen that... so I copied the 192.168.178.37 from "Settings" to "SSH tunnel"-tab
Written by mmarsching
4 years ago
12 posts since Wed, 19 Jul 06
I have tried

[Settings]
Network typ: SSH tunnel
IP: 192.168.178.37
User: root
Password: (mysql-root-pw)
Port: 3306

[SSH tunnel]
plink.exe location: c:\plink.exe
SSH host+port: 192.168.178.37 / 22
Username: root (SSH-user)
Password: root-pw (SSH)
Private key file: (empty)
Local Port: 3306

now and get a "connection", but all I see is my local mysql db. If I turn that one off, I still get "SQL Error (2003): Can't connect to MySQL server on 'localhost' (10061)".

Any other ideas? unhappy
Written by mmarsching
4 years ago
12 posts since Wed, 19 Jul 06
OK, for all of you folks out there - I found the error!!happy

The first time plink connects to a server it has to accept the servers host key, whether you connected with putty before or not! So open the command shell, change to the directory where your plink.exe is located and just run the following line once (examples from my case):
plink.exe -P 22 -l root -pw (root-pw) 192.168.178.37

After thet you have to accept the servers key by pressing "y". You can close the command line now - en voilá, the next time you try to connect with HeidiSQL the connection works!

Good luck everyone - and anse please fix this "bug" :)
Written by ansgar
4 years ago
5023 posts since Fri, 07 Apr 06
plink is executed with a hidden window, intentionally. Very tricky to make plink and heidi interacting with each other. Basically the same discussion as in issue #1914.
Written by bitkidoku
4 years ago
2 posts since Wed, 14 Jul 10
@mmarsching: Thank you very much, if you had not post the solution I would have spent hours wink
 

Please login to leave a reply, or register at first.