high performance ssd vps
sound byJbgmusic
If we have helped you in our small way, please consider buying us a cup of coffee to keep us going or exit by clicking our sponsored links. Thank you.

Enter Amount:

Thank for sponsoring our site.
Please login to Automatic Backlinks and activate this site.
JoomlaWatch Stats 1.2.9 by Matej Koval
Google PageRank Checker
Install Adempiere ERP on Ubuntu Karmic Koala PDF Print E-mail
Written by Administrator   
Sunday, 25 April 2010 20:16
Article Index
Install Adempiere ERP on Ubuntu Karmic Koala
Setup Environment / Postgres
Install Adempiere
All Pages

 

Adempiere is an open source ERP solution which is another fork of the popular Compiere ERP. In any case, it took me a while to figure out the installation as the Adempiere site does not have a very clear installation procedure. So to help me remember and probably help out others, I have compiled below the steps to install Adempiere. There are only a few requirements for Adempiere to work, Java, Postgres (my preference), and Adempiere. If your are installing on Ubuntu Server Edition, you need to install X11, I have included it here.

So let's go.

 

 



STEP 1: Install Ubuntu 9.10 (Karmic Koala)

Won't explain how to download and install Ubuntu, except to mention that when you use Ubuntu Server, don't install anything if you want Adempiere to use port 80 except maybe OpenSSH if you are going to access via putty. Please set your server to use a static IP address, as the same IP will be used in the setup.

 

Update: works with Ubuntu Lucid (10.04)

 

STEP 2: UPDATE Ubuntu

$sudo apt-get update <--- Update package list
$sudo apt-get upgrade <--- Upgrade to latest packages

 

STEP 3: Setup an Adempiere user (optional).

The steps creates a user 'adempiere' and makes it a member of admin
Setup a dedicated adempiere user to handle Adempiere.

$ sudo adduser adempiere <--- name of user to manage Adempiere
$ sudo adduser adempiere admin <--- add to admin group

Login as user adempiere.

STEP 4: Get all Downloads

Download in one go all the necessary components. The gdm is necessary in the installation of Adempiere, however, if you are using Ubuntu Desktop, you may skip this step.

 

Note: In Ubuntu Lucid, Sun Java has been moved to the Partner repositories, so just activate this in your sources list.

 

$ sudo apt-get install xorg gdm gnome-core <--- Get graphical user interface (for Ubuntu Server install only)
$ sudo apt-get install postgresql sun-java6-jdk sun-java6-fonts sun-java6-jre sun-java6-plugin wget unzip <-- Get Postgres, Java, wget, and unzip
$ wget http://downloads.sourceforge.net/project/adempiere/ADempiere%20Official%20Release/Adempiere%203.4.2-stable/Adempiere_342s.zip?use_mirror=cdnetworks-us-2 <--- download latest stable version of Adempiere

 

Note: if you are not comfortable with wget, you can download the Adempiere files here.

 

update: You may replace this with the latest version Adempiere LTS (3.6.0)

 



STEP 5: Setup the environment

Edit /etc/hosts and add a Fully Qualified Domain Name (fqdn) like adempiere.company.com to identify the adempiere machin

127.0.0.1 localhost
127.0.1.1 adempiere
192.168.0.1 adempiere.company.com <-- change to your ip address, add your ip as host, you need this to be able to access from outside your server

Add the ff at the end of your /etc/profile, so that whenever you login it will be set.

$ sudo nano /etc/profile <---- store here to declare variables globally

export JAVA_HOME="/usr/lib/jvm/java-6-sun" <---- declare JAVA_HOME environment variable
export ADEMPIERE_HOME="/opt/Adempiere" <---- declare ADEMPIERE_HOME environment variable

Edit your pg_hba.conf to reflect the changes in bold font.

$ sudo nano /etc/postgresql/8.4/main/pg_hba.conf <---- add your host in trusted list for Postgres

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.0.161/24 trust <<<<---- use your ip address here

Edit your postgresql.conf. Look for listen_addresses and uncomment it i.e. remove the # (comment) and replace localhost by a '*' to allow it to listen to any hosts.

$ sudo nano /etc/postgresql/8.4/main/postgresql.conf

