SSH tunnel not re-connecting

SSH tunnel not re-connecting

Postby awx » Mon 27 Apr 2009 18:57

I am using the latest build and I am having a problem with the ssh tunnel. If the tunnel is dropped it will not re-connect. I tested this by going to the MySQL server and killed the SSH connection, then ran a query it failed. I even tried to clear the connection pool for that one connection and for all connections. I can't get it to re-establish a connection until I restarted the app.

Thanks for the help,
Jeff
awx
 
Posts: 2
Joined: Mon 27 Apr 2009 17:45

Postby Shalex » Tue 28 Apr 2009 09:58

Jeff, if you opened connection from your application, killed it from the server side, connection is considered as valid until the next interoperation with the database. It is not reopened automatically if the session is lost. In this case you should close this connection from the application side and reopen it before running a query.

Connection pool checks if connection is valid. There are no invalid connections in pool.
Shalex
Devart Team
 
Posts: 7614
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL