DB2 monitoring error check_db2_health

[jsburge]

The same one I started with. I get errors running this locally and when I try to configure it within NagiosXI.

root@qwmsdb201:/opt/nagios/libexec# ./check_db2_health --username=nagios --password=nagios --database=AWGQA --mode=lock-waits
CRITICAL - cannot connect to AWGQA. install_driver(DB2) failed: Can't load '/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/DB2/DB2.so' for module DBD::DB2: rtld: 0712-001 Symbol SQLCancel was referenced
from module /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/DB2/DB2.so(), but a runtime definition
of the symbol was not found.
....................

[tmcdonald]

What perl version are you running?

Can you post "perl -V" (capital V) in code wraps please? I think the issue might be that the DBD module was compiled against a different target than your system. 32bit vs 64bit, perl5.8 vs perl6.0, etc.

[jsburge]

The same ones that I started with.

[abrist]

Code: Select all

file /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/DB2/DB2.so
perl -V

There is a good chance that you are having architecture issues (32 vs. 64)

[jsburge]

This is what I get when running the perl -V.

# file /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/DB2/DB2.so
perl -V/usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBD/DB2/DB2.so:
executable (RISC System/6000) or object module not stripped

[tmcdonald]

It looks like you didn't run the perl command properly. We need you to do the following:

Type this into the Nagios server command line:

Code: Select all

perl -V

and then press Enter. Note that this is a capital V, not a lower-case v.

Post that command's output here.

[jsburge]

Summary of my perl5 (revision 5 version 10 subversion 1) configuration:

Platform:
osname=linux, osvers=2.6.32-220.el6.x86_64, archname=x86_64-linux-thread-mul ti
uname='linux c6b8.bsys.dev.centos.org 2.6.32-220.el6.x86_64 #1 smp tue dec 6 19:48:22 gmt 2011 x86_64 x86_64 x86_64 gnulinux '
config_args='-des -Doptimize=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fex ceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DDEBUG GING=-g -Dversion=5.10.1 -Dmyhostname=localhost -Dperladmin=root@localhost -Dcc= gcc -Dcf_by=Red Hat, Inc. -Dprefix=/usr -Dvendorprefix=/usr -Dsiteprefix=/usr/lo cal -Dsitelib=/usr/local/share/perl5 -Dsitearch=/usr/local/lib64/perl5 -Dprivlib =/usr/share/perl5 -Darchlib=/usr/lib64/perl5 -Dvendorlib=/usr/share/perl5/vendor _perl -Dvendorarch=/usr/lib64/perl5/vendor_perl -Dinc_version_list=5.10.0 -Darch name=x86_64-linux-thread-multi -Dlibpth=/usr/local/lib64 /lib64 /usr/lib64 -Duse shrplib -Dusethreads -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun - Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstal lusrbinperl=n -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr -Dd_getho stent_r_proto -Ud_endhostent_r_proto -Ud_sethostent_r_proto -Ud_endprotoent_r_pr oto -Ud_setprotoent_r_proto -Ud_endservent_r_proto -Ud_setservent_r_proto -Dscri ptdir=/usr/bin -Dusesitecustomize'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -f stack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' ,
optimize='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-pr otector --param=ssp-buffer-size=4 -m64 -mtune=generic',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-prot ector -I/usr/local/include'
ccversion='', gccversion='4.4.7 20120313 (Red Hat 4.4.7-3)', gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize =8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -fstack-protector'
libpth=/usr/local/lib64 /lib64 /usr/lib64
libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.12'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-rpath, /usr/lib64/perl5/CORE'
cccdlflags='-fPIC', lddlflags='-shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOU RCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=gener ic'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_64_BIT_ALL
USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
USE_PERLIO USE_REENTRANT_API USE_SITECUSTOMIZE
Built under linux
Compiled at Apr 30 2013 12:24:05
@INC:
/usr/local/lib64/perl5
/usr/local/share/perl5
/usr/lib64/perl5/vendor_perl
/usr/share/perl5/vendor_perl
/usr/lib64/perl5
/usr/share/perl5
.

[tmcdonald]

Just a guess, but it looks like some time in-between version 5.8.8 and 5.10.1 the paths did not get updated, because perl is looking for a module in /usr/opt/perl5/lib/site_perl/5.8.8

What happens when you run "ls -l /usr/opt/perl5/lib/site_perl/"? Please post the output.

[cyruseli]

After running the command below we get:

# ls -l /usr/opt/perl5/lib/site_perl/
total 8
drwxr-xr-x 3 root system 256 Dec 2 2010 5.8.2
drwxr-xr-x 13 root system 4096 Mar 22 2013 5.8.8

[slansing]

Locking this thread, you or one of your team members is already working with one of our techs via email on this....