listen_addresses = '*' <---- to allow postgres to listen from other hosts

Restart Postgres
$ sudo /etc/init.d/postgresql-8.4 restart <--- restart to effect changes


$ sudo unzip Adempiere_342s.zip -d /opt <---- unzip Adempiere program to /opt directory, if you don't want to use /opt make sure to make necessary changes to      $ADEMPIERE_HOME

 

STEP 6: Setup up the Database (Postgres)

$ sudo su - postgres <--- switch to postgres user
$ /usr/bin/createdb adempiere <---- create adempiere database
$ /usr/bin/createuser adempiere <---- create user adempiere
$ echo "ALTER USER adempiere WITH passWORD 'yourpw';" | psql <---- create a password for user adempiere and pipe it to psql
$ psql -h localhost -d adempiere -U adempiere <      $ADEMPIERE_HOME/data/Adempiere_pg.dmp <--- import/create database schema to be used by Adempiere
$ exit <--- switch back to adempiere user

 


STEP 7: Install Adempiere

$ cd      $ADEMPIERE_HOME <--- go to      $ADEMPIERE_HOME
$ sudo chmod +x *.sh <---- make all shell scripts executable
$ sudo ./RUN_setup.sh <---- execute setup script, a window will popup.

Note: Click <Test>, follow the wizard. Everything should indicate OK. Then press <Save>. Then press <OK> when another popup appears. Wait until compilation is complete.

  1. If you have Apache installed, you may need to change the webport to 8080.
  2. Enter adempiere.company.com for your apps directory/folder
  3. Enter adempiere.company.com for your db directory/folder


STEP 8: Start the server

$ cd      $ADEMPIERE_HOME/utils <--- go to utility folder
$ sudo ./RUN_Server2.sh <--- execute the server, wait for it to start listening

STEP 9: Access your Adempiere installation

Go to a brower and type in http://adempiere.company.com:port/admin
Go to a browser and type in http://adempiere.company.com:port/webui

Note: Default user/password is SuperUser/System, this is case sensitive. Play around with the sample GardenWorld company.

STEP 10: Stop the server


Open another terminal window
$ cd      $ADEMPIERE_HOME/utils
$ sudo ./RUN_Server2Stop.sh <--- if it won't stop, just press <CTRL-C> were the Adempiere Server is listening, it will shutdown normailly.

STEP 11: Installing as a service

 

Note:  Do this only, if you are sure you have a working Adempiere install

 

Open another terminal window

$ cd      $ADEMPIERE_HOME/utils/unix

$ sudo cp adempiere_Debian.sh adempiere_Ubuntu.sh   <-- make a copy to preserve original

$ sudo nano adempiere_Ubuntu.sh

EXECDIR=/opt/Adempiere   <--- replace /home/adempiere/Adempiere to reflect install of Adempiere
ADEMPIEREUSER=root        <--- since we are using a restricted area for the install and to avoid permission problems on startup, we have to use root as user

# ENVFILE=/home/adempiere/.bashrc    <--- comment out this line

 

Change the following line

su $ADEMPIEREUSER -c "cd $EXECDIR/utils;$EXECDIR/utils/RUN_Server2Stop.sh &> /dev/null &"

to

su $ADEMPIEREUSER -c "cd $EXECDIR/utils;$EXECDIR/utils/RUN_Server2Stop.sh &> $LASTLOG &"  <-- prevents errors in shutdown


MAXITERATIONS=90 # 2 seconds every iteration, max wait 2 minutes) <-- (Optional) To increase timeout for start/stop of server


$ sudo mv adempiere_Ubuntu.sh /etc/init.d   <--- move to boot scripts

$ sudo update-rc.d adempiere_Ubuntu.sh defaults   <--- automatically create run-level links

 

You now have a fully automatic Adempiere install, it will start and stop when you open and close your server.

 

Restart your server.  Wait a while before using as the service takes a while to start.

 

You may also use the following command to control your Adempiere

$ sudo /etc/init.d/adempiere_Ubuntu [start|stop|restart|status|condrestart]  <-- Inside brackets are choices available.

 

That's it! Enjoy.

Thanks to all the numerous websites/forums that helped me figure out the installation of Adempiere.
Time to study Adempiere.

 

