Setup on Tomcat with PostgreSQL

Prerequisites

Download and unpack Apache Tomcat 8.0.x from here.

More information about how to deploy on Tomcat can be found here.

macOS

brew install ttyd

Linux

Linux support is built-in

More info about ttyd can be found at: ttyd

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

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