Last Updated: 2024-11-21

I encountered the following error when trying to access postgres via acceptance tests running on my Vagrant machine (a virtual machine):

PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "192.168.10.10", user "homestead", database "projectx_test", SSL on
FATAL:  no pg_hba.conf entry for host "192.168.10.10", user "homestead", database "projectx_test", SSL off

What is HBA?

First off, we need to know that a hba.conf file controls client authentication. In fact, HBA stands for Host-Based-Authentication.

Each record within this file specifies:

• a connection type,
• a client IP address range (if relevant for the connection type)
• a database name
• a user name
• the authentication method to be used for connections matching these parameters.

Giving myself access via the HBA

I was able to fix my access issue by adding the following line to the end of the pg_hba.conf file (stored at /etc/postgresql/12/main/pg_hba.conf in my Vagrant machine)

host  all  all 0.0.0.0/0 md5

Meaning:

• host means TCP/IP (as opposed to a unix socket)
• all databases
• all users
• all IP addresses
• auth-method of md5 to verify passwords (other options could be, for example, to trust)

To get the config running, I restarted the service sudo service postgresql restart

Resources

• https://www.postgresql.org/docs/12/auth-pg-hba-conf.html