Psap at 08:25, 27 December 2007

2007-12-27T08:25:00Z

New page

When you are using Nagios (http://www.nagios.org) as a monitoring tool, it's real easy to implement your own checks for Sybase servers. Here's a sample check to see if your Sybase BackupServer is up and connectable.

===Create Nagios check script===
#!/bin/sh
# Plugin for Nagios to check if a BackupServer is up
# Author Peter Sap (www.petersap.nl)
# All disclamers apply.

if [ $# -ne 1 ]
then
echo "Usage $0: <Backup server>"
exit 1
fi

SERVER=$1

STATE_OK=0
STATE_WARNING=1
STATE_CRITICAL=2
STATE_UNKNOWN=3
STATE_DEPENDENT=4

export SYBASE=<location of OpenClient software>
export SYBASE_OCS=OCS-15_0

$SYBASE/$SYBASE_OCS/bin/isql -Unagios -Pnagios -S${SERVER} -b<<EOF > /tmp/$$
sp_who
go
EOF

if [ `head -n 1 /tmp/$$|grep "CT-LIBRARY"|wc -l` -gt 0 ]
then
rm -f /tmp/$$
echo "Could not connect to ${SERVER}."
exit ${STATE_CRITICAL}
fi

MSG="`head -n 1 /tmp/$$`"
if [ `echo ${MSG}|grep "No language handler installed"|wc -l` -ne 1 ]
then
rm -f /tmp/$$
echo "State of backupserver unknown, ${MSG}"
exit ${STATE_CRITICAL}
fi

rm -f /tmp/$$

echo "Server ${SERVER} up"
exit ${STATE_OK}

Store this script in the Nagios libexec directory with the name "check_sybase_backup_up" . Do a "chmod +x" to make it executable.

==Setup Sybase environment==
Before you go further, check if you have Sybase OpenClient software installed on the server where Nagios is running.

Add the servers you want to monitor to the $SYBASE/interfaces file. Sample:
SYB_BACKUP
query tcp ether prd-syb-ase1 4001
The interfaces file must be stored on the machine where Nagios is running.

==Edit Nagios files==
Define the "check_sybase_backup_up" script in the definition file for commands, e.g. checkcommands.cfg
# 'check_sybase_backup_up' command definition
define command{
command_name check_sybase_backup_up
command_line $USER1$/check_sybase_backup_up $ARG1$
}

Now you can use the command as a service check. Add this sample to the definition file for your checks, to check the SYB_BACKUP server.

define service{
use generic-service
host_name prd-syb-ase1
service_description SYB_BACKUP
is_volatile 0
check_period 24x7
max_check_attempts 4
normal_check_interval 5
retry_check_interval 1
contact_groups admins
notification_options w,u,c,r
notification_interval 960
notification_period 24x7
check_command check_sybase_backup_up!SYB_BACKUP
}

Restart Nagios.

[[category:ASE]]

Nagios plugin for BackupServer - Revision history

Psap at 08:25, 27 December 2007