Re: centos 7 database access only possible trough localhost and not IP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxx>:

> 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@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>



-- 
Laurent.
crepetl@xxxxxxxxx / root@xxxxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos




[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux