#!/bin/sh

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

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

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
sleep 2

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


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



# 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 \`Rujel%\`.* TO 'rujel'@'localhost' IDENTIFIED BY '$RUJEL_PASS';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`VseLists\`.* TO 'rujel'@'localhost';" | mysql mysql
echo "GRANT ALL PRIVILEGES ON \`Contacts\`.* TO 'rujel'@'localhost';" | mysql mysql


sed -i s/wikiadmin/$WIKI_PASS/ /usr/share/installed-db-office-server/LocalSettings.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/config/

# Owncloud
echo "create database owncloud;" | mysql
echo "GRANT ALL ON owncloud.* TO 'owncloud'@'localhost.localdomain' IDENTIFIED BY '$OWNCLOUD_PASS';" | mysql wikidb
echo "GRANT ALL ON owncloud.* TO 'owncloud'@'localhost' IDENTIFIED BY '$OWNCLOUD_PASS';" | mysql wikidb
echo "GRANT ALL ON owncloud.* TO 'owncloud'@'%' IDENTIFIED BY '$OWNCLOUD_PASS';" | mysql owncloud
service httpd2 start
curl 'http://localhost/owncloud/index.php' -d "install=true&adminlogin=root&adminpass=to%be%changed&directory=%2Fvar%2Fwww%2Fwebapps%2Fowncloud%2Fdata&dbtype=mysql&dbuser=owncloud&dbpass=$OWNCLOUD_PASS&dbname=owncloud&dbhost=localhost"
service httpd2 stop

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

service mysqld restart && chkconfig mysqld on

mt-install-auto --install=auto --authset='' --lang=ru --datarootauto --dbrootforce --adminpass="$MOODLE_PASS"
