Behavior

I've got a strange behavior on one of my systems. I am trying to connect to the mysql-server on a remote system. After 15 seconds (command timeout) I get a timeout exception. On the other systems which are likely the same, the same code works.

A closer look into the sent messages with wireshark shows that the Client(MySQLConnector) and Server (MySQL5.7) are giving each other Certificates, Handshakes and the "new session Ticket". But the Open method of the MySQLConnection-class does not continue.

Is there anything about the server configuration I forgot? Anything in the connectionstring I should add?

If you need furthermore Information let me know.

System Components

Both Systems are Windows 10.0.19043, x64 with an installed .NET Framework 4.8.04084

Remote Target MySQL Server:

• Version: 5.7.36
• Host OS: Ubuntu 20.04.3 LTS (by WSL)

Application:

• tested MySQLConnector Versionen 1.0.1.0 | 2.0
• Connectionstring: Server=xxx.xxx.xxx.xxx;Database=MySQL_TestDB;Port=3306;Uid=Username;Pwd=myPassword;

Exception

Message
Connect Timeout expired.

Inner Exception
Unable to connect to any of the specified MySQL hosts.

Stacktrace

at MySqlConnector.MySqlConnection.<CreateSessionAsync>d__117.MoveNext() in //src/MySqlConnector/MySqlConnection.cs:line 843\r\n
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in f:\dd\ndp\clr\src\BCL\system\runtime\compilerservices\TaskAwaiter.cs:line 184\r\n
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in f:\dd\ndp\clr\src\BCL\system\runtime\compilerservices\TaskAwaiter.cs:line 157\r\n
at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult()\r\n
at MySqlConnector.MySqlConnection.<OpenAsync>d__27.MoveNext() in //src/MySqlConnector/MySqlConnection.cs:line 407\r\n
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) in f:\dd\ndp\clr\src\BCL\system\runtime\compilerservices\TaskAwaiter.cs:line 184\r\n
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) in f:\dd\ndp\clr\src\BCL\system\runtime\compilerservices\TaskAwaiter.cs:line 157\r\n
at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 365\r\n

Code

C# console application:

MySqlConnection conn = new MySqlConnection(connectionstring);
try
{
 Console.WriteLine(sw.Elapsed.ToString() + ": First Connection establish...");
 conn.Open();
 Console.WriteLine(sw.Elapsed.ToString() + ": First Connection established. State: " + conn.State.ToString());
 conn.Close();
 Console.WriteLine(sw.Elapsed.ToString() + ": First Connection closed. State: " + conn.State.ToString());
}
catch(Exception ex)
{
 Console.WriteLine(sw.Elapsed.ToString() + ": Exception thrown:" + ex.Message);
} 

Output:

00:00:00.0002621: First Connection establish...

00:00:15.0468347: Exception thrown:Connect Timeout expired.