# Copyright 1999-2006 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
# $Header: /var/cvsroot/gentoo-x86/mail-filter/dspam/dspam-3.6.6.ebuild,v 1.3 2006/06/05 00:13:58 st_lim Exp $

inherit cvs eutils webapp autotools flag-o-matic

ECVS_SERVER="cvs.nuclearelephant.com:/usr/local/cvsroot"
ECVS_USER=cvs
ECVS_PASS=
ECVS_MODULE="dspam"

DESCRIPTION="A statistical-algorithmic hybrid anti-spam filter"
SRC_URI=""
S=${WORKDIR}/${ECVS_MODULE}

HOMEPAGE="http://dspam.nuclearelephant.com/"
LICENSE="GPL-2"

WEBAPP_MANUAL_SLOT="yes"
SLOT="0"

IUSE="clamav daemon debug large-domain ldap logrotate mysql postgres \
      sqlite sqlite3 virtual-users user-homedirs hash syslog frontend"

DEPEND="clamav?		( >=app-antivirus/clamav-0.86 )
	ldap?		( >=net-nds/openldap-2.2 )
	syslog?		( virtual/logger )
	mysql?		( >=dev-db/mysql-3.23 ) 
	postgres?	( >=dev-db/postgresql-7.4.3 )
	sqlite?		( <dev-db/sqlite-3 )
	daemon?		( >sys-kernel/linux-headers-2.6 )
	sqlite3?	( =dev-db/sqlite-3* )
        frontend?       ( net-www/apache >=dev-perl/GD-2.0 dev-perl/GD-Graph3d
        	        dev-perl/GDGraph dev-perl/GDTextUtil )"

RDEPEND="${DEPEND}
	sys-process/cronbase
	logrotate? ( app-admin/logrotate )"
PROVIDE="www-apps/dspam-web"

KEYWORDS="~x86 ~ppc ~alpha ~amd64"

# some FHS-like structure
HOMEDIR="/var/spool/dspam"
CONFDIR="/etc/mail/dspam"
LOGDIR="/var/log/dspam"

databases() {
	local foo
	local multiple_dbs="0"
	local supported_dbs="mysql postgres sqlite sqlite3 hash"
	for foo in ${supported_dbs}; do
		if use ${foo}; then
			let multiple_dbs=multiple_dbs+1
		fi
	done

	return $multiple_dbs
}

pkg_setup() {
        use frontend && webapp_pkg_setup

	databases

	if [ "$?" -eq "0" ] && use daemon ; then
		einfo "To use the DSPAM daemon mode, you need the storage driver used"
		einfo "must be thread-safe ( mysql postgresl hash )"
	fi

	if use virtual-users && use user-homedirs ; then
		ewarn "If the users are virtual, then they probably should not have home directories."
		die
	fi

	if use frontend && use user-homedirs ; then
		ewarn "user-homedirs and frontend are incompatible."
		die
	fi

	if use user-homedirs ; then
		ewarn "WARNING: dspam-web will not work with user-homedirs.  Disable this USE flag"
		ewarn "if you intend on using dspam-web."
	fi

	enewgroup dspam 1000
	enewuser dspam 100 -1 ${HOMEDIR} dspam
}

