0 Replies Latest reply on Feb 28, 2005 5:28 PM by brais

    jboss and postgresql error (problem with pg_hba.conf)

    brais

      Software 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