Install on Ubuntu 10.04 LTS

From ADempiere ERP Wiki
Jump to navigationJump to search

Table of Contents{{#if: Getting Started| | Getting Started }}{{#if: Installing ADempiere Manually| | Installing ADempiere Manually }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Install on Ubuntu 10.04 LTS{{#if: Launching the ADempiere Application| | Launching the ADempiere Application }} ⇒

Installation of prerequisites[edit]

After installing Ubuntu Server 10.04.2 LTS, there are two more packages to install: PostgreSQL and Java JDK.

sudo apt-get install postgresql-8.4 default-jdk

Set some important environmental variables

export JAVA_HOME=/usr/lib/jvm/default-java
export ADEMPIERE_HOME=/opt/Adempiere

Installation of ADempiere[edit]

Download ADempiere.

wget -b

Unzip the downloaded file, and put into the /opt directory

mv download Adempiere_360LTS.tar.gz
tar zxvf Adempiere_360LTS.tar.gz
sudo mv Adempiere /opt/.

Follow the steps described in Application Server Installation & Setup

N.B. If you are installing without a graphical display, use instead of

  1. Copy the into an AdempiereEnv.Template file
  2. Edit to suit your installation.
  3. Run the, while keeping close watch of any error messages that show up.
sudo ./


1. The setup stops because it cannot connect to the database user named, postgres. You will need to reset the password of postgres into 'postgres' as this is the password used by Adempiere to connect.

sudo su - postgres
psql -d template1
psql> ALTER USER postgres WITH PASSWORD 'postgres';

You need to change the password back to a secure one after installing Adempiere.

2. After running for the first time, you will notice the following error:

===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation "ad_table" does not exist
  Position: 15; State=42P01; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(
        at org.postgresql.core.v3.QueryExecutorImpl.execute(
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

This means that you need to Initialize the ADempiere Database.

cd utils
sudo ./

Post installation steps[edit]

Launching the Application Server

sudo ./

N.B. Use GNU screen before running the Application Server.