Bug #58529 | MySQL can not connect to localhost | ||
---|---|---|---|
Submitted: | 27 Nov 2010 0:47 | Modified: | 28 Dec 2010 8:04 |
Reporter: | Jim Deuvall | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S2 (Serious) |
Version: | 3.5.1 | OS: | Windows (XP, Vista and 7) |
Assigned to: | CPU Architecture: | Any |
[27 Nov 2010 0:47]
Jim Deuvall
[27 Nov 2010 10:01]
Valeriy Kravchuk
This problem is not related to any bug in MySQL it seems. How that SSH tunnel is created? What software is used to make it?
[27 Nov 2010 13:30]
Jim Deuvall
I open using Plink. It is stated to be open before I execute the ado connection string. I'm curious, how do you get to your conclusion that its not MySQL based on what is written?
[27 Nov 2010 14:14]
Valeriy Kravchuk
I try to understand what changes after the error and before next successful attempt, or when computer restarts. Driver version does not change, MySQL server does not change (if you think it crashes, please, send error log that proves that). The most likely thing to change is status of your SSH tunnel. I can be wrong though.
[27 Nov 2010 15:22]
Jim Deuvall
I've never used the log before. How do I send to a log file? DOes the plink ssh tunnel persist after turning off the app. Is it a timng issue. Not enough time to fulling create the tunnel? It says its open. Will the log assist in determining this.
[27 Nov 2010 15:44]
Peter Laursen
@Jim .. if you start the PLINK process from inside you application you will of course also need to terminate it yourself. If you don't the process will still run and if you use it again on the same local port you will connect to the same remote server as you did first time. This is actually a very dangerous scenario! DESTROY the PLINK instance when closing your application. And if your application allows for multiple connections ensure that they will not use the same local port (because they will then connect to the same server!). I think that you simply you do not initialize PLINK parameters properly first time you use it. Peter (not a MySQL person)
[27 Nov 2010 17:21]
Jim Deuvall
I set the ado connection to nothing and run the Close_SSH subroutine on the putty website. But the ssh is still established when I close down the app. I'm confused.
[28 Nov 2010 8:04]
Valeriy Kravchuk
Error log of MySQL server (usually it is file named <hostname>.err in the data directory) can help to make sure that MySQL server has nothing to do with your problem. Or it can show information about server crash at the moment when you tried to access server. I doubt there was a server crash, though.
[29 Dec 2010 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".