Обсуждение: PSQLException: FATAL: password authentication failed for user "XXX"

Hi,

I have experienced authentication problems after applying a security
patch(147440-09) to Solaris 10.

PostgreSQL 9.2.1
JDBC: 9.2 1002

I got the following exception during startup of my application:
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication
failed for user "XXX"
    at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398)
    at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173)
    at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
    at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
    at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
    at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
    at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
    at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:393)
    at org.postgresql.Driver.connect(Driver.java:267)
    at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
    at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:183)
    at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:172)
    at

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.ensureFirstConnectionAcquisition(C3P0PooledConnectionPoolManager.java:959)
    at

com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:846)
    at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:319)
    at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:311)
    at
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:134)
    at
org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:132)
    ... 18 more



However I can login via psql


My pg_hba.conf file

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local  all              all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
host    replication     XXX       127.0.0.1/32            md5
host    replication     XXX          ::1/128                 md5


Does anyone know how to fix it ?

PS.
I must say that uninstalling the security patch is not an option for me :)

Regards,
Paweł




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PSQLException-FATAL-password-authentication-failed-for-user-XXX-tp5753396.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

On 26.04.2013 16:09, pawel_kukawski wrote:
> Hi,
>
> I have experienced authentication problems after applying a security
> patch(147440-09) to Solaris 10.
>
> PostgreSQL 9.2.1
> JDBC: 9.2 1002

Dunno what that Solaris patch has in it, but if you care about security,
you'll also want to upgrade your PostgreSQL server to 9.2.4...

- Heikki

pawel_kukawski <kukismen@gmail.com> writes:
> I have experienced authentication problems after applying a security
> patch(147440-09) to Solaris 10.

> PostgreSQL 9.2.1
> JDBC: 9.2 1002

> I got the following exception during startup of my application:
> Caused by: org.postgresql.util.PSQLException: FATAL: password authentication
> failed for user "XXX"

You might try looking into the postmaster log to see what the server
logged about it --- the log entries are frequently more verbose than
what the client got told.  Also, if the problem isn't immediately
obvious from the log entry, try turning on log_connections to verify
that the JDBC app is connecting with the database+username and from
the IP address that you're expecting.

            regards, tom lane

SOLVED.

This problem seems to be connected with my JPA provider (EclipseLink) rather
than JDBC driver.

Upgrade to JDK 1.7u21 fixes the problem.

Thanks,
Paweł



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PSQLException-FATAL-password-authentication-failed-for-user-XXX-tp5753396p5753614.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.