#!/bin/bash
#
# /usr/local/sbin/localezcreate
# Copyright 2001-2002 Jonas Smedegaard <dr@jones.dk>
#
# $Id: localezcreate,v 1.19 2002-12-08 15:06:22 jonas Exp $
#
# Create local eZ Publish site
#
# This script makes use of the Debian package wwwconfig-common if installed
#
# TODO: Ask for and set default language and theme
# TODO: Make a note about installed languages and themes (for smooth upgrades)
# TODO: Make md5 of all files (for smooth upgrades)
# TODO: Make script (mostly) work as noon-root

set -e

prg=`basename $0`

TEMP=`getopt -o hu:g:d:m:f::v --long help,user:,group:,domain:,mailuser:,maildomain:,dbname:,dbserver:,dballow:,force::,verbose -n "$prg" -- "$@"`

# Check for non-GNU getopt
if [ $? != 0 ] ; then echo "Terminating..." >&2 ; exit 1 ; fi

eval set -- "$TEMP"

# Defaults are evaluated at runtime in this order
# (If changing defaults, you might need to change these as well)
opts1="user group domain maildomain dbserver dballow" # Options with self-contained defaults
opts2="dbuser home" # Options requiring $opts1 to resolve default
opts3="mailuser dbname basedir adminhost webcfg" # Options requiring $opts1, $opts2 or $host to resolve default

# Defaults
defaultuser="www-data"
defaultgroup="www-data"
defaultdomain="ez."`hostname -d`
defaultmailuser='$dbuser'
defaultmaildomain=`cat /etc/mailname 2> /dev/null || hostname -d`
defaultdbname='ez_2_2_$host' # TODO: Allow all defaults to be set like this
defaultdbuser='$user'
defaultdbserver="localhost"
defaultdballow="localhost"
defaultforce="off"

# Defaults not (yet) user configurable
templates=""
languages="en_GB en_GB_org"
sqlchunks="publish data"
defaulthome="/var/www"
defaultbasedir='/var/www/ez-$host.$domain'
defaultadminhost='admin.$host.$domain'
defaultwebcfg='/etc/apache/vhosts.d/ez-$host.$domain'
templatedirs="/usr/src/ezpublish/templates"
languagedirs="/usr/src/ezpublish/lang"
sqldirs="/usr/share/ezpublish/sql"

# Override defaults from config file if available
if [ -e /etc/local/localezcreate.conf ]; then
	. /etc/local/localezcreate.conf
fi

# These are unlikely to change
sourcedirs="/usr/src/ezpublish"
sources="lib data tpl www"
bindir="/usr/share/ezpublish/bin"

function usage() {
	echo "Usage: $prg [OPTION]... HOST [HOST]..."
	echo "Create local eZ Publish sites"
	echo
	echo "Mandatory arguments to long options are mandatory for short options too."
	echo "  -h, --help               Show this help"
	echo "  -u, --user=UID           System user id (default: $defaultuser)"
	echo "  -g, --group=GID          System group id (default: $defaultgroup)"
	echo "  -d, --domain=DOMAIN      Domain name with hostname stripped off (default:"
	echo "                             $defaultdomain)"
	echo "      --mailuser=UID       User part of mail address (default: $defaultmailuser)"
	echo "  -m, --maildomain=DOMAIN  Domain part of mail address (default:"
	echo "                             $defaultmaildomain)"
	echo "      --dbname=DB          MySQL database name (default:"
	echo "                             $defaultdbname)"
	echo "      --dbuser=UID         MySQL database user (default: $defaultdbuser)"
	echo "      --dbserver=HOST      IP or host of MySQL server (default:"
	echo "                             $defaultdbserver)"
	echo "      --dballow=HOST       IP or host of eZ server (default:"
	echo "                             $defaultdballow)"
	echo "  -f, --force[=FLAG]       Replace existing installation (default: $defaultforce)"
	echo "  -v, --verbose            Be talkative during installation"
	echo
	echo "Each HOST is a simple hostname, without the domain part."
	echo
	echo "MySQL password for \$dbuser can be stored in \$HOME/.my.cnf of \$user."
}

function setparams () {
	for param in $@; do
		# TODO: Check here if default exists or fail loudly
		eval "$param=`eval \"echo \"\\\"\$\{$param:-\\\$default${param}\}\\\"\"\"`"
		[ $verbose ] && echo "--> $param="`eval echo \$\{$param\}`
	done
}

