Opening a connection takes long time if wrong password

LarsOberg · Post by **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 · Post by **LarsOberg** » Fri 16 Mar 2012 14:44

Bump - Devart, any word on this?

Pinturiccio · Post by **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 · Post by **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.

LarsOberg · Post by **LarsOberg** » Wed 21 Mar 2012 14:13

Thanks!

Pinturiccio · Post by **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