#!/bin/sh

MOODLE_PASS=`pwgen 16 1`
WIKI_PASS=`pwgen 16 1`

service mysqld start
#service mysqld stop

echo "create database wikidb;" | mysql

STATUS=$?
i=0
while [ $i -lt 10 ] && [ "$STATUS" != "0" ]; do
    echo "create database wikidb;" | mysql
    STATUS=$?
    let i=i+1
    if [ "$STATUS" -ge "1" ]; then
	sleep 1
    fi
done

if [ "$i" == "10" ]; then
    exit 1
fi

echo "create database moodle;" | mysql

#rm -rf /var/lib/mysql/db
mysql moodle < /usr/share/installed-db-school-server/moodle.sql
mysql wikidb < /usr/share/installed-db-school-server/wikidb.sql
#cp -r /usr/share/installed-db-school-server/db/moodle /var/lib/mysql/db/
#cp -r /usr/share/installed-db-school-server/db/wikidb /var/lib/mysql/db/

#service mysqld start

echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'moodleuser'@'localhost.localdomain' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle
echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'moodleuser'@'localhost' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle
echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'moodleuser'@'%' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle

echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'wikiuser'@'localhost.localdomain' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb
echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'wikiuser'@'localhost' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb
echo "GRANT DELETE,INSERT,SELECT,UPDATE,LOCK TABLES,CREATE TEMPORARY TABLES ON *.* TO 'wikiuser'@'%' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb

#ROOT_PASS=`pwgen 16 1`

sed -i s/wikiadmin/$WIKI_PASS/ /usr/share/installed-db-school-server/LocalSettings.php
sed -i s/moodleadmin/$MOODLE_PASS/ /usr/share/installed-db-school-server/config.php

cp /usr/share/installed-db-school-server/LocalSettings.php /var/www/webapps/mediawiki/
cp /usr/share/installed-db-school-server/config.php /var/www/webapps/moodle/

#mysqladmin password $ROOT_PASS

#service mysqld stop

echo "init-file=/passwd-init" >> /var/lib/mysql/my.cnf

service mysqld restart && chkconfig mysqld on

cp -rf /usr/share/installed-db-school-server/moodledata/* /var/www/webapps/moodledata/
chown -R apache2:apache2 /var/www/webapps/moodledata
chmod -R a+rwx /var/www/webapps/moodledata
