CentOS 7 Database Access Only Possible Trough Localhost And Not IP

Home » CentOS » CentOS 7 Database Access Only Possible Trough Localhost And Not IP
CentOS 4 Comments

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 :

  • 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