linux_setup.sh

#!/bin/sh
if [ "$(id -u)" != "0" ]; then
    echo "This script must be run as root" 1>&2
    exit 1
fi

# Instal required software.
echo "Install required software."
apt-get install -y apache2 libapache2-mod-php5 php5-cli php5-mcrypt php5-mhash curl php5-curl
apt-get install -y php5-json

echo "Mysql server will now be installed, if it is not already, you will be asked for the password for the 'root' user. Choose a good one. After installation you will be asked for this again. This will make sure this install script can create the required user and database for phpminer."
apt-get install -y mysql-server php5-mysql

echo "Please enter the mysql password for the user root:"
read MYSQL_ROOT
if [ -n "$MYSQL_ROOT" ]; then
    echo "Ok."
else
    echo "You really have to provide the password. One more chance."

    echo "Please enter the mysql password for the user root:"
    read MYSQL_ROOT
    if [ -n "$MYSQL_ROOT" ]; then
        echo "Ok."
    else
        echo "Password can not be empty."
        exit 1;
    fi
fi

PW_GOOD=`echo "SELECT 1" | mysql -u root --password=$MYSQL_ROOT 2>&1`

echo $PW_GOOD
if echo "$PW_GOOD" | grep -q ".*Access denied.*"
then
      echo $PW_GOOD
      exit 1;
fi

echo "Please enter the database username for phpminer, this user will be created afterwards and must not exists (Default=phpminer):"
read DB_USER
if [ -n "$DB_USER" ]; then
    echo "Using database user: $DB_USER"
else
    DB_USER="phpminer"
    echo "Using database user: $DB_USER"
fi

echo "Please enter the password for phpminer user which you provided above (REQUIRED):"
read DB_PASS
if [ -n "$DB_PASS" ]; then
    echo "Using database pass: ****** (not shown)"
else
    echo "Database pass is required"
    exit 1;
fi

echo "Please enter the database name for phpminer, this database will be created afterwards and the database user will be granted with all permissions. (Default=phpminer):"
read DB_NAME
if [ -n "$DB_NAME" ]; then
    echo "Using database: $DB_NAME"
else
    DB_NAME="phpminer"
    echo "Using database: $DB_NAME"
fi

echo "Creating database and user"
echo "CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';GRANT USAGE ON *.* TO '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS \`$DB_NAME\`;GRANT ALL PRIVILEGES ON \`$DB_NAME\`.* TO '$DB_USER'@'localhost';" | mysql -u root --password=$MYSQL_ROOT

# Setup required variables.
echo "Setup required variables."
PHPMINER_PATH=`readlink -f $0`
PHPMINER_PATH=`dirname $PHPMINER_PATH`

HOSTNAME=`hostname`
DOMAIN="phpminer.$HOSTNAME"
APACHE_USER=`cat /etc/apache2/envvars | grep APACHE_RUN_USER | awk -F= '{print $2}'`
APACHE_GROUP=`cat /etc/apache2/envvars | grep APACHE_RUN_GROUP | awk -F= '{print $2}'`
APACHE_PORT=`cat /etc/apache2/ports.conf | grep NameVirtualHost | grep -v "add NameVirtualHost" | awk -F : '{print $2}'`

PHPMINER_DB_CFG_PATH="$PHPMINER_PATH/config/config2.php"

# Create config.php
echo "<?php
\$db = array(
    'type' => 'mysql',
    'server' => 'localhost',
    'database' => '$DB_NAME',
    'username' => '$DB_USER',
    'password' => '$DB_PASS',
);
" > $PHPMINER_DB_CFG_PATH;

echo "chown $APACHE_USER:$APACHE_GROUP $PHPMINER_DB_CFG_PATH" | sh

# Install cronjob
echo "Install cronjob."
echo "# /etc/cron.d/phpminer: crontab fragment for phpminer" > /etc/cron.d/phpminer
echo "#  This will run the cronjob script for phpminer to send notifications and other periodic tasks." >> /etc/cron.d/phpminer
echo "* * * * * $APACHE_USER php -f $PHPMINER_PATH/cron.php" >>  /etc/cron.d/phpminer

# Install apache vhost
echo "Install apache2 vhost."
echo "<VirtualHost *:$APACHE_PORT>
        ServerAdmin webmaster@$DOMAIN
        ServerName $DOMAIN

        DocumentRoot $PHPMINER_PATH
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory $PHPMINER_PATH/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride All
        </Directory>

        ErrorLog \${APACHE_LOG_DIR}/error.log

        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn

        CustomLog \${APACHE_LOG_DIR}/access.log combined
</VirtualHost>" > /etc/apache2/sites-available/phpminer
a2ensite phpminer
a2enmod rewrite
service apache2 restart

echo "chown $APACHE_USER:$APACHE_GROUP $PHPMINER_PATH/config" | sh
sed -i "s/localhost/localhost $DOMAIN/g" /etc/hosts


echo "PHPMiner installation finshed."
echo ""
echo "Now you have to install phpminer_rpcclient on each rig you want to control."
echo ""
echo "If you are running phpminer webinterface from a different machine than your normal pc"
echo "then add the network ip-address (the one you got from DHCP or which you manually configurated) from the phpminer webinterface server to your hostfile"
echo ""
echo "if phpminer webinterface runs on your normal pc then add 127.0.0.1 to your host file"
echo ""
echo "The domain for the hostfile is $DOMAIN"
echo ""
echo "example entry for hostfile is '127.0.0.1 $DOMAIN'"
echo ""
echo "After installing all phpminer_rpclient's you can open phpminer within a browser at http://$DOMAIN:$APACHE_PORT"