[CentOS] centos 7 database access only possible trough localhost and not IP

Sun Mar 15 08:03:24 UTC 2015
Laurent CREPET <crepetl at gmail.com>

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 <robert at redcor.ch>:

> 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
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>



-- 
Laurent.
crepetl at gmail.com / root at tnpl127.net