SSH tunnel not re-connecting

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
awx
Posts: 2
Joined: Mon 27 Apr 2009 17:45

SSH tunnel not re-connecting

Post by 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

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Post by 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.

Post Reply