#!/bin/sh
set -e
# mlohn postinst

# check MariaDB or MySQL
maria=$(mysql -V |grep MariaDB) || true

# check, whether mlohn user exists
if ! mysql -umlohn -pmlohn mlohn -e";" >/dev/null 2>&1
then
	echo "Installation of mlohn user ..."
	# unix_socket authentification for MariaDB 10
	if [ -n "$maria" ]
	then
		mysql <<END
create user mlohn@localhost identified by 'mlohn';
create database mlohn;
grant all on mlohn.* to mlohn@localhost;
END
	else
		echo "Password of mysql root:"
		read pw
		mysql -uroot -p$pw <<END1
create user mlohn@localhost identified by 'mlohn';
create database mlohn;
grant all on mlohn.* to mlohn@localhost;
END1
	fi

	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
	mysql -umlohn -pmlohn mlohn <<END2
CREATE TABLE version (db_version INT NOT NULL);
INSERT INTO version VALUES (4);
END2
	
else
	echo "Perform upgrade ... if necessary."
	/usr/share/php/mLohn/Lohn/etc/upgrade || 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-enabled
if ! grep "#mlohn#" * >/dev/null
then
	# .conf necessary for Debian 7
	a2ensite mlohn.conf
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

# activate https
a2enmod ssl

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

# create directory for Lohnabrechnungen / Socket
mkdir -p /var/mlohn/print
chown www-data /var/mlohn/print
chgrp www-data /var/mlohn/print
chown www-data /var/mlohn
chgrp www-data /var/mlohn

# pdftkd installieren
#systemctl enable pdftkd
#systemctl restart pdftkd

# suppress debug logging in syslog
sed -i "s/^\*\.\*/*.info/" /etc/rsyslog.conf
systemctl restart rsyslog