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.

Please follow the below links for more tutorials

How to secure Apache web server in Linux using password (.htaccess)
How to register Red Hat Linux with RHN (Red Hat Network )
Red hat Enterprise Linux 5.5 Installation Guide (Screenshots)
15 tips to enhance security of your Linux machine
Why is Linux more secure than windows and any other OS
What is the difference between "su" and "su -" in Linux?
What is swappiness and how do we change its value?
How to log iptables messages in different log file
What are the s and k scripts in the etc rcx.d directories
How to check all the currently running services in Linux
How to auto start service after reboot in Linux
What is virtual memory, paging and swap space?