# Copyright 1999-2007 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
# $Header: $

WANT_AUTOCONF=latest
WANT_AUTOMAKE=latest

inherit autotools eutils ssl-cert toolchain-funcs java-pkg-2 java-ant-2 versionator multilib depend.apache

KEYWORDS="~x86 ~amd64"

MY_PV=$(replace_version_separator 3 -)
MY_P=open-xchange-server-${MY_PV/beta/BETA}

DESCRIPTION="A Collaboration and Integration Server Environment"
HOMEPAGE="http://www.open-xchange.com/header/community_area.html"
SRC_URI="http://www.open-xchange.com/fileadmin/community/${MY_P}.tar.gz"
LICENSE="GPL-2"
SLOT="0"
IUSE="doc java5 ssl webdav"

S=${WORKDIR}/open-xchange-${MY_PV/_beta}

CDEPEND=">=www-servers/tomcat-5.0.28-r4
	dev-java/jdom
	dev-java/sun-javamail
	dev-java/sun-jaf
	net-nds/openldap
	app-text/aspell
	dev-perl/XML-NamespaceSupport
	dev-perl/Net-SSLeay
	>=dev-perl/XML-SAX-0.11
	dev-perl/Authen-SASL
	dev-perl/Convert-ASN1
	dev-perl/perl-ldap
	dev-java/jdbc-postgresql
	ssl? ( dev-libs/openssl dev-perl/IO-Socket-SSL )"

DEPEND="${CDEPEND}
	app-arch/zip
	!java5? ( =virtual/jdk-1.4* )
	java5? ( =virtual/jdk-1.5* )
	dev-java/ant-core"

RDEPEND="${CDEPEND}
	www-apache/mod_jk
	!java5? ( =virtual/jre-1.4* )
	java5? ( =virtual/jre-1.5* )"

ox_setup_tomcat() {
	TOMCAT_CONF=${TOMCAT_CONF:-$(ls -1 /etc/conf.d/tomcat* | sort -r | head -n 1)}
	einfo "Using tomcat configuration file: '${TOMCAT_CONF}'"
	einfo "You can change this with:"
	einfo "    export TOMCAT_CONF=/etc/conf.d/tomcat-MYVERSION"
	einfo "before starting the merge."
	. ${TOMCAT_CONF}

	SERVLETDIR=${CATALINA_BASE}/webapps
}

pkg_setup() {
	if use java5 && ! built_with_use dev-java/jdbc-postgresql java5 ; then
		eerror "If you want to build ${PN} with java5, jdbc-postgresql has to be"
		eerror "built with it as well. Please enable the java5 USE-flag for it"
		eerror "and re-emerge it."
		die "Missing USE-flag for jdbc-postgresql."
	elif ! use java5 && built_with_use dev-java/jdbc-postgresql java5 ; then
		eerror "You can't build ${PN} with java-1.4 and having jdbc-postgresql built"
		eerror "with java5. Please either enable java5 for ${PN} or disable it"
		eerror "for jdbc-postgresql."
		die "Non-matching USE-flags"
	fi

	java-pkg-2_pkg_setup
	ox_setup_tomcat
}

src_unpack() {
	unpack ${A}
	cd "${S}"

	epatch "${FILESDIR}/ox-${PV}-build_fix.patch"

	AT_M4DIR=m4
	eautoreconf

	epatch "${FILESDIR}/ox-${PV}-umin_ssl.patch"

	# This makes it possible to use newer versions of jdbc-postgresql
	# instead of the old (unmaintained?) jdbc3-postgresql
	epatch "${FILESDIR}/ox-${PV}-wrong_jdbc_usage.patch"

	if use ssl; then
		# change login.pm-script if ssl should be used
		sed -i "s|connection_mode = 3;|connection_mode = 2;|g" src/misc/login/login.pm.in
	fi

	sed -i \
		-e "s|/cfintranet/|/open-xchange/cfintranet/|g" \
		conf/groupware/system.properties.in \
		conf/webmail/system.properties.in

	sed -i \
		-e 's:/cgi-bin/:/open-xchange/cgi-bin/:' \
		src/misc/login/login.pm.in

	sed -i \
		-e 's/@JAVA@/java/' \
		-e 's#@JAVA_HOME@/bin/java#java#' \
		-e "s/\(.*\) -classpath @.*@ \(.*\)/\1 -classpath \$(java-config -p open-xchange-serverpack):\$(java-config -p ${jdbc_db}) \2/" \
		sbin/addusersql_ox.in sbin/delgroup_ox.in sbin/deluser_ox.in || die "sed failed"

	mkdir jars
	cd jars

	java-pkg_jar-from jdbc-postgresql
	java-pkg_jar-from sun-javamail
	java-pkg_jar-from sun-jaf
	java-pkg_jar-from jdom-1.0
	java-pkg_jar-from xerces-2
	java-pkg_jar-from servletapi-2.4 servlet-api.jar
}

