X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/projects.git/blobdiff_plain/efa81b77e9cd610758ccc80eaf00093542a521a5..cbabc7139cc6dce50483157c45f5aef80966c07c:/debian/verleihnix.postinst

diff --git a/debian/verleihnix.postinst b/debian/verleihnix.postinst
new file mode 100755
index 0000000..4f72e56
--- /dev/null
+++ b/debian/verleihnix.postinst
@@ -0,0 +1,42 @@
+#!/bin/bash
+set -e
+
+# check MariaDB or MySQL
+maria=$(mysql -V |grep MariaDB) || true
+
+# check, whether mkrimi user exists
+if ! mysql -umkrimi -pmkrimi mkrimi -e";"
+then
+	echo "Installation of mkrimi user ..."
+	# unix_socket authentification for MariaDB 10
+	if [ -n "$maria" ]
+	then
+		mysql <<END
+create user mkrimi@localhost identified by 'mkrimi';
+create database mkrimi;
+grant all on mkrimi.* to mkrimi@localhost;
+END
+	else
+		echo "Password of mysql root:"
+		read pw
+		mysql -uroot -p$pw <<END1
+create user mkrimi@localhost identified by 'mkrimi';
+create database mkrimi;
+grant all on mkrimi.* to mkrimi@localhost;
+END1
+	fi
+fi
+
+# check schema
+if ! mysql -umkrimi -pmkrimi mkrimi -e"select * from medium;" >/dev/null 2>&1
+then
+	echo "Installation of mkrimi schema ..."
+	mysql -umkrimi -pmkrimi mkrimi </usr/share/php/verleihnix/Verleihnix/impl/data/build/sql/schema.sql
+fi
+
+# Apache configuration
+sctl=$(which systemctl) || sctl=$(which sysd2sysv) || (echo "install sysd2sysv"; exit 1)
+
+a2ensite verleihnix
+$sctl reload apache2
+