Guide for running with clickhouse docker
aaronvg opened this issue · 1 comments
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.
Have been off for a while but will see if I get a chance to take a look at this and improve our docs!