SelfHosted - Bad Gateway

Hey,

So I am trying to get Appwrite running on my Ubuntu Server using the below command

I am planning on adding a domain name, but for now I am running it localhost and proxying the ports to my local machine. During the setup I set the ports to 8000 and 8443 and changed the secret, the rest I have left default. This worked locally on my Windows PC but not my server (no idea why)

When I run docker-compose logs I see a large number of errors regarding connecting to redis and mariadb. I've attached a snippet for the SQL connection error and the picture is redis connection issues.

I found https://discord.com/channels/564160730845151244/1111268781734514750/1111268781734514750 although I tried running as sudo but no luck.

When I run docker ps I see that appwrite-maintenance, appwrite-scheduler-messages and appwrite-scheduler-functions keep crashing and restarting.

Any ideas?

Also now when I run docker logs appwrite I get the snippet below, it did this before infinitly.

Is appwrite-mariadb running? What do you see in the logs for that one?

mariadb doesnt seem to have restarted or thrown any unusual errors that I can see

Try a compose down and compose up to bounce if you haven't, just to rule out its not transient. Are you able to connect to the MariaDB database using the environment vars set in the .env file?

When I down and back up it, the Redis and SQL connection errors persist.

And after modifying the compose file for exposing 3306 and connecting, I can connect as both users, root and user