Skip site navigation (1) Skip section navigation (2)

password authentication error

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: password authentication error
Date: 2006-05-16 20:44:06
Message-ID: 6992E470F12A444BB787B5C937B9D4DF045AEFCA@ca-mail1.cis.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi

 

I keep getting this error

 

Could not create connection; - nested throwable: (Something unusual has
occured to cause the driver to fail. Please report this exception:
Exception: java.sql.SQLException: FATAL: password authentication failed
for user "dataman" Stack Trace: java.sql.SQLException: FATAL: password
authentication failed for user "dataman" at
org.postgresql.Connection.openConnection(Connection.java:178) at
org.postgresql.Driver.connect(Driver.java:149) at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.crea
teManagedConnection(LocalManagedConnectionFactory.java:150) at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.creat
eConnectionEventListener(InternalManagedConnectionPool.java:455) at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getCo
nnection(InternalManagedConnectionPool.java:214) at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool
.getConnection(JBossManagedConnectionPool.java:496) at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedCo
nnection(BaseConnectionManager2.java:425) at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConne
ction(TxConnectionManager.java:318) at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn
ection(BaseConnectionManager2.java:477) at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa
nagerProxy.allocateConnection(BaseConnectionManager2.java:814) at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD
ataSource.java:102) at

 

<local-tx-datasource>

    <jndi-name>fwdb01DS</jndi-name>

 
<connection-url>jdbc:postgresql://fwdb10.sv.counterpane.com:5432/fwdb01<
/connection-url>

    <driver-class>org.postgresql.Driver</driver-class>

    <user-name>dataman</user-name>

    <password>0rak1ller</password>

 
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation
>

    <max-pool-size>25</max-pool-size>

    <min-pool-size>5</min-pool-size>

  </local-tx-datasource>

 

This happens sporadically.. I have to reload pg_hba.conf and restart
jboss for the error to go away..and after a few minutes, it reappears. 

 

The postgres driver is postgresql-8.1-404.jar and my pg_hba allows
trusted access to the box issuing this jdbc connections.

 

 

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2006-05-16 21:47:06
Subject: Re: COPY rehashed
Previous:From: Chuck DavisDate: 2006-05-16 19:06:00
Subject: Re: JDBC driver and java strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group