Postgres database from Heroku is not able to connect - Connection issue: SQL Database Connector issue: Connection attempt failed: no pg_hba.conf entry for host

Need help Database
1

Connection issue: SQL Database Connector issue: Connection attempt failed: no pg_hba.conf entry for host “54.185.181.28”, user “emkwejrdqbhqbj”, database “dfbi2jumbcm7va”, SSL off

The database is a free Heroku database, it works in all other apps and websites like Retool.com or any database client.

I’m pretty sure i cant fix this issue since Heroku doesn’t let you edit some random .conf files. So i have no way to connect my database at all?

1 Like
2

The authentication failed because the connection didn’t use SSL encryption: (SSL off). All Heroku databases require using SSL connections to ensure that communications between applications and the database remain secure. Bubble is not using SSL to connect to your database, you would see these errors even if you’re using the right credentials to connect to it.