Skip to content

Guide for running with clickhouse docker #15

Open
@aaronvg

Description

I think a guide would be nice -- for some reason I can't get this to connect to my local clickhouse instance running on docker.

How I'm starting docker instance (on macOS m1 chip):

docker run -d -p 8123:8123 -p 9000:9000 \
    -v "$(pwd)/ch_data":/var/lib/clickhouse/ \
    -v "$(pwd)/ch_logs":/var/log/clickhouse-server/ \
    -v "$(pwd)/config.d":/etc/clickhouse-server/config.d/ \
    --name local-clickhouse --ulimit nofile=262144:262144 \
    -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=username -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 -e CLICKHOUSE_PASSWORD=1234 \
    clickhouse/clickhouse-server

How I start housewatch:

CLICKHOUSE_HOST=localhost \
CLICKHOUSE_CLUSTER=local-clickhouse \
CLICKHOUSE_USER=username \
CLICKHOUSE_PASSWORD=1234 \
CLICKHOUSE_SECURE=false \
docker compose -f docker-compose.yml up

Resulting errors

housewatch-app-1 | Failed to connect to localhost:9000

housewatch-worker-1 | Failed to connect to localhost:9000

housewatch-web-1 |
housewatch-web-1 | Proxy error: Could not proxy request /api/analyze/hostname from localhost:3000 to http://localhost:8000.
housewatch-web-1 | See https://nodejs.org/api/errors.html#errors_common_system_errors for more information (ECONNREFUSED).
housewatch-web-1 |

Would love any insights.

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions