Hello--

I am running a fresh install of Magnolia EE 5.2 using mysql for storage.

I am unable to edit access roles for a user.

Steps to produce error:

Log into a public instance

Under manage / security / roles -> double click on anonymous will open a window
click in the tab "access controls list"
click "add" in DAM and put read only and "/"
Click Save.

Error message appears in admincentral: "javax.jcr.NoSuchWorkspaceException: Store"

Info from Magnolia error logs:

ERROR info.magnolia.ui.dialog.formdialog.FormDialogPresenterImpl 23.01.2014 13:15:39 – An error occurred while executing an action.
info.magnolia.ui.api.action.ActionExecutionException: javax.jcr.NoSuchWorkspaceException: Store

ERROR nolia.ui.dialog.formdialog.FormDialogPresenterImpl: An error occurred while executing an action.

ERROR info.magnolia.ui.dialog.formdialog.FormDialogPresenterImpl 23.01.2014 11:25:45 – An error occurred while executing an action.
info.magnolia.ui.api.action.ActionExecutionException: Action execution failed for action: commit

ERROR org.apache.jackrabbit.core.util.db.ConnectionHelper 22.01.2014 17:15:03 – Failed to execute SQL (stacktrace on DEBUG log level): java.sql.SQLException: Could not retrieve transation read-only status server

Bootstrap Log:

INFO 23.01.2014 12:46:10 Trying to initialize repositories from:
/opt/tomcat/webapps/cms/WEB-INF/bootstrap/author
/opt/tomcat/webapps/cms/WEB-INF/bootstrap/common
INFO 23.01.2014 12:46:10 Repository [dam] has been initialized.
INFO 23.01.2014 12:46:10 Repository [forum] has been initialized.
INFO 23.01.2014 12:46:10 Repository [contacts] has been initialized.
INFO 23.01.2014 12:46:10 Repository [usergroups] has been initialized.
INFO 23.01.2014 12:46:10 Repository [templates] has been initialized.
INFO 23.01.2014 12:46:10 Repository [mgnlSystem] has been initialized.
INFO 23.01.2014 12:46:10 Repository [scripts] has been initialized.
INFO 23.01.2014 12:46:10 Repository [mgnlVersion] has been initialized.
INFO 23.01.2014 12:46:10 Repository [website] has been initialized.
INFO 23.01.2014 12:46:10 Repository [userroles] has been initialized.
INFO 23.01.2014 12:46:10 Repository [googleSitemaps] has been initialized.
INFO 23.01.2014 12:46:10 Repository [workflow] has been initialized.
INFO 23.01.2014 12:46:10 Repository [profiles] has been initialized.
INFO 23.01.2014 12:46:10 Repository [users] has been initialized.
INFO 23.01.2014 12:46:10 Repository [imaging] has been initialized.
INFO 23.01.2014 12:46:10 Repository [category] has been initialized.
INFO 23.01.2014 12:46:10 Repository [rss] has been initialized.
INFO 23.01.2014 12:46:10 Repository [resources] has been initialized.
INFO 23.01.2014 12:46:10 Repository [messages] has been initialized.
INFO 23.01.2014 12:46:10 Repository [config] has been initialized.
INFO 23.01.2014 12:46:10 Repository [dms] has been initialized.
INFO 23.01.2014 12:46:10 Repository [data] has been initialized.

Server configuration data:

