Issue with Appwrite Sites

When self hosting, Appwrite Sites has serious issues. When deploying a new site, the subdomain to be generated has no extensions, e.g instead of subdomain.example.com, it’s just subdomain. without example.com.

After several hours of making changes to .env, I got it showing the example.com, and can actually deploy something, but it refuses to issue ssl certificate.

I’m not sure if I’m doing something wrong or this thing was just meant for Appwrite cloud, because when it was announced I thought it’s something similar to Coolify but with all other Appwrite features.

I have attached screenshots of what it looks like