Information Technology

First, collect some software for support Adempiere running on your linux server.
1. jdk-1_5_0_11-linux-i586-rpm.bin
You can download from :
http://www.filewatcher.com/m/jdk-1_5_0_11-linux-i586-rpm.bin.47746738.0.0.html
2. ADempiere312-PG-linux-java5.jar
You can download from :
http://www.adempiere.com/index.php/Release_312

In this case i'm install at Fedora 12 Unite ( Final Release Rescheduled at 2009-11-17)

1. Testing java version

root@mis-test master]# java -version
java version "1.6.0_0" OpenJDK Runtime Environment (IcedTea6 1.6) (fedora-31.b16.fc12-i386) OpenJDK Client VM (build 14.0-b16, mixed mode)

2. In this case i will use java version 1.5.0_11 for Adempiere,
jdk-1_5_0_11-linux-i586-rpm.bin, change file permissions mode with chmod.

[root@mis-test master]# chmod +x jdk-1_5_0_11-linux-i586-rpm.bin
[root@mis-test master]# ./jdk-1_5_0_11-linux-i586-rpm.bin
bla..bla... more preamble words and agrements, use space bar to forward to next preamble, until you clicking yes.

Extracting... UnZipSFX 5.42 of 14 January 2001, by Info-ZIP (Zip-Bugs@lists.wku.edu). inflating: jdk-1_5_0_11-linux-i586.rpm
Preparing... ################################## [100%]
1:jdk ################################## [100%]
Done.

java installed at folder /usr/java/jdk1.5.0_11

3. Add more statements at profile in etc directory, for java service can running automaticaly when the server restarted.

export JAVA_HOME=/usr/java/jdk1.5.0_11 (path from java installed)
export PATH=$JAVA_HOME/bin:$PATH

and save this file profile and restart your server,
tested server after restarted :

[root@mis-test ~]# java -version

java version "1.5.0_11" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03) Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing)
the server succes installed Java

4. Do this below statement for access control disavled, clients can connect from any host.
[root@mis-test /]# xhost +
access control disabled, clients can connect from any host

5. Create a postgres user as root, log on as postgress and execute the installer.

[root@mis-test /]# useradd -d /home/postgres -m postgres
and copy file cp ADempiere312-PG-linux-java5.jar to folder /home/postgres

[root@mis-test master]# cp ADempiere312-PG-linux-java5.jar /home/postgres/

6. changes the user and/or group ownership of each given file.

[root@mis-test /]# chown -R postgres /home/postgres/

7. create password for user postgres.
[root@mis-test /]# passwd postgres
Changing password for user postgres.
New password: **********
Retype new password: **********
BAD PASSWORD: it is based on a dictionary word BAD PASSWORD: is too simple passwd: all authentication tokens updated successfully.

8. Run ADempiere312-PG-linux-java5.jar, at user postgres.

[root@mis-test /]# su - postgres
[postgres@mis-test ~]$ java -jar ADempiere312-PG-linux-java5.jar
After running that's file, new window will appear, and follow more instruction.


Press OK, appear new window and press Next, and choose radio button " I Accept the terms of this license agrement" and press Next,
This window will appear, and be sure five check box had checked, that is : Base, Postgresql Linux, JDBC, PL java, and Adempiere. press button Next.
Use default path /home/postgres/Adempiere for instalation, and press Next.
New Window appear for Instalation progress. After that appear

Edit the values :
Database type = postgresql
SSL = 4443
WebPort = 8088
and press test and Windows key Store Dialog will appear, and press button Green Check.


And the system will check and testing all options in that window. Windows Finish testing will appear.

press Save,

Press "Yes, I understand and Accept", OK, Next and Done (Finish)




9. Add statement at pg_hba.conf, in folder /home/postgres/Adempiere/postgresql/8.2.0/pgdata

host all all 192.168.0.0/24 trust

more clients can acces this server Adempiere

10. Test the server, to know service postgres was started.

[root@mis-test /]# ps ax|grep postgres
17594 pts/0 S 0:00 /home/postgres/Adempiere/postgresql/8.2.0/bin/postgres
17597 ? Ss 0:00 postgres: writer process
17598 ? Ss 0:00 postgres: stats collector process
18019 pts/0 S+ 0:00 grep postgres

