AnsweredAssumed Answered

Setting up DB Role Manager

Question asked by nickc on Aug 29, 2014
I am building Alfresco using Maven and am having difficulty, activating the DB Role manager.

I have updated the bootstrap file, the context.xml file (in the META_INF folder) and setup a table using PGAdmin for the DB Role Manager to use.

The error I am getting suggests that it can not retrieve DataSource by name/id=java:/PostgreSQLDS

Does anyone know why this does not work?

Thanks

<Code>Error: Role Manager could not be loaded: com.wewebu.ow.server.roleimpl.dbrole.OwDBRoleManager - Could not create DB role manager.
Error Source: OECM
com.wewebu.ow.server.exceptions.OwConfigurationException: Role Manager could not be loaded: com.wewebu.ow.server.roleimpl.dbrole.OwDBRoleManager - Could not create DB role manager.
         at com.wewebu.ow.server.app.OwConfiguration.createRoleManager(OwConfiguration.java:748)
         at com.wewebu.ow.server.app.OwConfiguration.init(OwConfiguration.java:300)
         at com.wewebu.ow.server.app.OwMainAppContext.init(OwMainAppContext.java:354)
         at com.wewebu.ow.server.ui.OwWebApplication.checkSessionObjects(OwWebApplication.java:246)
         at com.wewebu.ow.server.ui.OwWebApplication.handleRequest(OwWebApplication.java:346)
         at org.apache.jsp.default41_jsp._jspService(default41_jsp.java:79)
         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
         at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
         at com.wewebu.ow.server.servlets.OwServletFilter.doFilter(OwServletFilter.java:57)
         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
         at java.lang.Thread.run(Thread.java:745)
Caused by: com.wewebu.ow.server.exceptions.OwServerException: Could not create DB role manager.
         at com.wewebu.ow.server.roleimpl.dbrole.OwDBRoleManager.init(OwDBRoleManager.java:224)
         at com.wewebu.ow.server.app.OwConfiguration.createRoleManager(OwConfiguration.java:733)
         … 30 more
Caused by: com.wewebu.ow.server.exceptions.OwConfigurationException: OwDBRoleManager.init: No default data source configured! The DB Role Manager needs a default data source to read the access rights from.
         at com.wewebu.ow.server.roleimpl.dbrole.OwDBRoleManager.init(OwDBRoleManager.java:195)
         … 31 more



Startup / Configuration Error
Error: Application initializing error: Exception reading the bootstrap configuration data.
Error Source: OECM
com.wewebu.ow.server.exceptions.OwConfigurationException: Application initializing error: Exception reading the bootstrap configuration data.
         at com.wewebu.ow.server.app.OwConfiguration.applicationInitalize(OwConfiguration.java:412)
         at com.wewebu.ow.server.servlets.OwConfigurationInitialisingContextListener.applicationInitalize(OwConfigurationInitialisingContextListener.java:28)
         at com.wewebu.ow.server.servlets.OwInitialisingContextListener.init(OwInitialisingContextListener.java:63)
         at com.wewebu.ow.server.servlets.OwInitialisingContextListener.contextInitialized(OwInitialisingContextListener.java:97)
         at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
         at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
         at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
         at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
         at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
         at java.lang.Thread.run(Thread.java:745)
Caused by: com.wewebu.ow.server.exceptions.OwDataSourceException: OwDataSourceUtil.retrieveDataSource: Could not retrieve DataSource by name/id=java:/PostgreSQLDS
         at com.wewebu.ow.server.util.OwDataSourceUtil.retrieveDataSource(OwDataSourceUtil.java:60)
         at com.wewebu.ow.server.app.OwConfiguration.createJdbcDataSource(OwConfiguration.java:314)
         at com.wewebu.ow.server.app.OwConfiguration.applicationInitalize(OwConfiguration.java:397)
         … 12 more
Caused by: javax.naming.NameNotFoundException: Name [PostgreSQLDS] is not bound in this Context. Unable to find [PostgreSQLDS].
         at org.apache.naming.NamingContext.lookup(NamingContext.java:820)
         at org.apache.naming.NamingContext.lookup(NamingContext.java:168)
         at org.apache.naming.SelectorContext.lookup(SelectorContext.java:158)
         at javax.naming.InitialContext.lookup(InitialContext.java:417)
         at com.wewebu.ow.server.util.OwDataSourceUtil.retrieveDataSource(OwDataSourceUtil.java:54)
         … 14 more</code>

Outcomes