#!/bin/sh

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

echo "skip-grant-tables" >> /var/lib/mysql/my.cnf
service mysqld start
#service mysqld stop

PASS=`echo "select Password from user where user='root'" | mysql mysql | grep -v ^$ | grep -v ^Password`

echo "update user set Password = '' where user='root'" | mysql mysql

sed -i "s/skip-grant-tables//" /var/lib/mysql/my.cnf

service mysqld restart

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
    echo "update user set Password = '$PASS' where user='root'" | mysql mysql
    exit 1
fi

echo "create database moodle;" | mysql

#rm -rf /var/lib/mysql/db
mysql moodle < /usr/share/installed-db-office-server/moodle.sql
mysql wikidb < /usr/share/installed-db-office-server/wikidb.sql
grep -v '^GRANT' /usr/share/rujel/SQL/firstRun.sql | mysql mysql

#cp -r /usr/share/installed-db-office-server/db/moodle /var/lib/mysql/db/
#cp -r /usr/share/installed-db-office-server/db/wikidb /var/lib/mysql/db/

#service mysqld start

# Moodle access right
echo "GRANT ALL ON moodle.* TO 'moodleuser'@'localhost.localdomain' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle
echo "GRANT ALL ON moodle.* TO 'moodleuser'@'localhost' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle
echo "GRANT ALL ON moodle.* TO 'moodleuser'@'%' IDENTIFIED BY '$MOODLE_PASS';" | mysql moodle

# MediaWiki access right
echo "GRANT ALL ON wikidb.* TO 'wikiuser'@'localhost.localdomain' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb
echo "GRANT ALL ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb
echo "GRANT ALL ON wikidb.* TO 'wikiuser'@'%' IDENTIFIED BY '$WIKI_PASS';" | mysql wikidb

# RUJEL access right
echo "GRANT ALL PRIVILEGES ON \`RujelYear%\`.* TO 'rujel'@'localhost' IDENTIFIED BY '$RUJEL_PASS';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`RujelStatic\`.* TO 'rujel'@'localhost';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`VseLists\`.* TO 'rujel'@'localhost';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`Contacts\`.* TO 'rujel'@'localhost';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`RujelUsers\`.* TO 'rujel'@'localhost';" | mysql mysql

#ROOT_PASS=`pwgen 16 1`

sed -i s/wikiadmin/$WIKI_PASS/ /usr/share/installed-db-office-server/LocalSettings.php
sed -i s/moodleadmin/$MOODLE_PASS/ /usr/share/installed-db-office-server/config.php
sed -i s/RUJELpassword/$RUJEL_PASS/ /etc/webobjects/rujel/modules/database.plist

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

#mysqladmin password $ROOT_PASS

#service mysqld stop

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

echo "update user set Password = '$PASS' where user='root'" | mysql mysql

service mysqld restart && chkconfig mysqld on

