@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?
Any update on this ? @Anuradha did you resolve this ?
is this change released ?
ok I figured it out . Under the connection properties you can add
useSSL true
trustServerCertificate true