Update:  Just did this for the latest version of Adempiere LTS (3.6.0) and Ubuntu Lucid Server (10.04), and it works.

Last Updated on Wednesday, 06 October 2010 12:25
 
Comments (9)
error on database port
9 Thursday, 15 December 2011 13:40
danishfa
Dear,

I'm using Ubuntu 11.10 and everything is okay.
But when I run ./RUN_setup.sh
I see warning:
Error Port Database
(DB Server Port = 5432)

Can't I repair that and How?
Thanks

Regards,
I couldn't access my Adempiere installation
8 Thursday, 27 January 2011 00:57
Pekoi
I had to remove the libtcnative-1 package from my linux installation - used by previous Jboss versions.
Adempiere + Ubuntu
7 Thursday, 13 January 2011 00:09
pete_pablo
STEP 7: Install Adempiere:

...
1. If you have Apache installed, you may need to change the webport to 8080.
2. Enter adempiere.company.com for your apps directory/folder
3. Enter adempiere.company.com for your db directory/folder
....

what does it mean?

thx
error message
6 Thursday, 23 September 2010 04:44
Bob Meyers
There error message I got was:
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "adempiere", database "adempiere", SSL on
FATAL: no pg_hba.conf entry for host "127.0.0.1", user "adempiere", database "adempiere", SSL off
error install
5 Thursday, 23 September 2010 04:40
Bob Meyers
I tried the above on two Ubuntu systems but neither worked. On the Ubuntu Lucid 10.04 I could not enter a "web port" without error. On the other a 9.10 Karmic I got error trying to run step 6 "psql" command, error message: "psql -h localhost -d adempiere -U adempiere nks for the very well written tutorial!

Nice tunes:)
Administrator's reply:
Nice catch
Friday, 24 September 2010 13:22
Administrator
Oops, my mistake. The unzip should be prior to that command, I have adjusted the article to reflect the change.
Error Email Admin
4 Sunday, 19 September 2010 21:44
clp3z
***o! I have an error on "Email Admin", how i should to do for solved it? I tried changing the file pg_hba.conf, but don't work, it show this message for console:

ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:25 - Connection refused [15]
09:08:58.382 ConfigurationData.testMailServer: SMTP Server NOT available [15]
testPort[190.207.204.193, 110]
-----------> ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:110 - Connection refused [15]
09:08:58.383 ConfigurationData.testMailServer: POP3 Server NOT available [15]
testPort[190.207.204.193, 143]
-----------> ConfigurationData.testPort: Open Socket adempiere.company.com/190.207.204.193:143 - Connection refused [15]
09:08:58.384 ConfigurationData.testMailServer: IMAP4 Server NOT available [15]
-----------> ConfigurationData.testMailServer: No active Mail Server [15]
-----------> ConfigurationData.testMail: Not verified EMail = info@XXUser

Thanks!
Works perfect.
3 Thursday, 05 August 2010 22:39
crazyabs
works perfect in ubuntu 10.04 and adempiere 3.6Lts

just to add. for the noobies like me. when using nano and editing the script. if you gonna save the file just press F2.... *** it took me a long time to know that. lol.
Adempiere + Ubuntu Lucid + Service Startup on Boot
2 Sunday, 16 May 2010 04:02
Ahmad H. Ashkanani
What an excellent tutorial. It worked like a charm on my Ubuntu 10.04. However,i was unable to setup Adempiere to start automatically upon PC startup. I have tried following up related material on the internt but i failed;It won't startup. Can you shed some light on the subject?Many thanks
Adempiere + Ubuntu Lucid + Service Startup on Boot
1 Sunday, 16 May 2010 04:00
Ahmad H. Ashkanani
Hi,
What an excellent tutorial. It worked like a charm on my Ubuntu 10.04. However,i was unable to setup Adempiere to start automatically upon PC startup. I have tried following up related material on the internt but i failed;It won't startup. Can you shed some light on the subject?Many thanks
Administrator's reply:
Service startup
Tuesday, 18 May 2010 21:49
Administrator
I have added the procedure to set it as a service at boot time

Add your comment

Your name:
Your email:
Subject:
Comment:
  The word for verification. Lowercase letters only with no spaces.
Word verification: