topic Re: Can't connect to MySQL v8.0.28 using SAS EG in SAS Enterprise Guide

Can't connect to MySQL v8.0.28 using SAS EG

joaohenriques — Tue, 23 Aug 2022 08:08:08 GMT

After enabling auto update on one of our MySQL db, hosted in AWS, a new update was made to v8.0.28. Since then, we are not able to connect to the db, using the libname statement:

LIBNAME <libname_name> MYSQL SERVER='<server>' DATABASE='<db_name>' USER='<user>' PASSWORD='<password>';

This is the rror message:

ERROR: Error trying to establish connection: SSL connection error: unknown error number
ERROR: Error in the LIBNAME statement.

This code had always worked, even without the port. It was working since we build our ETL framework, beginning 2021.

Fyi, using MySQL Workbench CE we can establish the connection, without any problem (no SSL is being used).

In the meantime, we realise that this can be related with the fact that MySQL v8.0.28 deprecated TLSv1 and TLSv1.1:

MySQL :: MySQL 8.0 Reference Manual :: 6.3.2 Encrypted Connection TLS Protocols and Ciphers

After realising this, we have updated our MySQL client to v8.0.30, including the MySQL Connector/Net. However, even after updating all MySQL tools to their newest versions, we still can't connect to the db using the libname. Btw, we are sure that the mysql client is using TLSv1.2 and v1.3, because we checked it directly in MySQL Workbench CE using the code:

SHOW GLOBAL VARIABLES LIKE 'tls_version';

Which returned:

Before downgrading the MySQL versions, we would like to challenge you with this issue. Is this familiar to anyone?

Thanks in advance! 😉

Re: Can't connect to MySQL v8.0.28 using SAS EG

LinusH — Tue, 23 Aug 2022 09:04:00 GMT

I suggest that you open a track with SAS tech support to assist you in your trouble shooting.

Since I suspect not many of the users of this forum have the exact the same set up as you.

Re: Can't connect to MySQL v8.0.28 using SAS EG

JosvanderVelden — Tue, 23 Aug 2022 09:58:05 GMT

This issue is currently under investigation by SAS Technical Support.

Re: Can't connect to MySQL v8.0.28 using SAS EG

JCBelland — Tue, 29 Aug 2023 14:18:24 GMT

Hi,

Did you finally solve the problem ?

Re: Can't connect to MySQL v8.0.28 using SAS EG

JosvanderVelden — Tue, 29 Aug 2023 14:32:31 GMT

After checking some points with SAS tech support, reinstallation of MySQL components and restarting SAS the connection to the new database is successful.