#!/bin/bash

VERSION="v2014012200"

#------------------------------------------------------------------------------#
### Parameterauswertung

if [ -z "${2}" ] ; then
        PARAMETER_1=""
        PARAMETER_2="${1}"
else
        PARAMETER_1="${1}"
        PARAMETER_2="${2}"
fi

#------------------------------------------------------------------------------#
### Variablen

export OCF_ROOT=/usr/lib/ocf/
ZUGANGSDATEN="$(awk '/^user|^password/{print $1,$NF}' /root/.my.cnf)"
BENUTZER="$(echo "${ZUGANGSDATEN}" | awk '/^user /{print $NF}')"
PASSWORT="$(echo "${ZUGANGSDATEN}" | awk '/^password /{print $NF}')"
DATUMZEIT="$(date +'%Y%m%d%H%M%S')"
TESTDB="Test${DATUMZEIT}"

#------------------------------------------------------------------------------#
### Funktion

MySQLABFRAGE()
{
        unset DBSTATUS
        #mysqlshow -t -u"${BENUTZER}" -p"${PASSWORT}"
        echo "CREATE DATABASE ${TESTDB};" | mysql -u"${BENUTZER}" -p"${PASSWORT}" > /dev/null 2>&1
        #mysqlshow -t -u"${BENUTZER}" -p"${PASSWORT}"
        mysqlshow -t -u"${BENUTZER}" -p"${PASSWORT}" ${TESTDB} > /dev/null 2>&1 && export DBSTATUS=gestartet || export DBSTATUS=gestoppt
        echo "DROP DATABASE ${TESTDB};" | mysql -u"${BENUTZER}" -p"${PASSWORT}" > /dev/null 2>&1
        #mysqlshow -t -u"${BENUTZER}" -p"${PASSWORT}"
}

#------------------------------------------------------------------------------#
### Abarbeitung

case "${PARAMETER_2}" in
        [Ss][Tt][Aa][Rr][Tt])
                MySQLABFRAGE
                STATUSSTATUS="Nein"
                STATUSMONITOR="Nein"
                ;;
        [Ss][Tt][Aa][Tt][Uu][Ss])
                MySQLABFRAGE
                STATUSSTATUS="Ja"
                STATUSMONITOR="Nein"
                ;;
        [Mm][Oo][Nn][Ii][Tt][Oo][Rr])
                MySQLABFRAGE
                STATUSSTATUS="Nein"
                STATUSMONITOR="Ja"
                ;;
        *)
                DBSTATUS="gestartet"
                STATUSSTATUS="Nein"
                STATUSMONITOR="Nein"
                ;;
esac

if [ "${STATUSSTATUS}" == "Ja" -a "${DBSTATUS}" == "gestartet" ] ; then
        echo "running"
elif [ "${STATUSSTATUS}" == "Ja" -a "${DBSTATUS}" == "gestoppt" ] ; then
        echo "stopped"
fi


if [ "${DBSTATUS}" == "gestartet" ] ; then
        #echo /usr/lib/ocf/resource.d/heartbeat/IPaddr2 ${PARAMETER_1} ${PARAMETER_2}
        /usr/lib/ocf/resource.d/heartbeat/IPaddr2 ${PARAMETER_1} ${PARAMETER_2} | sed 's/IPaddr2/mysqlIP/g'
else
        unset DBSTATUS
        if [ "${STATUSMONITOR}" == "Ja" ] ; then
                exit 7;
        else
                exit 3;
        fi
fi
unset DBSTATUS

#------------------------------------------------------------------------------#