Postgres create db script

[fchatzia]

Hi,

I want to set activiti explorer running with postgres so  i change the configuration of the activiti-5.10\setup\build.db.properties file to see my postgres db and i also change the activiti-5.10\apps\apache-tomcat-6.0.32\webapps\activiti-explorer\WEB-INF\classes\db.properties file but when i run activiti explorer it doesn't work. I was wondering if i need to run any script to create the activiti db into postgres. The content of db.properties and build.db.properties is this:

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

[trademak]

Hi,

So you have a database created in PostgreSQL with the name "activiti" ?
To run the Activiti Explorer with PostgreSQL you only have to change the db.properties in the WEB-INF classes.

Best regards,

[vvpds_ram]

Hi,

db.properites entries should be..

db=pgsql
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbcostgresql://localhost:5432/Activiti  (it will be different for others)
jdbc.username=postgres (Username)
jdbc.password=**** (password)

make sure the java driver for postgressql postgresql-9.3-1102.jdbc4.jar (it might vary for versions) in the activiti "lib" directory.

[blvnt]

I had tried this, but still can't access activiti explorer on web browser. any ideas?

[stephane1]

To make it work, I've changed the following parameters:
db=postgres
jdbc.url=jdbcostgresql://localhost/activiti

Also I have used a dedicated connection role rather than the prebuilt postgres account.