Monitor Sybase error log

 Monitor Sybase error log

#!/bin/sh

#set -x

##

## This scripts scans the errorlog for errors and notifies if

## problems are found.

##

##

## Usage: check_errorlog_and_notify <ASE Server Name>

##

##

##

VERSION="check_errorlog_and_notify Version 1.2"

## Input Parameters for script

SRVNAME=`echo $1 | tr '[a-z]' '[A-Z]'`

ENV_DIR="/sybase_sa"

ENVFILE="$ENV_DIR/.$SRVNAME.env"

##

## Check for correct number of parameters

if [ $# -lt 1 ]

then

    echo "Usage: $0 <SQL-Server Name> "

    exit 1

fi

EXECUTE_ENV()

{

 ##

 ## Check for existence of ASE file

 if [ ! -s $ENVFILE ]

 then

    echo "$ENVFILE files does not exist for ASE Server ($SRVNAME) .."

    echo "Script exiting ..."

    exit 1

 fi

 ##

 ## Source environment (ASE) file

 . $ENVFILE

}

SET_VARIABLES()

{

 ##

 ## Defining system variables

 SA_PW=`$GET_PW $SRVNAME`

 SEARCHFILE="$SRV_LOG/errorlog_$SRVNAME"

 NUMBERED_SEARCHFILE="$SYB_TMP/errorlog_$SRVNAME"

 STARTLINE_FILE="$SYB_BIN/STARTLINE_FILE"

 KEYWORD_FILE="$SYB_BIN/KEYWORDS"

 TEMP_MSGFILE="$SYB_TMP/check_msgfile.$SRVNAME"

 TEMP_MSGFILE1="$SYB_TMP/check_msgfile1.$SRVNAME"

 TEMP_MSGFILE2="$SYB_TMP/check_msgfile2.$SRVNAME"

 MSGFILE="$SYB_TMP/check_msgfile3.$SRVNAME"

 rm -f $NUMBERED_SEARCHFILE $TEMP_MSGFILE $TEMP_MSGFILE1 2>/dev/null

 rm -f $TEMP_MSGFILE2 $MSGFILE 2>/dev/null

}

FIND_COUNTER()

{

 ##

 ## start at this line in log file

 ##

 if [ -f "$STARTLINE_FILE" ]

 then

    STARTLINE=`cat $STARTLINE_FILE`

 else

    STARTLINE=0

 fi

}

CONTINUE_SEARCH()

{

 ##

 ## are there any lines past our start point ?

 ## if not, we are done

 ##

 if [ $STARTLINE -ge `cat $SEARCHFILE | wc -l` ]

 then

    exit 0

 fi

}

CREATE_NUMBER_FILE()

{

 ##

 ## start at starting line number

 ## put line numbers on errorlog for message output

 ##

 LINE_COUNTER=`expr $STARTLINE + 1`

 cat $SEARCHFILE | tail +$STARTLINE | while read SEARCHLINE

 do

   if [ $LINE_COUNTER -ge $STARTLINE ]

   then

      echo "$LINE_COUNTER  $SEARCHLINE" >> $NUMBERED_SEARCHFILE

   fi

   LINE_COUNTER=`expr $LINE_COUNTER + 1`

   echo $LINE_COUNTER > $STARTLINE_FILE

 done

}

KEYWORD_SEARCH()

{

 ##

 ## now get down to business....

 ## grep for errors. KEY_ERROR file has what we grep for and what we ignore

 ##

 cat $KEYWORD_FILE | tail +7 | while read LINE

 do

   KEY_ERROR=`echo $LINE | cut -d~ -f1`

   IGNORE=`echo $LINE | cut -d~ -f2`

   ROWS=`echo $LINE | cut -d~ -f3`

   NUM=`echo $LINE | cut -d~ -f4`

   if [ $NUM -ne 0 ]

   then

      grep -i "$KEY_ERROR" $NUMBERED_SEARCHFILE > $TEMP_MSGFILE2

      NEW_NUM=5

      LAST_NUM=`expr $NUM + 4`

      while [ $LAST_NUM -ge $NEW_NUM ]

      do

        NEW_ERROR=`echo $LINE | cut -d~ -f$NEW_NUM`

        grep -v "$NEW_ERROR" $TEMP_MSGFILE2 > $TEMP_MSGFILE1

        cp $TEMP_MSGFILE1 $TEMP_MSGFILE2

        NEW_NUM=`expr $NEW_NUM + 1`

      done

      if [ $ROWS -ne 0 ]

      then

         cat $TEMP_MSGFILE2 | nawk '{print $1}' | while read FILE_ROW

         do

           FILE_ROW=`expr $FILE_ROW - $STARTLINE`

           cat $NUMBERED_SEARCHFILE | tail +$FILE_ROW | head -$ROWS >> $TEMP_MSGFILE

         done

      else

         mv $TEMP_MSGFILE2 $TEMP_MSGFILE

      fi

   else

      if [ $ROWS -eq 0 ]

      then

         grep -i "$KEY_ERROR" $NUMBERED_SEARCHFILE > $TEMP_MSGFILE

      else

         grep -i "$KEY_ERROR" $NUMBERED_SEARCHFILE | nawk '{print $1}' | while read FILE_ROW

         do

           FILE_ROW=`expr $FILE_ROW - $STARTLINE`

           cat $NUMBERED_SEARCHFILE | tail +$FILE_ROW | head -$ROWS >> $TEMP_MSGFILE

         done

      fi

   fi

   if [ -s "$TEMP_MSGFILE" ]

   then

      rm -f $MSGFILE

      UNIX_SRVR=`grep -w $SRVNAME $SERVERS | grep -w sql | nawk '{print $4}' | head -1`

      if [ "$IGNORE" = "MAIL" ]

      then

         echo "Sql($SRVNAME):Unix($UNIX_SRVR)-MAILONLY: " > $MSGFILE

         cat $TEMP_MSGFILE >> $MSGFILE

      else

         echo "Sql($SRVNAME):Unix($UNIX_SRVR):" > $MSGFILE

         cat $TEMP_MSGFILE | while read LINE

         do

           echo $LINE | cut -d" " -f5- >> $MSGFILE

         done

      fi

      if [ -s "$MSGFILE" ]

      then

        MSGTEXT=`cat $MSGFILE | sed s/\'/\ /g`

        echo "################### `date` #################################"

        cat $MSGFILE

      fi

      MSGTEXT1=`echo $MSGTEXT | cut -c1-210`

      MSGTEXT="$MSGTEXT1 *END*"

      echo "***END***" >> $MSGFILE

      MSG_CNT1=`cat $MSGFILE | wc -c`

      MSG_CNT=`echo $MSG_CNT1`

      TEXT_CNT1=`echo $MSGTEXT | wc -c`

      TEXT_CNT=`echo $TEXT_CNT1`

      $SYB_BIN/send_messages $SRVNAME "$MSGFILE" "$MSGTEXT" BOTH ALL

   fi

   rm -f $TEMP_MSGFILE

 done

}

CLEANUP()

{

 ##

 ## Mom taught us to clean up after ourselves...

 ## remove our work files

 ##

 rm -f $MSGFILE $TEMP_MSGFILE $TEMP_MSGFILE1 $TEMP_MSGFILE2 $NUMBERED_SEARCHFILE 2>/dev/null

}

##

## MAIN SECTION

EXECUTE_ENV

SET_VARIABLES

FIND_COUNTER

CONTINUE_SEARCH

CREATE_NUMBER_FILE

KEYWORD_SEARCH

CLEANUP

exit