Unable to connect to ClickHouse with SSL #1391
Past Issues Searched
Issue is a Bug Report
Describe the bugContext:
When running the Plausible container, logs are indicating a connectivity issue with ClickHouse: docker run -p 8080:8080 org/plausible
Loading plausible..
Starting dependencies..
Starting repos..
create Plausible.Repo database if it doesn't exist
13:32:46.593 [error] Clickhousex.Protocol (#PID<0.179.0>) failed to connect: ** (ErlangError) Erlang error: :closed
13:32:46.593 [error] Clickhousex.Protocol (#PID<0.178.0>) failed to connect: ** (ErlangError) Erlang error: :closed
13:32:47.759 [error] Clickhousex.Protocol (#PID<0.179.0>) failed to connect: ** (ErlangError) Erlang error: :closed
create Plausible.ClickhouseRepo database if it doesn't exist
13:32:47.990 [error] GenServer #PID<0.212.0> terminating
** (UndefinedFunctionError) function :closed.exception/1 is undefined (module :closed is not available)
:closed.exception([])
(db_connection 2.2.2) lib/db_connection/connection.ex:87: DBConnection.Connection.connect/2
(connection 1.0.4) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.14) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
13:32:48.004 [error] GenServer #PID<0.214.0> terminating
** (UndefinedFunctionError) function :closed.exception/1 is undefined (module :closed is not available)
:closed.exception([])
(db_connection 2.2.2) lib/db_connection/connection.ex:87: DBConnection.Connection.connect/2
(connection 1.0.4) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.14) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
13:32:48.019 [error] GenServer #PID<0.216.0> terminating
** (UndefinedFunctionError) function :closed.exception/1 is undefined (module :closed is not available)
:closed.exception([])
(db_connection 2.2.2) lib/db_connection/connection.ex:87: DBConnection.Connection.connect/2
(connection 1.0.4) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.14) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
13:32:48.029 [error] GenServer #PID<0.218.0> terminating
** (UndefinedFunctionError) function :closed.exception/1 is undefined (module :closed is not available)
:closed.exception([])
(db_connection 2.2.2) lib/db_connection/connection.ex:87: DBConnection.Connection.connect/2
(connection 1.0.4) lib/connection.ex:622: Connection.enter_connect/5
(stdlib 3.14) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
** (MatchError) no match of right hand side value: {:error, "killed"}
(plausible 0.0.1) lib/plausible_release.ex:48: anonymous fn/2 in Plausible.Release.createdb/0
(elixir 1.11.3) lib/enum.ex:2193: Enum."-reduce/3-lists^foldl/2-0-"/3
(plausible 0.0.1) lib/plausible_release.ex:47: Plausible.Release.createdb/0
(stdlib 3.14) erl_eval.erl:680: :erl_eval.do_apply/6
(elixir 1.11.3) lib/code.ex:341: Code.eval_string_with_error_handling/3While running the same Plausible container using Expected behaviorPlausible should be able to support SSL connectivity to clickhouse ScreenshotsNo response Environment- OS: N/A
- Browser: N/A
- Browser Version: N/A |
Replies: 3 comments 4 replies
|
Tried to use https in other environments than Azure, and I'm facing the same issue. |
|
SSL must be configured in Clickhouse: https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings/#http-porthttps-port |
|
Actually our ClickHouse server is exposed through a proxy that already handles SSL. The server responds without errors to https requests and the certificate is valid. |
|
Oh, interesting. I've only ever used http because we're on a private network. You can try adding If that doesn't work I can't help you. Maybe you could ask the authors of the clickhouse connection library or Ecto itself. |
|
There is an example config with SSL support in the clickhouse ecto repo. Maybe useful? https://github.com/clickhouse-elixir/clickhouse_ecto/blob/bc963d3f53bf4264e6fa2b7345c7e3c3dc49d6ee/examples/config/prod.exs#L22-L44 |
|
👋 everyone I tried running clickhouse on digitalocean with caddy in front of it and encountered the same issue. Seems like |
|
I see three workarounds:
|
SSL must be configured in Clickhouse: https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings/#http-porthttps-port