metabase-clickhouse-driver SSL error

SSL error

Open aleksandr-melnik1 opened this issue 3 years ago • 5 comments

i have problem with ssl:

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

but metabase started with keystor java, system and java keystore have this certificate. I can not specify the path to the certificate in the plugin.

Jun 20 '22 09:06 aleksandr-melnik1

Have the same issue, where can we put certificate if we can not specify path to it

Jun 21 '22 06:06 egorperesada

Do you know the corresponding option in the JDBC driver?

Jun 21 '22 07:06 enqueue

Could you show where and what options need to be added?

Jun 21 '22 07:06 aleksandr-melnik1

The parameter is called sslrootcert. Connection example "jdbc:clickhouse://%s:8443/%s?ssl=1&sslmode=strict&sslrootcert=/path/to/CA.crt"

Jul 02 '22 16:07 smarkov92

probably related to #85

Aug 24 '22 14:08 enqueue

We just released 0.8.3, which should bring back "additional JDBC connection string options".

Please try specifying additional JDBC connection string options (something like sslrootcert=/path/to/CA.crt as was suggested by @smarkov92)

That should be available under the "advanced options":

Please feel free to re-open the issue if it does not work for you.

Dec 01 '22 17:12 slvrtrn