src_compile() {
	# Fix Lazy bindings
        append-flags $(bindnow-flags)

        cd "${S}"

	for X in manpage-in-right-section.dpatch \
                drivers-in-usr_lib_dspam.dpatch \
                dspam-webfrontend-config-debian.dpatch \
                dspam-default.prefs-in_etc.dpatch \
                where-to-find-txt-files.dpatch \
                add-config-dir.dpatch \
                default-server-pidfile.dpatch \
                background-dspam.dpatch \
                pos-neg-switched.dpatch \
                make-daemon-quiet.dpatch \
                make-dspam_clean-quiet.dpatch \
                improper-quotation-fix.dpatch \
                enable-domain-quarantine.dpatch \
                virus-notifications.dpatch \
                clean-warnings.dpatch
	do
		epatch "${FILESDIR}"/debian/${X}
	done

	databases
	if [ "$?" -ge "1" ] ; then
		epatch "${FILESDIR}"/debian/link-dynamically.dpatch
	fi
	AT_M4DIR="${S}"/m4
	WANT_AUTOMAKE=1.9 eautoreconf

	local myconf

	use large-domain && myconf="${myconf} --enable-large-scale" ||\
			    myconf="${myconf} --enable-domain-scale"

	use user-homedirs && myconf="${myconf} --enable-homedir"

	use debug && myconf="${myconf} --enable-debug --enable-verbose-debug --enable-bnr-debug"

	if use virtual-users ; then
		if use mysql || use postgres ; then
			myconf="${myconf} --enable-virtual-users"
		fi
	fi

	if use mysql || use postgres ; then 
		myconf="${myconf} --enable-preferences-extension"
	fi

	local STORAGE
	# select storage driver
	if use sqlite ; then
		if [ "$STORAGE" ] ; then STORAGE="${STORAGE}," ; fi
		STORAGE="${STORAGE}sqlite_drv"
	fi
	if use sqlite3 ; then
		if [ "$STORAGE" ] ; then STORAGE="${STORAGE}," ; fi
		STORAGE="${STORAGE}sqlite3_drv"
	fi
	if use mysql; then
		if [ "$STORAGE" ] ; then STORAGE="${STORAGE}," ; fi
		STORAGE="${STORAGE}mysql_drv"
		myconf="${myconf} --with-mysql-includes=/usr/include/mysql"
		myconf="${myconf} --with-mysql-libraries=/usr/lib/mysql"
#		if has_version ">dev-db/mysql-4.1"; then
#			myconf="${myconf} --disable-mysql4-initialization"
#		fi
	fi
	if use postgres ; then
		if [ "$STORAGE" ] ; then STORAGE="${STORAGE}," ; fi
		STORAGE="${STORAGE}pgsql_drv"
		myconf="${myconf} --with-pgsql-includes=/usr/include/postgresql"
		myconf="${myconf} --with-pgsql-libraries=/usr/lib/postgresql"
	fi
	if use hash ; then
		if [ "$STORAGE" ] ; then STORAGE="${STORAGE}," ; fi
		STORAGE="${STORAGE}hash_drv"
	fi

	econf ${myconf} --with-storage-driver="$STORAGE" \
			--enable-long-usernames \
			--with-dspam-home=${HOMEDIR} \
			--sysconfdir=${CONFDIR} \
			$(use_enable daemon) \
			$(use_enable ldap) \
			$(use_enable clamav) \
			$(use_enable syslog) \
		        --with-dspam-group=dspam \
		        --with-dspam-home-group=dspam \
			--with-logdir=${LOGDIR} || die
	emake || die
}

