| @@ -1,5 +1,5 @@
--- plugin/check_jobs.pl.in.orig 2013-11-02 12:34:30.935086664 +0100
-+++ plugin/check_jobs.pl.in 2013-11-02 13:14:40.207327666 +0100
++++ plugin/check_jobs.pl.in 2013-11-02 13:22:30.733689841 +0100
@@ -20,13 +20,6 @@
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
#
@@ -49,6 +49,21 @@
# Just in case of problems, let's not hang Nagios
$SIG{'ALRM'} = sub {
print "CRITCAL - Plugin Timed out\n";
+@@ -136,12 +146,12 @@
+ &debug(1,"Connect to DB: TRUE");
+
+ if ($opt_T eq 'archived') {
+- $dbQuery = $dbConnect->prepare("SELECT jobstate, count, jobtime, message FROM $dbTable WHERE type='archive'");
++ $dbQuery = $dbConnect->prepare("SELECT jobstate, count, jobtime, message FROM ${dbTable}_jobs WHERE type='archive'");
+ &debug(1,"Query: SELECT jobstate, count, jobtime, message FROM ".$dbTable." WHERE type='archive'");
+ $dbQuery->execute();
+ $jobResult = $dbQuery->fetchrow_hashref();
+ } elsif ($opt_T eq 'deleted') {
+- $dbQuery = $dbConnect->prepare("SELECT jobstate, count, jobtime, message FROM $dbTable WHERE type='delete'");
++ $dbQuery = $dbConnect->prepare("SELECT jobstate, count, jobtime, message FROM ${dbTable}_jobs WHERE type='delete'");
+ &debug(1,"Query: SELECT jobstate, count, jobtime, message FROM ".$dbTable." WHERE type='delete'");
+ $dbQuery->execute();
+ $jobResult = $dbQuery->fetchrow_hashref();
--- plugin/check_snmptraps.pl.in.orig 2013-11-02 12:34:21.551088535 +0100
+++ plugin/check_snmptraps.pl.in 2013-11-02 13:06:10.584945654 +0100
@@ -20,14 +20,6 @@
|
