Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Monitoring Sybase Replication Server? #9

Open
sebastien-prudhomme opened this issue Aug 8, 2014 · 0 comments
Open

Monitoring Sybase Replication Server? #9

sebastien-prudhomme opened this issue Aug 8, 2014 · 0 comments

Comments

@sebastien-prudhomme
Copy link

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant