Install on Fedora 10 with PostgreSQL

From ADempiere
Revision as of 04:53, 21 November 2011 by Chessmarcosz (Talk) (SETTING UP THE ADEMPIERE SOFTWARE)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.



  • This guide was written on the 12th April 2009 and 1st revision was finished on 14th April 2009 (GMT+8)
  • This is the 1st time I've ever written a guide, so any comment / amendment is much appreciated
  • Fedora Linux is the Upstream for Redhat/Centos and thus is more bleeding edge and platform for the adoption of new technology which will be included in Redhat upon maturity
  • The current version of Fedora as of writing is Fedora 10, which is the basis of this guide. The latest version, Fedora 11 will be coming out in a months time
  • I will be using PostgreSQL from the official repo to maintain consistency
  • The Java setup guide is not that comprehensive, I will tidy them up later as the way I do it is quite confusing for new user
  • All command are running under the root user unless specified otherwise
  • Make sure SELinux is turned off / permissive mode


If you Install Fedora from scratch:-

  • Install using the Fedora DVD
  • Customize your installation by selecting PostgreSQL database and deselecting the OpenJDK runtime
  • login to your fedora system
  • Download the Sun Java SE Development Kit here
  • Upon finish download, change the file permission so that its executable
chmod a+x jdk-6u13-linux-i586-rpm.bin
  • Extract the bin file file
  • Install the RPM file
rpm -ivh jdk-6u13-linux-i586-rpm
  • Check your java version by running
java -version

and it should show something like below

java version "1.6.0_11"
Java(TM) SE Runtime Environment (build 1.6.0_11-b03)
Java HotSpot(TM) Client VM (build 11.0-b16, mixed mode, sharing)

If you use your current fedora system:-

  • Adempiere use Sun JDK and JRE for it to work. If you are using OpenJDK, please follow this guide
  • Check your java version by running, upon altering your JDK
java -version

and it should show something like below

java version "1.6.0_11"
Java(TM) SE Runtime Environment (build 1.6.0_11-b03)
Java HotSpot(TM) Client VM (build 11.0-b16, mixed mode, sharing)


  • Install PostgreSQL from the command line/terminal
yum install postgresql postgresql-server
  • Start the database for the first time
service postgresql initdb
  • Start the PostgreSQL service
service postgresql start
  • If you install PostgreSQL from the repo, by default it will create a postgres user for the rights to use the database
  • For basic database connection please ensure your /var/lib/pgsql/data/pg_hba.conf as below
# "local" is for Unix domain socket connections only
local   all         all                               md5
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all          md5
host    all         all          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser
  • please ensure that the line with md5 is inserted above the default IPv4 local connections setup
  • Then restart the Postgresql database by running the command
service postgresql restart
  • Create a password for the user postgres by issuing the command below
passwd postgres
  • Then type your password when prompted to by the system
  • There is no password for postgres user in the postgresql database by default, so we need to create one by running the command below
psql -d template1 -U postgres
alter user postgres with password 'yourpostgresuserpassword';
  • We need to create the adempiere database to be used by the Adempiere application
createuser --pwprompt --encrypted --no-adduser --no-createdb adempiere
createdb --encoding=UNICODE --owner=adempiere adempiere
alter user adempiere with password 'youradempiereuserpassword';

(the first command will create the adempiere user while the second command will create the adempiere database named 'adempiere' owned by user adempiere)

  • Exit the #template1 shell by issuing command
  • Then type exit on the postgresql shell to go back to your normal shell
  • Setup the Postgres JDBC connector
mv postgresql-8.3-603.jdbc3.jar /var/lib/pgsql/
  • After that restart your database server by issuing this command
service postgresql restart
  • Now we can start setup the Adempiere software


  • Download the latest release of the adempiere software here
  • Move the software to the /opt folder and unzip it
cp /home/username/Download/Adempiere_353a.tar.gz /opt
tar xvzf /opt/Adempiere_353a.tar.gz 
  • This will create the /opt/Adempiere folder in your fedora system
  • Next,import the sample database to Postgres by issuing this command
sh /opt/Adempiere/utils/

(If you get this error: /opt/Adempiere/utils/ line 8: ./ File does not exist; then first set ADEMPIERE_HOME and JAVA_HOME variables, see instructions below)

  • Go to your /opt/Adempiere by issuing this command
cd /opt/Adempiere
  • You will be shown screen as below:-


  • Fill in appropriately with all the values

Some Notes

  • For the App Server, choose Jboss and set the port (default is port 80, choose another number if you are running web server on that port)
  • For the Database Server, Choose Postgresql. Put the database name=adempiere, database user=adempiere, port=5432, system password='yourpostgresuserpassword' and database password='youradempiereuserpassword'
  • Then hit test. If all things ok as it should, click save. The system will generate the necessary value (this will take some time)
Note: You can also set the value using the text editor by editing the /opt/Adempiere/ file
  • Set your java home and Adempiere home folder. Run this command (provided that you install JDK from RPM)
set JAVA_HOME=/usr/java/jdk1.6.0_11/bin/java
set ADEMPIERE_HOME=/opt/Adempiere
  • Then lets run this Adempiere Monster
sh /opt/Adempiere/
  • The Java Client will pop-up and voila, You can start playing with it
  • For the Jboss Web Interface, run command as below
sh /opt/Adempiere/utils/
  • Fire up your web browser and login to this address (provided that you use port 80)
  • If you want to access your Web Interface from the network, run this command
sh /opt/Adempiere/utils/ -b youripaddress
  • Login to the system by using the username=SuperUser and password=System

Wariola 19:41, 13 April 2009 (PDT)