10 Langkah Konfigurasi Menjalankan Adempiere

10 Langkah Konfigurasi Menjalankan Adempiere DI CentOS 5.5 dan Ubuntu 12.04

Step Pertama Buat Usser baru untuk acces Adempiere.
1. Tambahkan user adempiere

/usr/sbin/useradd adempiere
    /usr/sbin/passwd adempiere
    -----------------------------------------------------
    /usr/home $ usseradd -m adempiere (untuk ubuntu)
    /usr/home $ passwd adempiere (untuk ubuntu)
    /usr/home $ usserdel adempiere (untuk menghapus user)

2. Extract file adempiere

• Atau apabila file sudah di extrac langsung copy file ke /opt/

cp Adempiere_360LTS.010.tar.gz /opt/
    cd /opt/Adempiere
    tar -zxvf Adempiere_360LTS.010.tar.gz

3. Rubah owner folder adempiere

• Lakukan perintah dibawah ini di lokasi /opt/

chown -R adempiere:adempiere Adempiere

4. Setting profile user adempiere

cd /home/adempiere

vi .bashrc
    export ADEMPIERE_HOME=/opt/Adempiere
    export JAVA_HOME=/opt/jdk.1.6.0_33 (sesuai versi yang digunakan)

vi .bash_profile
    export ADEMPIERE_HOME=/opt/Adempiere
    export JAVA_HOME=/opt/jdk1.6.0_33

5. Install Java

• Download jdk-6u33-linux-x64.bin dari internet.

• Copy file jdk-6u33-linux-x64.bin ke direktori /opt/

• Rubah permission file agar bisa diinstall [root@adempiere opt]# cd ~
  [root@adempiere ~]# cd /opt/
  [root@adempiere opt]# chmod +x jdk-6u33-linux-x64.bin

• Instal jdk1.6.0_33 [root@adempiere opt]# ./jdk-6u33-linux-x64.bin
  
• Setelah selesai akan terbentuk folder dan file-file java di direktori opt [root@adempiere opt]# ls -la
  total 153960
  drwxr-xr-x 8 root root 4096 Oct 16 14:37 jdk1.6.0_33

• Mengaktifkan java yang sudah terinstal [root@adempiere opt]# update-alternatives --install "/usr/bin/java" "java" "/opt/jdk1.6.0_33/bin/java" 1
  [root@adempiere opt]# update-alternatives --install "/usr/bin/javac" "javac" "/opt/jdk1.6.0_33/bin/javac" 1
  [root@adempiere opt]# update-alternatives --install "/usr/bin/javaws" "javaws" "/opt/jdk1.6.0_33/bin/javaws" 1
  [root@adempiere opt]# update-alternatives --set java /opt/jdk1.6.0_33/bin/java
  [root@adempiere opt]# update-alternatives --set java /opt/jdk1.6.0_33/bin/javac
  [root@adempiere opt]# update-alternatives --set java /opt/jdk1.6.0_33/bin/javaws

[root@adempiere etc]# /opt/

echo “export JAVA_HOME=/opt/jdk1.6.0_33” >> /etc/profile
    echo “export PATH=$JAVA_HOME/bin” >> /etc/profile

• Cek java running [root@adempiere etc]# java -version
  java version "1.6.0_33"
  Java(TM) SE Runtime Environment (build 1.6.0_33-b03)
  Java HotSpot(TM) 64-Bit Server VM (build 20.8-b03, mixed mode)

• Restart server

6. Setting file adempiere properties

cd /opt/Adempiere
    vi AdempiereEnv.properties

• Catatan : Jika file akan di edit alngkah baiknya file asli di copy terlebih dahulu.

cp /AdempiereEnvTemplate.properties AdempiereEnv.properties

• Gambaran Seperti ini yang harus di edit :