src_install () {
	diropts -m0770 -o dspam -g dspam
	insinto ${CONFDIR}
	insopts -m644 -o dspam -g dspam
	doins src/dspam.conf
	doins webui/cgi-bin/default.prefs

        dosym /etc/mail/dspam /etc/dspam

	if use frontend ; then
		webapp_src_preinst
	        webapp_postinst_txt en ${FILESDIR}/postinst-en.txt

		exeinto ${MY_HTDOCSDIR}
		doexe webui/cgi-bin/*.cgi

		insinto ${MY_HTDOCSDIR}
		doins webui/htdocs/base.css
		doins webui/htdocs/dspam-logo-small.gif

		webapp_src_install

		insinto ${CONFDIR}
		insopts -m644 -o dspam -g dspam
		doins webui/cgi-bin/rgb.txt
		doins webui/cgi-bin/admins
		newins webui/cgi-bin/configure.pl webfrontend.conf

		insinto usr/share/dspam/templates
		doins webui/cgi-bin/templates/*.html
	fi

	# make install
	make DESTDIR=${D} install || die

#	fperms 6755 /usr/bin/dspam

	databases
	if [ "$?" -ge "1" ] ; then
		dodir /usr/lib/dspam
		mv ${D}/usr/lib/*drv* ${D}/usr/lib/dspam/
	fi

	diropts -m0755 -o dspam -g dspam
	keepdir /var/run/dspam

	# create logdir
	if use debug ; then
		diropts -m0770 -o dspam -g dspam
		keepdir ${LOGDIR}
	fi

        if use frontend ; then
                sed -e '130i\Trust apache' -i ${D}/${CONFDIR}/dspam.conf
                sed -e '130i\Trust dspam' -i ${D}/${CONFDIR}/dspam.conf
        fi

	if use daemon; then
		# We use sockets for the daemon instead of tcp port 24
		sed -e 's:^#*\(ServerDomainSocketPath[\t ]\{1,\}\).*:\1\"/var/run/dspam/dspam.sock\":gI' \
			-e 's:^#*\(ServerPID[\t ]\{1,\}\).*:\1/var/run/dspam/dspam.pid:gI' \
			-i ${D}/${CONFDIR}/dspam.conf

		newinitd ${FILESDIR}/dspam.rc dspam
	fi

	# generate random password
	local PASSWORD="${RANDOM}${RANDOM}${RANDOM}${RANDOM}"

	# database related configuration and scripts
	if use sqlite; then
		insinto ${CONFDIR}
		newins src/tools.sqlite_drv/purge-2.sql sqlite_purge.sql
	fi
	if use sqlite3; then
		insinto ${CONFDIR}
		newins src/tools.sqlite_drv/purge-3.sql sqlite3_purge.sql
	fi
	if use mysql; then
		# Use existing configuration if possible
		if [[ -f ${ROOT}${CONFDIR}/mysql.data ]]; then
			DSPAM_DB_DATA=( $(sed "s:^[\t ]*$:###:gI" "${ROOT}${CONFDIR}/mysql.data") )
			for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
				[[ "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" = "###" ]] && DSPAM_DB_DATA[$DB_DATA_INDEX]=""
			done
		else
			DSPAM_DB_DATA[0]="/var/run/mysqld/mysqld.sock"
			DSPAM_DB_DATA[1]=""
			DSPAM_DB_DATA[2]="dspam"
			DSPAM_DB_DATA[3]="${PASSWORD}"
			DSPAM_DB_DATA[4]="dspam"
			DSPAM_DB_DATA[5]="true"
		fi

		# Modify configuration and create mysql.data file
		sed -e "s:^#*\(MySQLServer[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[0]}:gI" \
			-e "s:^#*\(MySQLPort[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[1]}:gI" \
			-e "s:^#*\(MySQLUser[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[2]}:gI" \
			-e "s:^#*\(MySQLPass[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[3]}:gI" \
			-e "s:^#*\(MySQLDb[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[4]}:gI" \
			-e "s:^#*\(MySQLCompress[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[5]}:gI" \
			-i ${D}/${CONFDIR}/dspam.conf
		for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
			echo "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" >> ${D}/${CONFDIR}/mysql.data
		done

		insinto ${CONFDIR}
		newins src/tools.mysql_drv/mysql_objects-space.sql mysql_objects-space.sql
		newins src/tools.mysql_drv/mysql_objects-speed.sql mysql_objects-speed.sql
		newins src/tools.mysql_drv/mysql_objects-4.1.sql mysql_objects-4.1.sql
		newins src/tools.mysql_drv/virtual_users.sql mysql_virtual_users.sql
		newins src/tools.mysql_drv/purge.sql mysql_purge.sql
		newins src/tools.mysql_drv/purge-4.1.sql mysql_purge-4.1.sql

                fperms 660 ${D}/${CONFDIR}/mysql.data
                fowners dspam:dspam ${D}/${CONFDIR}/mysql.data
	fi
	if use postgres ; then
		# Use existing configuration if possible
		if [ -f ${ROOT}${CONFDIR}/pgsql.data ]; then
			DSPAM_DB_DATA=( $(cat "${ROOT}${CONFDIR}/pgsql.data") )
			for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
				[[ "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" = "###" ]] && DSPAM_DB_DATA[$DB_DATA_INDEX]=""
			done
		else
			DSPAM_DB_DATA[0]="127.0.0.1"
			DSPAM_DB_DATA[1]="5432"
			DSPAM_DB_DATA[2]="dspam"
			DSPAM_DB_DATA[3]="${PASSWORD}"
			DSPAM_DB_DATA[4]="dspam"
		fi

		# Modify configuration and create pgsql.data file
		sed -e "s:^#*\(PgSQLServer[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[0]}:gI" \
			-e "s:^#*\(PgSQLPort[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[1]}:gI" \
			-e "s:^#*\(PgSQLUser[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[2]}:gI" \
			-e "s:^#*\(PgSQLPass[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[3]}:gI" \
			-e "s:^#*\(PgSQLDb[\t ]\{1,\}\).*:\1${DSPAM_DB_DATA[4]}:gI" \
			-e "s:^#*\(PgSQLConnectionCache[\t ]*.\):\1:gI" \
			-i ${D}/${CONFDIR}/dspam.conf
		for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
			echo "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" >> ${D}/${CONFDIR}/pgsql.data
		done

		insinto ${CONFDIR}
		newins src/tools.pgsql_drv/pgsql_objects.sql pgsql_objects.sql
		newins src/tools.pgsql_drv/virtual_users.sql pgsql_virtual_users.sql
		newins src/tools.pgsql_drv/purge.sql pgsql_purge.sql

                fperms 660 ${D}/${CONFDIR}/pgsql.data
                fowners dspam:dspam ${D}/${CONFDIR}/pgsql.data
	fi

	sed -e "s:^\(Purge.*\):###\1:g" \
		-e "s:^#\(Purge.*\):\1:g" \
		-e "s:^###\(Purge.*\):#\1:g" \
		-i ${D}/${CONFDIR}/dspam.conf

	# installs the notification messages
	# -> The documentation is wrong! The files need to be in ./txt
	diropts -m0770 -o dspam -g dspam
	insinto ${CONFDIR}/txt
	doins ${S}/txt/*.txt

	# Create the opt-in / opt-out directories
	diropts -m0770 -o dspam -g dspam
	dodir ${HOMEDIR}
	diropts -m0770 -o dspam -g dspam
	keepdir ${HOMEDIR}/opt-in
	keepdir ${HOMEDIR}/opt-out

	# logrotation scripts
	if use logrotate && use debug ; then
		insinto /etc/logrotate.d
		newins ${FILESDIR}/logrotate.dspam dspam
	fi

	# dspam cron job
	exeinto /etc/cron.daily
	doexe ${FILESDIR}/dspam.cron

	# documentation
	dodoc CHANGELOG LICENSE README* RELEASE.NOTES UPGRADING
	docinto doc
	dodoc doc/*.txt
	docinto gentoo
	dodoc ${FILESDIR}/README.postfix ${FILESDIR}/README.qmail
	doman man/dspam*


}

pkg_postinst() {
	if use mysql || use postgres; then
		echo
		einfo "To setup DSPAM to run out-of-the-box on your system with a MySQL,"
		einfo "PostgreSQL database, run:"
		einfo "emerge --config =${PF}"
	fi

	if use postgres && has_version ">dev-db/postgresql-8.0"; then
		echo
		einfo "Before executing the configuration command mentioned above you have"
		einfo "to execute the following command:"
		einfo "createlang plpgsql -U postgres dspam"
	fi

	if use daemon; then
		echo
		einfo "If you want to run DSPAM in the new daemon mode remember"
		einfo "to make the DSPAM daemon start during boot:"
		einfo "  rc-update add dspam default"
	fi

	if use vhosts; then
    		ewarn "Use the command"
    		ewarn "    webapp-config"
    		ewarn "to install Dspam Frontend for each virtual host. See the proper man page."
    		webapp_pkg_postinst
	fi

        ewarn "Edit /etc/mail/dspam.conf with your delivery agent"
        ewarn "See http://dspamwiki.expass.de/Installation for more info"
}

pkg_config () {
	if use sqlite || use sqlite3 ; then
		einfo "sqlite_drv will automatically create the necessary database"
	fi
	if use mysql ; then
		DSPAM_DB_DATA=( $(sed "s:^[\t ]*$:###:gI" "${ROOT}${CONFDIR}/mysql.data") )
		for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
			[[ "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" = "###" ]] && DSPAM_DB_DATA[$DB_DATA_INDEX]=""
		done
		DSPAM_MySQL_USER="${DSPAM_DB_DATA[2]}"
		DSPAM_MySQL_PWD="${DSPAM_DB_DATA[3]}"
		DSPAM_MySQL_DB="${DSPAM_DB_DATA[4]}"

		ewarn "When prompted for a password, please enter your MySQL root password"
		ewarn

		einfo "Creating DSPAM MySQL database \"${DSPAM_MySQL_DB}\""
		/usr/bin/mysqladmin -u root -p create ${DSPAM_MySQL_DB}


		if has_version ">dev-db/mysql-4.1"; then
			/usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < ${CONFDIR}/mysql_objects-4.1.sql
		else
			einfo "Creating DSPAM MySQL tables for data objects"
			einfo "  Please select what kind of object database you like to use."
			einfo "    [1] Space optimized database"
			einfo "    [2] Speed optimized database"
			einfo
			while true
			do
				read -n 1 -s -p "  Press 1 or 2 on the keyboard to select database" DSPAM_MySQL_DB_Type
				[[ "${DSPAM_MySQL_DB_Type}" == "1" || "${DSPAM_MySQL_DB_Type}" == "2" ]] && echo && break
			done

			if [ "${DSPAM_MySQL_DB_Type}" == "1" ]
			then
				/usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < ${CONFDIR}/mysql_objects-space.sql
			else
				/usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < ${CONFDIR}/mysql_objects-speed.sql
			fi
		fi

		if use virtual-users ; then
			einfo "Creating DSPAM MySQL database for virtual-users users"
			/usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < ${CONFDIR}/mysql_virtual_users.sql
		fi

		einfo "Creating DSPAM MySQL user \"${DSPAM_MySQL_USER}\""
		/usr/bin/mysql -u root -p -e "GRANT SELECT,INSERT,UPDATE,DELETE ON ${DSPAM_MySQL_DB}.* TO ${DSPAM_MySQL_USER}@localhost IDENTIFIED BY '${DSPAM_MySQL_PWD}';FLUSH PRIVILEGES;" -D mysql
	fi
	if use postgres ; then
		DSPAM_DB_DATA=( $(sed "s:^[\t ]*$:###:gI" "${ROOT}${CONFDIR}/pgsql.data") )
		for DB_DATA_INDEX in $(seq 0 $((${#DSPAM_DB_DATA[@]} - 1))); do
			[[ "${DSPAM_DB_DATA[$DB_DATA_INDEX]}" = "###" ]] && DSPAM_DB_DATA[$DB_DATA_INDEX]=""
		done
		DSPAM_PgSQL_USER="${DSPAM_DB_DATA[2]}"
		DSPAM_PgSQL_PWD="${DSPAM_DB_DATA[3]}"
		DSPAM_PgSQL_DB="${DSPAM_DB_DATA[4]}"

		ewarn "When prompted for a password, please enter your PgSQL postgres password"
		ewarn

		einfo "Creating DSPAM PostgreSQL database \"${DSPAM_PgSQL_DB}\" and user \"${DSPAM_PgSQL_USER}\""
		/usr/bin/psql -h localhost -d template1 -U postgres -c "CREATE USER ${DSPAM_PgSQL_USER} WITH PASSWORD '${DSPAM_PgSQL_PWD}' NOCREATEDB NOCREATEUSER; CREATE DATABASE ${DSPAM_PgSQL_DB}; GRANT ALL PRIVILEGES ON DATABASE ${DSPAM_PgSQL_DB} TO ${DSPAM_PgSQL_USER}; GRANT ALL PRIVILEGES ON SCHEMA public TO ${DSPAM_PgSQL_USER}; UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='${DSPAM_PgSQL_USER}') WHERE datname='${DSPAM_PgSQL_DB}';"

		einfo "Creating DSPAM PostgreSQL tables"
		PGUSER=${DSPAM_PgSQL_USER} PGPASSWORD=${DSPAM_PgSQL_PWD} /usr/bin/psql -d ${DSPAM_PgSQL_DB} -U ${DSPAM_PgSQL_USER} -f ${CONFDIR}/pgsql_objects.sql 1>/dev/null 2>&1

		if use virtual-users ; then
			einfo "Creating DSPAM PostgreSQL database for virtual-users users"
			PGUSER=${DSPAM_PgSQL_USER} PGPASSWORD=${DSPAM_PgSQL_PWD} /usr/bin/psql -d ${DSPAM_PgSQL_DB} -U ${DSPAM_PgSQL_USER} -f ${CONFDIR}/pgsql_virtual_users.sql 1>/dev/null 2>&1
		fi
	fi

	# add mail to the dspam group for mta
	local groups
    	groups=`groups mail`
    	groups=`echo ${groups} | sed -e 's/ /,/g'`
	if [ "'echo ${groups}|grep dspam'" ] ; then
    		usermod -G "${groups},dspam" mail
	fi

        # add apache to the dspam group so the CGIs can access the data
	if use frontend; then
    		groups=`groups apache`
    		groups=`echo ${groups} | sed -e 's/ /,/g'`
		if [ "'echo ${groups}|grep dspam'" ] ; then
    			usermod -G "${groups},dspam" apache
		fi
	fi
}

pkg_prerm() {
        use frontend && webapp_pkg_prerm
}