Ubuntu Install Howto710
From ADempiere
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
Requirements
* 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
./jdk-1_5_0_13-linux-i586.bin
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
./enterprisedbpg_x86-32.bin
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 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
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