src_compile() {
	local myconf
	local tempvar

	myconf="${myconf} --with-jdbcjar=${S}/jars/jdbc-postgresql.jar"

	econf \
		$(use_enable doc) \
		$(use_enable webdav) \
		$(use_enable ssl) \
		--with-servletdir="${SERVLETDIR}" \
		--with-jsdkjar="${S}/jars/servlet-api.jar" \
		--with-mailjar="${S}/jars/mail.jar" \
		--with-activationjar="${S}/jars/activation.jar" \
		--with-jdomjar="${S}/jars/jdom.jar" \
		--with-xercesjar="${S}/jars/xercesImpl.jar" \
		--with-jni-dir="$(java-config-2 -O)/include" \
		--with-runuid=tomcat \
		--with-rungid=tomcat \
		--with-tomcatuser=tomcat \
		--with-htdocsdir=/usr/share/open-xchange/www \
		--with-cgibindir=/usr/share/open-xchange/www/cgi-bin \
		--sysconfdir=/etc/open-xchange \
		--datadir=/usr/share/open-xchange \
		--includedir=/usr/include/open-xchange \
		--libdir=/usr/$(get_libdir)/open-xchange \
		--localstatedir=/var/open-xchange \
		${myconf} || die "econf failed"

	EANT_BUILD_TARGET=war
	java-pkg-2_src_compile

	emake -C javabuild misc || die "emake failed"
	emake -C src || die "emake failed"
}

