====== openQRM - Cloud/VM per Skript stoppen ======

  #!/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