Skip site navigation (1) Skip section navigation (2)

Re: weird network issue

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: Jonathan Nalley <jnalley(at)fgp(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: weird network issue
Date: 2008-03-28 17:18:58
Message-ID: D0AF6926-D0A1-41C5-A652-A5718B366219@kevinkempterllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
I'm not sure how to get the version however given the below listing  
of /boot/grub/grub.conf it's obviously Cent OS:


#boot=/dev/sda
default=0
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title CentOS (2.6.18-8.1.6.el5)
         root (hd0,0)
         kernel /vmlinuz-2.6.18-8.1.6.el5 ro root=/dev/VolGroup00/ 
LogVol00 clock=
pit noapic nolapic rhgb quiet
         initrd /initrd-2.6.18-8.1.6.el5.img
title CentOS (2.6.18-8.el5)
         root (hd0,0)
         kernel /vmlinuz-2.6.18-8.el5 ro root=/dev/VolGroup00/LogVol00  
rhgb quiet

         initrd /initrd-2.6.18-8.el5.img

I also did a uname -a:

[root(at)db1 ~]# uname -a
Linux vmsrv02.myclient.local 2.6.18-8.1.6.el5 #1 SMP Thu Jun 14 17:29:04
EDT 2007 x86_64 x86_64 x86_64 GNU/Linux



I ran the telnet command and got this:

-bash-3.1$ telnet 192.168.111.11 5432
Trying 192.168.111.11...
telnet: connect to address 192.168.111.11: No route to host
telnet: Unable to connect to remote host: No route to host


However a ping works:

-bash-3.1$ ping 192.168.111.11
PING 192.168.111.11 (192.168.111.11) 56(84) bytes of data.
64 bytes from 192.168.111.11: icmp_seq=1 ttl=64 time=0.438 ms
64 bytes from 192.168.111.11: icmp_seq=2 ttl=64 time=0.168 ms
64 bytes from 192.168.111.11: icmp_seq=3 ttl=64 time=0.232 ms



Thanks for the help...

/Kevin






[root(at)db1 ~]#On Mar 28, 2008, at 11:03 AM, Jonathan Nalley wrote:

> Could you send us the distro and version of Linux that you're using  
> on these two boxes?
>
> Just as a sanity check and assuming you have a telnet client on the . 
> 13 box, can you perform the following command:
>
> telnet 192.168.111.11 5432
>
> and then paste the output to us. I guess conceptually there's not a  
> whole lot of difference between doing that and using psql -h  
> 192.168.111.11 but it might eliminate some layer of issues.  If  
> you're familiar with nmap or similar programs you can accomplish the  
> same thing to ping .11 on port 5432
>
>> -----Original Message-----
>> From: kevin kempter [mailto:kevin(at)kevinkempterllc(dot)com]
>> Sent: Friday, March 28, 2008 12:56
>> To: Jonathan Nalley
>> Cc: 'pgsql-admin(at)postgresql(dot)org'
>> Subject: Re: [ADMIN] weird network issue
>>
>> Not sure. I'm not so well versed in the firewall/networking areas. I
>> can however do an scp pull from both machines :
>>
>> scp a file from 192.168.111.13 while logged onto 192.168.111.11
>> and
>> scp a file from 192.168.111.11 while logged onto 192.168.111.13
>>
>>
>> Can you point me where to look for firewall/iptables/SE issues?
>>
>>
>> Thanks in advance
>>
>>
>>
>>
>>
>> On Mar 28, 2008, at 10:45 AM, Jonathan Nalley wrote:
>>
>>> are you running any kind of firewall/iptables/SELinux  where the
>>> settings are perhaps not the same on the two machines?
>>>
>>>
>>> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
>> owner(at)postgresql(dot)org
>>> ] On Behalf Of kevin kempter
>>> Sent: Friday, March 28, 2008 12:31
>>> To: pgsql-admin(at)postgresql(dot)org
>>> Subject: [ADMIN] weird network issue
>>>
>>> Hi LIst;
>>>
>>> I have 2 Linux servers:
>>> 192.168.111.11
>>> 192.168.111.13
>>>
>>> Both are running postgres v 8.2.6
>>>
>>> I can ping the .11 box from .13 and vice versa
>>> I can connect remotely from the .11 box to the .13 box but I cannot
>>> connect to the .11 box from the .13 box.
>>>
>>> I can do this:
>>>
>>> on the 192.168.111.11 box:
>>>
>>> -bash-3.1$   psql -h 192.168.111.13
>>> Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
>>>
>>> Type:  \copyright for distribution terms
>>>      \h for help with SQL commands
>>>      \? for help with psql commands
>>>      \g or terminate with semicolon to execute query
>>>      \q to quit
>>>
>>> postgres=#
>>>
>>> However if I do this it fails:
>>>
>>> on the 192.168.111.13 box:
>>>
>>> -bash-3.1$   psql -h 192.168.111.11 postgres
>>> psql: could not connect to server: No route to host
>>>       Is the server running on host "192.168.111.11" and accepting
>>>       TCP/IP connections on port 5432?
>>>
>>>
>>>
>>> Both boxes have the same copy of the postgresql.conf file and the
>>> pg_hba.conf file.
>>>
>>> Here's the listen address setting (on the 192.168.111.11 box) from
>>> the postgresql.conf file:
>>> listen_addresses = '*'
>>>
>>>
>>> I also checked (after a restart) that the listen address and port
>>> was in fact as I thought
>>> on 192.168.111.11 :
>>>
>>>
>>> Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
>>>
>>> Type:  \copyright for distribution terms
>>>      \h for help with SQL commands
>>>      \? for help with psql commands
>>>      \g or terminate with semicolon to execute query
>>>      \q to quit
>>>
>>> postgres=# show listen_addresses;
>>> listen_addresses
>>> ------------------
>>> *
>>> (1 row)
>>>
>>> postgres=# show port
>>> ;
>>> port
>>> ------
>>> 5432
>>> (1 row)
>>>
>>> postgres=#
>>>
>>>
>>> Here's the current pg_hba.conf file on 192.168.111.11 :
>>>
>>>
>>>
>>> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>>>
>>> # "local" is for Unix domain socket connections only
>>> local   all         all                               ident sameuser
>>> # IPv4 local connections:
>>> host    all         all         127.0.0.1/32          ident sameuser
>>> # IPv6 local connections:
>>> host    all         all         ::1/128               ident sameuser
>>>
>>> #DRW.  This should be tighted up once the db instances are figured
>> out
>>> host    all         all         192.168.111.0/24              trust
>>>
>>>
>>>
>>> I'm stumped..
>>>
>>> Anyone have any thoughts ?
>>>
>>> Thanks in advance.
>>>
>>>
>>
>>
>
>
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

Responses

pgsql-admin by date

Next:From: salmanDate: 2008-03-28 17:38:02
Subject: Re: off-topic - list files on linux
Previous:From: Jonathan NalleyDate: 2008-03-28 17:03:19
Subject: Re: weird network issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group