search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
254 stars 89 forks source link

ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted #443

Open kleinmantara opened 5 months ago

kleinmantara commented 5 months ago

Hello, I have the following error on a Power BI Gateway:

ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted

We installed the both drivers:

The PowerBI Gateway ist connected to the Power BI Web. The Status is online. image

The Clickhouse driver is added as "User-configured data connectors" and is also displayed as a connection type in Power BI Web. When I then try to add a new "Connection" in Power BI Web, I get the same error message as above:

image

Details: ClickhousePowerBI_Gateway1: ODBC: ERROR [HY000] Certificate validation error: Failed to verify certificate chain: CA not trusted

image

I have already added the same in the issue SSL error in the Repo power-bi-clickhouse. But I think this is the better place

carelesssava commented 6 days ago

+1, any updates on this issue?

kleinmantara commented 5 days ago

@carelesssava Unfortunately, no. It might not be the 'actual' error message but rather the result of a previous error.

carelesssava commented 5 days ago

I solved this problem by installing the cloud certificates in 2 places at once on Windows local machine with Power BI:

Environment: I'm not using a Power BI Gateway like you, instead I'm editing the dashboard and using the "Publish" button.

I'm using a cloud platform for ClickHouse deploying (Managed Service), this cloud platform provides certificates for connection to its Managed Services.

kleinmantara commented 5 days ago

Hello @carelesssava , that sounds interesting, thanks for the feedback. Which certificates (and from where) did you take exactly?

carelesssava commented 2 days ago

Hello @carelesssava , that sounds interesting, thanks for the feedback. Which certificates (and from where) did you take exactly?

Hello! I'm using Managed service for ClickHouse in the Yandex Cloud environment. According to the Yandex Cloud documentation, it is required to have special certificates installed to connect to the cluster.

Resource - https://yandex.cloud/en/docs/managed-clickhouse/operations/connect/#get-ssl-cert