I got this error while trying to connect my postgresql database using openfire server.
Save and exit the file and restart the postgresql service
Now re try to connect your database using openfire. Let me know your success and failure.
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.
no pg_hba.conf entry for host "*", user "*", database "*", SSL off
Reviewed by Deepak Prasad
on
Saturday, September 21, 2013
Rating:
No comments: