GateIn AS 7.1 preview is not able to switch to MySQL backend
tonykaska Apr 5, 2012 5:58 AMI am using the AS 7.1 preview installation. I am trying to setup MySQL as my backend. I am following the reference guide online. Additionally I have setup the MySQL datasource in AS 7.1.
But it is failing. Any guidance or help will be appreciated. Has anyone successfully able to create the schema automatically if they switch the db source? I appreciate any guidance.
I am also wondering if there is any where you can find the specific errors that causes. Where the problem is exctly. I am not able to locate any log file. Thanks.
Thank you.
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileF
ilter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitiali
zedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:116) [exo.jc
r.framework.web-1.14.6-GA.jar:1.14.6-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilt
er(SetCurrentIdentityFilter.java:88) [exo.core.component.security.core-2.4.6-GA.
jar:2.4.6-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.web.login.ClusteredSSOFilter.doFilter(ClusteredSSOFil
ter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalCo
ntainerFilter.java:69) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS
7-Beta03]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:275) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:161) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:397) [jbossweb-7.0.10.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(Secu
rityContextAssociationValve.java:154) [jboss-as-web-7.1.0.Final.jar:7.1.0.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:155) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:368) [jbossweb-7.0.10.Final.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:877) [jbossweb-7.0.10.Final.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:671) [jbossweb-7.0.10.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:93
0) [jbossweb-7.0.10.Final.jar:]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.lang.ClassLoader.findClass(ClassLoader.java:358) [rt.jar:1.6.0_3
1]
at java.lang.ClassLoader.loadClass(ClassLoader.java:306) [rt.jar:1.6.0_3
1]
at java.lang.ClassLoader.loadClass(ClassLoader.java:247) [rt.jar:1.6.0_3
1]
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1420) [commons-dbcp-1.4.jar:1.4]
... 85 more
04:34:24,884 ERROR [exo.kernel.container.MX4JComponentAdapter] (http--127.0.0.1-
8080-1) Failed to instanciate plugin DefaultRequestHandler for component org.exo
platform.web.WebAppController@1e600bf: Cannot instantiate component key=org.exop
latform.portal.config.UserPortalConfigService type=org.exoplatform.portal.config
.UserPortalConfigService found at jndi:/default-host/portal/WEB-INF/conf/portal/
portal-configuration.xml: java.lang.RuntimeException: Cannot instantiate compone
nt key=org.exoplatform.portal.config.UserPortalConfigService type=org.exoplatfor
m.portal.config.UserPortalConfigService found at jndi:/default-host/portal/WEB-I
NF/conf/portal/portal-configuration.xml
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:
2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.management.ManageableComponentAdapter.getCo
mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-
GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr
entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G
A-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc
eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet
a03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.CachingContainer.getComponentInstanceOfType
(CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-
GA-AS7-Beta03]
at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.jmx.MX4JComponentAdapter.addComponentPlugin
(MX4JComponentAdapter.java:155) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.
3.6-GA-AS7-Beta03]
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:114) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:
2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.management.ManageableComponentAdapter.getCo
mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-
GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr
entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G
A-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc
eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet
a03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.CachingContainer.getComponentInstanceOfType
(CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-
GA-AS7-Beta03]
at org.exoplatform.portal.application.PortalController.onService(PortalC
ontroller.java:126) [exo.portal.webui.portal-3.2.0-GA.jar:3.2.0-GA]
at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHtt
pServlet.java:132) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Be
ta03]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-s
ervlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:329) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.
java:89) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.
java:55) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doF
ilter(ExtensibleFilter.java:110) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.
0-GA]
at org.exoplatform.sample.ext.web.SampleFilter.doFilter(SampleFilter.jav
a:46) [exo.portal.sample.extension.jar-3.2.0-GA.jar:3.2.0-GA]
at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doF
ilter(ExtensibleFilter.java:106) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.
0-GA]
at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter
.java:80) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.0-GA]
at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:
79) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileF
ilter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitiali
zedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:116) [exo.jc
r.framework.web-1.14.6-GA.jar:1.14.6-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilt
er(SetCurrentIdentityFilter.java:88) [exo.core.component.security.core-2.4.6-GA.
jar:2.4.6-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.web.login.ClusteredSSOFilter.doFilter(ClusteredSSOFil
ter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalCo
ntainerFilter.java:69) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS
7-Beta03]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:275) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:161) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:397) [jbossweb-7.0.10.Final.jar:]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(Secu
rityContextAssociationValve.java:154) [jboss-as-web-7.1.0.Final.jar:7.1.0.Final]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:155) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:368) [jbossweb-7.0.10.Final.jar:]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:877) [jbossweb-7.0.10.Final.jar:]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:671) [jbossweb-7.0.10.Final.jar:]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:93
0) [jbossweb-7.0.10.Final.jar:]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exop
latform.services.organization.OrganizationService type=org.exoplatform.services.
organization.idm.PicketLinkIDMOrganizationServiceImpl found at jndi:/default-hos
t/portal/WEB-INF/conf/organization/idm-configuration.xml
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:
2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.management.ManageableComponentAdapter.getCo
mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-
GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr
entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G
A-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc
eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet
a03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.CachingContainer.getComponentInstanceOfType
(CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-
GA-AS7-Beta03]
at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2
.3.6-GA-AS7-Beta03]
... 54 more
Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exop
latform.services.organization.idm.PicketLinkIDMService type=org.exoplatform.serv
ices.organization.idm.PicketLinkIDMServiceImpl found at jndi:/default-host/porta
l/WEB-INF/conf/organization/idm-configuration.xml
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:
2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.management.ManageableComponentAdapter.getCo
mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-
GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr
entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G
A-AS7-Beta03]
at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc
eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet
a03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.CachingContainer.getComponentInstanceOfType
(CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-
GA-AS7-Beta03]
at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2
.3.6-GA-AS7-Beta03]
... 60 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[rt.jar:1.6.0_31]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39) [rt.jar:1.6.0_31]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27) [rt.jar:1.6.0_31]
at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [rt.j
ar:1.6.0_31]
at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j
ava:417) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]
at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan
ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2
.3.6-GA-AS7-Beta03]
... 66 more
Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set whe
n no Connection avalable
at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFac
tory.java:107) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
134) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j
ava:2119) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115
) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1339) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(Annotat
ionConfiguration.java:867) [hibernate-annotations-3.4.0.GA.jar:3.3.2.GA]
at org.exoplatform.services.database.impl.HibernateServiceImpl$2.run(Hib
ernateServiceImpl.java:302) [exo.core.component.database-2.4.6-GA.jar:2.4.6-GA]
at org.exoplatform.services.database.impl.HibernateServiceImpl$2.run(Hib
ernateServiceImpl.java:299) [exo.core.component.database-2.4.6-GA.jar:2.4.6-GA]
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(Secur
ityHelper.java:291) [exo.kernel.commons-2.3.6-GA.jar:3.2.0-GA]
at org.exoplatform.services.database.impl.HibernateServiceImpl.getSessio
nFactory(HibernateServiceImpl.java:298) [exo.core.component.database-2.4.6-GA.ja
r:2.4.6-GA]
at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.<i
nit>(PicketLinkIDMServiceImpl.java:147) [exo.portal.component.identity-3.2.0-GA.
jar:3.2.0-GA]
... 72 more
04:34:25,034 ERROR [org.exoplatform.web.WebAppController] (http--127.0.0.1-8080-
1) Could not associate the request path=/ with an handler