Adempire ERP Installation on Linux

HOWTO: ADempiere Installation on Ubuntu (with PostgreSQL 8.2 and PL/Java )
About Adempiere
ADempiere is a commons-based peer-production of Open Source ERP Applications.


- Requirements
Java JDK for Linux
Adempiere Zip Archives
PostgreSQL
Pljava
- Installing and Configuring PostgreSQL for Pljava
Go to System --> Administration -->Synaptic Package Manager
Search for JDK and PostgreSQL and pgAdmin3
Choose sun-6-JDK for java
Choose PostgreSQL 8.2
Choose pgAdmin3
Right Click and do Mark for installation for all of them
Do Apply
It will download and install PostgreSQL, JDK java and PGadmin3 for you
Configure pljava support for postgresql:

Download the precompiled binaries package:
for postgresql-8.1: from pgfoundry.org
for postgresql-8.2: http://www.posterita.org/share/pljava.zip

- Configure so that postgres user is trusted (edit pg_hba.conf and do postgresql server restart after) While you're at it, remember to also configure adempiere user access in pg_hba.conf (I just set it to trust for local access) : -
Once PostgtreSQL has been installed, 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
- Then Unzip pljava.zip and Copy pljava.so and pljava.jar from the pljava package to /usr/lib/postgresql/VERSION(e.g. 8.2)/lib

- Link libjvm.so (without it, pljava install will fail, I choose linking than adding entries to ld.so.conf) :
ln -s /usr/lib/jvm/java-1.5.0-sun/jre/lib/i386/server/libjvm.so /usr/lib/libjvm.so


Configuring your JAVA HOME and ADEMPIERE HOME

Download Adempiere package:
Url : http://sourceforge.net/project/downloading.php?groupname=adempiere&filename=Adempiere_353a.tar.gz&use_mirror=nchc
OR
Url: http://ftp.heanet.ie/disk1/sourceforge/a/ad/adempiere/Adempiere_353a.zip

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
- Add the following lines to end of postgresql.conf :
custom_variable_classes = 'pljava'
pljava.classpath='/usr/lib/postgresql/8.2/lib/pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = ' '
pljava.debug = false
- Then to environment (/etc/postgresql/VERSION/main/environment)
JAVA_HOME = '/usr/lib/jvm/java-6-sun'
Also do this:
export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
export ADEMPIERE_HOME=/home/arief/Adempiere

and remember to put those lines on the end of ~/.bashrc too.


Configuring Postgresql and create Postgresql database
# su postgres
# psql -d template1
template1=# ALTER USER postgres WITH PASSWORD '${POSTGRESQL_POSTGRES_PASSWORD}';
Now go to Applications --> System tools --> pgAmin III
PgAdmin III
Do a New Server Register Registration
New Server 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
New Role
Create a database and assign the owner to adempiere



- 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 < /home/user/Adempiere/data/Adempiere_pg.dmp Installing Adempiere
on Server, I do:
chmod 755 *.sh utils/*.sh

Then execute: Server/RUN_setup.sh


On the configuration setup screen, I usually setup webserver port to: 8080 and 4433, so that I could run Adempiere as regular user. For database, don't forget to set it to postgresql. If on testing the configuration you failed to connect to the web or database, try changing the host to '127.0.0.1' or localhost or your computer name and re-test.

If test all passed, you can save the config (click the Save button) then just wait for the setup to finish.
If all's fine with the postgres-pljava setup, we should move along just fine here. And when it's all done. We could start the Adempiere Server with:
Server/utils/RUN_Server2.sh (Don't close this service terminal panel)

And then we could start client by:
Client/RUN_Adempiere.sh

at first run it will ask for configuration. Just fill it the values you put on the server setup.

After that, Client should started up and showing nice graphs and dashboards. This is where I get amazed and confused and pressed the Quit button :-)
Adempiere Logging Details :
After the complete installation go to the web browser and access this Appliction by web interface :
Url: http://your-host-name:8080/

Initially you can log into the system with the following users:
Usage-----------------------------------User----------Password

System Management-----------------------System--------System
System Management or any role/company---SuperUser-----System
Sample Client Administration------------GardenAdmin---GardenAdmin
Sample Client User----------------------GardenUser----GardenUser



Note : if any one have any queries please do contact on this mail kha_pradnesh@yahoo.com. I would like to help you.

Screen Shot:


------------:Thank you so much:----------