5 Replies Latest reply on Jun 21, 2006 6:02 PM by silicio

    Configuring JBoss Portal Bundled with PostgreSQL database pr

    silicio

      I'm trying to setup postreSQL db for JBoss Portal 2.2.1 SP1 with AS.
      I've created database portal and user portaluser with portalpassword as written in the User Guide. I've downloaded JDBC connector and put in lib directory. Then I copied portal-postgresql-ds.xml from /setup folder to /deploy folder. But I get a lot of ERRORS and WARING. This is the log of first JBoss boot up. Need help...

      2006-06-09 18:51:38,187 ERROR [org.apache.myfaces.util.LocaleUtils] Locale name null or empty, ignoring


      2006-06-09 18:51:55,562 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      2006-06-09 18:51:55,562 ERROR [org.hibernate.util.JDBCExceptionReporter] Tabella non trovata in statement [select top ? securitypo0_.PK as PK70_, securitypo0_.REF as REF70_, securitypo0_.PARENTREF as PARENTREF70_ from JBP_SECURITY_POLICY securitypo0_]


      2006-06-09 18:51:55,578 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      2006-06-09 18:51:55,578 ERROR [org.hibernate.util.JDBCExceptionReporter] Tabella non trovata in statement [select top ? hbmsecurit0_.PK as PK71_, hbmsecurit0_.ROLE as ROLE71_, hbmsecurit0_.ACTIONS as ACTIONS71_ from JBP_SECURITY_CONSTRAINT hbmsecurit0_]


      And others tables...
      Then I get this:


      2006-06-09 18:51:55,562 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select hbmsecurit0_.PK as PK71_, hbmsecurit0_.ROLE as ROLE71_, hbmsecurit0_.ACTIONS as ACTIONS71_ from JBP_SECURITY_CONSTRAINT hbmsecurit0_]
      java.sql.SQLException: Tabella non trovata in statement [select top ? hbmsecurit0_.PK as PK71_, hbmsecurit0_.ROLE as ROLE71_, hbmsecurit0_.ACTIONS as ACTIONS71_ from JBP_SECURITY_CONSTRAINT hbmsecurit0_]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:312)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:172)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
       at org.hibernate.loader.Loader.doQuery(Loader.java:661)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
       at org.hibernate.loader.Loader.doList(Loader.java:2147)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
       at org.hibernate.loader.Loader.list(Loader.java:2021)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
       at org.jboss.portal.core.hibernate.SessionFactoryBinder.doCheck(SessionFactoryBinder.java:352)
       at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:296)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
       at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:86)
       at org.jboss.portal.core.security.store.HibernateCacheLoader.startService(HibernateCacheLoader.java:88)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
       at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:86)
       at org.jboss.cache.TreeCache.createCacheLoader(TreeCache.java:1320)
       at org.jboss.cache.TreeCache.startService(TreeCache.java:1088)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
       at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:428)
       at org.jboss.system.ServiceController.start(ServiceController.java:446)
       at org.jboss.system.ServiceController.start(ServiceController.java:446)
       at org.jboss.system.ServiceController.start(ServiceController.java:446)
       at org.jboss.system.ServiceController.start(ServiceController.java:446)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
       at $Proxy94.start(Unknown Source)
       at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:185)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
       at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy9.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
       at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:428)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy5.deploy(Unknown Source)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
       at org.jboss.Main.boot(Main.java:187)
       at org.jboss.Main$1.run(Main.java:438)
       at java.lang.Thread.run(Thread.java:595)



      Another Error....

      2006-06-09 18:52:01,109 ERROR [org.jboss.deployment.MainDeployer] Could not create deployment: file:/C:/Programmi/jboss-portal-2.2.1-SP1-bundled/server/default/deploy/portal-postgresql-ds.xml
      org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jca:service=LocalTxCM,name=PortalDS
       at org.jboss.system.ServiceCreator.install(ServiceCreator.java:70)
       at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:431)
       at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:153)
       at org.jboss.system.ServiceController.install(ServiceController.java:215)
       at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy4.install(Unknown Source)
       at org.jboss.deployment.SARDeployer.create(SARDeployer.java:232)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
       at $Proxy94.create(Unknown Source)
       at org.jboss.deployment.XSLSubDeployer.create(XSLSubDeployer.java:180)
       at org.jboss.deployment.MainDeployer.create(MainDeployer.java:935)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:789)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
       at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy9.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
       at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:428)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
       at $Proxy5.deploy(Unknown Source)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
       at org.jboss.Main.boot(Main.java:187)
       at org.jboss.Main$1.run(Main.java:438)
       at java.lang.Thread.run(Thread.java:595)
      


      2006-06-09 18:52:01,281 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
      
      --- Incompletely deployed packages ---
      org.jboss.deployment.DeploymentInfo@f0e7ca86 { url=file:/C:/Programmi/jboss-portal-2.2.1-SP1-bundled/server/default/deploy/portal-postgresql-ds.xml }
       deployer: org.jboss.deployment.XSLSubDeployer@b4b0a4
       status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:service=LocalTxCM,name=PortalDS
       state: FAILED
       watch: file:/C:/Programmi/jboss-portal-2.2.1-SP1-bundled/server/default/deploy/portal-postgresql-ds.xml
       altDD: null
       lastDeployed: 1149871921093
       lastModified: 1149871921093
       mbeans:
      


        • 1. Re: Configuring JBoss Portal Bundled with PostgreSQL databas
          silicio

          I get similar erros with MySQL 5.0. Probably I miss something in the correct installing procedure. This is what I did (same thing for postresql):

          - Create new db jbossportal.
          - create new user portal with portalpassword as password
          - mysql> GRANT ALL PRIVILEGES ON *.* TO 'portal@localhost'
          -> IDENTIFIED BY 'portalpassword' WITH GRANT OPTION;
          - download mysql jdbc connector
          - copy jdbc connector into \%JBOSS_HOME%\server\deafault\lib
          - for the last i must copy/move data source file portal-mysql-ds.xml from \%JBOSS_HOME%\docs\portal\setup\ to \%JBOSS_HOME%\server\deafault\deploy
          - i must do the same for file jboss-portal.sar, but the file (it's a directory) is already into deploy directory...

          At jboss sturtup i get a lot of errors and warning, same as posted above with postgresql.

          Please tell me if i've made errors in the configuration sequence...

          this is the last error shown in the console after completed boot up sequence:

          01:10:53,343 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
          
          --- Incompletely deployed packages ---
          org.jboss.deployment.DeploymentInfo@799e5cc4 { url=file:/C:/Programmi/jboss-port
          al-2.2.1-SP1-bundled/server/default/deploy/portal-mysql-ds.xml }
           deployer: org.jboss.deployment.XSLSubDeployer@b90a6e
           status: Deployment FAILED reason: Trying to install an already registered mbea
          n: jboss.jca:service=LocalTxCM,name=PortalDS
           state: FAILED
           watch: file:/C:/Programmi/jboss-portal-2.2.1-SP1-bundled/server/default/deploy
          /portal-mysql-ds.xml
           altDD: null
           lastDeployed: 1150067453171
           lastModified: 1150067453156
           mbeans:

          I'm on windows xp OS using JBoss Portal 2.2.1 SP1 bundled with AS

          • 2. Update. Still stuck.
            silicio

            Hi all.

            I downloaded AS and Portal separately.

            so I'm tryong to use:
            - JBoss AS 4.0.4.GA
            - JBoss Portal 2.2.1SP1
            - PostgreSQL JDBC connector (postgresql-8.2dev-503.jdbc3.jar)
            - portal-postgresql-ds.xml


            Precondition:
            I've already created jbossportal database, user (in postgresql user is called login role !?) portal and password portalpassword

            Steps:
            - First I unzipped AS zip file.
            - Then unzipped Portal 2.2.1 to C:\Programmi\jboss-4.0.4.GA\server\default\deploy
            - Modified file portal-postgresql-ds.xml as shown:

            <?xml version="1.0" encoding="UTF-8"?>
            <datasources>
             <local-tx-datasource>
             <jndi-name>PortalDS</jndi-name>
             <connection-url>jdbc:postgresql://localhost:5432/jbossportal</connection-url>
             <driver-class>org.postgresql.Driver</driver-class>
             <user-name>portal</user-name>
             <password>portalpassword</password>
             </local-tx-datasource>
            </datasources>
            


            - copied file /setup/portal-postgresql-ds.xml into ../deploy directory

            - For the First boot i get some hibernate dialect problem. So I tried to force dialect as shown in the user guide
            - In the dir server\default\deploy\jboss-portal.sar\conf\hibernate\[modules]\ I've only uncommented and modify this line as shown for all 4 modules:
            ...
            <property name="dialect">org.hibernate.dialect.ProgressDialect</property>
            ...
            

            - then i went to \server\default\deploy\jboss-portal.sar\portal-cms.sar\META-INF\ dir searching for jboss-service.xml
            - I've uncommented and modify this line for all 5 blocks as shown:
            ...
            <param name="dialect" value="org.hibernate.dialect.ProgressDialect"/>
            ...
            


            Though modifies I get a lof of errors... It says it can't get connection to database.
            here my log file (I zipped it avoiding topic confusion):
            http://www.overmodding.org/files/2006-06-21.log.zip (150 kb)

            Any suggestion will be appreciate.

            • 3. Re: Configuring JBoss Portal Bundled with PostgreSQL databas
              silicio

              I've forgot to copy jdbc connector to lib directory. I reached to populate postgresql tables, but i get a 500 error when try to connect to portal.

              I reset all and try new installation with Jboss Portal 2.4 beta1.
              I did all previous steps (included jdbc connector), but have alwasy 500 error
              first get errors saying that hibernate needs a specific dialect to be set.
              This is what i did, but I can't find lines specified in the user guide:

              Modify jboss-portal.sar/portal-cms.sar/META-INF/jboss-service.xml. You will be searching this file for the commented "org.hibernate.dialect." blocks. Once found, replace with
              whichever dialect you are trying to force from the Hibernate list. There are 5 such commented blocks in this file.
              Make sure you uncomment them all!

              In that jboss-service.xml there isn't none of these blocks.
              I'm stuck.

              • 4. Re: Configuring JBoss Portal Bundled with PostgreSQL databas
                silicio

                Maybe I resolved.
                I read many errors like this

                2006-06-21 23:17:08,484 ERROR [org.hibernate.util.JDBCExceptionReporter] Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: database "portal" does not exist); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: database "portal" does not exist))
                2006-06-21 23:17:08,484 DEBUG [org.jboss.portal.core.hibernate.SessionFactoryBinder] Starting failed portal:service=Hibernate
                


                So I create a new database named it portal although jbossportal as written in the user guide.
                Then I modified portal-*-ds.xml file.
                And Jboss Portal is running.

                Is this a 2.4 beta1 bug?

                Still have some error in the log:

                ...
                2006-06-21 23:35:12,406 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_users" does not exist
                ...
                2006-06-21 23:35:12,421 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_roles" does not exist
                ...
                2006-06-21 23:35:13,671 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_instance_security" does not exist
                ...
                2006-06-21 23:35:13,687 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_instance_per_user" does not exist
                ...
                2006-06-21 23:35:13,687 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_instance" does not exist
                ...
                2006-06-21 23:35:14,656 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_portal_object" does not exist
                ...
                2006-06-21 23:35:14,671 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_context" does not exist
                ...
                2006-06-21 23:35:14,671 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_portal" does not exist
                ...
                2006-06-21 23:35:14,703 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_object_node_security" does not exist
                ...
                2006-06-21 23:35:28,125 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: relation "jbp_portlet_state_entry" does not exist
                ...
                


                and others.

                • 5. Re: Configuring JBoss Portal Bundled with PostgreSQL databas
                  silicio

                  Rebooting I get no errors, only locale erros (ignored)