#!/bin/bash

VERSION="v2014012300"

#------------------------------------------------------------------------------#
### 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}"

#------------------------------------------------------------------------------#
### MySQL-Kontrolle

unset DBSTATUS
echo "CREATE DATABASE ${TESTDB};" | mysql -u"${BENUTZER}" -p"${PASSWORT}" > /dev/null 2>&1
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

if [ "${DBSTATUS}" == "gestoppt" ] ; then
        KONFIGURATION="$(crm configure show | sed 's#[ \t]$# #;s#.*#&|#;s#[\][|]##g' | tr -s '\n' ' ' | tr -s '|' '\n' | grep -F mysqlIP | tr -s ' ' '\n' | grep -E 'ip=|nic=')"
        IPA="$(echo "${KONFIGURATION}" | awk '/ip=/{sub("="," ");print $NF}' | tr -d '"')"
        NIC="$(echo "${KONFIGURATION}" | awk '/nic=/{sub("="," ");print $NF}' | tr -d '"')"
        IP_ADDR_AUSGABE="$(ip addr | grep "${IPA}")"

        if [ -n "${IP_ADDR_AUSGABE}" ] ; then
                unset DBSTATUS
                IPNETZ="$(echo "${IP_ADDR_AUSGABE}" | awk '{print $2}')"

                halt -p
        fi
fi

#------------------------------------------------------------------------------#
### IP-Management

. /usr/lib/ocf/resource.d/heartbeat/.ocf-shellfuncs

#echo /usr/lib/ocf/resource.d/heartbeat/IPaddr2 ${@}
/usr/lib/ocf/resource.d/heartbeat/IPaddr2 ${@} | sed 's/IPaddr2/mysqlIP/g'

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