NagiosXI install_driver(DB2) failed

[paulol]

slansing,

Yes, Im sure that i installed DBD::DB2 module properly.

Following the prove:

In command line works fine :
as root or as the user "nagios" :

Code: Select all

/usr/local/nagios/libexec/check_db2_health --hostname X.X.X.X --port XXXXX --username XXXXX --password XXXXXX --mode last-backup --database XXXXXX
CRITICAL - last backup of db XXXXXX was 8.90 days ago | last_backup=8.90;1;2

But, when this action is launch by NagiosXI, the result is :

Code: Select all

install_driver(DB2) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/DB2/DB2.so' for module DBD::DB2: libdb2.so.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/nagios/libexec/check_db2_conexao.pl line 32

[cmerchant]

Can you post the output of the following command:

Code: Select all

ldd /usr/local/lib64/perl5/auto/DBD/DB2/DB2.so

if we cannot get this resolved early on Monday for you, we suggest you open up a ticket so that we can resolve this in a remote session.

[paulol]

[root@DOUAI ~]# ldd /usr/local/lib64/perl5/auto/DBD/DB2/DB2.so
linux-vdso.so.1 => (0x00007fff159ff000)
libdb2.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2.so.1 (0x00007f2edfce2000)
libc.so.6 => /lib64/libc.so.6 (0x00007f2edf93a000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f2edf702000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f2edf4fe000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f2edf2e1000)
libpam.so.0 => /lib64/libpam.so.0 (0x00007f2edf0d2000)
libm.so.6 => /lib64/libm.so.6 (0x00007f2edee4e000)
libdb2dascmn.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2dascmn.so.1 (0x00007f2edec21000)
libdb2g11n.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2g11n.so.1 (0x00007f2ede398000)
libdb2genreg.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2genreg.so.1 (0x00007f2ede158000)
libdb2install.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2install.so.1 (0x00007f2eddf4c000)
libdb2locale.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2locale.so.1 (0x00007f2eddd26000)
libdb2osse.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2osse.so.1 (0x00007f2edd5f8000)
libdb2osse_db2.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2osse_db2.so.1 (0x00007f2edd36d000)
libdb2sdbin.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2sdbin.so.1 (0x00007f2edd0d2000)
libdb2trcapi.so.1 => /opt/ibm/db2/V10.1/lib64/libdb2trcapi.so.1 (0x00007f2edceb8000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f2edcbb2000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f2edc99b000)
/lib64/ld-linux-x86-64.so.2 (0x0000003be9600000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f2edc722000)
libaudit.so.1 => /lib64/libaudit.so.1 (0x00007f2edc4fe000)
librt.so.1 => /lib64/librt.so.1 (0x00007f2edc2f5000)

[cmerchant]

So I tried to recreate the problem, and was successful to find the same problem.
What you need to add to your configurations is a global dynamic library config entry. I first installed the dsdriver into my /root/ directory, but later unpacked the dsdriver into /usr/local/lib64:

Code: Select all

cd /usr/local/lib64
tar -xvzf ibm_data_server_driver_package_linuxx64_v10.5.tar.gz 

Run the installer: (the script requires ksh - you might need to do a yum install ksh

Code: Select all

cd /usr/local/lib64/dsdriver
./installDSDriver

Clean up the ownership of the installed files to assign them to root:

Code: Select all

cd /usr/local/lib64/dsdriver
chown -v -R root:root *

Create an entry for the /etc/ld.so.conf.d/

Code: Select all

echo "/usr/local/lib64/dsdriver/lib" >> /etc/ld.so.conf.d/db2-x86_64.conf

Then update ldconfig

Code: Select all

ldconfig -v

to verify:

Code: Select all

ldconfig -p | grep -i db2

and you should get:

Code: Select all

[root@nagiosxi ~]# ldconfig -p | grep -i db2
	libdb2o.so.1 (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2o.so.1
	libdb2o.so (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2o.so
	libdb2clixml4c.so.1 (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2clixml4c.so.1
	libdb2clixml4c.so (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2clixml4c.so
	libdb2.so.1 (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2.so.1
	libdb2.so (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libdb2.so
	libDB2xml4c.so.58 (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libDB2xml4c.so.58
	libDB2xml4c.so (libc6,x86-64) => /usr/local/lib64/dsdriver/lib/libDB2xml4c.so

I did not need to recompile the cpan module DBD::DB2., nor did I need to restart Apache. I did the force immediate check and it came back without the library error. I still got an connection error, but we don't have a DB2 database install in-house.

[paulol]

Great Job cmerchant! Its works!!! Thanks All!

[cmerchant]

Glad we could help. I will go ahead and close this thread. Thanks.