資料庫 & ERP

(原創)Install ADempiere Business Suite 342s On FreeBSD 7.1

install freebsd 7.1(Minimal+ports+X.Org)
login as root
install WGET
cd /usr/ports/ftp/wget
make install clean
rehash

install JDK1.6
cd /usr/ports/distfiles
wget http://www.java.net/download/jdk6/6u3/promoted/b05/jdk-6u3-fcs-src-b05-jrl-24_sep_2007.jar
wget http://www.java.net/download/jdk6/6u3/promoted/b05/jdk-6u3-fcs-bin-b05-jrl-24_sep_2007.jar
wget http://www.java.net/download/jdk6/6u3/promoted/b05/jdk-6u3-fcs-mozilla_headers-b05-unix-24_sep_2007.jar
wget http://shuqun.com/files/bsd-jdk16-patches-4.tar.bz2
wget http://shuqun.com/files/diablo-caffe-freebsd7-i386-1.6.0_07-b02.tar.bz2
wget http://shuqun.com/files/tzupdater-1_3_12-2009a.zip

cd /usr/ports/java/jdk16
make install clean
[X] JAIL      Port is being built within a jail


install PostgreSQL 8.3
cd /usr/ports/databases/postgresql83-server
make install clean

vi /etc/rc.conf
jail_sysvipc_allow="YES"
postgresql_enable="YES"

shutdown -r now
login as root
/usr/local/etc/rc.d/postgresql initdb

#su - pgsql
$psql -d template1 -U pgsql
template1=# alter user pgsql with password 'AdministratorDB';
template1=# \q
$createuser -U pgsql postgres
  Shall the new role be a superuser? (y/n) y
$psql -U pgsql -c "ALTER USER postgres WITH PASSWORD 'DBAdministrator'" template1
$createuser -U pgsql adempiere
  Shall the new role be a superuser? (y/n) n
  Shall the new role be allowed to create databases? (y/n) y
  Shall the new role be allowed to create more new roles? (y/n) y
$createdb -U adempiere -W adempiere
$psql -U pgsql -c "ALTER USER adempiere WITH PASSWORD 'DBUser'" adempiere
$exit

#vi /usr/local/pgsql/data/postgresql.conf
listen_addresses = '*'
#vi /usr/local/pgsql/data/pg_hba.conf
host    all         all         10.2.91.118/24        md5

#/usr/local/etc/rc.d/postgresql restart

#adduser
Username: adempiere
Full name: ADempiere Business Suite
Uid (Leave empty for default):
Login group [adempiere]:
Login group is adempiere. Invite adempiere into other groups? []:
Login class [default]:
Shell (sh csh tcsh nologin) [sh]: csh
Home directory [/home/adempiere]:
Home directory permissions (Leave empty for default):
Use password-based authentication? [yes]:
Use an empty password? (yes/no) [no]:
Use a random password? (yes/no) [no]:
Enter password:
Enter password again:
Lock out the account after creation? [no]:
Username   : adempiere
Password   : *****
Full Name  : ADempiere Business Suite
Uid        : 1002
Class      :
Groups     : adempiere
Home       : /home/adempiere
Home Mode  :
Shell      : /bin/csh
Locked     : no
OK? (yes/no): yes
adduser: INFO: Successfully added (adempiere) to the user database.
Add another user? (yes/no): no
Goodbye!

#vi /home/adempiere/.cshrc
setenv ADEMPIERE_HOME /home/adempiere/Adempiere
setenv JAVA_HOME /usr/local/jdk1.6.0

#shutdown -r now

login as adempiere
>wget http://nchc.dl.sourceforge.net/sourceforge/adempiere/Adempiere_342s.tar.gz
>tar -zxvf Adempiere_342s.tar.gz
>chmod -R +x *.sh
>cd Adempiere
>startx
>./RUN_setup.sh
>cd utils
>./RUN_ImportAdempiere.sh
>./RUN_Server2.sh

Accounts:
GardenAdmin / GardenAdmin
GardenUser / GardenUser
SuperUser / System
System / System