while true ; do
	case "$1" in
		-h|--help) usage; exit 0;;
		-u|--user) user="$2"; shift 2;;
		-g|--group) group="$2"; shift 2;;
		-d|--domain) domain="$2"; shift 2;;
		-a|--mailuser) mailuser="$2"; shift 2;;
		-m|--maildomain) maildomain="$2"; shift2 ;;
		--dbname) dbname="$2"; shift 2;;
		--dbuser) dbuser="$2"; shift 2;;
		--dbserver) dbserver="$2"; shift 2;;
		--dballow) dballow="$2"; shift 2;;
		-f|--force)
			case "$2" in
				""|on) force="on"; shift 2;;
				*) force="off"; shift 2;;
			esac
			;;
		-v|--verbose) verbose="1"; shift;;
		--) shift; break;;
		*) echo "Internal error!" ; exit 1 ;;
	esac
done

setparams $opts1
setparams $opts2

# Attempt to figure out dbpass, dbadmin and dbadmpass, else ask for them
if [ -z "$dbpass" ]; then
	if [ -f $home/.my.cnf ]; then
		dbpass=$(grep password $home/.my.cnf | awk -F= '{print $2}' | head -1 | sed 's/^ //g')
	fi
	if [ -z "$dbpass" ]; then
		echo -n "Enter MySQL password for $dbuser: "
		read -s dbpass
		echo
	fi
fi
if [ -e /usr/share/wwwconfig-common/mysql-localadmpass.get -a "$dbserver" = "localhost" ] ; then
	status=""
	. /usr/share/wwwconfig-common/mysql-localadmpass.get
	if [ "$status" = "error" ] ; then
		[ $verbose ] && echo "$error"
	fi
fi
if [ -z "$dbadmpass" ]; then
	echo -n "Enter MySQL administrator (usually root): "
	read -s dbadmin
	echo
	echo -n "Enter MySQL root password: "
	read -s dbadmpass
	echo
fi

# Do not force TCP/IP access when connecting locally
optdbserver=""
if [ "$dbserver" != "localhost" ]; then
	optdbserver="-p$dbserver"
fi

##############################################
# The rest of the script is host-specific... #
##############################################

for host do

echo "Installing $host..."

setparams $opts3

if [ -d $basedir -o -d $webcfg ]; then
	echo "WARNING: Target dir or Apache config snippet already exists."
	echo -n "         Purge existing installation (y/N)?: "
	read -s ack
	echo
	case $ack in
	    y|Y)
		mysqladmin -u$dbadmin -p$dbadmpass $optdbserver drop $dbname
		rm -rf $basedir
		;;
	    *)
		echo "Installation aborted!"
		exit 1
		;;
	esac
fi

[ $verbose ] && echo "Create database $dbname"
if [ -e /usr/share/wwwconfig-common/mysql-createdb.sh ] ; then
	status=""
	. /usr/share/wwwconfig-common/mysql-createdb.sh
	if [ "$status" = "error" ] ; then
		echo "$error"
		exit 1
	fi
else
	mysqladmin -u$dbadmin -p$dbadmpass $optdbserver create $dbname
fi

[ $verbose ] && echo "Create/update database user $dbuser"
if [ -e /usr/share/wwwconfig-common/mysql-createuser.sh ] ; then
	status=""
	. /usr/share/wwwconfig-common/mysql-createuser.sh
	if [ "$status" = "error" ] ; then
		echo "$error"
		exit 1
	fi
	for h in `echo "localhost $dballow" | sort -u`; do
		echo "GRANT INDEX ON $dbname.* TO '$dbuser'@$h IDENTIFIED BY '$dbpass';" | mysql -u$dbadmin -p$dbadmpass $optdbserver
	done
else
	for h in `echo "localhost $dballow" | sort -u`; do
		echo "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX ON $dbname.* TO '$dbuser'@$h IDENTIFIED BY '$dbpass';" | mysql -u$dbadmin -p$dbadmpass $optdbserver
	done
fi

for chunk in $sqlchunks; do
	[ $verbose ] && echo -n "Feeding $chunk into database: "
	found=""
	for dir in $sqldirs; do
		if [ -f $dir/${chunk}_mysql.sql ]; then
			found="1"
			sqldir=$dir
			sqlfile=${chunk}_mysql.sql
			break
		fi
	done
	if [ "$found" = "1" ]; then
		if [ -e /usr/share/wwwconfig-common/mysql-exec.sh ] ; then
			status=""
			(cd $sqldir && . /usr/share/wwwconfig-common/mysql-exec.sh)
			if [ "$status" = "error" ] ; then
				echo "$error"
				exit 1
			fi
		else
			cat $sqldir/$sqlfile | mysql -u$dbadmin -p$dbadmpass $optdbserver $dbname
		fi
		echo -n " "
	else
		[ $verbose ] && echo
		echo "ERROR: $chunk not found!"
		exit 1
	fi
