ClickHouse / clickhouse-tableau-connector-jdbc

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

Error Code: 14D18B1F #58

Open KhoruzhevskiiGeorgii opened 9 months ago

KhoruzhevskiiGeorgii commented 9 months ago

Tableau 2023.1, port 8443, An error occurred while communicating with ClickHouse JDBC by ANALYTIKA PLUS There was a problem while running the connector plugin. Reinstall the plugin or contact the plugin provider. Note that you might need to make local configuration changes to resolve the error. Error Code: 14D18B1F Package signature verification failed during connection creation. Connector Class: clickhouse_jdbc, Version: 0.2.6

yurifal commented 9 months ago

Tableau Desktop / Server ? If Desktop, macOS / Windows ?

KhoruzhevskiiGeorgii commented 9 months ago

Tableau Desktop / Server ? If Desktop, macOS / Windows ?

Desktop, Windows

KhoruzhevskiiGeorgii commented 9 months ago

windows 11, if matters

yurifal commented 9 months ago

add this flag to the Tableau Desktop Shortcut

-DDisableVerifyConnectorPluginSignature=true

KhoruzhevskiiGeorgii commented 9 months ago

add this flag to the Tableau Desktop Shortcut

excuse me, how to add a flag?

yurifal commented 9 months ago

here:

Screenshot 2023-09-12 at 13 10 50
KhoruzhevskiiGeorgii commented 9 months ago

-DDisableVerifyConnectorPluginSignature=true

i've added the flag, but the error is the same

yurifal commented 9 months ago

strange, it works for me. could you please try to start TD from the command line with this flag at the end of the command?

KhoruzhevskiiGeorgii commented 9 months ago

I'm not experienced with cmd, could you please provide the full command?

yurifal commented 9 months ago

"C:\Program Files\Tableau\Tableau 2023.1\bin\tableau.exe" -DDisableVerifyConnectorPluginSignature=true

KhoruzhevskiiGeorgii commented 9 months ago

then i have another error image

vlauzeckas commented 9 months ago

this is general error that you can't reach clickhouse. 2 things pop to my head:

  1. check if AWS firewall rules allow to connect to 8443 port from outside
  2. check clickhouse configuration, does you allow connection from outside
yurifal commented 9 months ago

8443 is the https port. make sure the SSL checkbox is set.

KhoruzhevskiiGeorgii commented 9 months ago

8443 is the https port. make sure the SSL checkbox is set.

thank you, that helped