Opening a connection takes long time if wrong password
Posted: 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:
DevArt MySQL Version: 6.60.283.0
VS 2008, .NET 3.5
Please advise.
Thanks,
Lars
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();
}
VS 2008, .NET 3.5
Please advise.
Thanks,
Lars