11. Sevice Postgres can start automatic when server reboot, edit more statements on /etc/init.d/ at postgres file.

## EDIT FROM HERE
## enter in path of adempiere
. /home/postgres/Adempiere/postgresql/8.2.0/PGSQL.env
# Installation prefix
prefix=/home/postgres/Adempiere/postgresql/8.2.0

# Data directory
PGDATA="/home/postgres/Adempiere/postgresql/8.2.0/pgdata"

# Who to run the postmaster as, usually "postgres". (NOT "root")
PGUSER=postgres

# Where to keep a log file
PGLOG="$PGDATA/serverlog"

## STOP EDITING HERE

if you not find file postgres, you can create it, with command

[root@mis-test init.d]#nano postgres
and copy these statements below , and paste in your postgres file:

#! /bin/sh

# chkconfig: 2345 98 02
# description: PostgreSQL RDBMS

# This is an example of a start/stop script for SysV-style init, such
# as is used on Linux systems. You should edit some of the variables
# and maybe the 'echo' commands.
#
# Place this file at /etc/init.d/postgresql (or
# /etc/rc.d/init.d/postgresql) and make symlinks to
# /etc/rc.d/rc0.d/K02postgresql
# /etc/rc.d/rc1.d/K02postgresql
# /etc/rc.d/rc2.d/K02postgresql
# /etc/rc.d/rc3.d/S98postgresql
# /etc/rc.d/rc4.d/S98postgresql
# /etc/rc.d/rc5.d/S98postgresql
# Or, if you have chkconfig, simply:
# chkconfig --add postgresql
#
# Proper init scripts on Linux systems normally require setting lock
# and pid files under /var/run as well as reacting to network
# settings, so you should treat this with care.

# Original author: Ryan Kirkpatrick

# $PostgreSQL: pgsql/contrib/start-scripts/linux,v 1.7 2004/10/01 18:30:21 tgl Exp $

## EDIT FROM HERE
. /home/postgres/Adempiere/postgresql/8.2.0/PGSQL.env
# Installation prefix
prefix=/home/postgres/Adempiere/postgresql/8.2.0

# Data directory
PGDATA="/home/postgres/Adempiere/postgresql/8.2.0/pgdata"

# Who to run the postmaster as, usually "postgres". (NOT "root")
PGUSER=postgres

# Where to keep a log file
PGLOG="$PGDATA/serverlog"

## STOP EDITING HERE

# Check for echo -n vs echo \c
if echo '\c' | grep -s c >/dev/null 2>&1 ; then
ECHO_N="echo -n"
ECHO_C=""
else
ECHO_N="echo"
ECHO_C='\c'
fi

# The path that is to be used for the script
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
# What to use to start up the postmaster (we do NOT use pg_ctl for this,
# as it adds no value and can cause the postmaster to misrecognize a stale
# lock file)
DAEMON="$prefix/bin/postmaster"

# What to use to shut down the postmaster
PGCTL="$prefix/bin/pg_ctl"

set -e

# Only start if we can find the postmaster.
test -x $DAEMON || exit 0
# Parse command line parameters.
case $1 in
start)
$ECHO_N "Starting PostgreSQL: "$ECHO_C
su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
echo "ok"
;;
stop)
echo -n "Stopping PostgreSQL: "
su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast"
echo "ok"
;;
restart)
echo -n "Restarting PostgreSQL: "
su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast -w"
su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
echo "ok"
;;
reload)
echo -n "Reload PostgreSQL: "
su - $PGUSER -c "$PGCTL reload -D '$PGDATA' -s"
echo "ok"
;;
status)
su - $PGUSER -c "$PGCTL status -D '$PGDATA'"
;;
*)
# Print help
echo "Usage: $0 {start|stop|restart|reload|status}" 1>&2
exit 1
;;
esac
exit 0

And then change file mode bits execute with command chmod +x postgres


and use this command for updates and queries runlevel information for system ser-
vices :

[root@mis-test init.d]# chkconfig postgres on

Good Luck...