Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

by
I was getting this error while trying to connect my openfire server with postgresql database. Well let

me show you the step to fix this error.

Error:

Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

Solution:

This can happen due to following 2 reason

  • Your Firewall is blocking postgresql from making connection.
  • You have not configured your postgresql database on the server to accept connection from particular machines on the network
For firewall rules
# iptables -A INPUT -s 0.0.0.0/0 -p tcp --dport 5432 -j ACCEPT
# iptables -A INPUT -s 0.0.0.0/0 -p udp --dport 5432 -j ACCEPT

For postgresql configuration
# vi /var/lib/pgsql/data/postgresql.conf
Look out for this line
listen_addresses = 'localhost'

and change it to
listen_addresses = '*'

Restart the database services
# service postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ]
Now try connecting to the postgresql database using openfire. Let me know your success and failure