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
----------------------------------------------------------------
