Error connecting when user has no password

From: Ed Tyrrill <ed(dot)tyrrill(at)avamar(dot)com>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Error connecting when user has no password
Date: 2004-10-17 02:18:18
Message-ID: 3250F281630BD6418DCF23E78151979B0ADB83@hermes.avamar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am in the process of moving our application from postgresql 7.2.1-5 to
7.3.6-7. I also changed the jdbc driver we use from pg72jdbc2.jar to
pg73jdbc2.jar. I can no longer get a connection for users that have
no password from java. I couldn't figure out why I couldn't get a
connection with our usual user that has no database password, and then
on a hunch tried using a different user that has a password, and
everything worked fine. The no password user can connect using psql
with no problems.

The postgres upgrade is just one part of our platform update from
red hat 7.3 to enterprise linux 3, and java 1.4.2 to 5.0. So it could
possibly be something with the new java version as well, but the
exception I get is in the postgres jdbc driver code:

A connection error has occurred: FATAL: Password authentication failed for
user "admin"

at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con
nection.java:202)
at org.postgresql.Driver.connect(Driver.java:122)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
com.avamar.mc.datatap.ConnectionPool.createConnections(ConnectionPool.java:1
84)

ConnectionPool.java line 184 is basically this:

Connection con = DriverManager.getConnection( connectURL, "admin", "" );

This all worked fine with 7.2.1.5, and before that with some version of
7.1. Thanks in advance for any assistance.

Ed

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-10-17 05:05:20 Re: Error connecting when user has no password
Previous Message Dave Cramer 2004-10-16 15:21:43 Re: problem with dates when using a java calendar object with