Installing step of Adempiere ERP and database
First Install Database
(Install Postgresql8.4)
install postgresql through
net
Step1 .
sudo apt-get install postgresql
sudo apt-get install postgresql
Step2.
After install postgresql path will be having postgrsql at 3 different location
After install postgresql path will be having postgrsql at 3 different location
as per my
system
location1 :
/var/lib/postgresql/8.4/
location2 :
/usr/share/postgresql/8.4
location3 :
/etc/postgresql/8.4/
Location1 :
/usr/share/postgresql/8.4/x
no pg_hba.conf.sample
available
Location2 :
/usr/share/postgresql/8.4/pg_hba.conf.sample
configuration has to check
@remove-line-for-nolocal@# "local" is for Unix
domain socket connections only
@remove-line-for-nolocal@local all
all
@authmethod@
# IPv4 local connections:
#host all all 127.0.0.1/32 trust
host postgres postgres
127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 @authmethod@
Location3 :
/etc/postgresql/8.4/pg_hba.conf
configuration has to check
# Database administrative login by UNIX sockets
local all postgres trust
# TYPE DATABASE USER
CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections
only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host adempiere adempiere 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 md5
NB: Location3 is actual
configuration file for pg_hba.conf
Step3:
Now check postgresql.conf using location3
Now check postgresql.conf using location3
listen_addresses = 'localhost' # what IP address(es) to listen on;
#
comma-separated list of addresses;
#
defaults to 'localhost', '*' = all
#
(change requires restart)
port = 5432
NB: listen_addresses
and post will be close by #. just remove # then
listen_addresses and post will be active.
Step4 : Now created user
Command : createuser -P -E -d adempiere
Step5 : Create Database
command : createdb -O adempiere adempiere
Step6 : now do Adempiere dump using flowing commad
Commnd :
psql -d adempiere < Adempiere.dmp
wait for few moment. Your database will be inserted.
-----------------------------------------------------------------------
Do host setting/ or check
setting
path for host : /etc/host
192.168.52.101 debobrota-Compaq-Presario-C700-Notebook-PC # Added by NetworkManager
127.0.0.1 localhost.localdomain localhost
::1 debobrota-Compaq-Presario-C700-Notebook-PC localhost6.localdomain6 localhost6
127.0.1.1 debobrota-Compaq-Presario-C700-Notebook-PC
# The following lines are desirable for IPv6 capable hosts
::1 localhost
ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
NB: this checking is required when
you will do ./RUN_setup.sh (this is adempiere file)
Do profile or bash_profile setting
path for host : /root/
then go to /view/show hidden file
----------------------------------------
export JAVA_HOME=/u01/jdk1.6.0_16
export ADEMPIERE_HOME=/u01/Adempiere
export PATH=$JAVA_HOME/bin:$PATH
export PATH
unset USERNAME
NB: Remember do the same path setting for each user login.
Example when u will login using root then go to profile (if ubuntu) and .bash_profile(if
fedora)
same way when you will login by other user then set same path
in the file.
Important Link :
8.
http://www.adempiere.com/index.php/ADempiere_Install_Linux%26PostgreSQL
No comments:
Post a Comment