By wjziv
I have a Python (FastAPI) application running on the app platform within a docker container which I’d like to connect to a managed database. At the moment, I’m only using a dev database.
When I deploy my application, the message which pops up is as follows:
asyncpg.exceptions.InvalidAuthorizationSpecificationError: no pg_hba.conf entry for host "167.99.147.79", user "db", database "db", SSL off
I’m using sqlalchemy to make the connection, but it appears as though I’m making the conscious effort not to use SSL.
Default connection options try SSL first; when I require it, it still returns this message.
Any leads? I imagine the cause is that the server may not be set up for SSL from the get-go, but I’m stumped on proving this to myself.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
