Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes. - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.
Date
Msg-id Pine.LNX.4.04.9902081910370.19320-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.  (Bob VonMoss <bvonmoss@bigfoot.com>)
List pgsql-interfaces
On Mon, 8 Feb 1999, Bob VonMoss wrote:

> Peter T Mount wrote:
>
> > On Sun, 7 Feb 1999, Bob VonMoss wrote:
> >
> > > Tom Lane wrote:
> > >
> > > > Bob VonMoss <bvonmoss@bigfoot.com> writes:
> > > > > [ can connect via unix socket, but not via TCP ]
> > > >
> > > > > The administrator says this is how postmaster is invoked:
> > > > > /usr/local/pgsql/bin/postmaster -S -i -D /usr/local/pgsql/data -p 5432
> > > >
> > > > OK, that eliminates the "forgot -i" gotcha.
> > > >
> > > > James Thompson is almost certainly right that the problem is that
> > > > Postgres' pg_hba.conf file is not set up to allow connections from
> > > > whichever IP address you are connecting from.
> > > >
> > > > We heard about a similar problem recently which turned out to be
> > > > due to use of "virtual server" IP addresses.
> > >
> > > The pgsql administrator put a line in pg_hba.conf that looks like this,
> > > where my_db is substituted for my database name:
> > >
> > > host my_db 0.0.0.0 0.0.0.0 ident sameuser
> > >
> > > I'm still getting the same 'User authentication failed' messages. Same thing
> > > from JDBC.
> > Is the machine you are running the java app or psql on running ident?
>
> Not that I know of. I'm requesting this from the administrator:
>
> host my_db 0.0.0.0 0.0.0.0 password sameuser

Yeah, he's changed it to ident. I'd go back to him, and get him to change
it to either password or crypt.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


pgsql-interfaces by date:

Previous
From: "Sebastian Feher"
Date:
Subject: Fw: "User Authentication Failed" with PostgreSQL 6.4.2 & psqlODBC
Next
From: Matthew Hagerty
Date:
Subject: Dealing with large query results