no pg_hba.conf entry for host “*”, user “*”, database “*”, SSL off

I got this error while trying to connect my postgresql database using openfire server.

Error:

FATAL: no pg_hba.conf entry for host “10.10.20.26”, user “deepak”, database “openfire”, SSL off

Solution:

You need to make a host entry in the host access file of postgresql which is pg_hba.conf
# vi /var/lib/pgsql/data/pg_hba.conf
At the last line make a new entry as shown below
host    all         all         0.0.0.0/0               md5
Save and exit the file and restart the postgresql service
# service postgresql restart
Now re try to connect your database using openfire. Let me know your success and failure.

Leave a Comment

close button