Dremio source as Mysql with SSL enabled

@balaji.ramaswamy
Can Dremio connect to a Mysql which having SSL enabled? If yes do weed to provide any properties in advance tab?

Hi @ann This is currently a feature request in our backlog that is not yet prioritized,

Thankyou. But I think for most organizations myql comes with SSL enabled.
So they wont be able to access their mysql with Dremio.

This is currently also a blocker for us

@igorsechyn @ann Have checked internally and will update when I hear back

2 Likes

@ann @igorsechyn Target is summer of 2022

thank you for the update.

Hi @balaji.ramaswamy , Is the feature to connect to MySql having SSL enabled yet in Dremio? I copied the truststore & keystore files to the folder dremio/cert and set the appropriate connection parameter in the advanced options, still I am unable to connect to the MySql DB.
The parameters I set in the adv options are as below:
verifyServerCertificate=true
useSSL=true
requireSSL=true
clientCertificateKeyStoreUrl=dremio/cert/keystore
clientCertificateKeyStorePassword=****
trustCertificateKeyStoreUrl=dremio/cert/truststore
trustCertificateKeyStorePassword=****

Am I missing anything?