check_mssql_health

Call me noob but I don't get it. The documentation states the following...

Please keep in mind that check_mssql_health’s functionality is limited when using SQL Server authentication. This method is strongly discouraged . Normally there is already a Nagios-(Windows-)-user which can be used for the Windows authentication method.

So how is this possible on a Linux server? With an NRPE plugin on the remote machine? But how? What am I missing?

Hi,
This script works fine for what I needed. Except for mode failed-job. Many error about uninitialized value and there is no way to filter on the job name.
So, I've debugged the script for this part and added a --filter parameter that take a regex and filter on the job name.
You can find my version of the script here : https://pastebin.com/1VvwuSfa

Plugin is working without error but only the connection-time mode seems to return some values. The others just return "OK"
Connecting to database with sa so I don't think it's permission related.

I say average because:
1) It obviously works for SOMEONE here
2) My experience mirrors the user from 2009, who said:
"Not easy to get working, still having hell of a time getting DBD::Sybase to install. Really would like to have this but most likely wont due to sybase requirement."
It's a pity that linux software/tool config&install details have to remain cryptic and/or non-existent.
I'm not a newbie, but just trying to get this thing up & running is fairly painful..
;(
I REALLY want(ed) it to work..

Hello!
I want to ask you about the check_mssql_health plug in. The plug in works properly in the server in any mode but this does not happen in Nagios web version. Could you help me with this please?

Error: UNKNOWN - cannot create status dir /var/tmp/check_mssql_health! check your filesystem (permissions/usage/integrity) and disk devices, cannot write status file /var/tmp/check_mssql_health/cpu-busy_secs_busy_ip-server

how can i check multiple databases with --name options ? , can i check all database but not system databases (tempdb,model ecc) ?

Hi there

Unfortunately on the labs.consol.de page there is an issue with the download link to the plugins. The links are pointing to "download/nagios/check_mssql_health-1.5.20.6.tar.gz" which is not working.

Regards

Marc

Script errored due to empty $minutessincestart:

sub nagios {
my $self = shift;
my %params = @_;
if (! $self->{nagios_level}) {
if ($params{mode} =~ /server::jobs::failed/) {
if ($self->{lastrunstatus} ne "succeeded") {
if ($self->{lastrunstatus} eq "failed") {
$self->add_nagios_critical(
sprintf "%s failed: %s", $self->{name}, $self->{lastrunstatusmessage});
} elsif ($self->{lastrunstatus} eq "retry" || $self->{lastrunstatus} eq "canceled") {
$self->add_nagios_warning(
sprintf "%s %s: %s", $self->{name}, $self->{lastrunstatus}, $self->{lastrunstatusmessage});
} else {
if ($self->{lastrunstatus}) {
print "else: $params{mode} $self->{name} $self->{lastrunstatus}
";
$self->add_nagios(
$self->check_thresholds($self->{lastrundurationseconds}, 60, 300),
#sprintf("job %s ran for %d seconds (started %s)
", $self->{name},
sprintf("job %s ran for %d seconds (started %s)", $self->{name},
$self->{lastrundurationseconds}, $self->{lastrundatetime}));
}
}
} else {
print "OK - $self->{name}, $self->{lastrundurationseconds}, $self->{lastrundatetime}
";
}
}
}
}


Script alerted if lastrunstatus was not set:

sub nagios {
my $self = shift;
my %params = @_;
if (! $self->{nagios_level}) {
if ($params{mode} =~ /server::jobs::failed/) {
if ($self->{lastrunstatus} ne "succeeded") {
if ($self->{lastrunstatus} eq "failed") {
$self->add_nagios_critical(
sprintf "%s failed: %s", $self->{name}, $self->{lastrunstatusmessage});
} elsif ($self->{lastrunstatus} eq "retry" || $self->{lastrunstatus} eq "canceled") {
$self->add_nagios_warning(
sprintf "%s %s: %s", $self->{name}, $self->{lastrunstatus}, $self->{lastrunstatusmessage});
} else {
if ($self->{lastrunstatus}) {
print "else: $params{mode} $self->{name} $self->{lastrunstatus}
";
$self->add_nagios(
$self->check_thresholds($self->{lastrundurationseconds}, 60, 300),
#sprintf("job %s ran for %d seconds (started %s)
", $self->{name},
sprintf("job %s ran for %d seconds (started %s)", $self->{name},
$self->{lastrundurationseconds}, $self->{lastrundatetime}));
}
}
} else {
print "OK - $self->{name}, $self->{lastrundurationseconds}, $self->{lastrundatetime}
";
}
}
}
}

Thank you very much. Works like a charm.

There is an english translation on the project site.

Connecting with the perl Sybase module can be somewhat tricky.
I finally got a succesfull connection this way:

1 - Edit /etc/freetds/freetds.conf

[sqlhost1]
host = 192.168.1.1
port = 1433
tds version = 8.0

2 - Use the --server command line option instead of the --hostname option:

check_mssql_health --server=sqlhost1 --username=nagiosuser --password=nagiospass --mode connected-users

The document is in german, I didn't found any how-to install :(

Not easy to get working, still having hell of a time getting DBD::Sybase to install. Really would like to have this but most likely wont due to sybase requirement.