install.sh

#!/bin/bash

echo "Welcome to Reason";
echo "================="
echo "This script will walk you through the first step of installing Reason."
echo "DO NOT RUN THIS SCRIPT ON UPGRADES!"
echo "Do you wish to continue? (y/n)"
read ans

case $ans in
Y|y) ;;
[Yy][Ee][Ss]) ;;
N|n) exit ;;
[Nn][Oo]) exit ;;
*) echo "Invalid command"
esac

if ! which mysql 1> /dev/null
then
  echo "No Mysql client was not found in your path."
  echo "Enter the path to the mysql client"
  echo "For example /Applications/MAMP/Library/bin/mysql"
  read mysqlcmd
else
  mysqlcmd="mysql"
fi

if ! which mysqladmin 1> /dev/null
then
  echo "Mysqladmin was not found in your path."
  echo "Enter the path to the mysqladmin"
  echo "For example /Applications/MAMP/Library/bin/mysqladmin"
  read mysqladmincmd
else
  mysqladmincmd="mysqladmin"
fi

echo " "
echo "Where's your web root?";
echo "Please supply a path from the root of your server"
echo "DO NOT include a trailing slash."
echo "For example /var/www/htdocs"
read webdir

ln -ns $PWD/reason_4.0/www/ $webdir/reason
ln -ns $PWD/www/ $webdir/reason_package
ln -ns $PWD/thor/ $webdir/thor

echo "Symlinks created"

echo " "

if [ -z ${MYSQL_HOST+x} ]
  then
    echo "Enter the name of your mysql server."
    echo "If you wish to use mysql on this server, enter localhost"
    read mysqlhost
  else
    echo "Based on your environment, the hostname for the mysql server for Reason is '$MYSQL_HOST'"
    mysqlhost=$MYSQL_HOST
fi


echo " "
echo "If you have an account that can create databases and users,"
echo "this script can create the users and databases for you."
echo "If not, you'll need to create a database and user for Reason."
echo "Should this script try to create your database and user? (y/n)"
read permission

case $permission in
Y|y)
    echo "Enter the name of the database Reason should create:"
    read mysqldb

    echo "Enter a mysql user which can create databases:"
    read mysqlroot

    echo "Enter the mysql password for $mysqlroot:"
    read mysqlrootpassy

    #create mysql database and user now
    $mysqladmincmd -u$mysqlroot -p$mysqlrootpassy create $mysqldb;

    echo "Database created."
    echo " "
    echo "It's not recommended to run Reason as the root user"
    echo "Enter a mysql username to use to run Reason:"
    read mysqluser

    echo "Enter a password for your Reason user:"
    read mysqlpassy

    case $mysqlhost in
    localhost)
      mysqlfrom="localhost"
    ;;
    *)
      mysqlfrom="*"
    ;;
    esac

    $mysqlcmd -u$mysqlroot -p$mysqlrootpassy -Bse "GRANT ALL ON $mysqldb.* to $mysqluser@$mysqlfrom identified by '$mysqlpassy';"

;;
N|n)
    echo " "
    if [ -z ${MYSQL_DATABASE+x} ]
      then
        echo "Enter the name of the database you have created for Reason:"
        read mysqldb
      else
        echo "Based on your environment, the database you have created for Reason is '$MYSQL_DATABASE'"
        mysqldb=$MYSQL_DATABASE
    fi

    if [ -z ${MYSQL_USER+x} ]
      then
        echo "Enter the mysql username Reason should use:"
        read mysqluser
      else
        echo "Based on your environment, the database username for Reason is '$MYSQL_USER'"
        mysqluser=$MYSQL_USER
    fi


    if [ -z ${MYSQL_PASSWORD+x} ]
      then
        echo "Enter the mysql password for $mysqluser:"
        read mysqlpassy
      else
        echo "Based on your environment, the database username for Reason is '$MYSQL_PASSWORD'"
        mysqlpassy=$MYSQL_PASSWORD
    fi

;;
*) echo "Invalid command"
esac

$mysqlcmd -u$mysqluser -p$mysqlpassy -h$mysqlhost $mysqldb < $PWD/reason_4.0/data/dbs/reason4.8.sql

sed -e "s/<db>reason/<db>$mysqldb/g" -e "s/<db>thor/<db>$mysqldb/g" -e "s/reason_user/$mysqluser/g" -e "s/some_password/$mysqlpassy/g" -e "s/your.mysql.hostname.or.ip.address/$mysqlhost/g" $PWD/settings/dbs.xml.sample > $PWD/settings/dbs.xml

echo " "
echo "Database complete."

echo " "
echo "Reason will only output errors to ip addresses configured in"
echo "settings/error_handler_settings.php"
echo "Enter the ip address of your developer's workstation"
read devip

sed "s/put_your_ip_here/$devip/g" $PWD/settings/error_handler_settings.php.sample > $PWD/settings/error_handler_settings.php

echo "Great, the nerdy bits are done. Continue the installer by visiting /reason/setup.php on your Web site."