Populate DB with own users / groups / memberships

hazel8 — Wed, 08 Jun 2011 20:11:44 GMT

HelloI would like to use activiti-explorer as frontend for our process and populate the DB with our own users and groups. I made that by adding our users / groups to the sql-script h2.data.sql (script source see below). Users, groups and memberships are added to the DB without problems, but when I t

Re: Populate DB with own users / groups / memberships

frederikherema1 — Thu, 09 Jun 2011 06:11:36 GMT

The to activiti-rest returns a status that isn't "Status.STATUS_OK". Can you check the log of your tomcat install to see if there are any other exception besides the one you posted before?

Re: Populate DB with own users / groups / memberships

hazel8 — Thu, 09 Jun 2011 10:31:51 GMT

Dear Frederik

catalina.log does not contain any error messages.
localhost.log –> see below

How can I add new users, groups, memberships to activiti (is tutorial / documentation available)?
Is a database model available with detailed information about Activiti tables and fields?

Many thanks in advance for your reply.

Log localhost-date.log
*****************
09.06.2011 12:04:14 org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
09.06.2011 12:04:14 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
09.06.2011 12:04:38 org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
09.06.2011 12:04:38 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
09.06.2011 12:05:02 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
09.06.2011 12:05:04 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
09.06.2011 12:05:04 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
09.06.2011 12:09:41 org.apache.catalina.core.ApplicationDispatcher invoke
SCHWERWIEGEND: Servlet.service() for servlet Spring MVC Dispatcher Servlet threw exception
org.springframework.extensions.surf.exception.UserFactoryException: Unable to create user - failed to retrieve user info:
at org.activiti.surf.ActivitiUserFactory.loadUser(ActivitiUserFactory.java:204)
at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:176)
at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:99)
at org.springframework.extensions.surf.RequestContextUtil.initialiseUser(RequestContextUtil.java:202)
at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:175)
at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:130)
at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.populateRequestContext(AbstractWebFrameworkView.java:274)
at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:136)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
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:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
09.06.2011 12:09:41 org.apache.catalina.core.StandardWrapperValve invoke
SCHWERWIEGEND: Servlet.service() for servlet [Spring MVC Dispatcher Servlet] in context with path [/activiti-explorer] threw exception [Request processing failed; nested exception is org.springframework.extensions.surf.exception.UserFactoryException: Unable to retrieve user from repository] with root cause
org.springframework.extensions.surf.exception.UserFactoryException: Unable to create user - failed to retrieve user info:
at org.activiti.surf.ActivitiUserFactory.loadUser(ActivitiUserFactory.java:204)
at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:176)
at org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:99)
at org.springframework.extensions.surf.RequestContextUtil.initialiseUser(RequestContextUtil.java:202)
at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:175)
at org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:130)
at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.populateRequestContext(AbstractWebFrameworkView.java:274)
at org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:136)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
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:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Re: Populate DB with own users / groups / memberships

frederikherema1 — Thu, 09 Jun 2011 10:39:07 GMT

Hi,

If you don't mind using a UI, you should take a look at the activiti-administrator (http://localhost:8080/activiti-administrator in default distro, you can run the webapp standalone if you want) in the current distribution. This allows you to add users and groups without you having to worry about database stuff. This functionality will also be present in the activiti-explorer2 in (probabilly) the next activiti realease.

You can also use the Java-api to add users (IdentityService)…

Re: Populate DB with own users / groups / memberships

hazel8 — Thu, 09 Jun 2011 13:15:57 GMT

Hi

After defining the users and groups in acitiviti-administrator I get the same error message in activiti-explorer as well as in activiti-probe. In activiti-administrator I can login with a new defined users without problems.

Many thanks for help.

Re: Populate DB with own users / groups / memberships

frederikherema1 — Thu, 09 Jun 2011 14:06:44 GMT

Are you sure your administrator is pointing to the right DB? The configuration for that is in a different place…

Re: Populate DB with own users / groups / memberships

hazel8 — Thu, 09 Jun 2011 14:52:09 GMT

I'm absolutely shure that administrator is pointing to same db, cause I have currently only one DB installed.

Re: Populate DB with own users / groups / memberships

frederikherema1 — Fri, 10 Jun 2011 07:53:25 GMT

And the existing users, can you use them to login (kermit)?

Re: Populate DB with own users / groups / memberships

hazel8 — Fri, 10 Jun 2011 08:05:14 GMT

With existing users (kermit, etc.) login is possible without problem.

Is anybody using activiti-explorer with own users / groups?

Many thanks for your help

Re: Populate DB with own users / groups / memberships

frederikherema1 — Fri, 10 Jun 2011 09:06:01 GMT

Are your new users part of the "user" group (security-role type, not assignement)? This is needed to get access to rest-login…

Re: Populate DB with own users / groups / memberships

hazel8 — Mon, 13 Jun 2011 09:23:46 GMT

Hi Frederik

I set the new users as part of the user-group (type "security-role") and everything works fine.

Can you provide a brief documentation of the activiti-DB?

Many thanks

Re: Populate DB with own users / groups / memberships

hazel8 — Mon, 13 Jun 2011 09:35:52 GMT

Hi Frederik

Many thanks for your help.
I set the new users as part of the "user" group (security-role type) and everything works fine.

Can anybody provide a description of activitif-DB (DB-model containing explication of all important fields).

Re: Populate DB with own users / groups / memberships

frederikherema1 — Mon, 13 Jun 2011 11:24:49 GMT

I'm affraid we don't have documentation on the columns. But most of them, speak for themselves By inspecting the data-model (and mapping.xml files) you'll get a quite good overview…

topic Re: Populate DB with own users / groups / memberships in Alfresco Archive

Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships

Re: Populate DB with own users / groups / memberships