Hi, I am validating Magnolia CE 5.4.2, but I've stumble on problems when using MySQL 5.6 as repository.
I followed this guide to set up a [url=https://wiki.magnolia-cms.com/display/WIKI/Magnolia+CMS+with+MySQL#MagnoliaCMSwithMySQL-BundlepersistentmanagerwithJNDI]Pooled persistence manager[/url]. I did the following steps up the [b]magnoliaAuthor[/b] instance; 1) Run MySQL and create two schemas [b]mgnl_author[/b] and [b]mgnl_public[/b] 2) Replaced the [b]derby-10.5.3.0_1[/b] with mysql-connector-java-5.0.8-bin in folder [b]magnoliaAuthor\WEB-INF\lib[/b] 3) Edit the [b]magnolia.properties[/b] and [b]jackrabbit-bundle-mysql-search.xml[/b] according to the guide, not using JNDI 4) Run the magnolia_control.bat start scrip in the bin folder 5) Update modules for the [b]magnoliaAuthor [/b]instance through the web interface and -re-start it Up to this point everything works as suspected. If I try update modules for [b]magnoliaPublic[/b] I'll get the following error; [i]Error while installing or updating core module. Task 'IPConfig rules changed' failed. (ItemExistsException: a node with uuid ...[/i] If I stop magnolia an configure [b]magnolia.properties[/b] and [b]jackrabbit-bundle-mysql-search.xml[/b] to point to [b]mgnl_public[/b] I get the same error. [i]ERROR info.magnolia.module.InstallContextImpl 17.09.2015 13:24:24 -- [3/609 tasks - Magnolia Core Module (version 5.4.2)]> Error while installing or updating core module. Task 'IPConfig rules changed' failed. (ItemExistsException: a node with uuid b038735c-9351-4083-bc09-5b70576c05e2 already exists!) java.lang.RuntimeException: Error importing config.server.IPConfig: a node with uuid b038735c-9351-4083-bc09-5b70576c05e2 already exists! at info.magnolia.importexport.DataTransporter.importXmlStream(DataTransporter.java:385) at info.magnolia.importexport.DataTransporter.importXmlStream(DataTransporter.java:240) at info.magnolia.importexport.BootstrapUtil.bootstrap(BootstrapUtil.java:120) at info.magnolia.module.delta.BootstrapResourcesTask.execute(BootstrapResourcesTask.java:73) at info.magnolia.module.ModuleManagerImpl.applyDeltas(ModuleManagerImpl.java:511) at info.magnolia.module.ModuleManagerImpl.installOrUpdateModule(ModuleManagerImpl.java:493) at info.magnolia.module.ModuleManagerImpl$1.doExec(ModuleManagerImpl.java:274) at info.magnolia.context.MgnlContext$VoidOp.exec(MgnlContext.java:421) at info.magnolia.context.MgnlContext$VoidOp.exec(MgnlContext.java:418) at info.magnolia.context.MgnlContext.doInSystemContext(MgnlContext.java:392) at info.magnolia.module.ModuleManagerImpl.performInstallOrUpdate(ModuleManagerImpl.java:268) at info.magnolia.module.ui.ModuleManagerWebUI$2.run(ModuleManagerWebUI.java:123) at java.lang.Thread.run(Thread.java:745)[/i] I understand I need to two DB schemas to handle author and public instance. But what is the correct way to set up Magnolia 5.4.2 with MySQL, please provide a step-by-step answer? Greetings anykeystudio -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=ac879348-cf18-429d-a0d7-305dfa384473 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <user-list-unsubscr...@magnolia-cms.com> ----------------------------------------------------------------
