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

Thanks for the suggestions so far that people have made.

Here's the current status...
1) psql works (and always was working) from both Windows and Linux remote
machines
2) Using the Perl PgPP module works from both Windows and Linux remote
machines
3) Using devpgjdbc1.jar works on Linux from a remote machine (on Linux, I'm
stuck with JDK 1.1.8)
4) Using any of the current .jar files at jdbc.postgresql.org fails for
Windows

Is JNI or something similar being used that might cause the JDBC drivers to
fail on Windows?

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

> -----Original Message-----
> From: Nick Fankhauser [mailto:nickf(at)ontko(dot)com]
> Sent: Thursday, 18 September 2003 2:36 PM
> To: Gerald Dalley; pgsql-jdbc(at)postgresql(dot)org
> Subject: RE: [JDBC] Password authentication working with psql, but fails
> with jdbc for me
>
>
> Gerald-
>
> Try connecting using psql with the -h option to specify the host (even if
> you're on the same machine) this is a better test, since it will
> force psql
> to connect using an IP socket in exactly the same fashion that jdbc does.
> This will allow you to more definitely sort your problem into
> either "pg_hba
> problem" or "java problem" groups.
>
> -NF
>
> > -----Original Message-----
> > From: pgsql-jdbc-owner(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Gerald Dalley
> > Sent: Thursday, September 18, 2003 11:16 AM
> > To: pgsql-jdbc(at)postgresql(dot)org
> > Subject: [JDBC] Password authentication working with psql, but fails
> > with jdbc for me
> >
> >
> > 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?
> >
> > Thanks in advance.
> >
> > --Gerald Dalley
> > dalleyg(at)mit(dot)edu
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
>
>
>