#!/bin/sh
set -e

# sysal postinst

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

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

# check schema
if ! mysql -usysal -psysal sysal -e"select * from alm_bal_mon;" >/dev/null 2>&1
then
	echo "Installation of sysal schema ..."
	mysql -usysal -psysal sysal </usr/share/php/SysAl/AlarmManagement/etc/schema.sql
	mysql -usysal -psysal sysal </usr/share/php/SysAl/AlarmInterface/etc/schema.sql
	mysql -usysal -psysal sysal <<END
		CREATE TABLE version (db_version INT NOT NULL);
		INSERT INTO version VALUES (3);
END
fi

# check default data
id=$(mysql -usysal -psysal sysal -N -e"select id from alm_bal_mon where name='STALBAMO'")
if [ "$id" = "" ]
then
	echo "Datainstallation ..."
	/usr/share/php/SysAl/AlarmManagement/DataInstallation.php
fi

# check schema version
if ! mysql -usysal -psysal -N sysal -e"select * from version" >/dev/null 2>&1
then
	echo "upgrade from DB version 1 not supported"
	exit 1
else
	version=$(mysql -usysal -psysal -N sysal -e"select * from version")
fi

# check for upgrade
if [ $version -ne 3 ]
then
	echo "perform DB upgrade 2 -> 3"
	/usr/share/php/SysAl/AlarmManagement/etc/upgrade
fi

# activate sysal configuration
if ! test -e /etc/apache2/sites-enabled/sysal.conf
then
	ln -s /etc/apache2/sites-available/sysal.conf /etc/apache2/sites-enabled
	echo "sysal-apache2 configration enabled"
fi
# remove old style
if test -L /etc/apache2/sites-enabled/sysal
then
	rm /etc/apache2/sites-enabled/sysal
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

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