jboss and postgresql error (problem with pg_hba.conf)
brais Feb 28, 2005 5:28 PMSoftware installed: jboss-3.2.1, postgresql-7.4.2-1, Linux Fedora Core 2.
Database name= j2ee.
Database username= j2ee.
postgresql.conf contains 'tcpip_socket = true'
*****************************************************
If pg_hba.conf contains
'local all all trust'
the error in JBoss is:
14:43:52,123 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while fixing table
name; - nested throwable: (org.jboss.util.NestedSQLException: Could
not create connection; - nested throwable:
(org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException:
FATAL: no hay una liÂÂÂnea
en
pg_hba.conf para "127.0.0.1", usuario "j2ee", base de datos "j2ee",
SSL inactivo
); - nested throwable: (org.jboss.resource.JBossResourceException:
Could not create connection; - nested throwable:
(org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException:
FATAL: no hay una liÂÂÂnea
en
pg_hba.conf para "127.0.0.1", usuario "j2ee", base de datos "j2ee",
SSL inactivo
)))
at
org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:119)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:438)
*****************************************************
If pg_hba.conf contains
'local j2ee j2ee'
the error in JBoss is:
org.jboss.deployment.DeploymentException: Error while fixing table
name; - nested throwable: (org.jboss.util.NestedSQLException: Could
not create connection; - nested throwable:
(org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException: FATAL: No se encuentra pg_hba.conf
o el archivo es incorrecto
); - nested throwable: (org.jboss.resource.JBossResourceException:
Could not create connection; - nested throwable:
(org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException: FATAL: No se encuentra pg_hba.conf
o el archivo es incorrecto
)))
at
org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:68)
at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:119)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:438)
Thanks,
Brais