1 2 Previous Next 15 Replies Latest reply on Nov 26, 2008 3:38 PM by theute

    No such user admin

      Just installed JBoss Portal on a box. It uses Oracle10g on another box. server.log shows issues related to 'No such user admin'. Has anyone encountered this before? If yes, may I know how to overcome this issue?

      Thanks

        • 1. Re: No such user admin
          peterj

          I assume that you configured a *-ds.xml file to connect to Oracle. What username and password did you provide in that file? Is it a valid Oracle username and password?

          • 2. Re: No such user admin

            ======================
            Environment is -
            ======================

            - jboss-portal-2.7.0.GA running on a Windows Vista box
            - Oracle10g running on another box (Windows XP)
            - jvm is jdk1.6.0_07
            - ojdbc6.jar is in server/default/lib
            - portal-oracle-ds.xml is only *-ds.xml file in server/default/deploy dir
            - Necessary restart done to ensure all database objects are created in database
            - Few missing sequences created in database after spotting some ORA- issues during initial start attempts
            - This 'No such user admin' is tha last missing puzzle

            ======================
            From server.log -
            ======================
            2008-11-25 14:38:31,111 DEBUG [org.jboss.mx.loading.ClassLoaderUtils] Multiple class loaders found for pkg:

            2008-11-25 14:38:31,111 DEBUG [org.jboss.deployment.MainDeployer] found 0 subpackages of file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] Watching new file: file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] create step for deployment file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] Done with create step of deploying WEB-INF

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] Begin deployment start file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: WEB-INF

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: jmx-console.war

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/

            2008-11-25 14:38:31,126 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/ -> file:/C:/jboss-portal-2.7.0.GA/server/default/deploy/jmx-console.war/WEB-INF/web.xml

            2008-11-25 14:38:31,126 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

            --- MBeans waiting for other MBeans ---
            ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
            State: CONFIGURED
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=DefaultDS

            ObjectName: portal:service=CMS
            State: FAILED
            Reason: java.lang.RuntimeException: org.jboss.portal.identity.NoSuchUserException: No such user No such user admin
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=PortalDS
            portal:service=JAASLoginModule
            portal:service=Hibernate,type=CMS
            cms.pm.cache:service=TreeCache
            portal:service=AuthorizationManager,type=cms
            portal:service=InterceptorStackFactory,type=Cms
            Depends On Me:
            portal:commandFactory=CMSObject

            ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=Invoker
            jboss.web:service=WebServer

            ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
            State: CONFIGURED
            I Depend On:
            jboss:service=TransactionManager
            jboss.jca:service=DataSourceBinding,name=DefaultDS

            ObjectName: jboss.mq:service=StateManager
            State: CONFIGURED
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=DefaultDS
            Depends On Me:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq:service=DestinationManager
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=MessageCache
            jboss.mq:service=PersistenceManager
            jboss.mq:service=StateManager
            jboss.mq:service=ThreadPool
            jboss:service=Naming
            Depends On Me:
            jboss.mq.destination:service=Topic,name=testTopic
            jboss.mq.destination:service=Topic,name=securedTopic
            jboss.mq.destination:service=Topic,name=testDurableTopic
            jboss.mq.destination:service=Queue,name=testQueue
            jboss.mq.destination:service=Queue,name=A
            jboss.mq.destination:service=Queue,name=B
            jboss.mq.destination:service=Queue,name=C
            jboss.mq.destination:service=Queue,name=D
            jboss.mq.destination:service=Queue,name=ex
            jboss.mq:service=SecurityManager
            jboss.mq.destination:service=Queue,name=DLQ

            ObjectName: jboss.mq:service=PersistenceManager
            State: CONFIGURED
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=DefaultDS
            Depends On Me:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq.destination:service=Topic,name=testTopic
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            ObjectName: jboss.mq.destination:service=Queue,name=testQueue
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            ObjectName: jboss.mq.destination:service=Queue,name=A
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq.destination:service=Queue,name=B
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq.destination:service=Queue,name=C
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq.destination:service=Queue,name=D
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq.destination:service=Queue,name=ex
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager

            ObjectName: jboss.mq:service=Invoker
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=TracingInterceptor
            jboss:service=Naming
            Depends On Me:
            jboss.mq:service=InvocationLayer,type=HTTP
            jboss.mq:service=InvocationLayer,type=JVM
            jboss.mq:service=InvocationLayer,type=UIL2

            ObjectName: jboss.mq:service=TracingInterceptor
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=SecurityManager
            Depends On Me:
            jboss.mq:service=Invoker

            ObjectName: jboss.mq:service=SecurityManager
            State: CONFIGURED
            I Depend On:
            jboss.security:service=JaasSecurityManager
            jboss.mq:service=DestinationManager
            Depends On Me:
            jboss.mq.destination:service=Topic,name=testTopic
            jboss.mq.destination:service=Topic,name=securedTopic
            jboss.mq.destination:service=Topic,name=testDurableTopic
            jboss.mq.destination:service=Queue,name=testQueue
            jboss.mq:service=TracingInterceptor
            jboss.mq.destination:service=Queue,name=DLQ

            ObjectName: jboss.mq.destination:service=Queue,name=DLQ
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            ObjectName: jboss.mq:service=InvocationLayer,type=JVM
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=Invoker

            ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
            State: CONFIGURED
            I Depend On:
            jboss.mq:service=Invoker

            --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
            ObjectName: portal:service=CMS
            State: FAILED
            Reason: java.lang.RuntimeException: org.jboss.portal.identity.NoSuchUserException: No such user No such user admin
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=PortalDS
            portal:service=JAASLoginModule
            portal:service=Hibernate,type=CMS
            cms.pm.cache:service=TreeCache
            portal:service=AuthorizationManager,type=cms
            portal:service=InterceptorStackFactory,type=Cms
            Depends On Me:
            portal:commandFactory=CMSObject

            ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
            State: NOTYETINSTALLED
            Depends On Me:
            jboss.ejb:service=EJBTimerService,persistencePolicy=database
            jboss:service=KeyGeneratorFactory,type=HiLo
            jboss.mq:service=StateManager
            jboss.mq:service=PersistenceManager



            2008-11-25 14:38:31,408 DEBUG [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Notified that enabled: true

            2008-11-25 14:38:31,408 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL

            2008-11-25 14:38:31,408 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.deployment:type=DeploymentScanner,flavor=URL dependent components: []

            2008-11-25 14:38:31,564 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: jboss-service.xml

            2008-11-25 14:38:31,564 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/jboss-portal-2.7.0.GA/server/default/conf/jboss-service.xml

            2008-11-25 14:38:31,580 DEBUG [org.jboss.web.tomcat.service.JBossWeb] Saw org.jboss.system.server.started notification, starting connectors

            2008-11-25 14:38:31,626 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] Periodic recovery - first pass <Tue, 25 Nov 2008 14:38:31>

            2008-11-25 14:38:31,626 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] StatusModule: first pass

            2008-11-25 14:38:31,626 DEBUG [com.arjuna.ats.txoj.logging.txojLoggerI18N] [com.arjuna.ats.internal.txoj.recovery.TORecoveryModule_3] - TORecoveryModule - first pass

            2008-11-25 14:38:31,626 DEBUG [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.recovery.info.firstpass] Local XARecoveryModule - first pass

            2008-11-25 14:38:31,642 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-ws-nvijayapuram%2F10.10.24.128-8080

            2008-11-25 14:38:31,689 INFO [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-ws-nvijayapuram%2F10.10.24.128-8009

            2008-11-25 14:38:31,736 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)] Started in 1m:29s:846ms








            • 3. Re: No such user admin
              peterj

               

              --- MBeans waiting for other MBeans ---
              ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
              State: CONFIGURED
              I Depend On:
              jboss.jca:service=DataSourceBinding,name=DefaultDS


              Looks like you also removed the hsqldb-ds.xml file. That file declares the DefaultDS data source. Unless you plan on converting DefaultDS to use Oracle (or some other database), you should put the hsqldb-ds.xml file back into the server/xxx/deploy directory.

              And I repeat:
              PeterJ wrote:
              What username and password did you provide in [the oracle-ds.xml] file? Is it a valid Oracle username and password?


              • 4. Re: No such user admin

                 

                "PeterJ" wrote:
                I assume that you configured a *-ds.xml file to connect to Oracle. What username and password did you provide in that file? Is it a valid Oracle username and password?


                ===============

                Yes, valid username/password created using sqlplus with all necessary permissions -

                1. CREATE SESSION
                2. CREATE TABLE
                3. CREATE SEQUENCE

                ===============

                Here's the *-ds.xml file -

                $ cat portal-oracle-ds.xml
                <?xml version="1.0" encoding="UTF-8"?>



                <local-tx-datasource>
                <jndi-name>PortalDS</jndi-name>
                <connection-url>jdbc:oracle:thin:@lp-nvijayapuram:1521:sainaga</connecti
                on-url>
                <driver-class>oracle.jdbc.OracleDriver</driver-class>
                <user-name>jbossportal</user-name>
                jbossportal
                </local-tx-datasource>



                ================================================

                Question: This particular line in setup/portal-oracle-ds.xml surprised me, as I not used to seeing un/pw between 'thin:' and '@host', so took off the 'un/pw' in my *-ds.xml file as listed above.

                $ grep thin portal-oracle-ds.xml
                <connection-url>jdbc:oracle:thin:SYSTEM/password@localhost:1521:orcl</connec
                tion-url>

                ================


                • 5. Re: No such user admin

                   

                  "PeterJ" wrote:
                  --- MBeans waiting for other MBeans ---
                  ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
                  State: CONFIGURED
                  I Depend On:
                  jboss.jca:service=DataSourceBinding,name=DefaultDS


                  Looks like you also removed the hsqldb-ds.xml file. That file declares the DefaultDS data source. Unless you plan on converting DefaultDS to use Oracle (or some other database), you should put the hsqldb-ds.xml file back into the server/xxx/deploy directory.

                  And I repeat:
                  PeterJ wrote:
                  What username and password did you provide in [the oracle-ds.xml] file? Is it a valid Oracle username and password?


                  ===============

                  You are right. I did remove hsqldb-ds.xml. I will put it back and retry.

                  Thanks very much!

                  • 6. Re: No such user admin
                    peterj

                    Looking more closely at the error, it appears that the CMS code is having an issue with logging into the portal and loading the default CMS content. It would use a username of admin.

                    Go into Oracle and do: select * from jbp_users;

                    You should get two rows - one with jbp_uname of 'admin', the other with 'user'.

                    If you do not get any rows, then there is a problem with loading the tables. Look earlier in the console log for the first exception stack trace and post that.

                    Also, when posting XML or code text please use code tags (select the text and click the Code button that appears above the message body edit window). Also, click Preview and make sure the post is formatted correctly before clicking Post.

                    • 7. Re: No such user admin

                       

                      "PeterJ" wrote:
                      Looking more closely at the error, it appears that the CMS code is having an issue with logging into the portal and loading the default CMS content. It would use a username of admin.

                      Go into Oracle and do: select * from jbp_users;

                      You should get two rows - one with jbp_uname of 'admin', the other with 'user'.

                      If you do not get any rows, then there is a problem with loading the tables. Look earlier in the console log for the first exception stack trace and post that.

                      Also, when posting XML or code text please use code tags (select the text and click the Code button that appears above the message body edit window). Also, click Preview and make sure the post is formatted correctly before clicking Post.


                      ==========

                      Thanks for guiding me along. You are right, I did hit the CMS related issue after putting hsqldb-ds.xml back in place. I will start using the CODE blocks from now on. Tried the query, no rows returned -

                      SQL> select * from jbp_users;
                      
                      no rows selected
                      


                      I will provide first stack trace from server.log soon.

                      • 8. Re: No such user admin

                        Here's first stack trace from console -

                        16:15:08,111 INFO [JBossCachePersistenceManager] ------------------------------
                        -------------------
                        16:15:08,111 INFO [JBossCachePersistenceManager] JBossCachePersistenceManager i
                        s fully loaded.....
                        16:15:08,111 INFO [JBossCachePersistenceManager] ------------------------------
                        -------------------
                        16:15:08,283 INFO [RepositoryImpl] initializing workspace 'default'...
                        16:15:08,376 INFO [RepositoryImpl] workspace 'default' initialized
                        16:15:08,783 INFO [LocalFileSystem] LocalFileSystem initialized at path C:\jbos
                        s-portal-2.7.0.GA\server\default\data\portal\cms\conf\workspaces\default\index
                        16:15:09,017 INFO [SearchIndex] Index initialized: C:\jboss-portal-2.7.0.GA\ser
                        ver\default\data\portal\cms\conf\workspaces\default/index Version: 2
                        16:15:09,017 INFO [RepositoryImpl] Repository started
                        16:15:09,017 INFO [JackrabbitJCRService] Repository 'PortalRepository' created
                        16:15:09,111 INFO [JackrabbitJCRService] The repository has already the CMS nod
                        e types registered
                        16:15:09,126 INFO [JCRCMS] Creating default CMS content.
                        16:15:09,142 WARN [ServiceController] Problem starting service portal:service=C
                        MS
                        java.lang.RuntimeException: org.jboss.portal.identity.NoSuchUserException: No su
                        ch user No such user admin
                         at org.jboss.portal.cms.security.AuthorizationProviderImpl.getRoot(Autho
                        rizationProviderImpl.java:247)
                         at org.jboss.portal.cms.impl.jcr.JCRCMS.createContent(JCRCMS.java:397)
                         at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:352)
                         at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:305)
                         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
                        upport.java:289)
                         at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
                        96)
                         at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJB
                        ossService.java:73)
                         at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.e
                        xecute(JBossServiceModelMBean.java:486)
                         at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.s
                        tartService(JBossServiceModelMBean.java:452)
                         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
                        upport.java:289)
                         at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
                        96)
                         at org.jboss.portal.jems.as.system.JBossServiceModelMBean$6.invoke(JBoss
                        ServiceModelMBean.java:374)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                        or.java:133)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                        BeanOperationInterceptor.java:142)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
                        ler.java:995)
                         at $Proxy0.start(Unknown Source)
                         at org.jboss.system.ServiceController.start(ServiceController.java:417)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at org.jboss.system.ServiceController.start(ServiceController.java:435)
                         at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                         at $Proxy4.start(Unknown Source)
                         at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
                        java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                        or.java:133)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                        BeanOperationInterceptor.java:142)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                         at $Proxy198.start(Unknown Source)
                         at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
                         at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                         at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                        or.java:133)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                        BeanOperationInterceptor.java:142)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                         at $Proxy9.deploy(Unknown Source)
                         at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen
                        tScanner.java:421)
                         at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS
                        canner.java:634)
                         at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.
                        doScan(AbstractDeploymentScanner.java:263)
                         at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A
                        bstractDeploymentScanner.java:336)
                         at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
                        upport.java:289)
                         at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB
                        eanSupport.java:245)
                         at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
                        ler.java:978)
                         at $Proxy0.start(Unknown Source)
                         at org.jboss.system.ServiceController.start(ServiceController.java:417)
                         at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                         at $Proxy4.start(Unknown Source)
                         at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
                         at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                         at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
                        java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
                        sorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
                        er.java:155)
                         at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                         at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
                        or.java:133)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
                        BeanOperationInterceptor.java:142)
                         at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                         at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
                        java:264)
                         at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                         at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                         at $Proxy5.deploy(Unknown Source)
                         at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                         at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                         at org.jboss.Main.boot(Main.java:200)
                         at org.jboss.Main$1.run(Main.java:508)
                         at java.lang.Thread.run(Thread.java:619)
                        Caused by: org.jboss.portal.identity.NoSuchUserException: No such user No such u
                        ser admin
                         at org.jboss.portal.identity.db.HibernateUserModuleImpl.findUserByUserNa
                        me(HibernateUserModuleImpl.java:97)
                         at org.jboss.portal.cms.security.AuthorizationProviderImpl.getRoot(Autho
                        rizationProviderImpl.java:241)
                         ... 127 more
                        16:15:10,189 INFO [IdentityUIConfigurationServiceImpl] not starting jBPM workfl
                        ow ...
                        16:15:10,204 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.mo
                        del.instance.persistent.PersistentInstanceDefinition.relatedSecurityBindings ->
                        JBP_INSTANCE_SECURITY
                        16:15:10,204 INFO [HbmBinder] Mapping collection: org.jboss.portal.core.impl.mo
                        del.instance.persistent.PersistentInstanceDefinition.relatedCustomizations -> JB
                        P_INSTANCE_PER_USER
                        16:15:10,220 INFO [NamingHelper] JNDI InitialContext properties:{}
                        16:15:10,220 INFO [DatasourceConnectionProvider] Using datasource: java:PortalD
                        S
                        16:15:10,220 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g
                         Enterprise Edition Release 10.1.0.5.0 - Production
                        With the Partitioning, OLAP and Data Mining options
                        16:15:10,236 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 1
                        1.1.0.6.0-Production
                        16:15:10,236 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
                        
                        16:15:10,236 WARN [Oracle9Dialect] The Oracle9Dialect dialect has been deprecat
                        ed; use either Oracle9iDialect or Oracle10gDialect instead
                        16:15:10,236 INFO [TransactionFactoryFactory] Transaction strategy: org.hiberna
                        te.transaction.JTATransactionFactory
                        16:15:10,251 INFO [NamingHelper] JNDI InitialContext properties:{}
                        16:15:10,251 INFO [TransactionManagerLookupFactory] instantiating TransactionMa
                        nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
                        16:15:10,251 INFO [TransactionManagerLookupFactory] instantiated TransactionMan
                        agerLookup
                        16:15:10,251 INFO [TransactionManagerLookupFactory] instantiating TransactionMa
                        nagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
                        16:15:10,267 INFO [TransactionManagerLookupFactory] instantiated TransactionMan
                        agerLookup
                        16:15:10,267 INFO [SettingsFactory] Automatic flush during beforeCompletion():
                        enabled
                        16:15:10,267 INFO [SettingsFactory] Automatic session close at end of transacti
                        on: disabled
                        16:15:10,267 INFO [SettingsFactory] JDBC batch size: 15
                        


                        • 9. Re: No such user admin

                          Two questions -

                          1. Something to do with WARN for Oracle9Dialect?

                          2. Incremental Oracle Schema update issue? Do I need to drop the orcale user cascade, and rerun, for systematic re-creation of the database objects, including seed data?

                          Thanks

                          • 10. Re: No such user admin

                            Third question -

                            3. In which xml/prop file can I change from Oracle9Dialect to Oracle10gDialect?

                            • 11. Re: No such user admin
                              peterj

                              You can set the dialect in the hibernate.cfg.xml files located at:

                              jboss-portal.sar/conf/hibernate/instance/
                              jboss-portal.sar/conf/hibernate/portal/
                              jboss-portal.sar/conf/hibernate/portlet/
                              jboss-portal.sar/conf/hibernate/user/
                              jboss-portal.sar/portal-cms.sar/conf/hibernate/cms/

                              Were the tables actually created? You should have about 83 tables.

                              Did you make any changes to jboss-portal.sar/conf/hibernate/user/setup.txt?

                              • 12. Re: No such user admin

                                Thanks for info on location of the .cfg.xml files. The issue was in portal-oracle-ds.xml. Having noticed there are two places to provide un/pw, I eliminated the un/pw in the connection-url line. And that somehow triggered the 'No such user admin' issue. Don't know how. Obviously this is some kind of a very minor bug that trips users who tend to think on "why two places to specify un/pw in portal-oracle-ds.xml?" and do cut short the connection-url line by eliminating the un/pw in it, as there is explicit mention of it in the user-name and password lines. Treating this as a closed issue from my end. Thanks for all the help and support by way of very valuable info/insight.

                                • 13. Re: No such user admin

                                  Here's the last bit of info ...

                                  SQL> select object_type, count(object_type)
                                   2 from user_objects
                                   3 group by object_type;
                                  
                                  OBJECT_TYPE COUNT(OBJECT_TYPE)
                                  ------------------- ------------------
                                  INDEX 134
                                  LOB 5
                                  SEQUENCE 7
                                  TABLE 82
                                  
                                  


                                  • 14. Re: No such user admin

                                    No changes done to jboss-portal.sar/conf/hibernate/user/setup.txt

                                    1 2 Previous Next