:econnrefused and auth issues after contribution guide steps

[vladislavkovaliov]

Follow the guide, I have a running DB and Clickhouse inside Docker.

After that, I ran the command make install and then I saw the error:

mix ecto.create
The database for Plausible.Repo has been created
** (Mix) The database for Plausible.IngestRepo couldn't be created: %Mint.TransportError{reason: :econnrefused}
make: *** [install] Error 1

I have checked the connection to ClickHouse:

curl http://localhost:8123                              
curl: (7) Failed to connect to localhost port 8123 after 0 ms: Couldn't connect to server

I figured out whether the line in Makefile would be changed from:

docker run $(CH_FLAGS) --network host --volume=$$PWD/.clickhouse_db_vol:/var/lib/clickhouse clickhouse/clickhouse-server:latest-alpine

to:

docker run $(CH_FLAGS) --volume=$$PWD/.clickhouse_db_vol:/var/lib/clickhouse clickhouse/clickhouse-server:latest-alpine

The connection to ClickHouse is ok:

curl http://localhost:8123                                 
Ok.

But after repeating make install, I have gotan issue with the user and password:

The database for Plausible.Repo has been created
** (Mix) The database for Plausible.IngestRepo couldn't be created: %Ch.Error{code: 194, message: "Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.\n\nIf you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/\non the settings page for the corresponding service.\n\nIf you have installed ClickHouse and forgot password you can reset it in the configuration file.\nThe password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml\nand deleting this file will reset the password.\nSee also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.\n\n. (REQUIRED_PASSWORD) (version 25.4.1.2934 (official build))\n"}
make: *** [install] Error 1

Can someone help me or direct me to where I can find more info about how to run this locally, please?

And is contributing guide up-to-date?

[ruslandoga]

👋 @vladislavkovaliov

The last error can probably be fixed by adding -e CLICKHOUSE_SKIP_USER_SETUP=1

[vladislavkovaliov]

Awesome. It works.

What about --network-host?
Does it make sense to remove this arg from Makefile?

[ruslandoga]

I don't know :)

For reference, --network=host was added in #5078.

^{One thing to keep in mind is that Makefile is likely used by the core team more often than outside contributors :)}