#!/bin/sh

# mlohn postinst

# check, whether mlohn user exists
if ! mysql -umlohn -pmlohn mlohn -e";"
then
	echo "Installation of mlohn user ..."
	echo "Password of mysql root:"
	read pw
	mysql -uroot -p$pw <<END
create user mlohn@localhost identified by 'mlohn';
create database mlohn;
grant all on mlohn.* to mlohn@localhost;
quit;
END

	echo "Installation of mlohn schema ..."
	mysql -umlohn -pmlohn mlohn </usr/share/php/mLohn/Lohn/etc/schema.sql

	echo "Datainstallation ..."
	mysql -umlohn -pmlohn mlohn </usr/share/php/mLohn/Lohn/etc/insert.sql
else
	echo "Perform upgrade ... if necessary."
	if [ $# -eq 2 ]
	then
		echo "warning: postinst version parameter missing. Setting 1.0"
		vers="1.0"
	else
		vers=$2
	fi
	/usr/share/php/mLohn/Lohn/etc/upgrade $vers || exit 1
fi

# Check existence of mLohn configuration file
if ! [ -e /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php ]
then
	cp /usr/share/php/mLohn/Lohn/impl/ConfigurationData.default.php /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php
	echo "Default configuration copied to /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php"
	echo "Edit this file, if necessary!"
fi

# add sysal site to apache configuration
cd /etc/apache2/sites-available
if ! grep "#mlohn#" default >/dev/null
then
	awk '/<.Virtual/ { print ""; \
	                	print "#mlohn#"; \
		             	print "# Configuration for mLohn Gui"; \
		             	print "   Alias /mlohn/gui/ \"/usr/share/php/mLohn/gui/\""; \
		             	print "   <Directory /usr/share/php/mLohn/gui/>"; \
		             	print "      Options +FollowSymlinks"; \
		             	print "      RewriteEngine On"; \
		             	print "      RewriteBase /mlohn/gui/"; \
		             	print "      RewriteRule ^.*php$ mLohnGUI.php"; \
			          	print "   </Directory>"; \
		        			print "   <Directory /var/www/mlohn/print/>";\
                		print "   	Options Indexes";\
        					print "   </Directory>";\
			         	print "#mlohn end#"; } \
		          {print $0;}' default >xxx

	mv xxx default
	echo "/etc/apache2/sites-available/default changed"
fi

# activate rewrite engine
if ! test -e /etc/apache2/mods-enabled/rewrite.load
then
	ln -s /etc/apache2/mods-available/rewrite.load /etc/apache2/mods-enabled
	echo "rewrite engine enabled"
fi

# restart apache
/etc/init.d/apache2 restart