Opening a connection takes long time if wrong password

Opening a connection takes long time if wrong password

Postby LarsOberg » Wed 14 Mar 2012 17:40

Hello,

When using SSH (with the proper ssh user name and password), but the incorrect MySQL password, it takes a very long time before you get the MySQL Access denied exception when calling Open(). If you do not use SSH, it comes back instantaneously.

Sampel to reproduce:
Code: Select all
using (var conn = new MySqlConnection("User Id=samtst;Password=TheIncorrectMySqlPassword;Host=192.168.168.1;Port=3306;Database=Global;Protocol=Ssh;Connection Timeout=60;Pooling=True;SSH Host=192.168.168.1;SSH User=mysqlssh;SSH Password=TheCorrectSshPassword;Connection LifeTime=600;"))
{
    conn.Open(); // With SSH, takes 60 seconds, without SSH takes 1 second.

    conn.Close();
}


DevArt MySQL Version: 6.60.283.0
VS 2008, .NET 3.5

Please advise.

Thanks,
Lars
LarsOberg
 
Posts: 41
Joined: Tue 11 Oct 2005 18:45

Postby LarsOberg » Fri 16 Mar 2012 14:44

Bump - Devart, any word on this?
LarsOberg
 
Posts: 41
Joined: Tue 11 Oct 2005 18:45

Postby Pinturiccio » Mon 19 Mar 2012 13:10

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Wed 21 Mar 2012 08:42

We have fixed the bug with freezing for a ConnectionTimeOut time in case of a connection error when using SSH protocol. We will post here when the corresponding build of dotConnect for MySQL is available for download.
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44

Postby LarsOberg » Wed 21 Mar 2012 14:13

Thanks!
LarsOberg
 
Posts: 41
Joined: Tue 11 Oct 2005 18:45

Postby Pinturiccio » Thu 29 Mar 2012 14:22

The new build of dotConnect for MySQL 6.80.332 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23776
Pinturiccio
Devart Team
 
Posts: 2046
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL