Using the Alfresco Activiti Enterprise with PostgreSQL

Using the Alfresco Activiti Enterprise with PostgreSQL


When you download and install the trial version of Alfresco Activiti, you get a functional server, ready to be used for tests, but the database is configured to use H2.

If you want to play with it in a more production like environment, the ideal is to have it connected to a "real" database.

In my case, Im running this Activiti instance in the same server I already have an Alfresco for development, which is already connected to a local PostgreSQL server.
Because of that, I decided to configure Activiti to use PostgreSQL too.

The required steps are easy, and are available in the official documentation here https://docs.alfresco.com/activiti/docs/admin-guide/1.5.0/

What Im going to do here is to provide an as easy to follow step by step procedure to make it work as quick as possible.


Getting the installer


In order to get the installer, you have to fill in a form at https://www.alfresco.com/products/bpm/alfresco-activiti/trial

You will receive an email containing all the links you need to get the installer, the trial license and also links for some documentation pages.

Download the installer you want to use (On this blog post, Im going to use the Linux version. If you are using another option, you will have to adapt the paths accordingly)

Do not forget to download the license too, or you will not be able to use Activiti.


Install Activiti


For the sake of simplicity, I used the default options presented by the installer, so Im going going to describe them here. Simply execute the installer as follow

chmod +x activiti-1.5.0-linux-x64-installer.run
sudo ./activiti-1.5.0-linux-x64-installer.run

Install the license file

cd /opt/activiti/tomcat/lib
sudo cp ~/activiti.lic .

Install the PostgreSQL JDBC driver

cd /opt/activiti/tomcat/lib
sudo wget https://jdbc.postgresql.org/download/postgresql-9.4.1211.jre6.jar

Create a new PostgreSQL database

sudo -u postgres createdb -O alfresco activiti

Configure Activiti to use the created database

cd /opt/activiti/tomcat/lib
sudo vim activiti-app.properties

Comment the lines below

datasource.driver=org.h2.Driver
datasource.url=jdbc:h2:tcp://localhost:9092/activiti
hibernate.dialect=org.hibernate.dialect.H2Dialect

And then uncomment these ones

datasource.driver=org.postgresql.Driver
datasource.url=jdbc:postgresql://localhost:5432/activiti
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
datasource.preferred-test-query=select 1

Thats all.


Testing


Start Activiti using the start-activiti.sh script.
If everything is right, you should be able to access the Activiti console going to http://server:8080/activiti-app

Use the default credentials to connect: admin@app.activiti.com with password admin.

download file now

Popular posts from this blog

UTAUloid Voicebank Download Utane Uta Defoko

Image
UTAUloid Voicebank Download Utane Uta Defoko Name: Utane Uta (Defoko) Gender: Female Age: 15 Weight: - Height: 155 cm Birthday: 5 February 2008 Release: May 10 2008 Likes: Rice Hates: Darume Otoshi Voice Range: E3~G5 Character Item: Rocket Propelled Grenade Creator: Ameya/Ayame Voicebank: Download Here (already converted to Romaji) ----- Uta is packed with UTAU as a default voice bank. She does not come from an organic voice source; that is, her voice is 100% machine synthesized. Her voice bank is from "AquesTalk Female-1," which is distributed free by Aquest Com. Ameya has been granted special permission by the company to feature their software in UTAU. Because of this, and adding the fact that she only has Japanese phonemes, Uta is not for beginners. Though some have tried to come up with quality output using her, this is no easy task, due to her excessive airiness, or lack of voice clarity. Users can attempt to overcome voice quality issues through tweaking of note flags i
Read more

Using a Wii U Pro Controller as an Xbox 360 Controller in Windows 10

Image
Using a Wii U Pro Controller as an Xbox 360 Controller in Windows 10 In some VR applications, the Xbox 360 controller is a hardcoded default. If you dont have one, you may be able to emulate with a tool like x360ce. If you specifically have a Wii U Pro Controller, you can connect via Bluetooth and emulate a 360 controller with the steps below. Heres how: Unzip WiinUSoft Install the SCP driver from the subfolder (right click as Administrator)   Go to Bluetooth settings in Windows Pair with Nintendo controller Run WiinUSoft as Administrator Press the X button on the screen to start emulating Xbox 360 controller with Wii U Pro Controller You can also create custom mappings Here is how it shows up under Game Controllers: Some links: WiinUSoft 2.1.zip Download MS_BT_HotFix.zip Download Downloads - WiinUPro download  file  now
Read more