Install Prerequisites

⇐ Table of Contents | Install Prerequisites | Downloading Installers ⇒

In order to run iDempiere you need to have a JDK (not JRE) version of java, and a proper database (PostgreSQL and Oracle are supported).

The examples on this guide are using the following versions:

• Ubuntu 14.04.2 64 bits
• PostgreSQL 9.4.1 (it's also tested and working with version 8.4.22)
• PostgreSQL contrib (for UUID support)
• OpenJDK 1.7.0_75 (for version 2.1 it requires it works with 1.6.0_34)

But this guide can be used in other systems (even Windows) taking care of installing the corresponding packages and using corresponding commands.

Install Ubuntu

Please refer to http://www.ubuntu.com/download

Install PostgreSQL 9.4.1

iDempiere can also run with Oracle 10G or 11G, and also with PostgreSQL 8.4 to 9.3, but for this tutorial we use postgresql 9.4.1 - see http://www.postgresql.org/download/linux/ubuntu/ for details

echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.4
sudo apt-get install postgresql-contrib

Assign a password to user postgres

In order to create the database the installer needs to know the password of user postgres, by default this user doesn't have a password in ubuntu (windows installer asks for a password).

Please take note of the password you assign here as it will be required in the setup process:

Steps are (replace your_chosen_password by your preferred):

sudo su - postgres
psql -U postgres -c "alter user postgres unencrypted password 'your_chosen_password'"
logout

Install OpenJDK 1.7.0_75

sudo apt-get install openjdk-7-jdk
# Note - to work with iDempiere version 2.1 please install openjdk-6-jdk
# Note - to work with iDempiere version 3.0 you can also use oracle java 8

Now you have your prerequisites ready to receive the iDempiere installer

Troubleshooting

Linux

After installing postgres you must check the correct configuration of pg_hba.conf. These two entries must be configured to use password (md5):

local   all         all                               md5
host    all         all         127.0.0.1/32          md5

NOTE that some guides suggest configuring trust - but that creates a security issue on your postgres server.

Windows

Most installation problems in Windows are caused by not configured environment variables:

• PATH must be configured to make the commands psql and jar accessible
• JAVA_HOME environment variable must be configured

This tutorial is brought to you by Carlos Ruiz from GlobalQSS. Feel free to improve directly or suggest using the Discussion tab.