Hi Narinder, The information on the wiki has been superceded by Anthony Ogier's DataSourcePersistenceManager method of using MySQL for data storage. As that doesn't seem to be on the wiki yet you will have to do a search through the user list archive - there are several threads of discussion, but read through them all and it should eventually make sense :-)
The default jackrabbit persistence manager for MySQL is flawed, and while it should be OK for testing, I wouldn't want to trust a production system to it. Anthony's replacement seems to work great - several people have reported positive experiences. Hope that helps, Simon On 22/03/07, Narinder Kumar <[email protected]> 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 ----------------------------------------------------------------
