MySQL SSL Problem since V20 update

[rupteur]

Hello,

We are using MySQL Database CRM Integration.

Since V20 update, I get an error message. Nothing was changed server-side.

The message is: SSL Authentication Error

In attachement you will find debug.

 

[Evolute IT]

Make sure you have TLS 1.2 enabled on the MySQL server.

Also disable SSLv3 if enabled. It is unsecure.

 

[rupteur]

It's enabled.

Variable_name	Value
in_predicate_conversion_threshold	1000
innodb_version	10.4.17
protocol_version	10
slave_type_conversions
system_versioning_alter_history	ERROR
system_versioning_asof	DEFAULT
tls_version	TLSv1.1,TLSv1.2,TLSv1.3
version	10.4.17-MariaDB-1:10.4.17+maria~jessie-log
version_comment	mariadb.org binary distribution
version_compile_machine	x86_64
version_compile_os	debian-linux-gnu
version_malloc_library	system
version_source_revision	5fbfdae130950d0a5a07d4b909f3bf1ff0498d34
version_ssl_library	OpenSSL 1.0.2l 25 May 2017
wsrep_patch_version	wsrep_26.22

 

[edossantos]

This is most probably because the MySQL user account you're using to login, is configured with an old authentication mechanism. You will need to reconfigure your user to use "caching_sha2_password".