Postgres setup only works when DB_PORT specified explicitly

koel / docker

A minimal docker image for the koel music streaming server.

https://hub.docker.com/r/phanan/koel/

MIT License

166 stars 54 forks source link

Postgres setup only works when DB_PORT specified explicitly #168

Open HannesJo0139 opened 1 year ago

HannesJo0139 commented 1 year ago

Tried to setup using docker-compose.postgres.yml. Initialization seems to work but then login is impossible. Looking into log one can find that koel is trying to connect using port 3306 instead of 5432.

Long story short: One has to add env var DB_PORT=5432 to docker-compose.postgres.yml in order to make it work.

mattiasghodsian commented 11 months ago

I can confirm this, report from laravel

SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host "database" (172.26.0.2) and accepting
TCP/IP connections on port 3306? (SQL: select * from "personal_access_tokens" where "token" = e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 limit 1)

after doing php artisan koel:init --no-assets i hade to run php artisan serve and then i could login

patrick-motard commented 6 months ago

Lets get a PR out to update the documentation for the docker compose file to include this environment variable.