Setup on Tomcat with PostgreSQL

Tomcat

Download and unpack Apache Tomcat 8.0.x from here.

PostgreSQL

Install postgresql on Linux (Debian-based) with:

sudo apt-get update

sudo apt-get install postgresql postgresql-contrib

Create Database

Create the default database for Eclipse Dirigible:

sudo -i -u postgres

createdb dirigible_database

Create System User for the Eclipse Dirigible Database

psql dirigible_database

create user dirigible_system with password ‘dirigible1234’;

grant all on database dirigible_database to dirigible_system;

Datasource Configuration

  1. Download the postgresql JDBC driver version 4.1 from here.
  2. Copy the postgresql-*.jar file to the */lib* directory.

Set the Environment Variables

1
2
3
4
5
6
7
8
9
10
11
12
export DIRIGIBLE_DATABASE_PROVIDER=custom
export DIRIGIBLE_DATABASE_CUSTOM_DATASOURCES=POSTGRES
export DIRIGIBLE_DATABASE_DATASOURCE_NAME_DEFAULT=POSTGRES
export POSTGRES_DRIVER=org.postgresql.Driver
export POSTGRES_URL=jdbc:postgresql://localhost:5432/dirigible_database
export POSTGRES_USERNAME=dirigible_system
export POSTGRES_PASSWORD=dirigible1234
export DIRIGIBLE_SCHEDULER_DATABASE_DRIVER=org.postgresql.Driver
export DIRIGIBLE_SCHEDULER_DATABASE_URL=jdbc:postgresql://localhost:5432/dirigible_database
export DIRIGIBLE_SCHEDULER_DATABASE_USER=dirigible_system
export DIRIGIBLE_SCHEDULER_DATABASE_PASSWORD=dirigible1234
export DIRIGIBLE_SCHEDULER_DATABASE_DELEGATE=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate

Deploy

Copy the deployable artifact e.g. ROOT.war to */webapps*.

Start

Run Tomcat server via strtup.sh.

Go to the following locations:

http://localhost:8080/

Edit