done
[ $verbose ] && echo

for area in source language template; do
	[ $verbose ] && echo -n "Unpacking $area files: "
	for tarball in `eval echo \$\{$area\}s`; do
		[ $verbose ] && echo -n "$tarball"
		found=""
		for dir in `eval echo \$\{$area\}dirs`; do
			if [ -f $dir/$tarball.tar.gz ]; then
				found="1"
				(cd $basedir; tar -xz -C $basedir -f $dir/$tarball.tar.gz)
				break
			fi
		done
		if [ "$found" = "1" ]; then
			echo -n " "
		else
			[ $verbose ] && echo
			echo "ERROR: $area $tarball not found!"
			exit 1
		fi
	done
done
[ $verbose ] && echo

[ $verbose ] && echo "Configuring website"
su $user -c "
	set -e
	cd $basedir
	$bindir/modfix.sh >/dev/null
	$bindir/secure_modfix.sh $user $group >/dev/null
	mkdir -p override
	echo \"[site]
SiteURL=$host.$domain
AdminSiteURL=$adminhost
UserSiteURL=$host.$domain
SiteTitle=$host eZ site
Keywords=$host $maildomain
SiteAuthor=someone at $maildomain
SiteCopyright=someone &copy; 2001
SiteDescription=a web application suite
SiteKeywords=Content Management System, CMS, e-commerce
Database=$dbname
User=$dbuser
Server=$dbserver
Password=$dbpass

[eZUserMain]
DefaultCountry=58

[eZTradeMain]
OrderSenderEmail=$mailuser@$maildomain
OrderReceiverEmail=$mailuser@$maildomain
mailToAdmin=$mailuser@$maildomain
ForceSSL=disabled
ApacheUser=UserApacheRunsAs

[eZForumMain]
ReplyAddress=$mailuser@$maildomain
\"	> override/site.ini.append
"

chown -R $user:$group $basedir

[ $verbose ] && echo "Configuring Apache"
echo "# Generated for $pkg by $(basename $0)
<VirtualHost *>
	ServerName	$host.$domain
	ServerAdmin	$mailuser@$maildomain
	DocumentRoot	$basedir
	user		$user
	group		$group
	<Directory $basedir>
		Options		FollowSymLinks
		AllowOverride	None 
	</Directory>
	php_flag	magic_quotes_gpc off
	RewriteEngine	On
	RewriteRule	^/stats/store/(.*).gif\$ $basedir/ezstats/user/storestats.php [S=4]
	RewriteRule	^/filemanager/filedownload/([^/]+)/(.*)\$ $basedir/ezfilemanager/files/\$1 [T=\"application/oct-stream\",S=3]
	RewriteRule	.*/ezmediacatalogue/catalogue/(.*)\$ $basedir/ezmediacatalogue/catalogue/\$1 [T=\"application/oct-stream\",S=2]
	RewriteRule	^/xmlrpc.*\$  $basedir/index_xmlrpc.php [S=1]
	RewriteRule	!\.(gif|css|jpg|png|jar|wbmp)\$ $basedir/index.php
</VirtualHost>
<VirtualHost *>
	ServerName	$adminhost
	ServerAdmin	$mailuser@$maildomain
	DocumentRoot	$basedir
	user		$user
	group		$group
	<Directory $basedir>
		Options		FollowSymLinks
		AllowOverride	None 
	</Directory>
	php_flag	magic_quotes_gpc off
	RewriteEngine	On
	RewriteRule	.*/ezmediacatalogue/catalogue/(.*)\$ $basedir/ezmediacatalogue/catalogue/\$1 [T=\"application/oct-stream\",S=1]
	RewriteRule     !\.(gif|css|jpg|png|jar|wbmp) $basedir/index_admin.php
</VirtualHost>
<VirtualHost *>
	ServerName	www.$host.$domain
	RewriteEngine	On
	RewriteRule	/ http://$host.$domain/ [R]
	TransferLog	/dev/null
</VirtualHost>" > $webcfg

done

echo "All done! (Remember to reload the webserver...)"