lausser / check_mssql_health

Wenn du dich für Plugins (oder OMD oder allgemein Monitoring) interessierst oder von deiner Installation erzählen willst...die Tradition der deutschsprachigen Monitoring-Workshops wird wiederbelebt: https://discord.gg/jDfPZ63FcJ A plugin, which checks various parameters of Microsoft SQL database servers.
http://labs.consol.de/nagios/check_mssql_health
GNU General Public License v2.0
39 stars 28 forks source link

Monitoring Sybase Replication Server? #9

Open sebastien-prudhomme opened 10 years ago

sebastien-prudhomme commented 10 years ago

Hi,

I've made an uggly patch to monitor our Sybase Replication Server. Is it possible to include it in official version?

The main patch is:

  } elsif ($params{mode} =~ /^server::replication::status/) {
      my @health = $self->{handle}->fetchrow_array(q{
        ADMIN HEALTH
      });
      my $status = $health[2];
      if (! defined $status) {
        $self->add_nagios_unknown("unable to get replication info");
      } else {
        if ($status eq "HEALTHY") {
          $self->add_nagios_ok(sprintf "replication status: %s, all threads are executing as expected", $status);
        } elsif ($status eq "SUSPECT") {
          $self->add_nagios_critical(sprintf "replication status: %s, not all threads are executing as expected", $status);
        } else {
          $self->add_nagios_unknown(sprintf "replication status: %s", $status);
        }
      }

See there for the command: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.rs_15.0.refman/html/refman/X15699.htm

The ugly patch part is to disable product detection just after the dbconnect (Sybase Replication Server is not a SQL database, so no SELECT statements).