MySQL8.0 SSL connection failed with Protocol Version Mismatch

Issue Summary

We are trying to connect to the MySQL Instance from Redash with SSL connection;
however, it is failed with error message “Protocol Version Mismatch”.

Both OS and Redash are old version, so it might be TLS related issue; however, if you know any solution or workaround, please give me advice.

  • Configuration (Pem is generated by MySQL8.0)
    image
  • Error Message
    image

OS is using OpenSSL 1.0.1f 6 Jan 2014
MySQL8.0 is allowed connection from TLS1.2.

PS:
I downloaded mysqlsh then I tested MySQL connection from the redash server.
It is working fine with “–ssl-ca=” option. So pem, connection and account is OK.

https://dev.mysql.com/get/Downloads/MySQL-Shell/mysql-shell-8.0.22-linux-glibc2.12-x86-64bit.tar.gz

Technical details:

  • Redash Version: redash.4.0.1.b4038
  • Browser/OS: Ubuntu 14.04.5 LTS
  • How did you install Redash: Unknown (It is installed by ex-employee)

Best Regards
Shinya