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.