Install ADempiere in Ubuntu
By: Onno W. Purbo


$ su
# useradd -d /home/postgres -m postgres
# chown -R postgres /home/postgres/
# passwd postgres

# apt-get install sun-java5-bin sun-java5-demo sun-java5-fonts
# apt-get install sun-java5-jdk sun-java5-jre sun-java5-plugin

vi /etc/environment
        PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/lib/jvm/java-1.5.0-sun/bin"
        LANG="en_US.UTF-8"
        JAVA_HOME="/usr/lib/jvm/java-1.5.0-sun/"
        ADEMPIERE_HOME="/home/postgres/Adempiere"
        COMPIERE_HOME="/home/postgres/Compiere2"


Booting & login as postgres

$ vi .profile
	export JAVA_HOME="/usr/lib/jvm/java-1.5.0-sun/"
	export ADEMPIERE_HOME=/home/postgres/Adempiere/

Booting & login as postgres

# apt-get install postgresql-8.2 postgresql-client-8.2 pgadmin3

# vi /etc/postgresql/8.2/main/pg_hba.conf
	# 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         127.0.0.0/8           trust
	host    all         all         192.168.0.2/2         trust
	# IPv6 local connections:
	host    all         all         ::1/128               trust

Get http://www.posterita.org/share/pljava.zip
# unzip pljava.zip -d /opt/`


# vi /etc/postgresql/8.2/main/postgresql.conf
	listen_addresses = '*'
	dynamic_library_path = '\$libdir:/opt/pljava'
	custom_variable_classes = 'pljava'
	pljava.classpath = '/opt/pljava/pljava.jar'


# vi /etc/ld.so.conf
	$JAVA_HOME/jre/lib/i386
	$JAVA_HOME/jre/lib/i386/client
	$JAVA_HOME/jre/lib/i386/native_threads
or
	/usr/lib/jvm/java-1.5.0-sun/jre/lib/i386
	/usr/lib/jvm/java-1.5.0-sun/jre/lib/i386/client
	/usr/lib/jvm/java-1.5.0-sun/jre/lib/i386/native_threads

# ldconfig
# /etc/init.d/postgresql-8.2 restart


Applications --> System tools --> pgAmin III
	Do a New Server Register Registration
	Create a role as adempiere with password adempiere + privileges
	Create a database and assign the owner to adempiere

Alternative
$ su - postgres
$ createuser -P -E -d adempiere
	password
	password
	y
$ createdb -E UTF8 -O adempiere adempiere
	

postgres@laptop:~$ su - postgres
Password: 
postgres@laptop:~$ createuser -P -E -d adempiere
Enter password for new role: 
Enter it again: 
Shall the new role be a superuser? (y/n) y
CREATE ROLE
postgres@laptop:~$ createdb -E UTF8 -O adempiere adempiere
CREATE DATABASE
postgres@laptop:~$ 


# cp /home/postgres/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

# cp jboss-4.2.1.GA-src.tar.gz /usr/local/src/
# cd /usr/local/src/
# tar zxvf jboss-4.2.1.GA-src.tar.gz
# cd /usr/local/src/jboss-4.2.1.GA-src/build
# /usr/local/src/jboss-4.2.1.GA-src/build
# chown +x build.sh
# ./build.sh

$ su - postgres
$ psql -d adempiere </home/postgres/Adempiere/data/Adempiere_pg.dmp

Logout + Boot + login as postgres

$ cp Adempiere_330.tar.gz /home/postgres
$ tar zxvf Adempiere_330.tar.gz
$ cd Adempiere/
$ chmod a+x RUN_*
cd /home/postgres/Adempiere/utils/
$ ln -s RUN_UnixEnvTemplate.sh RUN_UnixEnv.sh
cd /home/postgres/Adempiere
$ ./RUN_setup.sh 


$ ./RUN_adempiere.sh