Bug: Current main branch 0bcb846 does not start properly, release 0.15.0 5b2c1ba and 0.15.1 ba556e1 runs fine

[fredriknk]

What were you trying to achieve?

Im just testing out Magistrala for a small project, and i couldnt get it up and running following the guides with the main branch, Release v0.15.0 and v0.15.1 works perfectly following the readme.

What are the expected results?

Working service

What are the received results?

Not working service.
It seems the service struggle to connect with the databases?

magistrala-ui               | 2025/01/21 08:07:56 Failed to setup postgres db : failed to apply migrations : failed to connect to `host=localhost user=magistrala-ui database=dashboards`: dial error (dial tcp [::1]:5432: connect: connection refused)

magistrala-spicedb-db       | 2025-01-21 08:08:11.825 UTC [1429] FATAL:  password authentication failed for user "supermq"
magistrala-spicedb-db       | 2025-01-21 08:08:11.825 UTC [1429] DETAIL:  Role "supermq" does not exist

magistrala-groups           | {"time":"2025-01-21T08:08:13.16277215Z","level":"ERROR","msg":"failed to create authn service is not serving"}

magistrala-nginx            | 2025/01/21 08:08:24 [emerg] 22#22: host not found in upstream "mqtt-adapter:8080" in /etc/nginx/snippets/mqtt-ws-upstream.conf:5

magistrala-http             | {"time":"2025-01-21T08:11:09.854832423Z","level":"ERROR","msg":"service is not serving"}
magistrala-http exited with code 1

magistrala-spicedb          | {"level":"error","error":"failed to create datastore: failed to create primary datastore: failed to connect to `user=supermq database=spicedb`: 172.18.0.10:5432 (spicedb-db): failed SASL auth: FATAL: password authentication failed for user \"supermq\" (SQLSTATE 28P01)","time":"2025-01-21T08:11:13Z","message":"terminated with errors"}

Steps To Reproduce

commands to replicate issue:

git clone https://github.com/absmach/magistrala.git
cd magistrala
docker compose -f docker/docker-compose.yml --env-file docker/.env up

In what environment did you encounter the issue?

Ubuntu Server - 22.04 and 24.04

Client: Docker Engine - Community
Version: 27.5.0
API version: 1.47
Go version: go1.22.10
Git commit: a187fa5
Built: Mon Jan 13 15:24:49 2025
OS/Arch: linux/amd64
Context: default

Docker Compose version v2.32.4

Additional information you deem important

No response

[arvindh123]

The Nginx conf is not update. So only it is failing
I will send PR this issue

[arvindh123]

Hope this PR will solve the issue
#49

[igorvdev]

it didn't fix the error for me
magistrala-ui | 2025/01/22 09:28:33 Failed to configure postgres db: failed to apply migrations: failed to connect to host=localhost user=magistrala-ui database=dashboards: dialing error (dial tcp [::1]: 5432: connection: connection refused)
magistrala-ui | 2025/01/22 09:29:33 Failed to configure postgres db: failed to apply migrations: failed to connect to host=localhost user=magistrala-ui database=dashboards: dialing error (dial tcp [::1]: 5432: connection: connection refused)