forums › forums › SQLyog › Using SQLyog › Ssh Tunneling Problem
- This topic is empty.
-
AuthorPosts
-
-
March 14, 2010 at 9:33 pm #11906OthmarMember
Hi Support team!
I have a problem to use SQLYog Professional.
Connect to my databse server with sqlyog works well.(direct connect to port 3306) Now i will save my connect with a ssh tunnel. I have tested ssh connect with a (old)trial version of SQLYog. worked well. (did't know version) So i have purchase the actual pro version.
But with the current version ssh did not work. I get the error 2003 “Can't connect to MYSQL Server on 'localhost' (10061)”
For MYSQL server host i have checked the IP address or official remote name or localhost – nothing helps – everything there was displayed 'localhost'. (is this a bug ??) i cand type anything – always connnect to 'localhost'
To connect with putty and than start mysql console works fine.
I also have checked the SSH config:
GatewayPorts no
AllowTcpForwarding yes
KeepAlive yes
Have you a idea? Please help.
Edit: Additional info
At the sqlyog.ini thre was a strange setting:
SshHost=www.xxxxx.at (here is the official name)
SshPort=22
SshForHost=22 (here always 22 – at a old config there is localhost –> bug ???)
SshForPort=3310
SshPasswordRadio=1
SshPrivateRadio=0
SSHPrivateKeyPath=
SshSavePassword=1
Best Regards
Othmar from Austria
-
March 15, 2010 at 4:01 am #30577peterlaursenParticipantQuote:SshForHost=22 (here always 22 – at a old config there is localhost –> bug ???)
Can you try to change from '22' to 'localhost'.
-
March 15, 2010 at 7:50 am #30578OthmarMember
Have try localhost but no success.
I have also test another host (abcde) but on error message always 'localhost' was displayed.
If i disable SSH the error message box contains the entry from MYSQL host. If SSH enabled always 'localhost' was displayed.
Othmar
-
March 15, 2010 at 11:32 am #30579SupratikMember'Othmar' wrote on '15:
Have try localhost but no success.
I have also test another host (abcde) but on error message always 'localhost' was displayed.
If i disable SSH the error message box contains the entry from MYSQL host. If SSH enabled always 'localhost' was displayed.
Othmar
Hi,
Can you please provide us with a temporary connection of your MySQL server, you may create a ticket in our support system for privacy.
Can you please provide us the following details.
1. What is the SQLyog version you are using ?
2. Are you able to connect if you are using “127.0.0.1” instead of “localhost” ?
-
March 15, 2010 at 12:37 pm #30580OthmarMember
Hello!
Yes i also try 127.0.0.1 – did not work.
Did you also need a SSh login ?
Othmar
-
March 15, 2010 at 12:48 pm #30581OthmarMember
Have generated a ticket
I use newest public version: 8.3
Othmar
-
March 30, 2010 at 5:05 pm #30582OthmarMember
SQLYog Support team have fixed the Bug in version 8.32. Now all is OK.
Very big thank's for Mahesh Patil, Nithin John and Supratik Goswami who have done great job.
SQLYog Support team have done very good work 🙂
Othmar
-
April 13, 2010 at 10:44 am #30583jexxerMember
Well,Now I have the same error on current 8.32 and 8.4beta2. What can I do to help to resolve this problem?
-
April 13, 2010 at 11:54 am #30584peterlaursenParticipant
Please describe the problem again. Â What is exactly the problem?Â
-
April 13, 2010 at 12:09 pm #30585jexxerMember
I configured SQLyog to connect to my server using a SSH tunnel. All my connection setups do not work anymore.I always get a error: “Error No. 2003, Can't connect to MySQL server on 'localhost' (10061)”It makes no difference if I use 'localhost' or '127.0.0.1' as 'MySQL Host Address'.My settings worked on older versions, but I cannot tell you on which version it stopped working. I only upgrade from time to time and I do not know what version the last working one was.I guess it is a plink problem again (I recently had a ticket open for a similar problem). If I connect to my server using Putty, configuring a SSH tunnel in Putty and use this tunnel in SQLyog, I get a perfect connection.
-
April 13, 2010 at 12:18 pm #30586jexxerMember
OT: Sorry for the awful formatting of my last reply, but there seems to be a problem with the WYSIWYG post editor.
-
April 13, 2010 at 1:20 pm #30587peterlaursenParticipant
“All my connection setups do not work anymore.I always get a error: “Error No. 2003, Can't connect to MySQL server on 'localhost' (10061)” seems to be a completely new issue. Â Can you create a ticket and attach the SQLyog. ini? Â You can overwrite passwords with garbage if you want. Â
As I understand either the .ini is corrupted (by SQLyog or somebody/something else) or we are not able to read it properly.
-
April 13, 2010 at 1:32 pm #30588jexxerMember
I deleted the ini, startet SQLyog, created a new connection. Same problem. I noticed that the current Versions do not create the config value: SshForPort=3310. Not needed anymore? Bug?
-
April 13, 2010 at 1:46 pm #30589nithinMember
Hello,
The 'SshForPort' is no longer required.
The 8.21 version change log tells:
— The local port used by SSH-tunneling will now be selected automatically. This will avoid conflicts in case multiple programs use SSH. Also with Data Sync from command-line/scheduler it was possible to use same port for both connections what would effectively sync a server with itself
I provide you a special binary, please try this and let us know the status?
http://webyog.com/downloads/betas/not_released/SQLyog83n1.exe
Thank you
Nithin
-
April 13, 2010 at 2:03 pm #30590jexxerMember
The version you provided works with my old configfile 🙂
-
April 14, 2010 at 6:57 am #30591nithinMember
Thanks for verifying the build(But issue has not been solved here with, just commented out some functions to confirm the issue)
We are providing you another special build, there we had made some code changes as well as logging some function return values.
– The path of the log file is 'App Data folder' where the SQLyog.ini is(C:Documents and Settings{user}Application DataSQLyog).
– log file name is “sqlyog_ssh.log”
– Install this special binary, and click on 'Test connection' button in connection dialog, then copy the 'sqlyog_ssh.log' and send to us (one fix we did may solve your issue but please attach the log file whatever is the situation, so that we could analyze the issue)
http://webyog.com/downloads/betas/not_released/SQLyog84n1.exe
Thank you
Nithin
-
April 14, 2010 at 8:22 am #30592jexxerMember
I will attach the logfile.
-
April 14, 2010 at 10:31 am #30593nithinMember
Thanks for attaching log file.
Also please tell whether this build has been worked fine for you?
Regards
Nithin
-
April 14, 2010 at 10:44 am #30594jexxerMember
Yes, I was able to connect to the server.
-
April 14, 2010 at 11:28 am #30595nithinMember
Thanks for the reply. From the log file we confirmed the API is failing, and we modified it. In btw what's your OS?
This is the another special build.
– Delete the 'sqlyog_ssh.log' before install this.
– Connect SQLyog again and attach new log file created. (This special build is for assuring the locking *port for current session is working fine)
http://webyog.com/downloads/betas/not_released/SQLyog84n2.exe
Thanks again
Nithin
-
April 14, 2010 at 11:33 am #30596jexxerMember
My OS is Windows 7 Ultimate/32bit.
Your changes seem to work 😉 but see yourself – logfile attached.
-
April 14, 2010 at 12:53 pm #30597nithinMember
Thanks for the cooperation.
We provide you special build with issue got fixed(also no logging here).
You can use this until we do next public release.
http://webyog.com/downloads/betas/not_released/SQLyog84n3.exe
Regards
Nithin
-
-
AuthorPosts
- You must be logged in to reply to this topic.