Re: password authentication error

Sriram,

You say you have to restart JBoss, and reload pg_hba.conf.

What happens if you only restart JBoss ?

Dave
On 16-May-06, at 4:44 PM, Sriram Dandapani wrote:

> 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.cr
> eateManagedConnection(LocalManagedConnectionFactory.java:150) at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cre
> ateConnectionEventListener(InternalManagedConnectionPool.java:455)
> at
> org.jboss.resource.connectionmanager.InternalManagedConnectionPool.get
> Connection(InternalManagedConnectionPool.java:214) at
> org.jboss.resource.connectionmanager.JBossManagedConnectionPool
> $BasePool.getConnection(JBossManagedConnectionPool.java:496) at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.getManaged
> Connection(BaseConnectionManager2.java:425) at
> org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCon
> nection(TxConnectionManager.java:318) at
> org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateCo
> nnection(BaseConnectionManager2.java:477) at
> org.jboss.resource.connectionmanager.BaseConnectionManager2
> $ConnectionManagerProxy.allocateConnection
> (BaseConnectionManager2.java:814) at
> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection
> (WrapperDataSource.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.
>
>
>
>
>
>