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

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
>
> also trying
> java basic.java jdbc:postgresl:funnystuff?auth=password doliov xxxxxx
>
> results in the same error message (connection refused). and the postmaster
> log confirms the authentication failure with:
> User authentication failed
>
> (btw, i am running the java program from the jdbc/example directory, with
> calss path set approately.  java has no problem loading the driver).
>
> tia,
> steve
>
> btw: for anyone who is willing to try this, i've set up a guest user with
> password guest who as read and write access to this database (funnystuff -
> two tables, two or thre rows each).
>
> my ip address (fixed is 198.11.51.133).
>
> lemme know if this helps.
>
> thanks,
> steve
>
> --
> Official WWW Site: http://www.postgresql.org
> Online Docs & FAQ: http://www.postgresql.org/docs
> Searchable Lists: http://www.postgresql.org/mhonarc
>

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