mindofbeholderM
Windmill3y ago
21 replies
mindofbeholder

Unable to start new Windmill instance with default docker due to "role 'root' does not exist'" error

I'm utilizing the default docker compose with the multiplayer and caddy services removed.

When I start up the services I see this error on the db container:
2023-08-08T17:22:25.573703934Z 2023-08-08 17:22:25.573 UTC [431] FATAL:  password authentication failed for user "root"
2023-08-08T17:22:25.573732259Z 2023-08-08 17:22:25.573 UTC [431] DETAIL:  Role "root" does not exist.


Reviewing the server container I see this:
2023-08-08T17:17:40.260238531Z 2023-08-08T17:17:40.260191Z  INFO windmill: Connecting to database...
2023-08-08T17:17:40.265424110Z Error: Connecting to database: error returned from database: password authentication failed for user "root"


I logged into the db container, installed curl, and ran the "init-db-as-superuser.sql" script but the error continued to occur.
Was this page helpful?