PostHog/HouseWatch

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!