Difference between revisions of "Install on Fedora 10 with PostgreSQL"

This Wiki is read-only for reference purposes to avoid broken links.

Latest revision as of 04:53, 21 November 2011

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:-

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)

Difference between revisions of "Install on Fedora 10 with PostgreSQL"

Latest revision as of 04:53, 21 November 2011

Contents

SUMMARY

SETTING UP THE SUN JDK

SETTING UP THE POSTGRESQL DATABASE

SETTING UP THE ADEMPIERE SOFTWARE

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools