MySQL Router Handshake error

[TonyViljoen]

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

[YanishevskiyVI]

Hi Tony!

Thank you for joining the forum and for your question!

It looks like you are having issues with OpenSSL library used on a client side. So, please, try to update OpenSSL library binaries.

In order to organize a secure SSL connection, you are recommended to use the SecureBridge product https://www.devart.com/sbridge/download.html

Please, let us know if there are any other questions!

Regards,
Vitaliy

[TonyViljoen]

Thanks Vitaliy, that solved the problem!