alan-turing-institute / WimbledonPlanner

Project planning for REG
MIT License
0 stars 0 forks source link

no pg_hba.conf entry for host, SSL connection required error #78

Open jack89roberts opened 4 years ago

jack89roberts commented 4 years ago

When running wimbledon locally sometimes getting an error like:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  no pg_hba.conf entry for host "<IP_ADDRESS>", user "<USERNAME>", database "<DATABASE_NAME>", SSL on
FATAL:  SSL connection is required. Please specify SSL options and retry.

The <IP_ADDRESS> here will be your own IP address. The error is because the Wimbledon database is IP restricted. To add your IP address go to WimbledonPlanner subscription -> wimbledon-planner-production resource group -> wimbledon-planner database -> connection security in the portal.