ClickHouse / clickhouse-tableau-connector-jdbc

Tableau connector to ClickHouse using JDBC driver
Apache License 2.0
57 stars 9 forks source link

Package signature verification failed. Tableau Server #25

Closed max-zorn closed 2 years ago

max-zorn commented 2 years ago

Hello. I did everything according to the instructions, installing the latest versions of the driver and connector, but get the following error:

image

Linux 4.15.0-55-generic x86_64 clickhouse-jdbc-0.3.2-patch2-shaded.jar clickhouse_jdbc_0.2.1.taco

image

How can it be fixed?

yurifal commented 2 years ago

The screenshot you've provided looks like the one of the previous version of the Connector (something like 0.1.1 or less). The error is about the Connector (*.taco) file not to be signed properly.

Please make sure you've installed and activated the newest release (version 0.2.1 as of now). This would require applying changes to the TS config (tsm pending-changes apply) and re-starting TS (tsm stop / tsm start).

artshevchenko commented 2 years ago

Hi! Which version of Tableau Server are you using?

max-zorn commented 2 years ago

@yurifal thank you, re-starting tsm helped to fix this issue. But I received another error:

image

I use the same credits on the server as for the Tableau desktop where the connection works. Should I open a new ticket for this error?

@artshevchenko Tableau Server Version: 2021.4.1 (20214.21.1214.2057) 64-bit Linux

yurifal commented 2 years ago

As far as I know, the connections on the http protocol (port 8123) to the CH managed instances hosted in the Yandex Cloud network are allowed from the hosts belonging to the same net (Y.Cloud only). The 'external' connections have to be using https (port 8443) and SSL. Please check the subnet of the host running your Tableau Server (as compared to the computer with the Tableau Desktop).

artshevchenko commented 2 years ago

@max-zorn Hi! Did Yuri's comment help? I found the proof in the documentation.

max-zorn commented 2 years ago

Thank you. It helped to set a local ip address instead of fqdn, btw, how to specify a parameter with a path to ssl cert if I want to use it?

yurifal commented 2 years ago

Please refer to this my comment (and the picture of the Advanced tab): https://github.com/analytikaplus/clickhouse-tableau-connector-jdbc/issues/23#issuecomment-1013135359