Install on Ubuntu 10.04 LTS

From ADempiere
Revision as of 04:33, 16 May 2011 by Renrengabas (Talk) (Troubleshooting)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

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

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

Download ADempiere.

wget -b http://sourceforge.net/projects/adempiere/files/ADempiere%20Official%20Release/Adempiere%203.6.0-LTS%20Laura%20Edition/Adempiere_360LTS.tar.gz/download

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 RUN_silentsetup.sh instead of RUN_setup.sh:

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

Troubleshooting

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';
psql>\d

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

2. After running RUN_silentsetup.sh 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(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
etc... 

This means that you need to Initialize the ADempiere Database.

cd $ADEMPIERE_HOME
cd utils
sudo ./RUN_ImportAdempiere.sh

Post installation steps

Launching the Application Server

screen
cd $ADEMPIERE_HOME/utils
sudo ./RUN_Server2.sh

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