-
1. Re: No such user admin
peterj Nov 25, 2008 6:45 PM (in response to nvipas)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
nvipas Nov 25, 2008 6:52 PM (in response to nvipas)======================
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 Nov 25, 2008 6:58 PM (in response to nvipas)--- 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
nvipas Nov 25, 2008 6:58 PM (in response to nvipas)"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
nvipas Nov 25, 2008 7:00 PM (in response to nvipas)"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 Nov 25, 2008 7:06 PM (in response to nvipas)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
nvipas Nov 25, 2008 7:12 PM (in response to nvipas)"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
nvipas Nov 25, 2008 7:18 PM (in response to nvipas)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
nvipas Nov 25, 2008 7:21 PM (in response to nvipas)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
nvipas Nov 25, 2008 7:22 PM (in response to nvipas)Third question -
3. In which xml/prop file can I change from Oracle9Dialect to Oracle10gDialect? -
11. Re: No such user admin
peterj Nov 25, 2008 9:16 PM (in response to nvipas)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
nvipas Nov 26, 2008 3:32 PM (in response to nvipas)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
nvipas Nov 26, 2008 3:36 PM (in response to nvipas)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
nvipas Nov 26, 2008 3:37 PM (in response to nvipas)No changes done to jboss-portal.sar/conf/hibernate/user/setup.txt