I'd recommend you clear out the repository folder in each failed
magnolia instance and drop the database tables generated by them. Then
restart tomcat and see what it does. Should bootstrap normally.
--David
Narinder Kumar wrote:
Hi
I was thinking of using MySQL as default back end database repository
instead of Derby in Magnolia.
Followed the steps mentioned in one of the articles at wiki :
http://www.magnolia.info/wiki/Wiki.jsp?page=SettingUpMySQLRepository
But didn't get the thing working, infact Magnolia just didn't start up
due
to :
1. Errors about not able to find Xalan class files :
ERROR info.magnolia.jackrabbit.ProviderImpl 22.03.2007 10:52:21 --
Unable
to initialize repository: Provider
org.apache.xalan.processor.TransformerFactoryImpl not found
javax.xml.transform.TransformerFactoryConfigurationError: Provider
org.apache.xalan.processor.TransformerFactoryImpl not found
at javax.xml.transform.TransformerFactory.newInstance(Unknown Source)
at
org.apache.jackrabbit.core.config.RepositoryConfig.internalCreateWorkspaceConfig(RepositoryConfig.java:516)
at
org.apache.jackrabbit.core.config.RepositoryConfig.createWorkspaceConfig(RepositoryConfig.java:571)
at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:330)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:141)
at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:83)
at
org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.java:134)
at
org.apache.jackrabbit.core.jndi.BindableRepository.create(BindableRepository.java:122)
at
org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.createInstance(BindableRepositoryFactory.java:58)
at
org.apache.jackrabbit.core.jndi.RegistryHelper.registerRepository(RegistryHelper.java:59)
at info.magnolia.jackrabbit.ProviderImpl.init(ProviderImpl.java:165)
at
info.magnolia.cms.beans.config.ContentRepository.loadRepository(ContentRepository.java:336)
at
info.magnolia.cms.beans.config.ContentRepository.loadRepositories(ContentRepository.java:300)
at
info.magnolia.cms.beans.config.ContentRepository.init(ContentRepository.java:187)
at
info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:114)
at
info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:100)
at
info.magnolia.cms.servlets.PropertyInitializer.contextInitialized(PropertyInitializer.java:212)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4343)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
2. After putting Xalan jar in Tomcat/common/lib directory then it started
giving errors related to premature end of file/syntax error without
giving
no details about the configuration file.
Finally I followed following steps :
1. completed
.../magnoliaAuthor/WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml
basically added information about url, user and password there
2. changed .../magnoliaAuthor/WEB-INF/config/default/magnolia.properties
file to use jackrabbit-mysql-search.xml instead of
jackrabbit-derby-search.xml file in
magnolia.repositories.jackrabbit.config
parameter.
3. Did the same in magnoliaPublic instance
Restarted Tomcat and not getting any errors.
But while trying to activate any of the webpages, I get the error : can't
version ... Unable to update item.. Tomcat logs are :
ERROR info.magnolia.cms.core.version.BaseVersionManager 22.03.2007
15:34:25 -- failed to copy versionable node to version store,
reverting all
changes made in this session
ERROR info.magnolia.module.admininterface.commands.VersionCommand
22.03.2007 15:34:25 -- can't version
javax.jcr.RepositoryException: /SoftwareDevelopment: unable to update
item.:
a08bcf2a-ad70-4541-b55c-6c50ba70a05c:
a08bcf2a-ad70-4541-b55c-6c50ba70a05c
at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1197)
at info.magnolia.cms.core.Content.save(Content.java:1155)
at info.magnolia.cms.core.version.CopyUtil.clone(CopyUtil.java:195)
at
info.magnolia.cms.core.version.CopyUtil.copyToversion(CopyUtil.java:107)
at
info.magnolia.cms.core.version.BaseVersionManager.createVersion(BaseVersionManager.java:153)
at
info.magnolia.cms.core.version.BaseVersionManager.addVersion(BaseVersionManager.java:124)
at info.magnolia.cms.core.Content.addVersion(Content.java:1060)
at
info.magnolia.module.admininterface.commands.VersionCommand.execute(VersionCommand.java:57)
at
info.magnolia.commands.MgnlCommand.executePooledOrSynchronized(MgnlCommand.java:141)
at info.magnolia.commands.MgnlCommand.execute(MgnlCommand.java:128)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at
info.magnolia.cms.servlets.CommandBasedMVCServletHandler.execute(CommandBasedMVCServletHandler.java:78)
at info.magnolia.cms.servlets.MVCServlet.doPost(MVCServlet.java:111)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
Can someone tell me where I am getting it wrong or what are the steps
to do
it ?
Do we need to do something on the database side as well ?
I am using Magnolia 3.0.1 release
Regards
Narinder
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/developer.html
----------------------------------------------------------------
