Author:  Van hees Michel <michel_AT_vanhees.cc>
Contributor:  
Release supported: e-smith SME 5.6 & 6.0b3
License: GPL
Last updated: Wednesday, August 06, 2003 08:49 AM

Problem: Install ofOpengroupware
Solution:  Follow this HowTo
NOTE: The installation of POSTGRES is needed by this howto.
All the installation are made with user ROOT.

rpm -ivh opengroupware-gstep-make*.rpm
rpm -ivh opengroupware-gstep-objc*.rpm
rpm -ivh opengroupware-libfoundation*.rpm
rpm -ivh opengroupware-js*.rpm
rpm -ivh opengroupware-libical*.rpm
rpm -ivh opengroupware-xml*.rpm
rpm -ivh opengroupware-core*.rpm
rpm -ivh opengroupware-gstep-db*.rpm
rpm -ivh opengroupware-gstep-db-postgresql72*.rpm
rpm -ivh opengroupware-sope*.rpm
rpm -ivh opengroupware-env*.rpm
rpm -ivh opengroupware-logic*.rpm
rpm -ivh opengroupware-docapi*.rpm
rpm -ivh opengroupware-database*.rpm
rpm -ivh opengroupware-webui-libs*.rpm
rpm -ivh opengroupware-webui-common*.rpm
rpm -ivh opengroupware-webui-admin*.rpm
rpm -ivh opengroupware-webui-app*.rpm
rpm -ivh opengroupware-webui-contact*.rpm
rpm -ivh opengroupware-webui-job*.rpm
rpm -ivh opengroupware-webui-mailer*.rpm
rpm -ivh opengroupware-webui-news*.rpm
rpm -ivh opengroupware-webui-prefs*.rpm
rpm -ivh opengroupware-webui-resource-en*.rpm
rpm -ivh opengroupware-webui-scheduler*.rpm
rpm -ivh opengroupware-webui-forms*.rpm
rpm -ivh opengroupware-webui-project*.rpm
rpm -ivh opengroupware-theme-default-en*.rpm
rpm -ivh mod_ngobjweb-200307161403-1.i386.rpm

# su - opengroupware
# cd Database/PostgreSQL
# psql ogo -U ogo

\i pg-build-schema.psql
<---RESULTAT--->
psql:pg-build-schema.psql:14: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_staff' for table 'staff'
psql:pg-build-schema.psql:14: NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_company_id' for table 'staff'
CREATE
psql:pg-build-schema.psql:93: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_company' for table 'company'
psql:pg-build-schema.psql:93: NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_company_number' for table 'company'
psql:pg-build-schema.psql:93: NOTICE: CREATE TABLE / UNIQUE will create implicit index 'unique_company_login' for table 'company'
CREATE
psql:pg-build-schema.psql:100: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_company_info' for table 'company_info'
CREATE
<---CUT--->
INSERT 16992 1
INSERT 16993 1
INSERT 16994 1
INSERT 16995 1
INSERT 16996 1
INSERT 16997 1
INSERT 16998 1
INSERT 16999 1
INSERT 17000 1
<---RESULTAT--->

\q

# source $HOME/OpenGroupware.org.sh
# Defaults write NSGlobalDomain LSAdaptor PostgreSQL72
# Defaults write NSGlobalDomain LSModelName OpenGroupware.org_PostgreSQL
# Defaults write NSGlobalDomain LSConnectionDictionary '{databaseName = ogo; hostName = [hostname]; password = ""; port = 5432; userName = ogo}'
# Defaults write NSGlobalDomain NGBundlePath /usr/lib/opengroupware.org/Library/OpenGroupware.org
# Defaults write NSGlobalDomain LSAttachmentPath /usr/lib/opengroupware.org/documents
# Defaults write NSGlobalDomain LSNewsImagesPath "/usr/lib/opengroupware.org/news"
# exit

# mkdir /usr/lib/opengroupware.org/documents
# chown opengroupware:skyrix /usr/lib/opengroupware.org/documents
# mkdir /usr/lib/opengroupware.org/news
# chown opengroupware:skyrix /usr/lib/opengroupware.org/news
# cd /usr/lib/opengroupware.org/WOApps/OpenGroupware.woa/WebServerResources
# ln -s /usr/lib/opengroupware.org/WebServerResources/English.lproj/ English.lproj

# chkconfig: 2345 75 25
# description: OpenGroupware is a groupware server

# Configuration section

OGO_DIR=/usr/lib/opengroupware.org
OGO_BIN=$OGO_DIR/WOApps/OpenGroupware.woa/ix86/linux-gnu/gnu-fd-nil/OpenGroupware
OGO_ARGS="-WOPort 20000 -WOHttpAllowHost localhost -OGoMinimumActiveSessionCount 0"
PID_FILE=/var/run/ogo.pid
LOG=/var/log/ogo.log

# end configuration section

# Source function library.
# Use the funtions provided by Red Hat or use our own
if [ -f /etc/rc.d/init.d/functions ]
then
. /etc/rc.d/init.d/functions
else
function action {
echo "$1"
shift
}
function success {
echo -n "Success"
}
function failure {
echo -n "Failed"
}
fi

[ -x $OGO_BIN ] || exit 0

case "$1" in
start)
echo -n "Starting OpenGroupware: "
pushd $OGO_DIR > /dev/null

# log separator
echo "----------------------------------------------------------------------" >> $LOG

# run as a user 'opengroupware':
if [ "`uname -s`" = "Linux" ]; then
env -i su - opengroupware -c "$OGO_BIN $OGO_ARGS" >> $LOG 2>&1 &
elif [ "`uname -s`" = "FreeBSD" ]; then
env -i su -l opengroupware -c "$OGO_BIN $OGO_ARGS" >> $LOG 2>&1 &
fi

echo $! > $PID_FILE
popd > /dev/null
success "Starting OpenGroupware"
echo
;;

stop)
echo -n "Shutting down OpenGroupware: "
if test -f "$PID_FILE" ; then
PID=`cat $PID_FILE`
if kill $PID >> $LOG 2>&1 ; then
/bin/rm $PID_FILE
success "Shutting down OpenGroupware"
else
echo ""
echo "Could not kill process $PID named in $PID_FILE. Check tail of $LOG."
failure "Shutting down OpenGroupware"
fi
else
echo ""
echo "No OpenGroupware pid file found. Looked for $PID_FILE."
failure "No OpenGroupware pid file found. Looked for $PID_FILE."
fi
echo
;;

restart)
$0 stop
$0 start
;;

*)
echo "Usage: opengroupware {start|stop|restart}"
exit 1

esac

exit 0

# su - opengroupware
# echo "source /usr/lib/opengroupware.org/OpenGroupware.org.sh" >> ~/.bash_profile
# echo "export LD_ASSUME_KERNEL=2.4.1" >> ~/.bash_profile
# exit

# service httpd restart
# /etc/init.d/opengroupware start

# ln -s /etc/init.d/opengroupware /etc/rc.d/rc7.d/S58opengroupware
# ln -s /etc/init.d/opengroupware /etc/rc.d/rc6.d/K02opengroupware