Not able to set sslmode=NONE

ClickHouse / clickhouse-tableau-connector-jdbc

Tableau connector to ClickHouse using JDBC driver

Apache License 2.0

57 stars 9 forks source link

Not able to set sslmode=NONE #73

Closed marshalladd closed 2 months ago

marshalladd commented 2 months ago

In advanced settings I need to set sslmode=NONE, but it stays always STRICT when SSL enabled in general tab.

marshalladd commented 2 months ago

options={custom_http_params=join_use_nulls=1,session_id=tableau-jdbc-connector-1714592691962-11745691,typeMappings=UInt64=java.lang.String,UInt128=java.lang.String,Int128=java.lang.String,UInt256=java.lang.String,Int256=java.lang.String,sslmode=STRICT,socket_timeout=300000}

Even though I wrote in custom connection parameters sslmode=NONE.

artshevchenko commented 2 months ago

Hi! You can use the solution from this issue: Issue #71

marshalladd commented 2 months ago

Solution: disable SSL in General tab, but in advanced tab add: ssl=true,sslmode=NONE