Re: [INTERFACES] Re: [QUESTIONS] postgresql-6.3 and jdbc -i not the problem

On Fri, 13 Mar 1998, The Hermit Hacker wrote:

>
> Redirected to 'the proper list' - pgsql-interfaces(at)postgresql(dot)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(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk