How to disable JDBC MySQL SSL


#1

Hi All,

After I upgraded my Metabase instance to v.32.1, I couldn’t connect to our MySQL database source.

I’ve checked the log and it looks like it keeps trying to connect using SSL but my MySQL doesn’t have SSL enabled in it.

Can you please advise how we can connect without SSL? What option do I need to put in the JDBC option field?

Please help.

Thank you.

H


#2

Hi @cehau37
Try 0.32.2 - it fixed some stuff with MySQL and SSL.
It shouldn’t try to connect with SSL by default, but try these options:

useSSL=false&requireSSL=false

Otherwise provide the logs. And which version did you upgrade from?


#3

Hi,

Thank you for your help. However, the options given “useSSL=false&requireSSL=false” didnt’ work.

Below are the logs that we have…

java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server
Apr 05 14:19:28 apigatewaystaging01.dusdusan.com metabase[64253]: :dbname “java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server”,
Apr 05 14:19:28 apigatewaystaging01.dusdusan.com metabase[64253]: :message “java.sql.SQLException: Trying to connect with ssl, but ssl not enabled in the server”}

Please help…


#4

@cehau37
Did you try upgrading to 0.32.2? Which version of MySQL?
I’ve just tried to add skip_ssl to my MariaDB 10.3 configuration and restarted, and Metabase connects without problems.


#5

Yes. I did try upgrading my 31.2 to 32.2.

Im using mariadb 10.2


#6

Okay, I cannot reproduce your issue. Try looking at the logs to see if you see something. Otherwise I can only recommend that you downgrade to 0.31.2
Out of curiosity, why is MariaDB configured with skip_ssl ?


#7

we didnt configure skip_ssl… we want to disable have_openssl… is it possible?


#8

But then just disable that on the MariaDB server. have_openssl is a global variable, so it cannot be set by the client/session.