-- edi baek blogs -- everyone to share: PostgreSQL Installation on Ubuntu (with PL/Java) for ADempiere

Instalasi Adempiere di Ubuntu

Requirements

Java JDK for Linux
Adempiere Zip Archives
PostgreSQL
Pljava

Configuring your JAVA HOME and ADEMPIERE HOME

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

  ./jdk-6-linux-i586.bin

Copy the Adempiere_.zip to your home directory for e.g. /home/user/
Right click on the zip file and do extract here
It will create a folder Adempiere with all the its files and folders

Go to your home directory /home/user/ on your file browser
Go to View -->> Show Hidden Files on the menu bar ( or simply Ctrl + h )
Open .profile file and add the following lines at the bottom

  export JAVA_HOME=/home/user/jdk1.6.0/
export ADEMPIERE_HOME=/home/user/Adempiere/

You need to logout and relogin for it to take your JAVA HOME and ADEMPIERE HOME

Installing and Configuring PostgreSQL for Pljava

Go to System --> Administration -->Synaptic Package Manager
Search for PostgreSQL and pgAdmin3
Right Click and do Mark for installation
Do Apply
It will download and install PostgreSQL for you
Download the Pljava from Adempiere wiki
For 64bit users, download from pljava64bit from Sim IT Sdn Bhd

  This is precompiled pljava for PostgreSQL 8.2 taken from Adempiere wiki

For other versions of PostgreSQL, you can download you pljava at here.

  You will need root rights to proceed

Once PostgtreSQL has been install, Open a terminal
Do su and and enter your password (to login as root)
Do passwd postgres to set the user postgres a password which is required
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 192.168.0.161)

  # Database administrative login by UNIX sockets
local   all         postgres                          trust

  # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

  # "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         192.168.0.161/24      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

  $JAVA_HOME/jre/lib/i386
$JAVA_HOME/jre/lib/i386/client
$JAVA_HOME/jre/lib/i386/native_threads
$JAVA_HOME/jre/lib/i386/server

Do ldconfig to reload the configuration

Now restart the PostgreSQL Server

  su - postgres
/etc/init.d/postgresql-8.2 restart

Now go to Applications --> System tools --> pgAmin III
Do a New Server Register Registration
- Enter the database host IP
- Give a description
- Enter the password that you have set for user postgres

Creating a role and database

Create a role as adempiere with password adempiere and give it all privileges
Create a database and assign the owner to adempiere
Alternatives:
Open a terminal and type in

Create User/Role and Database

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
cd /opt/pljava
java -cp postgresql.jar:pljava.jar:deploy.jar org.postgresql.pljava.deploy.Deployer -database adempiere -user adempiere -password adempiere -install

Issues with libjvm.so

Edit /etc/ld.so.conf as root

  su
gedit /etc/ld.so.conf

Replace $JAVA_HOME and put the exact path (/home/user/jdk1.6.0/) and it should be as follows

  /home/user/jdk1.6.0/jre/lib/i386
/home/user/jdk1.6.0/jre/lib/i386/client
/home/user/jdk1.6.0/jre/lib/i386/native_threads
/home/user/jdk1.6.0/jre/lib/i386/server

Do ldconfig to reload the configuration

Install your pljava

Importing the database dump

Go to pgAdminIII
Connect to the server
Go to Adempiere database and drop cascade sqlj schema
Now you can import your database
Open a terminal and type in

  su - postgres
psql -d adempiere

Export/Backup Database

Open a terminal and type in

  su - postgres
pg_dump -U username -cif > /home/user/filename.dmp dbname

Installing Adempiere

Go to $ADEMPIERE_HOME
Run RUN_setup.sh and enter your credentials, test and save
Once it's done, then run RUN_Adempiere.sh to start Adempiere

I tried this guide and while it was very useful it still didn't work with me, so here is what I changed in order to install Adempiere on Ubuntu 7.04 (March 2008):

1- I downloaded and installed java JDK using Synaptic instead of downloading it and then installing it as suggested here.

 - System --> Administration --> Synaptic
- Enter password if asked for it.
- Click "Search" and type JDK
- Choose Sun-6-JDK and install it
- Since your Java_Home will be different now then

 Change:-
export JAVA_HOME=/home/user/jdk1.6.0/
export ADEMPIERE_HOME=/home/user/Adempiere/

 To:-
export JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.00/  
export ADEMPIERE_HOME=/home/user/Adempiere/

Check if that path is correct and if the Java-6-sun is correct or not by looking to the folder name

2 - PLjava used here is broken and could give you errors when you try to install it, instead use the one in this link: http://pgfoundry.org/frs/?group_id=1000038&release_id=1024

3 - If you got a "Permission denied" error when you try to install Adempiere , go to Adempiere folder under root and change the permissions of the whole folder to allow it to be installed