Re: Error connecting when user has no password - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Error connecting when user has no password
Date
Msg-id Pine.BSO.4.56.0410170003380.14902@leary.csoft.net
Whole thread Raw
In response to Error connecting when user has no password  (Ed Tyrrill <ed.tyrrill@avamar.com>)
List pgsql-jdbc

On Sat, 16 Oct 2004, Ed Tyrrill wrote:

> 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.
>

This looks like a difference in your setup of pg_hba.conf.  Using psql is
not a valid test unless you use the "-h localhost" option to force it to
connect over tcpip sockets instead of unix sockets because these have
different lines in pg_hba.conf.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Ed Tyrrill
Date:
Subject: Error connecting when user has no password
Next
From: Kris Jurka
Date:
Subject: Re: A solution to the SSL customizing problem