Install on Fedora 10 with PostgreSQL

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

SUMMARY

Note:-

  • 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

SETTING UP THE SUN JDK

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
./jdk-6u13-linux-i586-rpm.bin
  • 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)

SETTING UP THE POSTGRESQL DATABASE

  • 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
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
# "local" is for Unix domain socket connections only
local   all         all                               md5
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         127.0.0.1/32          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
\q
  • Then type exit on the postgresql shell to go back to your normal shell
  • Setup the Postgres JDBC connector
wget http://jdbc.postgresql.org/download/postgresql-8.3-603.jdbc3.jar
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

SETTING UP 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/RUN_ImportAdempiere.sh

(If you get this error: /opt/Adempiere/utils/RUN_ImportAdempiere.sh: line 8: ./myEnvironment.sh: 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
sh RUN_setup.sh
  • You will be shown screen as below:-

Adempiere-setup.png

  • 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/AdempiereEnv.properties 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/RUN_Adempiere.sh
  • 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/RUN_Server2.sh
  • Fire up your web browser and login to this address (provided that you use port 80)
http://localhost/admin
  • If you want to access your Web Interface from the network, run this command
sh /opt/Adempiere/utils/RUN_Server2.sh -b youripaddress
  • Login to the system by using the username=SuperUser and password=System

Wariola 19:41, 13 April 2009 (PDT)