Re: Password authentication working with psql, but fails with jdbc for me

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Paul Thomas
> Sent: Thursday, 18 September 2003 1:46 PM
> To: pgsql-jdbc @ postgresql . org
> Subject: Re: [JDBC] Password authentication working with psql, but fails
> with jdbc for me
>
>
>
> On 18/09/2003 17:15 Gerald Dalley wrote:
> > I have setup a system with postgres 7.3.4-5 on Debian and am attempting
> > to
> > access a database from Java. When I use trust permissions, e.g. I have
> > the
> > following in my pg_hba.conf file:
> > host all <theuser> <ip-range> <ip-mask> trust
> > everything works fine (with values in angled brackets replaced as
> > appropriate of course). I can access the database both through psql and
> > with Java. If I modify pg_hba.conf to use any kind of password
> > authentication (other than Kerberos, which isn't supported in the JDBC
> > drivers), e.g. by using any one of the following lines
> > host all <theuser> <ip-range> <ip-mask> password
> > host all <theuser> <ip-range> <ip-mask> crypt
> > host all <theuser> <ip-range> <ip-mask> md5
> > then psql asks for a password and works properly, but I get the
> following
> > error for the JDBC drivers:
> > Password authentication failed for user "<theuser>"
> > at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection
> > AbstractJdbc1Connection.java:202)
> > at org.postgresql.Driver.connect(Driver.java:122)
> >
> > I get the same results from multiple machine with different JVMs and by
> > trying out pg73jdbc1.jar, pg73jdbc2.jar, and pg73jdbc3.jar (by adding
> > them,
> > one at a time, to the classpath). In my postgresql.conf file, I do have
> > "tcpip_socket=true".
> >
> > Most of the FAQs and discussions I've found on the topic point to
> > classpath
> > issues. As far as I can tell though, I'm using the classpath correctly
> > since everything works fine in trust mode.
> >
> > Any ideas what I could be doing incorrectly?
>
> First, don't thrown by "AbstractJdbc1Connection". The JDBC2 and JDBC3
> classes mostly extend the JDBC1 classes.

Yep, I noticed that after decompiling the classes. I included the error
message mostly for the "password authentication..." part

> How did you create the db user?

createuser -A -D -E -P <theuser>
...type in password as prompted...

> Maybe you got the password wrong or possibly no password at all.

I don't think so, since I have to type in the password when I use psql.
Just for fun, I tried using a blank password, which fails even in psql.

> Are your
> psql connections from the same machine because if they IRC, psql will
> connect using unix sockets instead of tcp/ip so the host lines
> will not be used.

I'm running psql and the jdbc program from the same machine, which is
different from the server. When psql is remote, I'm assuming that it uses
tcp/ip sockets instead of unix sockets.

> I'm sure it must just some simple configuration error as I've been
> successfully connecting with userid/password since version 7.1.

Agreed. I'm just having trouble thinking of what else to try.

--Gerald Dalley
dalleyg(at)mit(dot)edu