nagios监控sqlserver2005镜像

?more /opt/nagios/nagiosweb/libexec/check_mirror
#!/bin/bash
export LD_LIBRARY_PATH=/usr/local/lib
/opt/nagios/nagiosweb/libexec/check_dbmirroringbk? -H $1 -o $2 -d $3 -u $4 -p $5

?

[root@localhost libexec]# more /opt/nagios/nagiosweb/libexec/check_dbmirroringbk
#!/usr/bin/perl -w

use strict;
use Getopt::Long;
use DBI;

# Nagios specific

use lib "/opt/nagios/nagiosweb/libexec/";-----结合nagios安装目录修改
#use lib "/usr/lib/nagios/plugins";
use utils qw(%ERRORS $TIMEOUT);
#my $TIMEOUT = 15;
#my %ERRORS=('OK'=>0,'WARNING'=>1,'CRITICAL'=>2,'UNKNOWN'=>3,'DEPENDENT'=>4);

my $o_host;
my $o_db;
my $o_port;
my $o_user="sa";
my $o_pw="";
my $name="";
my $state="";
my $role="";

sub print_usage {
??? print "n";
??? print "Usage: check_dbmirroring.pl -H <host> -d <database> [-u <username>] [-p <password>] [-o <port>]n";
??? print "n";
??? print "tDefault Username is 'sa' without a passwordnn";
??? print "tScript should be run on the PRINCIPAL with a read-only usern";
??? print "tIf you want to run it on the MIRROR,the user MUST have SYSADMIN rights on the SQL-Servern";
??? print "totherwise you get NULLn";
??? print "n";
}

sub check_options {
??? Getopt::Long::Configure ("bundling");
??? GetOptions(
??????? 'H:s'?? => $o_host,
??????? 'd:s'?? => $o_db,
??????? 'u:s'?? => $o_user,
??????? 'p:s'?? => $o_pw,
??????? 'o:s'?? => $o_port
??????? );
??? if (!defined ($o_host) || !defined ($o_db)) { print_usage(); exit $ERRORS{"UNKNOWN"}};
}

########## MAIN #######

check_options();

my $exit_val;

# Connect to database
my $dbh =DBI->connect("dbi:Sybase:server=$o_host:$o_port","$o_user","$o_pw") or exit $ERRORS{"UNKNOWN"};
my $sth=$dbh->prepare("SELECT d.name,m.mirroring_role_desc,m.mirroring_state_desc
?????????????????????? FROM sys.database_mirroring m
?????????????????????? JOIN sys.databases d ON m.database_id = d.database_id
?????????????????????? WHERE mirroring_state_desc IS NOT NULL AND name = '$o_db'");
$sth->execute;

while (my @row = $sth->fetchrow_array) {
???????? $name=$row["0"];
???????? $role=$row["1"];
??????? $state=$row["2"];
}

$exit_val=$ERRORS{"CRITICAL"};
$exit_val=$ERRORS{"OK"} if ( $role eq "PRINCIPAL" ) && ( $state eq "SYNCHRONIZED" );

print "OK - $name - $role - $staten"??????? if ($exit_val eq $ERRORS{"OK"});
print "CRITICAL - Check your mirroring settingsn" if ($exit_val eq $ERRORS{"CRITICAL"});
exit $exit_val;

?

添加监控命令

define command{
??????? command_name??? check_sqlserver_mirroring
??????? command_line??? $USER1$/check_mirror $HOSTADDRESS$ $_HOSTPORT$ $_SERVICEDBNAME$ $_HOSTDBUSER$ $_HOSTDBPASSWORD$
??????? }

-------------------------------------------------------------------------------------------

添加监控主机和监控服务

define host{
??????? use???????????? windows-server? ;
??????? host_name?????? sql186??? ;
??????? alias?????????? sql186??? ;
??????? address???????? xxx..xx.xx186;
??????? _port?????????? XXXX
??????? _dbuser???????? XXXXXXXXXXXX
??????? _dbpassword???? XXXXXXXXXXXXXXX
??????? }

?

define service{
??????? use???????????????????? generic-service
??????? host_name?????????????? sql186??? ; The name we're giving to this host
??????? _dbname???????????????? user
??????? normal_check_interval?? 2
??????? service_description???? sqlmirror_186_card
??????? check_command?????????? check_sqlserver_mirroring
??????? }

?

?

参考文献

http://labs.consol.de/nagios/check_mssql_health/

?

http://www.voidcn.com/article/p-bquiwaer-bbr.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!