Rangkuman Instllasi Adempiere , PostgreSQL , iReport di Centos 5.3 (FInal)

 

PostgreSQL Driver

wget http://jdbc.postgresql.org/download/postgresql-8.3-603.jdbc3.jar

mv postgresql-8.3-603.jdbc3.jar /var/lib/pgsql/

8d postgresql user

Set up user

* set a password for postgres

passwd postgres

8e export path input to profile

vi /var/lib/pgsql/.bash_profile

export JAVA_HOME=/usr/java/jdk1.6.0_11/

export ADEMPIERE_HOME=/opt/Adempiere

PATH=$PATH:$HOME/bin:$JAVA_HOME/bin

Selain itu jalankan juga di console yang akjan digunakan untuk install

9. add adempiere user + profile

* Add adempiere user

useradd adempiere

passwd adempiere

su – adempiere

vi ~/.bash_profile

* Add these two lines before the path

export JAVA_HOME=/usr/java/jdk1.6.0_11/

export ADEMPIERE_HOME=/opt/Adempiere

PATH=$PATH:$HOME/bin:$JAVA_HOME/bin

dan jalankan juga di console..

10. masukkan juga di user admin

vi ~/.bash_profile

export JAVA_HOME=/usr/java/jdk1.6.0_11/

export ADEMPIERE_HOME=/opt/Adempiere

PATH=$PATH:$HOME/bin:$JAVA_HOME/bin

11. INSTALL PGADMIN

12. edit postgresql conf

vi /var/lib/pgsql/data/postgresql.conf

listen_addresses = ‘192.168.11.2’

13. change password postgres di postgresql

psql -d template1 -U postgres

alter user postgres with password ‘postgres_password’;

14. Create adempiere user dan database di postgresql

create user/role:

klik kanan Login Role : New Login Role

name : adempiere

checkmark superuser, can create database, can create roles, can modify catalog

create database

klik kanan databases – new

name : adempiere

owner : pilih adempiere

encoding UTF8

15. run script :

ref : http://www.depesz.com/index.php/2007/10/04/ident/

cd /opt/Adempiere/data

#kalau error, cuekin ajah

psql -U adempiere -d adempiere -c “drop schema sqlj cascade”

psql -U adempiere -d adempiere -f Adempiere_pg.dmp >> dump_errors.log

19. LOG OFF dan LOGIN untuk mereload parameter path

20. install adempiere

cd /opt/Adempiere

sh RUN_setup.sh

JAVA HOME : /usr/java/jdk1.6.0_11

Application server: 192.168.11.2

Web port : 8080

Database server: 192.168.11.2

Database type: Postgresql

database name : adempiere

klik TEST

setelah tidak ada error, klik SAVE

setelah sukses, jalankan server adempiere

/opt/Adempiere/utils/RUN_Server2.sh

setelah selesai jalan, jalankan adempiere client :

/opt/Adempiere/RUN_Adempiere.sh

dan jalankan juga client under web :

http://192.168.11.2:8080

user: GardenAdmin

Pass: GardenAdmin

30. install ireport

extract iReport

move ke /opt

copy tools.jar ke lib iReport

40. masukkan postgresql ke dalam service startup

50. autologin

autorun Adempiere Server

# gdmsetup

masukkan ke autologin

#create file /opt/Adempiere/RUN_autologin.sh :

/opt/Adempiere/run_adempiere_server

cd /opt/Adempiere/utils

./RUN_Server2.sh

chmod 755 /opt/Adempiere/RUN_autologin.sh

# masukkan admin sebagai sudo

su -> /usr/bin/visudo

add line:

admin ALL=NOPASSWD: /opt/Adempiere/RUN_autologin.sh

sebagai user non root (menggunakan admin)

# masukkan autorun adempiere

gnome-session-properties

pilih tab STARTUP PROGRAM – add

gnome-terminal -x sudo /opt/Adempiere/RUN_autologin.sh

——————————————-

60. FIREWALL

Accept If protocol is TCP and destination port is 5432

Accept If protocol is TCP and destination port is 8080

5432 8080 1099 1098

Advertisements

One thought on “Rangkuman Instllasi Adempiere , PostgreSQL , iReport di Centos 5.3 (FInal)

  1. Very great post. I just stumbled upon your blog and wished
    to mention that I’ve really enjoyed surfing around your webog
    posts. In any case I’ll be subscribing for your feed and
    I hope you write again very soon!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s