CentOS 7 Database Access Only Possible Trough Localhost And Not IP
Hi there and hello to everybody,
I am all new to CentOS but I have good experience working with ubuntu and suse.
We are moving a an elderly SuSe box to a virtual machine running CentOS 7.
Now I experience the following problem.
I can only access postgres using localhost as host. If I use the IP address
(even 127.0.0.1).
I found a similar problem when accessing the host using http. There I found out
(after lots of hair pulling) that I have to set a value using setsebool.
So I assume, that I have a similar problem here.
I would be grateful, if somebody could point me in the right direction ..
thanks
robert
4 thoughts on - CentOS 7 Database Access Only Possible Trough Localhost And Not IP
Hi Robert,
I have almost no experience with CentOS 7(still using CentOS 6). However, I
recommed the following checks:
1. Check that PostgreSQL is listening on 0.0.0.0 (all ip addresses) and not
127.0.0.1. To check, you can use the command:
netstat -tuplan
If PostgreSQL is listening only on 127.0.0.1, you’ll never be able to connect to it from the network. You’ll have to change the PostgreSQL
settings.
2. Check that iptables (firewall) is allowing the connections from the network to PostgreSQL. Use the following command to get the list of rules that are currently loaded:
iptables -L
Regards, Laurent.
2015-03-15 8:52 GMT+01:00 robert rottermann:
Hello Robert,
See if this will help [0], by default it appears to be listening for localhost only “listen_addresses=’localhost'”.
[0]
http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html
I usually use
iptables -L -vn
to see the full rules and what they are doing. the default -L display is missing important bits.
thanks very much to everybody, it was in deed the fact, that postgres was only listening to localhost.
robert