#!/bin/bash

httpuser="openqrm"
httppassword="openqrm"

### /usr/share/openqrm/web/base/server/appliance/appliance-index.php
#
#                        // here we stop
#                        $kernel = new kernel();
#                        $kernel->get_instance_by_id($appliance->kernelid);
#                        // send command to the openQRM-server
#                        $openqrm_server->send_command("openqrm_assign_kernel $resource->id $resource->mac default");
#                        // stop appliance
#                        $return_msg .= $appliance->stop();
#                        $strMsg .= "Stopped appliance $id <br>";
#
# https://192.168.3.11/openqrm/base/server/appliance/appliance-index.php?identifier[]=16&action=stop


if [ -r /usr/share/openqrm/etc/openqrm-server.conf ] ; then
        . /usr/share/openqrm/etc/openqrm-server.conf
else
        exit 1
fi


if [ -z "${1}" ] ; then
        echo "${0} [KVM] [openQRM-Benutzer] [openQRM-Passwort]"
        echo "${0} kvm07 openqrm openqrm"
        echo "${0} kvm07"
        exit 1
else
        KVMHOST="${1}"
fi


if [ -n "${2}" ] ; then
        httpuser="${2}"
fi


if [ -n "${3}" ] ; then
        httppassword="${3}"
fi


echo "SELECT appliance_id,resource_id,resource_openqrmserver,resource_hostname FROM appliance_info,resource_info WHERE appliance_virtualization=3 AND appliance_resources=resource_id AND resource_vhostid=(SELECT appliance_resources FROM appliance_info WHERE appliance_virtualization=2 AND appliance_name='${KVMHOST}') ORDER BY resource_id;" | mysql -N -u${OPENQRM_DATABASE_USER} -p${OPENQRM_DATABASE_PASSWORD} ${OPENQRM_DATABASE_NAME} | while read appliance_id resource_id resource_openqrmserver resource_hostname
do
        echo
        echo "# ${appliance_id} - ${resource_hostname} - ${resource_id}"
        echo " wget --http-user=${httpuser} --http-password=${httppassword} --no-check-certificate -O /dev/null \"https://${resource_openqrmserver}/openqrm/base/server/appliance/appliance-index.php?identifier[]=${resource_id}&action=stop\""
done