Clickhouse in Docker

compose.yaml

services:
  warehouse:
    image: clickhouse/clickhouse-server
    ports:
    - "8123:8123"
    - "8443:8443"
    - "9000:9000"
    - "9440:9440"
    healthcheck:
      test: wget --no-verbose http://localhost:8123/
    volumes:
    # Use long syntax so that missing config raises errors:
    - type: bind
      source: ports.xml
      target: /etc/clickhouse-server/config.d/ports.xml
    # Must be generated:
    - type: bind
      source: server.crt
      target: /etc/clickhouse-server/server.crt
    - type: bind
      source: server.key
      target: /etc/clickhouse-server/server.key

ports.xml

<clickhouse>
    <https_port>8443</https_port>
    <tcp_port_secure>9440</tcp_port_secure>
    <openSSL>
        <server> <!-- Used for https server AND secure tcp port -->
            <certificateFile>/etc/clickhouse-server/server.crt</certificateFile>
            <privateKeyFile>/etc/clickhouse-server/server.key</privateKeyFile>
        </server>
    </openSSL>
</clickhouse>

secure_connections.md

For more info about SSL connected to clickhouse, including how to generate self signed SSL certs for the clickhouse server:

• https://clickhouse.com/docs/en/guides/sre/configuring-ssl
• https://ubuntu.com/server/docs/security-certificates
• https://altinity.com/blog/2019-3-5-clickhouse-networking-part-2
• https://stackoverflow.com/questions/57778609/issue-connecting-to-dockerized-clickhouse-server-with-python-driver
• https://stackoverflow.com/questions/62662851/python-clickhouse-driver-through-ssh-connection-error?noredirect=1&lq=1