Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc -i not the problem - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc -i not the problem
Date
Msg-id Pine.LNX.3.95.980315085618.21425B-100000@maidast
Whole thread Raw
In response to Re: [QUESTIONS] postgresql-6.3 and jdbc -i not the problem  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-interfaces
On Fri, 13 Mar 1998, The Hermit Hacker wrote:

>
> Redirected to 'the proper list' - pgsql-interfaces@postgresql.org
>
> On Fri, 13 Mar 1998, Stephan B. Doliov wrote:
>
> > On Fri, 13 Mar 1998, e. lambrecht wrote:
> >
> > > Start the postmaster with the '-i' option to enable connections via
> > > sockets. The new server defaults to using unix domain sockets, which
> > > jdbc doesn't use. I had the same problem - drove me crazy for a while.
> > >
> > ugh. i thought i said in the post that i was using the -i option, still
> > the same problem though.
> >
> > ps -ef | grep postm
> > postgres  4038     1  0 13:50:16 pts/4    0:00
> > /opt/postgres/bin/postmaster -i
> >
> > so there you have it.  am i specifying the url incorrectly.  i am trying
> > java basic.java jdbc:postgresql:funnystuff doliov xxxxxx

Idealy this should be:
 java example.basic jdbc:postgresql:funnystuff doliov xxxxxx

note: no .java, and all the examples are in a package example.

Apart from that, it looks ok.

> >
> > also trying
> > java basic.java jdbc:postgresl:funnystuff?auth=password doliov xxxxxx

This is the old style URL - auth is no longer required in 6.3

> > results in the same error message (connection refused). and the postmaster
> > log confirms the authentication failure with:
> > User authentication failed

What have you got set in $PGDATA/pg_hba.conf for the client?

> > (btw, i am running the java program from the jdbc/example directory, with
> > calss path set approately.  java has no problem loading the driver).

Again, they should be run in the jdbc not jdbc/example directories.

--
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] pgaccess: I can't save a view
Next
From: Peter T Mount
Date:
Subject: Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc - grief