Ubuntu Install Howto710

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

This is a guide to how to install and configure PostgreSQL 8.3 with Pljava 1.4 on Ubuntu 7.10 for Adempiere


   * Java JDK for Linux jdk1.5.0_13
   * Adempiere 3.4.0 Zip Archives
   * PostgreSQL 8.3 
   * Pljava 1.4

Configuring your JAVA HOME and ADEMPIERE HOME

   *  Copy the java jdk (jdk-1_5_0_13-linux-i586.bin) to your home directory for e.g. /home/user/
   *  Open a terminal ( Application -->> Accessories -->> Terminal )
   *  Type in the command 

Installing and Configuring PostgreSQL 8.3 for Pljava

   *  Copy the PostgreSQL 8.3 (edb-linux-x86_82412-2.tar.gz) to your home directory for e.g. /home/user/
   *  unzip edb-linux-x86_82412-2.tar.gz
   *  Open a terminal ( Application -->> Accessories -->> Terminal )
   *  Type in the command 
 You will need root rights to proceed
   * Once PostgtreSQL has been install, Open a terminal
   * Do sudo -i and and enter your password (to login as root)
   * gedit /etc/postgresql/8.2/main/pg_hba.conf
   * Change the authentication method to trust
   * Add your database host IP under IPv4 if you are on a network (in my case my IP is 

 # Database administrative login by UNIX sockets
 local   all         postgres                          trust
 # "local" is for Unix domain socket connections only
 local   all         all                               trust
 # IPv4 local connections:
 host    all         all          trust
 host    all         all      trust
 # IPv6 local connections:
 host    all         all         ::1/128               trust

Unzip the pljava.zip to /opt/

 unzip pljava.zip -d /opt/
   *  gedit /etc/postgresql/8.2/main/postgresql.conf 

Look for listen_addresses and uncomment it i.e. remove the # and replace localhost by a *

   *  For pljava you will need these variable and add these lines to postgresql.conf 
 dynamic_library_path = '\$libdir:/opt/pljava'
 custom_variable_classes = 'pljava'
 pljava.classpath = '/opt/pljava/pljava.jar'
   *  Now edit /etc/ld.so.conf 
 gedit /etc/ld.so.conf
   *  Add these lines to ld.so.conf 
 Replace <home of java> with the directory of your java ex. /home/user/jdk1.5.0_13
 <home of java>/jre/lib/i386
 <home of java>/jre/lib/i386/client
 <home of java>/jre/lib/i386/native_threads
   *  Do ldconfig to reload the configuration 
   * Now restart the PostgreSQL Server 
 /etc/init.d/postgresql-8.3 restart

Open a terminal and type in

su postgres
createuser -P -E -d adempiere
createdb -E UTF8 -O adempiere adempiere

Installing Pljava

   * To proceed with pljava installation you will need postgresql.jar
   * Login as root on a terminal
   * Copy it postgresql.jar and put it /opt/pljava (do it under root) 
 cp /home/user/Adempiere/lib/postgresql.jar /opt/pljava
 java -cp postgresql.jar:pljava.jar:deploy.jar org.postgresql.pljava.deploy.Deployer -database adempiere -user adempiere -password adempiere -install