2013年9月2日月曜日

iDempiere Installation.

install iDempiere_v1.0b@fedora18.LatitudeD630



iDempiere Install しました。
I have installed the iDempiere.


idempiere の installer が出来ましたと、聞きしました。
idempiere には、OSGi が入ったので、
開発の勉強もしないと思っていました。

I've heard about the Installer of idempiere.
Idempiere based  on compiere,adempiere, and OSGi too,
I had thought that I had to study it's development.


しかし、installer を使って install してみると、
ADempiere の install と殆ど全く同じです。

When I installed it using it's installer,
It was almost all same as ADempiere's Installation.


以前、adempiere360 を fedora13 に install しました。
この時、postgresql が Jboss に繋がらなくて、困りました。
When I installed adempiere360 in fedora13,
I was troubled that it wasn't able to connect postgresql with Jboss.


重要な事は、
postgresql と Tomcat が、
一緒の hostComputer に同居していても、
UnixDomainSocket 通信ではなく、
TcpSocket 通信をすると言う事。

The important things are ::
it communicates not with unix domain socket but with tcp socket,
even if postgresql and Tomcat installed together in same host computer.


environment variable Settings for JDK , PostgreSQL , Idempiere.

in PostgreSQL,
at datadase name:idempiere ,
user:adempiere に操作権限を与える事。
Give user:adempiere the operation privileges.

以上で install は、成功します。
他の事は、些細な事でした。
That's all. Installation shall succeed.
The other things are trifles.

*********** prepair Host Machine ************************

install Fedora18@Dell_Latitude_D630
java version :: openjdk-1.7.0.25.x86_64

そして、hostname を決める。
And determine the hostname.

serverなので、固定 IP address を決める。
So server, determine the fixed IP address.

PostgreSQLを installし、動く様にする。
Install the PostgreSQL, and setting to work.

*********** stop iptables , SELinux *********************

# systemctl enable firewalld.service
stop firewall
# systemctl disable firewalld.service

stop SELinux
# vi /etc/selinux/config
SELINUX=permissive

:: SElinuxは警告を出力するが、アクセス制限は無効
:: SElinux works in warning, but access restrictions invalid

************ JDK ****************************************

environment variable Settings for JDK
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
env_java_var

JAVA_HOME=/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.25.x86_64
export JAVA_HOME

PATH=$JAVA_HOME:$JAVA_HOME/jre/bin:$PATH
export PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


************* PostgreSQL server *************************

environment variable Settings for PostgreSQL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

PGDATA=/var/lib/pgsql/data
MANPATH=/usr/share/man
LD_LIBRARY_PATH=/usr/lib64/pgsql
export PGDATA MANPATH LD_LIBRARY_PATH

PATH=/usr/bin:$MANPATH:$LD_LIBRARY_PATH:$PATH
export PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

今回も、
db-server_postgresql と idempiereのTomcat が、
一緒の hostComputer に同居していても、
やはり、TcpSocket 通信が出来る様に、
postgresql.conf , pg_hba.conf を設定します。

Also in this time,
It configures "postgresql.conf" and "pg_hba.conf",
to communicate with tcp socket,
even if postgresql and Tomcat installed together in same host computer.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
vi /var/lib/pgsql/data/postgresql.conf
59: listen_addresses = '*'
63: port = 5432
87 or 91: password_encryption = on

vi /var/lib/pgsql/data/pg_hba.conf
86: host all all 192.168.0.0/24 trust
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   
configure pgsql
# systemctl enable postgresql.service
start pgsql
# systemctl start postgresql.service


test connectinon

$ su -
# su - postgres
$ psql

$ psql -h 192.168.0.90


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

次に、この PostgreSQL 内に、idempiere の data を import する為、
to import the idempiere data inside PostgreSQL,

create ::
database-name: idempiere
database-user: adempiere

この adempiere user に、table 作成 などの権限を与えます。
give the PRIVILEGES to the user:adempiere.

postgres=# CREATE USER adempiere WITH PASSWORD '********' CREATEDB;
postgres=# CREATE DATABASE idempiere;
postgres=# GRANT ALL PRIVILEGES ON DATABASE idempiere to adempiere;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

environment variable Settings for Idempiere
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

IDEMPIERE_HOME=/opt/idempiere/idempiere-server
export IDEMPIERE_HOME

PATH=$IDEMPIERE_HOME:$IDEMPIERE_HOME/utils:$PATH
export PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



環境設定を1つの shell script file にまとめる。
"実行権限"を与える。
summarize the environment variable Settings
in the single shell script file.
give the "execute permission".

************* /etc/profile.d/env_var_idempiere.sh *******