#AdempiereEnv.properties
#Mon Nov 05 15:50:33 WIT 2012
ADEMPIERE_FTP_SERVER=172.16.x.x
ADEMPIERE_FTP_PREFIX=my
ADEMPIERE_DATE_VERSION=2010-06-14
ADEMPIERE_DB_PASSWORD=adempiere
ADEMPIERE_JNP_PORT=1099
ADEMPIERE_DB_SYSTEM=passwordpostgres
ADEMPIERE_MAIL_SERVER=172.16.x.x
ADEMPIERE_DB_NAME=adempiere
ADEMPIERE_KEYSTORECODEALIAS=adempiere
ADEMPIERE_KEYSTOREPASS=mypassword
ADEMPIERE_ADMIN_EMAIL=
ADEMPIERE_HOME=/opt/Adempiere
ADEMPIERE_MAIN_VERSION=360LTS.015
ADEMPIERE_FTP_PASSWORD=user@host.com
ADEMPIERE_MAIL_USER=
ADEMPIERE_DB_USER=adempiere
ADEMPIERE_JAVA_OPTIONS=-Xms1024m -Xmx2048m -XX\:NewSize\=512m -XX\:MaxNewSize\=512m -XX\:PermSize\=512m -XX\:MaxPermSize\=512m -XX\:+DisableExplicitGC
ADEMPIERE_APPS_TYPE=jboss
ADEMPIERE_APPS_SERVER=172.16.x.x
ADEMPIERE_DB_PORT=5432
ADEMPIERE_FTP_USER=anonymous
ADEMPIERE_KEYSTOREWEBALIAS=adempiere
ADEMPIERE_DB_PATH=postgresql
ADEMPIERE_SSL_PORT=4443
ADEMPIERE_WEB_ALIAS=172.16.x.x
ADEMPIERE_MAIL_UPDATED=
ADEMPIERE_WEB_PORT=8080
ADEMPIERE_DB_URL=jdbc\:postgresql\://172.16.x.x\:5432/adempiere
ADEMPIERE_APPS_DEPLOY=/opt/Adempiere/jboss/server/adempiere/deploy
ADEMPIERE_DB_SERVER=172.16.x.x
ADEMPIERE_KEYSTORE=/opt/Adempiere/keystore/myKeystore
ADEMPIERE_MAIL_PASSWORD=
JAVA_HOME=/opt/jdk1.6.0_33
ADEMPIERE_DB_TYPE=postgresql
ADEMPIERE_DB_VERSION=2011-10-03
ADEMPIERE_JAVA_TYPE=sun

7. Setting PosgreSQL terlebih dahulu sebelum menjalankan silensetup.sh

• Tempatkan software postgres di /opt
• chmod +x nama file
• ./ nama file
• Perintah : - Database Server = Y
  - Slony = N
  - PGJDBC = Y
  - Postgis = N
  - PsqLODBC = N
  - PgBouncer = Y
  - PgMemcache = Y
  - Pa Agent = Y
  - Is The Selection = Y
  - Database Instalation Tuning = Y
  - Update Notification Service = N
  - User Account = Y
  - Email [] = insert email
  - Password = insert password Email
  - Choose an Option = 3
  - OLTP system choose an Option = 1
  - Password Postgres = insert password
  - Continue = Y
  - Lounch Stack Builder = N

• /opt/postgres/8.0/bin - su postgres
  - ./createuser P adempiere
  ./createdb adempiere -O adempiere
  ./psql
  \l (untuk melihat database)
  \q (untuk keluar dari database)

• edit pg_hba.conf (vi /opt/postgres/8.4ss/data/pg_hba.conf) → isikan IP yg akan akses database

TYPE DATABASE USER CIDR-ADDRESS METHOD
"local" is for Unix domain socket connections only
local all all md5
IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 172.16.0.0/16 md5
host adempiere adempiere 172.16.0.0/16 md5
host adempiere postgres 172.16.0.0/16 md5
IPv6 local connections:
host all all ::1/128 md5

• edit pg_hba.conf (vi /opt/postgres/8.4ss/data/postgresql.conf) - listen_addresses = '*'
  - password_encryption = on (optinal)
  
  • Membuka Firewall
  Membuka firewall port sudo iptables -A INPUT -p tcp --dport 5432 -j ACCEPT
  
  • Membackup Database
  ./pg_restore -P 5432 -d adempiere -U adempiere /home/ademdb/DbAdempiere.backup
  ./pg_dump -d adempiere -U adempiere /home/ademdb/DbAdempiere.backup
  
  • Membackup Database format *.dmp
  ./psql -U adempiere adempiere < /opt/Adempiere/data/Adempiere_pg.dmp

• Create New Database di pgadmin

name : adempiere
owner : adempiere
collation : UTF-8
Caracter : UTF-8
Privilages : Centang All
SQL : ketik script "drop language phgsql" tekan F5
-Pilih DB adempiere
-Centang No Owner
Note : jika pada saat kita drop database tidak bisa, putuskan terlebih dahulu koneksi dari adempiere ke database.
8. Jalankan /opt/Adempiere $ ./RUN_silensetup.sh
9. Jalankan /opt/Adempiere $ ./RUN_Setup2.sh
10. Selesai ...