Install iDempiere, Open Source ERP, on a AWS Linux Server in 10 Min

Hi Everyone,

The purpose of this post is to record how to quickly install iDempiere on an AWS Ubuntu server. You do not need to use AWS. Any modern Ubuntu server should do fine.

***
Update (06/08/2014): The below script works best on ubuntu 12.04. phpPGAdmin does not work on newer ubuntu versions with the below script. As soon as I have the time to resolve the issue, I will update the script accordingly.
***

***
Update (07/08/2013): Here is a newer post that makes installation easier and faster. It also helps you better understand how to install iDempiere for better performance and scalability.
***

The purpose of this post is to remind me of the quickest path to get to iDempiere up and running from scratch. There are much better tutorials if you need more detail and options. Here is an example by Carlos Ruiz, one of the principal iDempiere developers.

Note: there is a shortcut list of commands listed toward to bottom of this post.

1. If you need to ‘see’ a desktop, follow these instructions to install a lightweight desktop that you can turn on and off.
2. Issue “sudo apt-get update”.
3. Install the database using “sudo apt-get install postgresql postgresql-contrib phppgadmin”.
   1. Note that postgresql-contrib and phppgadmin are optional. The contrib library includes extra tools. Phppgadmin is a web-based db admin tool. Here is a link to a phppgadmin install tutorial.
   2. Enter the DB command utility using “sudo -u postgres psql”.
   3. Change the ‘postgres’ password using “\password postgres” Note: enter you postgresql password and write it down. You will need it later.
   4. Exit the DB utility using “\q” .
4. Install Java using “sudo apt-get install openjdk-6-jdk”.
5. Go to your home directory using “cd ~”.
6. Create a directory for your installer “mkdir installer_20130410”.
7. Go to your new directory “cd installer_20130410”.
8. Download the iDempiere installer “wget http://jenkins.idempiere.com/job/iDempiereDaily/ws/buckminster.output/org.adempiere.server_1.0.0-eclipse.feature/idempiereServer.gtk.linux.x86_64.zip”.
   1. Note: the above links to the 64bit Linux installer.
   2. Note: the above links you to the cutting edge of the code base (the head).
   3. Note: here is the link to the 32-bit Linux installer.
9. Unzip the new file “unzip idempiereServer.gtk.linux.x86_64.zip”.
10. Go to the server directory “cd idempiere.gtk.linux.x86_64/idempiere-server/”.
11. Run the setup using “sh console-setup.sh”.
    1. Note: the defaults for most fields are acceptable. The default appears in brackets for each prompt.
    2. Note: the DB server should be “localhost” if installed locally.
    3. Note: remember your db admin password from above.
    4. Note: add some URL for the mail server or you will enter an endless loop.
12. Go to the utils directory “cd utils/”.
13. Import the seed iDempiere database “sh RUN_ImportIdempiere.sh”.
14. Go back a directory “cd ..” .
15. Start the server “sh idempiere-server.sh”
16. Go to a web browser and enter the url of your server. For example: “http://ec2-54-224-78-219.compute-1.amazonaws.com:8080/webui/”
    1. Note: iDempiere uses port 8080 by default.
    2. The Username and passwords are either
       1. SuperUser / System or
       2. superuser @ idempiere.com / System Note: the space in the email is intended.

I hope this helps. Here is a video to help you learn how to use the system. It uses ADempiere (iDempiere’s twin); therefore, the navigation will be slightly different. That said, you should be able to pick up the basics quite quickly.

Here is tutorial on how to keep iDempiere running after you disconnect your SSH client (like putty).

To make things even easier, I can prepare you an iDempiere AMI with all the bells and whistles installed. Just contact me with the request.

Here is a short list of commands used above. Posted for future quick reference:

• sudo apt-get –yes update
• sudo apt-get –yes install postgresql postgresql-contrib phppgadmin
• sudo -u postgres psql
• \password postgres
• \q
• sudo apt-get –yes install openjdk-6-jdk
• mkdir /home/ubuntu/installer_`date +%Y%m%d`
• wget http://jenkins.idempiere.com/job/iDempiereDaily/ws/buckminster.output/org.adempiere.server_1.0.0-eclipse.feature/idempiereServer.gtk.linux.x86_64.zip -P /home/ubuntu/installer_`date +%Y%m%d`
• sudo apt-get –yes install unzip
• unzip /home/ubuntu/installer_`date +%Y%m%d`/idempiereServer.gtk.linux.x86_64.zip -d /home/ubuntu/installer_`date +%Y%m%d`
• cd /home/ubuntu/installer_`date +%Y%m%d`/idempiere.gtk.linux.x86_64/idempiere-server/
• sh console-setup.sh
• cd utils/
• sh RUN_ImportIdempiere.sh
• cd ..
• sh idempiere-server.sh
• or “nohup ./idempiere-server.sh &” if you want to disconnect and keep iDempiere running.
• Resources
  • phppgadmin install tutorial
  • Change phppgadmin port in the following locations
    • sudo nano /etc/apache2/ports.conf
    • sudo nano /etc/apache2/sites-enabled/000-default
    • sudo service apache2 restart (start stop)

ADempiere vs iDempiere vs Openbravo vs Compiere

Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.