topic Re: How to use REST API with activiti-app? in Alfresco Forum

How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 07:04:03 GMT

There's a activiti-app had been deployed in my cluster, I'd like to do some operation with REAT API to this app, how can I do this? what's the endpoints of that?

Re: How to use REST API with activiti-app?

rallegre — Tue, 19 Sep 2017 07:21:30 GMT

Hi Klaus,

Here is the REST API doc page for Alfresco Process Services

REST API | Alfresco Documentation

We provide a REST API Explorer to let you discover and test the APIs of a locally running instance.

Using the REST API Explorer | Alfresco Documentation

Regards

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 07:31:16 GMT

Can not access . I'm using "activiti-app.war" from "activiti-6.0.0.zip".

Re: How to use REST API with activiti-app?

rallegre — Tue, 19 Sep 2017 07:34:29 GMT

For Activiti, here is the REST API doc:

Activiti User Guide

Regards

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 07:38:50 GMT

do you understand my question?

Re: How to use REST API with activiti-app?

rallegre — Tue, 19 Sep 2017 08:18:53 GMT

Did you install the activiti-rest.war?

Activiti User Guide

Thanks

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 15:13:40 GMT

Thanks very much . I just install activit-rest & activit-admin, the activiti-admin can access data now, but I can not access restful API because of authentication failure.

Here's the related info:

curl --user admin:test http://activiti.druid.io/activiti-rest/tasks <!doctype html><html lang="en"><head><title>HTTP Status 401 – Unauthorized</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} h2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} h3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} body {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} b {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} p {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;} a {color:black;} a.name {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 401 – Unauthorized</h1><hr class="line" /><p><b>Type</b> Status Report</p><p><b>Message</b> Authentication failed for this username and password</p><p><b>Description</b> The request has not been applied because it lacks valid authentication credentials for the target resource.</p><hr class="line" /><h3>Apache Tomcat/8.5.16</h3></body></html>MacPro-2:kube-arbitrator klaus$

Any suggestion?

Re: How to use REST API with activiti-app?

fcorti — Tue, 19 Sep 2017 15:29:35 GMT

Hi Klaus,

Did you setup the engine.properties file, as described at the following link?

Activiti User Guide

I hope this help you.

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 15:42:18 GMT

No special configuration, I'm using the default configuration. activit-admin can access rest api.

Re: How to use REST API with activiti-app?

fcorti — Tue, 19 Sep 2017 15:45:16 GMT

activiti-admin does not use REST API.

From your answer I assume you did not check the engine.proprties file and this is probably the issue.
I suggest you to setup it correctly.

I hope this help you.

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 15:48:15 GMT

What should I change? I'm using the default configuration:

# demo data properties
create.demo.users=true
create.demo.definitions=true
create.demo.models=true

# engine properties
engine.schema.update=true
engine.activate.jobexecutor=false
engine.asyncexecutor.enabled=true
engine.asyncexecutor.activate=true
engine.history.level=full

# rest properties

# Enable/disable Java serializable objects to be passed as variables in the REST API.
rest.variables.allow.serializable=true

# Enable/disable whether the docs are available on /docs
rest.docs.swagger.enabled=true

Re: How to use REST API with activiti-app?

k82cn — Tue, 19 Sep 2017 15:50:22 GMT

BTW, do activit-app and activiti-rest share data? It seem they're using different database.

Re: How to use REST API with activiti-app?

fcorti — Tue, 19 Sep 2017 15:54:42 GMT

Most of the times, the DB access is the issue.
Please check the db.properties file (in the same folder where you find the engine.properties file) has the same DB settings of the admin-app.war application.

Re: How to use REST API with activiti-app?

fcorti — Tue, 19 Sep 2017 15:55:15 GMT

Indeed, they have to point on the same DB.
Most of the times this is the issue.

Re: How to use REST API with activiti-app?

k82cn — Wed, 20 Sep 2017 00:05:22 GMT

great, let me try it again .

Re: How to use REST API with activiti-app?

k82cn — Wed, 20 Sep 2017 02:08:10 GMT

If I point to the same database, I got following errors:

INFO 9/20/17 2:06 AM:liquibase: classpath:META-INF/liquibase/db-changelog.xml: 1::activiti: Table USER_AUTHORITY created
SEVERE 9/20/17 2:06 AM:liquibase: classpath:META-INF/liquibase/db-changelog.xml: 1::activiti: Change Set classpath:META-INF/liquibase/db-changelog.xml::1::activiti failed. Error: Error executing SQL CREATE TABLE activiti.HIBERNATE_SEQUENCES (sequence_name VARCHAR(255) NULL, sequence_next_hi_value INT NULL): Table 'hibernate_sequences' already exists
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE activiti.HIBERNATE_SEQUENCES (sequence_name VARCHAR(255) NULL, sequence_next_hi_value INT NULL): Table 'hibernate_sequences' already exists
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:106)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1189)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1172)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:352)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)
at liquibase.Liquibase.update(Liquibase.java:202)
at liquibase.Liquibase.update(Liquibase.java:181)
at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:342)
at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:299)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)

Re: How to use REST API with activiti-app?

k82cn — Wed, 20 Sep 2017 02:26:36 GMT

Also user_info .

activiti_1 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class com.activiti.conf.DatabaseConfiguration: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:META-INF/liquibase/db-changelog.xml::1::activiti:
activiti_1 | Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE activiti.USER_INFO (login VARCHAR(50) NOT NULL, password VARCHAR(100) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, CONSTRAINT PK_USER_INFO PRIMARY KEY (login)): Table 'user_info' already exists
activiti_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
activiti_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
activiti_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
activiti_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
activiti_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
activiti_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
activiti_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
activiti_1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
activiti_1 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
activiti_1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
activiti_1 | at com.activiti.conf.WebConfigurer.contextInitialized(WebConfigurer.java:46)
activiti_1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)
activiti_1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)
activiti_1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
activiti_1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
activiti_1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
activiti_1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
activiti_1 | at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1144)
activiti_1 | at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1878)
activiti_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
activiti_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
activiti_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
activiti_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
activiti_1 | at java.lang.Thread.run(Thread.java:748)
activiti_1 | Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:META-INF/liquibase/db-changelog.xml::1::activiti:
activiti_1 | Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE activiti.USER_INFO (login VARCHAR(50) NOT NULL, password VARCHAR(100) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, CONSTRAINT PK_USER_INFO PRIMARY KEY (login)): Table 'user_info' already exists
activiti_1 | at liquibase.changelog.ChangeSet.execute(ChangeSet.java:388)
activiti_1 | at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)
activiti_1 | at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)
activiti_1 | at liquibase.Liquibase.update(Liquibase.java:202)
activiti_1 | at liquibase.Liquibase.update(Liquibase.java:181)
activiti_1 | at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:342)
activiti_1 | at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:299)

Re: How to use REST API with activiti-app?

fcorti — Wed, 20 Sep 2017 07:52:21 GMT

Which DB are you using?
I suggest to use MySql or PostgreSql, not the inmemory database because it won't work with it.

Re: How to use REST API with activiti-app?

k82cn — Wed, 20 Sep 2017 07:54:20 GMT

Yes, I'm using MySQL.

Re: How to use REST API with activiti-app?

k82cn — Wed, 20 Sep 2017 07:55:33 GMT

Anyway, my original request to use activiti-app, and can use script to create/query process instance in it.