#!/bin/bash
#########################################
#	Aquest script és obra de	#
#	  Fran Hermoso - franhp		#
#	Creative Commons by-nc-sa	#
#########################################

## Joomla
jdownloadpath="http://joomlacode.org/gf/download/frsrelease/9323/35155/Joomla_1.5.9-Stable-Full_Package-Catalan.zip"
jdbuser="joomlauser"
jdbpasswd="joomlapasswd"
jdbhost="localhost"
jdbname="joomla"

## Mediawiki
mdbuser="mediawikiuser2"
mdbpasswd="mediawikipasswd2"
mdbhost="localhost2"
mdbname="mediawiki2"

######################################
#DON'T TOUCH ANYTHING BELOW THIS LINE#
######################################

if [ "$(whoami)" != "root" ]; then
    echo "#####################################################"
    echo "###Si vols executar aquest script, has de ser root###"
    echo "#####################################################"
    exit 1
fi

currentdir=`pwd`

echo Instal·lant dependències del Servidor Web
apt-get -y -qq install mysql-server php5 php5-mysql apache2 
echo Fet

echo Configurant Joomla

#Creant usuari de joomla a la bd
echo "Insereixi la contrasenya de root de la base de dades"
read dbrootpasswd
echo "create database ${jdbname}" | mysql -u root -p${dbrootpasswd} -h ${jdbhost}
echo "grant all on ${jdbname}.* to '${jdbuser}'@'${jdbhost}' identified by '${jdbpasswd}'" | mysql -u root -p${dbrootpasswd} -h ${jdbhost}

# Posant joomla al seu directori
cd /var/www/
mkdir joomla
wget ${jdownloadpath}
echo Instal·lant unzip
apt-get -y -qq install unzip
cd joomla
unzip ../`basename ${jdownloadpath}`
cd ..
rm `basename ${jdownloadpath}`
cd joomla

#Copiant dades i configuracions
cp $currentdir/configs/configuration.php .
sed -e '/var $host/s/localhost/'${jdbhost}'/' -e '/var $user/s/joomlauser/'${jdbuser}'/' -e '/var $password/s/joomlapasswd/'${jdbpasswd}'/' -e '/var $db/s/joomla/'${jdbname}'/' configuration.php > configuration.php.tmp

mv configuration.php.tmp configuration.php

rm -rf installation/
mysql -u ${jdbuser} -p${jdbpasswd} -h ${jdbhost} < $currentdir/bdbackups/backup_joomla.sql
#Permisos
chmod 772 administrator/backups/ administrator/components/ administrator/language/ administrator/language/ca-ES/ administrator/language/en-GB/ administrator/modules/ administrator/templates/ components/ images/ images/banners/ images/stories/ language/ language/ca-ES/ language/en-GB/ language/pdf_fonts/ media/ modules/ plugins/ plugins/content/ plugins/editors/ plugins/editors-xtd/ plugins/search/ plugins/system/ plugins/user/ plugins/xmlrpc/ tmp/ templates/ cache/ administrator/cache/
chown -R www-data:www-data ../joomla/
cd ..
echo Fet

echo Configurant Mediawiki
apt-get -y -qq install mediawiki
echo "create database ${mdbname}" | mysql -u root -p${dbrootpasswd} -h ${mdbhost}
echo "grant all on ${mdbname}.* to '${mdbuser}'@'${mdbhost}' identified by '${mdbpasswd}'" | mysql -u root -p${dbrootpasswd} -h ${mdbhost}
ln -s /usr/share/mediawiki/ /var/www/mediawiki

#Copiant configuració
cd mediawiki
cp $currentdir/configs/LocalSettings.php .
sed -e '/$wgDBserver/s/localhost/'${mdbhost}'/' -e '/$wgDBuser/s/mediawikiuser/'${mdbuser}'/' -e '/$wgDBpassword/s/mediawikipasswd/'${mdbpasswd}'/' -e '/$wgDBname/s/mediawiki/'${mdbname}'/' LocalSettings.php > LocalSettings.php.tmp
mv LocalSettings.php.tmp /etc/mediawikiki/LocalSettings.php
rm LocalSettings.php
#BBDD
mysql -u ${mdbuser} -p${mdbpasswd} -h ${mdbhost} < $currentdir/bdbackups/backup_mediawiki.sql
#Permisos?
#chown -R www-data:www-data /usr/share/mediawiki/
cd ..
echo Fet

/etc/init.d/apache2 restart
# PHP display_errors

echo Configurant Mailman i Correus
cd $currentdir
apt-get -y -qq install mailman
newlist mailman
newlist llista
newlist coordinacio
newlist servidor
newlist traduccio
newlist web
newlist scarborough
newlist catux-usb
newlist devnull
cat aliases.txt >> /etc/aliases
newaliases
echo Fet