awt.toolkit sun.awt.X11.XToolkit
catalina.base /opt/tomcat
catalina.home /opt/tomcat
catalina.useNaming true
common.loader /opt/tomcat/lib,/opt/tomcat/lib/.jar,/opt/tomcat/lib,/opt/tomcat/lib/.jar
defaultPublicURI redirect:/demo-project.html
file.encoding UTF-8
file.encoding.pkg sun.io
file.separator /
info.magnolia.imaging.operations.load.ImageDecoder info.magnolia.imaging.operations.load.DefaultImageIOImageDecoder
info.magnolia.module.forum.ForumManager info.magnolia.module.forum.DefaultForumManager
info.magnolia.module.publicuserregistration.UserRegistrar info.magnolia.module.publicuserregistration.DefaultUserRegistrar
info.magnolia.module.templatingkit.sites.SiteManager info.magnolia.multisite.sites.MultiSiteManager
java.awt.graphicsenv sun.awt.X11GraphicsEnvironment
java.awt.printerjob sun.print.PSPrinterJob
java.class.path /opt/tomcat/bin/bootstrap.jar:/opt/tomcat/bin/tomcat-juli.jar
java.class.version 51.0
java.endorsed.dirs /opt/tomcat/endorsed
java.ext.dirs /usr/java/jre1.7.0_25/lib/ext:/usr/java/packages/lib/ext
java.home /usr/java/jre1.7.0_25
java.io.tmpdir /opt/tomcat/temp
java.library.path /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
java.naming.factory.initial org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs org.apache.naming
java.net.preferIPv4Addresses true
java.net.preferIPv4Stack true
java.runtime.name Java(TM) SE Runtime Environment
java.runtime.version 1.7.0_25-b15
java.security.auth.login.config /opt/tomcat/webapps/cms/WEB-INF/config/jaas.config
java.specification.name Java Platform API Specification
java.specification.vendor Oracle Corporation
java.specification.version 1.7
java.util.logging.config.file /opt/tomcat/conf/logging.properties
java.util.logging.manager org.apache.juli.ClassLoaderLogManager
java.vendor Oracle Corporation
java.vendor.url http://java.oracle.com/
java.vendor.url.bug http://bugreport.sun.com/bugreport/
java.version 1.7.0_25
java.vm.info mixed mode
java.vm.name Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name Java Virtual Machine Specification
java.vm.specification.vendor Oracle Corporation
java.vm.specification.version 1.7
java.vm.vendor Oracle Corporation
java.vm.version 23.25-b01
line.separator
log4j.config WEB-INF/config/default/log4j.xml
magnolia.app.rootdir /opt/tomcat/webapps/cms
magnolia.author.key.location /opt/tomcat/webapps/cms/WEB-INF/config/default/magnolia-activation-keypair.properties
magnolia.bootstrap.authorInstance true
magnolia.bootstrap.dir WEB-INF/bootstrap/author WEB-INF/bootstrap/common
magnolia.bootstrap.samples true
magnolia.cache.startdir /opt/tomcat/webapps/cms/cache
magnolia.connection.jcr.password admin
magnolia.connection.jcr.userId admin
magnolia.contextpath /cms
magnolia.develop false
magnolia.exchange.history /opt/tomcat/webapps/cms/history
magnolia.home /opt/tomcat/webapps/cms
magnolia.logs.dir /opt/tomcat/webapps/cms/logs
magnolia.repositories.config WEB-INF/config/default/repositories.xml
magnolia.repositories.home /opt/tomcat/webapps/cms/repositories
magnolia.repositories.jackrabbit.config WEB-INF/config/repo-conf/jackrabbit-bundle-mysql-search.xml
magnolia.servername wwwcmsdev01-sc9.virginam.com
magnolia.ui.vaadin.theme admincentral
magnolia.ui.vaadin.widgetset info.magnolia.ui.vaadin.gwt.MagnoliaWidgetSet
magnolia.update.auto false
magnolia.upload.tmpdir /opt/tomcat/webapps/cms/tmp
magnolia.utf8.enabled false
magnolia.webapp cms
org.apache.catalina.startup.ContextConfig.jarsToSkip
org.apache.catalina.startup.TldConfig.jarsToSkip
org.apache.jackrabbit.core.util.RepositoryLock:/opt/tomcat/webapps/cms/repositories/magnolia org.apache.jackrabbit.core.util.RepositoryLock:/opt/tomcat/webapps/cms/repositories/magnolia
os.arch amd64
os.name Linux
os.version 2.6.32-358.el6.x86_64
package.access sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
package.definition sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
path.separator :
server wwwcmsdev01-sc9.virginam.com
server.loader
shared.loader
sun.arch.data.model 64
sun.boot.class.path /usr/java/jre1.7.0_25/lib/resources.jar:/usr/java/jre1.7.0_25/lib/rt.jar:/usr/java/jre1.7.0_25/lib/sunrsasign.jar:/usr/java/jre1.7.0_25/lib/jsse.jar:/usr/java/jre1.7.0_25/lib/jce.jar:/usr/java/jre1.7.0_25/lib/charsets.jar:/usr/java/jre1.7.0_25/lib/jfr.jar:/usr/java/jre1.7.0_25/classes
sun.boot.library.path /usr/java/jre1.7.0_25/lib/amd64
sun.cpu.endian little
sun.cpu.isalist
sun.io.unicode.encoding UnicodeLittle
sun.java.command org.apache.catalina.startup.Bootstrap start
sun.java.launcher SUN_STANDARD
sun.jnu.encoding UTF-8
sun.management.compiler HotSpot 64-Bit Tiered Compilers
sun.os.patch.level unknown
themeName pop
tomcat.util.buf.StringCache.byte.enabled true
tomcat.util.scan.DefaultJarScanner.jarsToSkip bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-.jar,tomcat-api.jar,tomcat-util.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,tools.jar,commons-beanutils.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,junit.jar,junit-*.jar,ant-launcher.jar
user.country US
user.dir /opt/tomcat/webapps
user.home /root
user.language en
user.name root
user.timezone US/Pacific