src_install() {

	dodoc AUTHORS ChangeLog NEWS README

	emake DESTDIR="${D}" install || die "emake install failed"

	java-pkg_dolauncher ox_sessiond \
		--main com.openexchange.sessiond.Sessiond \
		--java_args "-Xms20M -Xmx280M -Dopenexchange.propfile=/etc/open-xchange/groupware/system.properties -DappName=sessiondApp"
	java-pkg_dolauncher ox_groupware \
		--main ComfireServer \
		--java_args "-Xms20M -Xmx280M -Djava.awt.headless=true -Dopenexchange.propfile=/etc/open-xchange/groupware/system.properties -DappName=groupwareApp"
	java-pkg_dolauncher ox_webmail \
		--main ComfireServer \
		--java_args "-Xms20M -Xmx280M -Djava.awt.headless=true -Dopenexchange.propfile=/etc/open-xchange/webmail/system.properties -DappName=webmailApp"

	dodir ${CATALINA_BASE}/shared/lib
	dosym /usr/$(get_libdir)/open-xchange/oxssl.jar ${CATALINA_BASE}/shared/lib/oxssl.jar

	java-pkg_regso "${D}/usr/$(get_libdir)/open-xchange/liboxssl.so"
	java-pkg_regjar ${D}/usr/$(get_libdir)/open-xchange/*.jar

	insinto /etc/open-xchange
	doins "${FILESDIR}/catalina.conf"

	# remove obsolete log-files they should be saved in /var/log/open-xchange
	rm -rf "${D}/var/open-xchange/log/"
	keepdir /var/log/open-xchange
	dosym /var/log/open-xchange /var/open-xchange/log

	# remove unessary war-files, they are needed for deploying application
	rm -f "${D}/usr/lib/open-xchange"/*.war

	# remove empty dirs
	rm -rf \
		"${D}/usr/include" \
		"${D}/usr/share"/{info,man}

	# remove unneeded init- and start-scripts - not used by gentoo
	rm -rf "${D}/etc/open-xchange/init.d" "${D}/etc/open-xchange/initscript.conf"
	rm -rf "${D}/usr/sbin"/openxchange-*

	# Init script
	newinitd "${FILESDIR}/init.d.open-xchange" open-xchange || die "newinitd failed"
	newconfd "${FILESDIR}/conf.d.open-xchange" open-xchange || die "newconfd failed"

	keepdir /var/run/open-xchange
	fowners tomcat:tomcat /var/run/open-xchange

	insinto "${SERVLETDIR}"
	doins lib/servlet.war

	# chown of war-files or tomcat gets problems with stopping itself
	fowners tomcat:tomcat ${SERVLETDIR}/servlet.war

	# open-xchange-webpack has to copy the html-files and images in and we want to change settings in oxuserminconfig.properties
	unzip lib/umin.war -d "${D}/${SERVLETDIR}/umin"
	dodir /etc/open-xchange/umin
	mv "${D}/${SERVLETDIR}/umin/WEB-INF/classes/oxuserminconfig.properties" "${D}/etc/open-xchange/umin"

	fowners -R tomcat:tomcat "${SERVLETDIR}/umin"
	for f in umin/oxuserminconfig.properties groupware/server.conf webmail/server.conf ; do
		fowners root:tomcat /etc/open-xchange/${f}
		fperms 640 /etc/open-xchange/${f}
	done

	# Put the schema in etc and symlink.  This way it's protected.
	dodir /etc/openldap/schema
	mv "${D}/usr/share/open-xchange/openxchange.schema" "${D}/etc/openldap/schema"
	dosym /etc/openldap/schema/openxchange.schema /usr/share/open-xchange/openxchange.schema
	dosym /etc/openldap/ldap.conf /etc/open-xchange/groupware/ldap.conf
	dosym /etc/openldap/ldap.conf /etc/open-xchange/webmail/ldap.conf

	if use ssl ; then
	    #create symlink to ssl directory for webmail
	    dosym /etc/open-xchange/groupware/sslcerts /etc/open-xchange/webmail/sslcerts
	fi

	for x in settings/intranet settings/webmail filespool drafts webmailupload dictionary ; do
		keepdir /var/open-xchange/${x}
		fowners tomcat:tomcat /var/open-xchange/${x}
	done

	insinto ${APACHE2_MODULES_CONFDIR}
	doins "${FILESDIR}/88_mod_jk.ox.conf"

	insinto ${APACHE2_VHOSTDIR}
	doins "${FILESDIR}/webinterface.ox.include"

	# copy ldap-aci-file
	insinto /etc/openldap/
	doins "${FILESDIR}/slapd.ox.inc"

	# copy sql update file
	insinto /usr/share/open-xchange/
	doins "${FILESDIR}/ox_reminder.sql"

	find "${D}/usr/share/open-xchange/" -iname "*.htm" -or -iname "*.lang" -or -iname "*.js" \
		| xargs sed -i 's|"/cfintranet/|"/open-xchange/cfintranet/|g'

}

#parameter $1 == 1 for config part or == 0 for preinst
ox_setup() {
	local config=$1
	local WORKINGBASE="${IMAGE}" #is used during pkg_*
	if [[ $config -eq 1 ]]; then
		#executed from in pkg_config
		WORKINGBASE="${ROOT}"
	fi
	# Simple defaults
	# some have to defined global
	OX_DBNAME=${OX_DBNAME-"open_xchange"}
	OX_DBUSER=${OX_DBUSER-"open_xchange"}
	OX_DBPASS=${OX_DBPASS-"secret"}
	OX_DOMAIN=${OX_DOMAIN-"example.org"}
	# some just needed local
	local OX_DBHOST=${OX_DBHOST-"localhost"}
	local OX_ORG=${OX_ORG-"Example Organization"}
	local OX_LDAPSERVER=${OX_LDAPSERVER-"localhost"}
	local OX_BASEDN=${OX_BASEDN-"dc=example,dc=org"}
	local OX_BASEDC=${OX_BASEDC-"example"}
	local OX_ROOTDN=${OX_ROOTDN-"cn=Manager,${OX_BASEDN}"}
	local OX_ROOTPW=${OX_ROOTPW-"secret"}

	# Guess base on the installed config but only if it exists
	if [[ -e "${ROOT}/etc/open-xchange/admintools.conf" ]] ; then
		local temp_var
		einfo "Installation of OX detected"

		temp_var=$(get_oxvar DEFAULT_SQL_HOST)
		[[ -n ${temp_var} ]] && OX_DBHOST=${temp_var}

		temp_var=$(get_oxvar DEFAULT_SQL_DB)
		[[ -n ${temp_var} ]] && OX_DBNAME=${temp_var}

		temp_var=$(get_oxvar DEFAULT_SQL_USER)
		[[ -n ${temp_var} ]] && OX_DBUSER=${temp_var}

		temp_var=$(get_oxvar DEFAULT_SQL_PASS)
		[[ -n ${temp_var} ]] && OX_DBPASS=${temp_var}

		temp_var=$(get_oxvar ORGA)
		[[ -n ${temp_var} ]] && OX_ORG=${temp_var}

		temp_var=$(get_oxvar BINDDN)
		[[ -n ${temp_var} ]] && OX_ROOTDN=${temp_var}

		temp_var=$(get_oxvar BINDPW)
		[[ -n ${temp_var} ]] && OX_ROOTPW=${temp_var}

		if [[ -e "${ROOT}/etc/open-xchange/groupware/ldap.conf" ]] ; then
			# taken from admintools.conf self
			temp_var=`grep -v '^#' ${ROOT}/etc/open-xchange/groupware/ldap.conf | grep -i BASE | head -n 1 | awk {'print $2'}`
			[[ -n ${temp_var} ]] && OX_BASEDN=${temp_var}
		fi
	fi

	if [[ ${config} -eq 1 ]]; then
		# Now asking the user
		einfo "If values are correct just press enter else enter the new value"

		OX_DBHOST=$(get_user_config "${OX_DBHOST}" "Database Host")
		OX_DBNAME=$(get_user_config "${OX_DBNAME}" "Database Name")
		OX_DBUSER=$(get_user_config "${OX_DBUSER}" "Database User")
		OX_DBPASS=$(get_user_config "${OX_DBPASS}" "Database User's Password")
		OX_ORG=$(get_user_config "${OX_ORG}" "Organization")
		OX_DOMAIN=$(get_user_config "${OX_DOMAIN}" "Domain")
		OX_LDAPSERVER=$(get_user_config "${OX_LDAPSERVER}" "LDAP Server")
		OX_BASEDN=$(get_user_config "${OX_BASEDN}" "LDAP Base DN")
		OX_ROOTDN=$(get_user_config "${OX_ROOTDN}" "LDAP Root DN")
		OX_ROOTPW=$(get_user_config "${OX_ROOTPW}" "LDAP Root Password")
		OX_BASEDC="`echo ${OX_BASEDN} | sed -n 's:dc=\([-A-Za-z_]*\).*:\1:p'|head -n 1`"
		einfo "Finished - now writing config"
	fi

	einfo "Domain = ${OX_DOMAIN}"

	## now create configs with the right values
	# starting with ldap
	sed -i \
		-e "s|dc=example,dc=org|${OX_BASEDN}|g" \
		-e "s|example\.org|${OX_DOMAIN}|g" \
		-e "s|Example Organization|${OX_ORG}|g" \
		-e "s|example|${OX_BASEDC}|g" \
		"${WORKINGBASE}/usr/share/open-xchange/init_ldap.ldif"

	sed -i \
		-e "s|ORGA=\".*\"|ORGA=\"${OX_ORG}\"|g" \
		-e "s|BINDDN=\".*\"|BINDDN=\"${OX_ROOTDN}\"|g" \
		-e "s|BINDPW=\".*\"|BINDPW=\"${OX_ROOTPW}\"|g" \
		-e "s|DEFAULT_SQL_HOST=\".*\"|DEFAULT_SQL_HOST=\"${OX_DBHOST}\"|g" \
		-e "s|DEFAULT_SQL_DB=\".*\"|DEFAULT_SQL_DB=\"${OX_DBNAME}\"|g" \
		-e "s|DEFAULT_SQL_USER=\".*\"|DEFAULT_SQL_USER=\"${OX_DBUSER}\"|g" \
		-e "s|DEFAULT_SQL_PASS=\".*\"|DEFAULT_SQL_PASS=\"${OX_DBPASS}\"|g" \
		${WORKINGBASE}/etc/open-xchange/admintools.conf

	# setup correct ACIs
	sed -i "s|@basedn@|${OX_BASEDN}|g" "${WORKINGBASE}/etc/openldap/slapd.ox.inc"

	# groupware : server.conf
	for f in /etc/open-xchange/groupware/server.conf /etc/open-xchange/webmail/server.conf ; do
		sed -i "s|NAS_CON_CLASS_NAME: jdbc:\(.*\)://.*|NAS_CON_CLASS_NAME: jdbc:\1://${OX_DBHOST}/${OX_DBNAME}|g" ${WORKINGBASE}/${f}
		sed -i \
			-e "s|NAS_CON_USER:.*|NAS_CON_USER: ${OX_DBUSER}|g" \
			-e "s|NAS_CON_PASS:.*|NAS_CON_PASS: ${OX_DBPASS}|g" \
			-e "s|NAS_CON_PASS:.*|NAS_CON_PASS: ${OX_DBPASS}|g" \
			${WORKINGBASE}/${f}
	done

	sed -i \
		-e "s|LDAP_SERVER=.*|LDAP_SERVER=${OX_LDAPSERVER}|g" \
		-e "s|LDAP_BASEDN=.*|LDAP_BASEDN=${OX_BASEDN}|g" \
		-e "s|SQL_SERVER_GROUPWARE=.*|SQL_SERVER_GROUPWARE=${OX_DBHOST}|g" \
		-e "s|SQL_SERVER_GROUPWARE_DATABASE_NAME=.*|SQL_SERVER_GROUPWARE_DATABASE_NAME=${OX_DBNAME}|g" \
		-e "s|SQL_SERVER_GROUPWARE_DATABASE_URL=.*|SQL_SERVER_GROUPWARE_DATABASE_URL=jdbc:postgresql://${OX_DBHOST}/${OX_DBNAME}|g" \
		-e "s|SQL_SERVER_GROUPWARE_DATABASE_USERNAME=.*|SQL_SERVER_GROUPWARE_DATABASE_USERNAME=${OX_DBUSER}|g" \
		-e "s|SQL_SERVER_GROUPWARE_DATABASE_PASSWORD=.*|SQL_SERVER_GROUPWARE_DATABASE_PASSWORD=${OX_DBPASS}|g" \
		-e "s|CSS_PATH=/cfintranet/css/stylesheet.css|CSS_PATH=/open-xchange/cfintranet/css/stylesheet.css|g" \
		"${WORKINGBASE}/etc/open-xchange/umin/oxuserminconfig.properties"

}

pkg_preinst(){
	#execute ox_setup from preinst(0)
	ox_setup_tomcat
	ox_setup 0

	# create user mailadmin, needed for mailsupport
	enewuser mailadmin -1 -1 /dev/null users
	_UID=`getent passwd mailadmin | awk -F : '{print $3}'`

	# get the default guid of the group 'users'
	OX_STDGID=`getent group users | awk -F : '{print $3}'`

	# replace the SuSE group id 500 of users with the gentoo group id of the group 'users' for the mailadmin in ldif + uid
	sed -i \
		-e "s|500|${OX_STDGID}|g" \
		-e "s|501|${_UID}|g" \
		"${D}/usr/share/open-xchange/init_ldap.ldif"

	# configuring admintools.conf

	# replace the SuSE standard group id 500 with the gentoo group id of the group 'users'
	sed -i "s|500|${OX_STDGID}|g" ${D}/etc/open-xchange/admintools.conf
	OX_STDGID=`expr ${OX_STDGID} + 1`
	sed -i "s|501|${OX_STDGID}|g" ${D}/etc/open-xchange/admintools.conf

	if use ssl ; then
		SSL_ORGANIZATION="${SSL_ORGANIZATION:-Open Xchange}"
		insinto /etc/open-xchange/groupware/sslcerts/oxCERTS
		docert groupware sessiond

		# copying the CA-certificate
		dodir /etc/open-xchange/groupware/sslcerts/oxCA
		cp ${T}/*ca.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCA/cacert.pem

		# copying the groupware-key and -cert the way ox would like it to have
		mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.key ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupwarekey.pem
		mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupwarecert.pem
		mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.key ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiondkey.pem
		mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiondcert.pem
		rm ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.pem \
			${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.pem \
			${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.csr \
			${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.csr

		chown -R tomcat:apache ${D}/etc/open-xchange/groupware/sslcerts
		find ${D}/etc/open-xchange/groupware/sslcerts -name '*.pem' -exec chmod 440 {} \;
	fi
}

pkg_postinst() {
	elog "Execute the following command"
	elog "  emerge --config =${CATEGORY}/${PF}"
	elog "to setup the initial open-xchange environment."

	ewarn "If you upgrade from a version prior 0.8.1.5 you should execute the following command:"
	ewarn "    psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/ox_reminder.sql"

	ewarn "If you upgrade from a version prior 0.8.1.6 you should execute the following command:"
	ewarn "    psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/ox_project.sql"

	if has_version '=net-nds/openldap-2.1*' ; then
		ewarn "You have got OpenLDAP-2.1.* installed."
		ewarn "Please make sure you've got enabled aci support for this package."
		ewarn "For more information: http://gentoo-wiki.com/HOWTO_Open-Xchange#OpenLDAP"
		ewarn
		ewarn "If you already have this done, ignore this warning"
	fi

	ewarn "Please make sure that the tomcat-user has a valid login-shell and home-directory."
}

get_oxvar() {
	sed -n "s:^\s*${1}=\"\(.*\)\":\1:p" ${ROOT}etc/open-xchange/admintools.conf | head -n 1
}

get_user_config() {
	local default=$1
	local desc=$2
	local read_val;

	echo -n "${desc}? [${default}] " 1>&2
	read readval
	if [[ -z ${readval} ]] ; then
		echo ${default}
	else
		echo ${readval}
	fi
}

pkg_config() {
	ox_setup_tomcat
	#execute ox_setup from pkg_config(1)
	## at first automatially change config in init_ldap.ldif and configuration-files
	ox_setup 1

	if use ssl ; then
		chown -R tomcat:apache ${ROOT}/etc/open-xchange/groupware/sslcerts
		find ${ROOT}/etc/open-xchange/groupware/sslcerts -name '*.pem' -exec chmod 440 {} \;
	fi

	#set correct user rights for ldap
	chown ldap:ldap ${ROOT}/etc/openldap/slapd.ox.inc

	einfo
	einfo "================================"
	einfo "Finished automatic configuration"
	einfo "================================"

	einfo
	einfo "Add the following line to ${TOMCAT_CONF}:"
	einfo "  '. /etc/open-xchange/catalina.conf'"

	einfo
	einfo "Setup /etc/conf.d/apache2"
	einfo "APACHE2_OPTS=\"-D JK\""

	einfo "You have to add \"Include webinterface.ox.include\" inside a virtual host directive."

	# Tell the user how to propegate ldap and the db
	## create ox-dbuser
	einfo
	einfo "HOWTO: Setup PostgreSQL database (following commands)"
	einfo "++++++++++++++++++++++++++++++++++++++++++++++++"
	einfo "echo \"CREATE USER ${OX_DBUSER} WITH PASSWORD '${OX_DBPASS}' CREATEDB NOCREATEUSER\" | psql -h localhost -U postgres template1 -f -"
	einfo "echo \"CREATE DATABASE ${OX_DBNAME} WITH OWNER=${OX_DBUSER} ENCODING='UNICODE'\" | psql -h localhost -U postgres template1 -f -"
	einfo "psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/init_database.sql"
	einfo "/usr/sbin/dbinit_ox"

	## initialise database with ox, after configurations have been changed	
	einfo
	einfo "HOWTO: Setup OpenLDAP"
	ewarn "Please make sure to STOP slapd to maintain database consistency (from slapadd(8c))!!!"
	einfo "+++++++++++++++++++++++++++++++++"
	einfo "/etc/init.d/slapd stop"
	einfo
	einfo "Add this to /etc/openldap/slapd.conf:"
	einfo "include         /etc/openldap/schema/cosine.schema"
	einfo "include         /etc/openldap/schema/inetorgperson.schema"
	einfo "include         /etc/openldap/schema/misc.schema"
	einfo "include         /etc/openldap/schema/nis.schema"
	einfo "include         /etc/openldap/schema/openldap.schema"
	einfo "include         /etc/openldap/schema/openxchange.schema"
	einfo
	einfo "If you want an initial set of access rights (enables your user, editing their password, ...)"
	einfo "you should also add the following line:"
	einfo "include         /etc/openldap/slapd.ox.inc"
	einfo
	einfo "slapadd -l /usr/share/open-xchange/init_ldap.ldif"
	einfo
	einfo "/etc/init.d/slapd start"

	einfo
	einfo "HOWTO: Add a group"
	einfo "++++++++++++++++++"
	einfo "This is suggested for correct webdav-access"
	einfo "/usr/sbin/addgroup_ox --group=NEWGROUPNAME"

	einfo
	einfo "HOWTO: Add a user"
	einfo "+++++++++++++++++"
	einfo "/usr/sbin/adduser_ox --username=MYUSERNAME --passwd=MYPASSWORD --name=FORENAME --sname=SURENAME --maildomain=${OX_DOMAIN} --ox_timezone=\"Europe/Berlin\""
	einfo "Now you can add the user to a group."
	einfo "/usr/sbin/addusertogroup_ox --user=MYUSERNAME --group=NEWGROUPNAME"
	einfo
	einfo "If you encounter any problems with this commands probably your ldap or database configuration is not correct"
	einfo
	einfo "Web Access:"
	einfo "To access open-xchange via the web, point your browser to: http://YOUR-HOST-NAME/open-xchange/cgi-bin/login.pl"
}