MySQL Router Handshake error
Posted: Mon 09 Aug 2021 21:39
Hi I hope someone can assist..
After upgrading to MySQL server 8.0.25 from 8.0.22, I get a "SSL_do_handshake=0, SSL_get_error(..., r2) =5, r2=0"
This only happens if I connect via MySQL Router on any port (6446,6447)
The MySQL Router was also upgraded to 8.0.25.
If I connect directly to any of the clustered MySQL servers directly (Port 3306), it works perfectly.
When connecting to the MySQL router from MySQL Workbench from the same machine, no problems are experienced.
The connection to the MySQL Router is set to SSL REQUIRED in MySQL Workbench
They had recently made changes to the way SSL is handled in the MySQL Router. The changes were made in V 8.0.23 (my last version was 8.0.22) so I suspect that the issue is with those changes somehow.
The MySQL Server/ Router is running on Ubuntu 16.04
I am using the latest version of MyDac (10.4.4) on Delphi XE2
After upgrading to MySQL server 8.0.25 from 8.0.22, I get a "SSL_do_handshake=0, SSL_get_error(..., r2) =5, r2=0"
This only happens if I connect via MySQL Router on any port (6446,6447)
The MySQL Router was also upgraded to 8.0.25.
If I connect directly to any of the clustered MySQL servers directly (Port 3306), it works perfectly.
When connecting to the MySQL router from MySQL Workbench from the same machine, no problems are experienced.
The connection to the MySQL Router is set to SSL REQUIRED in MySQL Workbench
They had recently made changes to the way SSL is handled in the MySQL Router. The changes were made in V 8.0.23 (my last version was 8.0.22) so I suspect that the issue is with those changes somehow.
The MySQL Server/ Router is running on Ubuntu 16.04
I am using the latest version of MyDac (10.4.4) on Delphi XE2