Activiti Explorer 5.12 in Alfresco community

[ggoutham]

Hi Community,

I am using alfresco community 4.2.c. I want to install activiti explorer 5.12 in alfresco.
For that i have placed the activiti-explorer war file into alfresco/tomcat/webapps folder.
For the first time i have not changed any database files in activiti configuration, the activiti explorer started and showed the login page,
But when i give login credentials showing a login error (obvious because not configured database)

Then i have changed the db.properties file in activiti-explorer with these values
db=postgresql
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbcostgresql://localhost:5432/alfresco
jdbc.username=alfresco
jdbc.password=admin 

When i am starting alfresco it is showing show many errors in log and activiti-explorer is not starting up..

Can anybody please tell me anything iam missing here and is it correct to do like this.

Pleaase help me,,

Regards,
Goutham

[ggoutham]

Hi,

when i change the db.properties file to default and using the default H2 database it is working fine.
But how can i point it to the alfresco database.

Please help me in this regard…

Thanks in Advance,
Goutham

[jbarrez]

Integrating it in Alfresco is pretty hard, as I remember. It's not only the database, but also things like authentication etc.

In theory changing the db.properties tot the same db as Alfresco should do the trick. If that fails, I actually don't really know what could go wrong without actually seeing a stacktrace.

[guhu1]

What worked for me:
(1) I have a look in the database from alfresco for the used version of activiti. For me it was 5.11
(2) I downloaded the wars (2: explorer and rest) an stored it in the webapps-directory.
(3) I started tomcat to deploy them.
(4) I changed both db.properties files.
(5) i copied the mysql-java*.jar file to the lib-directory of activiti-explorer and activiti-rest (I use mysql instead of postgres).

That works for me.

GuHu

[sureshinitx]

Will you please explain how did u do as i was trying this since last few weeks please note i am using alfresco 4.2.d community version with postfix as backend. The steps what i had done is as follows

1) Downloaded the activiti 5.12 and unzip and put the war files in alfresco webapps folder

2, Start alfresco to deploy the war

3, change the db.properties to point to alfresco ( the backend is postgresql)

db=alfresco
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbcostgresql://localhost:5432/alfresco
jdbc.username=alfresco
jdbc.password=*******

4, Change activiti.cfg.xml as follows

    <property name="databaseType" value="postgresql" />
    <property name="jdbcUrl" value="jdbcostgresql://localhost:5432/alfresco" />
    <property name="jdbcDriver" value="org.postgresql.Driver" />
    <property name="jdbcUsername" value="alfresco" />
    <property name="jdbcPassword" value="*******" />


5, Remove the default database creation and other entities  I had changed the values to false in activiti-standalone-context.xml and in activiti-context.xml

<bean id="demoDataGenerator" class="org.activiti.explorer.demo.DemoDataGenerator" init-method="init">
    <property name="processEngine" ref="processEngine" />

    <!– Set following properties to false if certain demo data is not wanted –>
    <property name="createDemoUsersAndGroups" value="false" />
    <property name="createDemoProcessDefinitions" value="false" />
    <property name="createDemoModels" value="false" />
    <property name="generateReportData" value="false" />
  </bean>


After all the changes when i restart the tomcat the database change to postgresql but not point to alfresco and also it creates the default username and groups  and other entities.

Kindly help me where did i went wrong.

Thanks in advance.

[voula_11]

Hi,

I am using Alfresco Community 5.0 and the newest version of Activiti. I followed your steps and still the integration is not working. The Activiti site exists, but authentication fails when trying to login as an Alfresco admin user.

According to Jeff Potts here http://ecmarchitect.com/archives/2014/11/06/3962, they have removed the workflow console from Alfresco 5.0 Community. Do you think this might be why it's not working?

Should I give up or is this actually possible?

Thanks,
Voula

[guhu1]

Did you have a connection to the database? (see point (5) in my former post).

GuHu

[bimki]

@sureshinitx

try to change:
db=alfresco
into:
db=postgres

@GUHU
I have problems with login into explorer.
I've also marked creating demo data to false:

<property name="createDemoUsersAndGroups" value="false" />
<property name="createDemoProcessDefinitions" value="false" />
<property name="createDemoModels" value="false" />
<property name="generateReportData" value="false" />

But now I'm revceiving:

java.lang.NullPointerException
at org.activiti.explorer.ui.login.DefaultLoginHandler.authenticate(DefaultLoginHandler.java:41)

Anyone can help me?

[frederikherema1]

You can't just throw in activiti-explorer in Alfresco, as you said. A downscaled version of Explorer is shipped with Alfresco Enterprise, which has all the needed customisations done on both sides. Unfortunatly, this is not part of the Community-edition.