#!/bin/sh
#
#
# vi /etc/profile.d/env_var_idempiere.sh :: chmod +x
#
#
# ~~~~~~~~~~~~~ env_java_var ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#
JAVA_HOME=/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.25.x86_64
export JAVA_HOME
#
PATH=$JAVA_HOME:$JAVA_HOME/jre/bin:$PATH
export PATH
#
# ~~~~~~~~~~~~~ env_pgsql_var ~~~~~~~~~~~~~~~~~~~~~~~~~~
#
POSTGRES_HOME=/var/lib/pgsql
PGDATA=/var/lib/pgsql/data
MANPATH=/usr/share/man
LD_LIBRARY_PATH=/usr/lib64/pgsql
export PGDATA MANPATH LD_LIBRARY_PATH
#
PATH=/usr/bin:$MANPATH:$LD_LIBRARY_PATH:$PATH
export PATH
#
# ~~~~~~~~~~~~~ env_idempiere_var ~~~~~~~~~~~~~~~~~~~~~~~
#
IDEMPIERE_HOME=/opt/idempiere/idempiere-server
export IDEMPIERE_HOME
#
PATH=$IDEMPIERE_HOME:$IDEMPIERE_HOME/utils:$PATH
export PATH
#
#
# ~~~~~~~~~~~~~ end ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



***************** Iinstall Idempiere ********************

Install IdempiereServer

Unzip the server installer you downloaded or created,

cd $IDEMPIERE_HOME
unzip idempiereServer.gtk.linux.x86_64.zip

Navigate to the idempiere-server folder


***************** Import the Data ***********************

# cd utils
# sh RUN_ImportIdempiere.sh

*************** setup Idempiere server ******************

# setup.sh




参考までに  For reference
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

JAVA JAVA_HOME
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.25.x86_64

ADempiere ADempiere_HOME /opt/idempiere/idempiere-server

key store pw ********


app svr application server d630fc18.lan
web port 8080
ssl 8443


db svr database server name d630fc18.lan
database PostgresSQL
database name(SID) idempiere
TNS *(idempiere)
database port 5432
system pw ********
database user name adempiere
database pw ********


mail svr mail server d630fc18.lan
mail info@d630fc18.lan
mail user info
mail pw ********

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Key store dialog
(ON) Common Name d630fc18.lan
(OU) Organization Unit root
(O) Organization AdempiereUser
(L) Local/Town MyTown
(S) State Cosmos
(C) Country (2 Char) JP

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


"BUILD SUCCESSFUL"
"Total time: 1 second"

と、出れば、成功です。
And, if appears this Msg, it is successful.


************ lunch Idempiere server *********************

# idempiere-server.sh


************* Starting Automatically on Boot **********

put launch-script in etc/rc.d/rc.local

これ、fc18では、OKですが、他のversionでは、???
It is OK in fc18, but in the other version,? ? ?

# vi /etc/rc.d/rc.local

#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.
#
#
# ~~~~~~~~~~~~~ Launch_idempiere-server ~~~~~~~~~~~~~~~~
#
# IDEMPIERE_HOME/idempiere-server.sh
#
# change directory and launch iDempiere Server
cd /opt/idempiere/idempiere-server
./idempiere-server.sh
#
# ~~~~~~~~~~~~~ end ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





*************** setup new client ************************

setup new client

Login Login
name : System
pw : System
Role : System Administrator
Client : System
Organization :*

Menu > System Admin > Client Rules > Initial Client Setup Process

Client Name : ABC
Org Key : abc
Organization Name : ABC Co.,Ltd
Admin User Name : admin
Normal User Name : user
Currency : JPY
Country " Japan
Check All(5) Accounting Checkboxes
Chart of Account : AccountingUS.csv ............
.......... /idempiere/idempiere-server/data/import/AccountingUS.csv

Do you want to start the Process?

** OK
Client=ABC Organization=ABC Co.,Ltd Role=ABC Admin Role=ABC
User User/Contact=admin/admin User/ Contact=user/user
Calendar=ABC Calendar Element=ABC Account Account Element # 53
Accounting Schema=ABC UN/35 Japanese Yen Acct.Schema
Element=Organization Acct.Schema Element=Account Acct.Schema
Element=Product Acct.Schema Element=BPartner ---- Campaign=Standard
Sales Region=Standard Business Partner Group=Standard
Business Partner=Standard Product Category=Standard
Tax=Standard Product=Standard Sales Representative=user
Sales Representative=admin Project=Standard Cash Book=Standard


log off : System .......... ( System 内 )
log in : admin ............. ( ABC 内 )
pw : admin
Role : ABC admin
Client : ABC
Warehouse : Standard

and check anything
open window : Warehouse & Location
open window : Organization

and
open window : Import File Loader
< Select file to Load > AccountingUS.csv
Import Format : Accounting-Accounts

Click Check Button
to start loading into "temporary Import Account" window


check next
open window : Import Account
open window : Accounting Schema
open window : Calendar Year and Period


****************************************************************

0 件のコメント:

コメントを投稿