Hello Richard. Unfortunately I do not have any experience with magnolia 2.1 on mysql, since I am using magnolia 3 rc2.
For me the log snippet you sent looks like there are no configuration values stored in the DB, or they cannot be found... On your initial startup, did you get any messages regarding a failed bootstrap? It could be that magnolia did not boostrap, because there is already a "repository folder" from your previous, non mysql setup. You have to make sure that magnolia bootstraps again after you changed the configuration to MS SQL, because it needs to create tables and data for the configuration. Please follow the instructions in this wiki page, it helps describing how to force magnolia to bootstrap again: http://www.magnolia.info/wiki/Search.jsp?query=mysql *********************************************** IPH Informatik AG Herr Claudio Greuter Lagerhausstrasse 9 8400 Winterthur Tel: +41 (052) 233 94 72 Fax: +41 (052) 233 94 71 [EMAIL PROTECTED] *********************************************** -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 29. August 2006 04:58 To: [email protected] Subject: Re: [magnolia-user] about using MySQL in Magnolia, and performance for Magnolia Hi Claudio, Thank you for your reply. I am pretty sure add "autoReconnect=true" will solve losing connection problem. But for the problem which Tomcat can not restart, I got no luck. BTW, I am using Magnolia 2.1.5 with Tomcat 5.5.16, MySQL 4.1.21. Is it because I am using Magnolia 2.1.5, not Magnolia 3? I have tried mysql-connector-java-3.1.12-bin.jar, mysql-connector-java-3.1.13-bin.jar, mysql-connector-java-5.0.3-bin.jar, no one works if restart Tomcat. It seems to try to get information from repository but can't. The log looks like: INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init virtualMap INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init i18n INFO info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Config : loading i18n configuration - i18n ERROR info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Config : Failed to load i18n configuration - i18n ERROR info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- server javax.jcr.PathNotFoundException: server at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2369) at info.magnolia.cms.core.Content.<init>(Content.java:110) at info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java :259) at info.magnolia.cms.i18n.MessagesManager.load(MessagesManager.java:130) at info.magnolia.cms.i18n.MessagesManager.init(MessagesManager.java:116) at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:137) at info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:89) at info.magnolia.cms.servlets.Initializer.contextInitialized(Initializer.ja va:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java: 608) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java :535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 0) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) INFO info.magnolia.cms.i18n.Messages 29.08.2006 14:02:12 -- Registering event listener for i18n INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- Init secureURI INFO info.magnolia.cms.beans.config.Server 29.08.2006 14:02:12 -- Config : loading Server ERROR info.magnolia.cms.beans.config.Server 29.08.2006 14:02:12 -- Config : Failed to load Server config: server javax.jcr.PathNotFoundException: server at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2369) at info.magnolia.cms.core.Content.<init>(Content.java:110) at info.magnolia.cms.core.HierarchyManager.getContent(HierarchyManager.java :259) at info.magnolia.cms.beans.config.Server.load(Server.java:78) at info.magnolia.cms.beans.config.Server.init(Server.java:64) at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:142) at info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:89) at info.magnolia.cms.servlets.Initializer.contextInitialized(Initializer.ja va:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java: 608) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java :535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 0) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) INFO info.magnolia.cms.beans.config.ConfigLoader 29.08.2006 14:02:12 -- An error occurred during initialization, incomplete configuration found? Cheers, Richard ([EMAIL PROTECTED]) ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
