sling connection to clickhouse with SSL and server certificate

[igrpon]

How could I setup sling connection to clickhouse with SSL and server certificate.

Currently I have YAML config like this:

connections:
  DWH_CH:
    type: clickhouse
    host: host.net
    port: 8443
    database: prod-01
    user: root
    password: **********
    http_url: https://[email protected]:8443

But I got the following error:

fatal:
~ could not connect to database
clickhouse [dsn parse]: https without TLS

[flarco]

Can you try adding query param secure=true in your http_url? Also, you can use skip_verify=true if network is trusted.

If you need to specify the certificate, sling doesn't accept it at the moment, need to add the functionality for a future version.

See README in https://github.com/ClickHouse/clickhouse-go?tab=readme-ov-file#dsn, which is the driver that sling uses.

[flarco]

Created #420

[igrpon]

With /?secure=true&skip_verify=true within http_url seems to be working with clickhouse

[igrpon]

By the way, for proper understanding, Am I right saying that http_url configuration overrides all the separate parameters in YAML (host: port: user: password:... ) ? That is not clear in the docs, I would clarify that.
Thank you!

[flarco]

Providing the http_url actually uses the HTTP interface, which is not as performant as the native interface. I'll add some context in the docs, but you shouldn't provide the http_url key if you don't want to use the HTTP interface.

You can try latest dev-build which should accept the properties secure and skip_verify, and generate the proper parameters for native connection. (see commit)