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:
Reviewing the server container I see this:
I logged into the db container, installed curl, and ran the "init-db-as-superuser.sql" script but the error continued to occur.
14 Replies
The default docker compose does not use a root user to connect to the db so you probably did more modifications than that
I can provide my file if you'd like to see it.
Sure
Are you using the .env file as well ?
Yerp
Can you send it as well
Sorry have to remove and re-add. Left something in there.
well yeah your DATABASE_URL is:
DATABASE_URL=postgres://db
that's what doesn't work
I appreciate you taking the time to identify the issue. Can you provide guidance on what that should be?
windmill_user@db?
I'm not really an ops guy so this is a little out of my wheelhouse
why not use the default .env provided ?
Because I didn't see it until you just mentioned it.
Thanks.
That's on me. Thanks again for taking the time.
no worries, maybe it's a sign it wasn't clear enough
I was reading through the self host article and clicked through to the compose. Didn't even think to back up a level on the repo and look for the .env
You do have curl commands specifically calling out to copy down the .env but I guess I just glossed right over it.