We're a self hosted, Enterprise user of Cal.com. I'm trying to set up SAML using the instructions, but get errors connecting to the SAML-specific DB. Is there a command (much like yarn workspace @calcom/prisma db-deploy) that is used to precreate the database structure for SAML? Just creating the empty DB didn't seem to work

The schema is extremely simple and is automatically generated at runtime, only an empty database needs to be created. What is the exact error you are seeing? Happy to point you to the migration scripts as plan B

When I log in as admin and go to the Security page, the load icon spins and I see this in the console: @calcom/webstart error connecting to postgres db: error: no pg_hba.conf entry for host "<<IP>>", user "<<USERNAME>>", database "cal-saml", SSL off

Look like it’s unable to connect to the database, how are you provisioning the postgres db?

Just pulled up PGAdmin with that username, right clicked and created the db. Nothing else fancy

It looks like you’ll have to try adding the IP and username to pg_hba.conf

That's what's baffling to me - I don't have a pg_hba.conf file that I've modified. I only added the entry to the .env file with SAML_DATABASE_URL

Very weird indeed, is the username different from the one used for the cal db?

No, same one. Even though I'm not hosting with Heroku, I found a Heroku KB that mentions that error can come up if your DB doesn't allow SSL to be off. Testing a change now...

Aah, good pointer to check. If that fails it's worth seeing what's currently in the pg_hba.conf file

Yup, that was it! The Postgresql database I have is hosted on Azure, and it's requiring SSL to connect (not a bad thing). Adding ?sslmode=require to the connection string in .env forced it to connect with SSL, solving the problem. Thanks for hopping on @Deepak Prabhakara to try and help!

Nice one @Mark Z. , will get this added to the doc 🙏