crontab monitoring alert

Oracle : Shell script for Crontab Monitoring alert

3 years ago by Vinod SiramOracle DB Admin

Hi Readers, In this article, we will see the Oracle : Shell script for Crontab Monitoring alert THIS SCRIPT WILL IDENTIFY changes with the crontab file made comparing with original file.

[oracle@nposqa1 ~]$ cat /home/oracle/DBA/bin/crontab_compare.bash
#!/bin/bash
# set -x
# Get the current crontab entries
# Compare with the expected crontab entries
# Notify if any changes found
#########################################################################################
# Control file locations separately.
# create following variables in the file
# ORIGFILE = Original file to compare the current crontab entries
# EMAILRECIPIENTS='example@example.com'
# EMAILBODY=Location of email body file.

VARIABLES=$1
. $VARIABLES

HOST=$(hostname)
CURRFILE='/tmp/currcron.file'
DIFFILE='/tmp/crondif.file'

crontab -l > $CURRFILE
diff $ORIGFILE $CURRFILE > $DIFFILE

#Function to push email to users on alert
function pushmail
{
SUBJ=$1
MAILBODY=$2
RECIPIENTS=$3
mail -s "$SUBJ" $RECIPIENTS < $MAILBODY
}

if [ -s $DIFFILE ]
then
echo "" > $EMAILBODY
echo "Attention: Found changes in the current crontab entry" >>$EMAILBODY
echo "" >> $EMAILBODY
echo "---- Below are the changes from DIFF command ----" >> $EMAILBODY
echo "" >> $EMAILBODY
cat $DIFFILE >> $EMAILBODY
pushmail "ALERT: Found changes in crontab entry on server $HOST" $EMAILBODY $EMAILRECIPIENTS
fi

[oracle@nposqa1 ~]$ cat /home/oracle/DBA/bin/crontab_compare.bash

#!/bin/bash

# set -x

# Get the current crontab entries

# Compare with the expected crontab entries

# Notify if any changes found

#########################################################################################

# Control file locations separately.

# create following variables in the file

# ORIGFILE = Original file to compare the current crontab entries

# EMAILRECIPIENTS='example@example.com'

# EMAILBODY=Location of email body file.

VARIABLES=$1

. $VARIABLES

HOST=$(hostname)

CURRFILE='/tmp/currcron.file'

DIFFILE='/tmp/crondif.file'

crontab -l > $CURRFILE

diff $ORIGFILE $CURRFILE > $DIFFILE

#Function to push email to users on alert

function pushmail

{

SUBJ=$1

MAILBODY=$2

RECIPIENTS=$3

mail -s "$SUBJ" $RECIPIENTS < $MAILBODY

}

if [ -s $DIFFILE ]

then

echo "" > $EMAILBODY

echo "Attention: Found changes in the current crontab entry" >>$EMAILBODY

echo "" >> $EMAILBODY

echo "---- Below are the changes from DIFF command ----" >> $EMAILBODY

echo "" >> $EMAILBODY

cat $DIFFILE >> $EMAILBODY

pushmail "ALERT: Found changes in crontab entry on server $HOST" $EMAILBODY $EMAILRECIPIENTS

Config file :

[oracle@nposqa1 ~]$ cat /home/oracle/DBA/cfg/crontab_compare.cfg
# Control file locations separately.
# create following variables in the file
# ORIGFILE = Original file to compare the current crontab entries
# EMAILRECIPIENTS='example@example.com'
# EMAILBODY=Location of email body file.

export DIR='/home/oracle/DBA'
export DBA_BIN=${DIR}/bin
export DBA_LOG=${DIR}/log
export DBA_CFG=${DIR}/cfg
export DBA_SQL=${DIR}/sql
export ORIGFILE="${DBA_CFG}/crontab_orig.cron"
export EMAILRECIPIENTS="admin@ktexperts.com"
export EMAILBODY="${DBA_CFG}/crontab_emailbody.file"

[oracle@nposqa1 ~]$ cat /home/oracle/DBA/cfg/crontab_compare.cfg

# Control file locations separately.

# create following variables in the file

# ORIGFILE = Original file to compare the current crontab entries

# EMAILRECIPIENTS='example@example.com'

# EMAILBODY=Location of email body file.

export DIR='/home/oracle/DBA'

export DBA_BIN=${DIR}/bin

export DBA_LOG=${DIR}/log

export DBA_CFG=${DIR}/cfg

export DBA_SQL=${DIR}/sql

export ORIGFILE="${DBA_CFG}/crontab_orig.cron"

export EMAILRECIPIENTS="admin@ktexperts.com"

export EMAILBODY="${DBA_CFG}/crontab_emailbody.file"

Create original crontab file :

cd /home/oracle/DBA/cfg\

1	cd /home/oracle/DBA/cfg\

crontab -l >crontab_orig.cron

1	crontab -l >crontab_orig.cron

Add below… Read More