ConnectionAvaliable

PostgresMP.Unix.ConnectionAvaliableMonitor (UnitMonitor)

Element properties:

Source Code:

<UnitMonitor ID="PostgresMP.Unix.ConnectionAvaliableMonitor" Accessibility="Internal" Enabled="true" Target="PostgresMP.Unix.Application" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="UnixAuth!Unix.Authoring.ShellScript.MatchesRegExp.ThreeState.MonitorType" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="PostgresMP.Unix.ConnectionAvaliableMonitor.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Host/Property[Type="Unix!Microsoft.Unix.Computer"]/NetworkName$</AlertParameter1>

      <!-- <AlertParameter2>$Data/Context///*[local-name()="StdOut"]$</AlertParameter2> -->

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="StatusOK" MonitorTypeStateID="StatusOK" HealthState="Success"/>

    <OperationalState ID="StatusWarning" MonitorTypeStateID="StatusWarning" HealthState="Warning"/>

    <OperationalState ID="StatusError" MonitorTypeStateID="StatusError" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <Interval>1800</Interval>

    <TargetSystem>

					$Target/Host/Property[Type="Unix!Microsoft.Unix.Computer"]/NetworkName$

		  </TargetSystem>

    <ShellScript>

					#!/bin/sh	

					DATABASE=postgres

					USERNAME=postgres

					OUT=$($1/psql -U "${USERNAME}" "${DATABASE}" -w -t -A -c "SELECT version()")

					if [ -n "$OUT" ]; then

						echo "OK"

					else

						echo "ERROR"

					fi

				</ShellScript>

    <ScriptArguments>$Target/Property[Type="PostgresMP.Unix.Application"]/psqlPath$</ScriptArguments>

    <Timeout>60</Timeout>

    <UserName>$RunAs[Name="Unix!Microsoft.Unix.ActionAccount"]/UserName$</UserName>

    <Password>$RunAs[Name="Unix!Microsoft.Unix.ActionAccount"]/Password$</Password>

    <ErrorRegExp>^ERROR</ErrorRegExp>

    <WarningRegExp>^Warning</WarningRegExp>

  </Configuration>

</UnitMonitor>