Re: odd psql behaviour on OSX

okay, i added in the machine to netinfo manager and now it works. i can
use psql to hit the internal address at work using either the ip address
or the name that i labelled it as in netinfo manager. i can also hit the
public ip at home from here at work.

when i get home i will see if i can hit the home server's private ip as
well as the work server public ip.

i have to say that i don't understand why psql could not see the servers
without this. actually, i'm guessing from previous emails that it isn't
psql but one of the system libs that psql uses that needs some addresses
to be explicity mapped. i just don't understand.

rjsjr

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Robert J.
> Sanford, Jr.
> Sent: Thursday, April 25, 2002 3:41 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] odd psql behaviour on OSX
>
>
> i don't know if i have said this before but i can use
> dbvisualizer with the
> postgres jdbc library to connect to either of the machines
> successfully both
> internally and externally.
>
> i was talking to both my boss and my network admin and they were wondering
> if there is something to do with configuring access to non-routable IP's
> under OSX...
>
> what do i need to do with netinfo manager, just try and add in a machine?
>
> rjsjr
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Robert J.
> > Sanford, Jr.
> > Sent: Thursday, April 25, 2002 3:21 PM
> > To: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] odd psql behaviour on OSX
> >
> >
> > okay, i'm doing a little more testing and i have some oddities.
> i'm hoping
> > to get some additional help with the additional info i'm providing here.
> >
> > i'm testing in two different networks - at home and at work. each of the
> > networks has postgres server on it. both of the servers have a
> public and
> > private ip address for each of the networks. the private ip
> > address for both
> > is a 192.168.69.xxx and the public ip address is, well, a public
> > ip address.
> >
> > the network at home is a cable modem network with a linksys
> > router/firewall
> > that is assigning dynamic ip addresses. the router passes
> requests coming
> > from outside through the port that i have selected to the
> machine running
> > postgres. when i attempt to use psql to access the private ip
> > address i get
> > the unknown host error listed below. when i attempt to use psql
> to access
> > the public ip address it responds and lets me in!
> >
> > the network at work is running a bunch of cisco routers and
> > switches and all
> > that good sort of stuff that i have no control over. when i attempt to
> > access the private ip address from my osx machine it fails to
> connect with
> > the unknown host error. when i try to connect to the public ip
> address it
> > also fails with the same error. when i try to connect to either
> the public
> > or private ip addresses from a windows machine running cygwin
> (i've tried
> > from both at work and at home) it works just fine.
> >
> > i have loaded up the netinfo manager application listed below but
> > i have no
> > idea as to what to do with it. i'm not a unix guy by any stretch of the
> > imagination. not afraid of it, just don't any experience with it
> > but willing
> > to learn.
> >
> > from my network at work i have explicitly set the DNS servers
> but still no
> > joy.
> >
> > i can still ping the server and get a response but psql is not
> seeing it.
> >
> > aaaaaauuuuuuugggggghhhhhhhh!
> >
> > so why can i see the one public ip address but not the other or the two
> > private ip addresses?
> >
> > many thanks!
> >
> > rjsjr
> >
> > > -----Original Message-----
> > > From: pgsql-general-owner(at)postgresql(dot)org
> > > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of
> Gregory Seidman
> > > Sent: Wednesday, April 24, 2002 10:48 PM
> > > To: pgsql-general(at)postgresql(dot)org
> > > Subject: Re: [GENERAL] odd psql behaviour on OSX
> > >
> > >
> > > Robert J. Sanford, Jr. sez:
> > > } i am running postgresql 7.2 for OSX (10.1.4?) that was
> > pre-built by marc
> > > } liyange (thank you very much mr. liyange!). whenever i'm
> > > working on my local
> > > } machine everything works gloriously. but when i attempt to
> use psql to
> > > } attach to a remote host i always receive the error message
> of "unknown
> > > } host".
> > > }
> > > } i will type in a command line of
> > > } $psql -h 192.168.1.128 -U myName myDBName
> > > }
> > > } and get back
> > > } psql: unknown host:192.168.1.128
> > > }
> > > } that server responds when i ping it. i have tried adding
> > entries into my
> > > } hosts file and restarting the system but that didn't help
> > either. i have
> > > } tried the -p 4532 option to specify the port but that doesn't
> > > work either.
> > >
> > > Incidentally, MacOS X normally ignores the /etc/hosts file. If
> > you want to
> > > set up that sort of thing, you need to do it in NetInfo
> Manager.app (or
> > > with niutil) to add an entry to /machines.
> > >
> > > } when i use dbvisualizer with the postgresql jdbc driver i can
> > > connect with
> > > } no problems. when i try psql on a win2k machine using cygin i
> > > can connect
> > > } with no problems. this leads me to believe that there is an
> > > issue with psql
> > > } accessing the network on osx.
> > > }
> > > } any ideas and/or suggestions?
> > >
> > > I am using the same package and version without any such
> difficulties. I
> > > suspect that it is a DNS issue. See if it has the same problem if
> > > you add a
> > > period to the end of the host. This will make the DNS lookup
> > behave a bit
> > > differently (I forget exactly what it shortcuts... maybe just
> expanding
> > > with search domains, maybe all lookups altogether on a
> numeric address).
> > > Thus:
> > >
> > > psql -h 192.168.1.128. -U myName myDBName
> > >
> > > } rjsjr
> > > --Greg
> > >
> > >
> > > ---------------------------(end of
> broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>