| Lists: | pgsql-jdbc |
|---|
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Sriram Dandapani <sdandapani(at)counterpane(dot)com> |
| Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: password authentication error |
| Date: | 2006-05-16 21:53:51 |
| Message-ID: | ABDFF1A4-7BB7-4262-9D8F-4BFFD2EFA630@fastcrypt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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.
>
>
>
>
>
>