INFORMIX MONITORING WITH NAGIOS

SDK INSTALATION

- add user informix

64 BIT CLIENT SDK INSTALLATION

1) Test if unixODBC is 64 bit rpm

[root@server]# rpm -qa | grep unixODBC
unixODBC-2.2.11-1.RHEL4.1

[root@server]# rpm -ql unixODBC | grep -v share
/etc/odbc.ini
/etc/odbcinst.ini
/usr/bin/dltest
/usr/bin/isql
/usr/bin/iusql
/usr/bin/odbc_config
/usr/bin/odbcinst
/usr/lib64/libboundparam.so.1
...
/usr/lib64/libtemplate.so.1
/usr/lib64/libtemplate.so.1.0.0

2) Create installation directory

[root@server]# mkdir /opt/informix3.5

[root@server]# cd /opt/informix3.5

3) Install SDK

[root@server]# tar –xvf clientsdk.3.50.FC1DE.LINUX.tar
.
.
./doc/Libcpp_machine_notes_3.50.txt
./doc/ESQLC_machine_notes_3.50.txt
./doc/Odbc_machine_notes_3.50.txt
./doc/client_defects_3.50.html
./doc/client_defects_3.50.txt
./doc/Client_install_guide.pdf
installclientsdk
csdk.ini
.jvm.bin

[root@server informix3.5]# ./installclientsdk

Initializing InstallShield Wizard........
…
The InstallShield Wizard has successfully installed IBM Informix Client-SDK
Version 3.50. Choose Finish to exit the wizard.

Press 3 to Finish or 4 to Redisplay [3]


4) Add service name and port to /etc/services

#informix port
/tcp # informix connection
/tcp # informix connection

5) SQLhost file from and add DSN

[root@server]# cat sqlhosts

onsoctcp autoboot=1,b=8192
onsoctcp autoboot=1,b=8192

6) Add servername to /etc/hosts


5) Environment variables to .profile or .bashrc in users

export INFORMIXDIR=/opt/IBM/informix64
export LD_LIBRARY_PATH=/opt/IBM/informix64/lib:/opt/IBM/informix64/lib/cli:/opt/IBM/informix64/lib/esql
export ODBCINI=$HOME/odbc.ini
export INFORMIXSQLHOSTS=$HOME/sqlhosts

6) Sample odbc.ini

[ODBC Data Sources]
=Informix
=Informix

[dsn1]
Driver=/opt/IBM/informix/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=
LogonID=
pwd=
Servername=
Host=server1.domain.com
Service=
Protocol=onsoctcp
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so

[dsn2]
Driver=/opt/IBM/informix/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=
LogonID=
pwd=
Servername=
Host=server1.domain.com
Service=
Protocol=onsoctcp
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so

[ODBC]
Trace=1
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/informix3.5_64


32 BIT CLIENT SDK INSTALLATION ON 64 BIT OS

1) Remove 64 bit unix rpm and installed 32 bit rpm
rpm –e –nodeps –allmatches unixODBC

2) Download dependency packages for 32 unixODBC rpm

libstdc++-3.4.6-10.i386.rpm
ncurses-5.4-15.el4.i386.rpm
readline-4.3-13.i386.rpm
unixODBC-2.2.11-1.RHEL4.1.i386.rpm

rpm –ivh *.rpm

3) Install 32 bit Informix client SDK Similar to above steps, but name ends with “UC” instead of FC


4) Test ISQL
isql -v

SNIPPLET OF NAGIOS CONFIGURATION FILES

/etc/objectscommands.cfg

# Check check_informix_connection
define command{
command_name
command_line $USER1$/
}

/etc/objects/.cfg

define service{
use local-service ; Name of service template to use
host_name
service_description Informix_test
check_command
notifications_enabled 1
}

/libexec/check_informix.sh

#!/bin/bash
result=`isql -v dsn1 Informix_user password < /usr/local/nagios/script/test.sql | grep rows | cut -d" " -f1`
if [ $result = "1" ] ; then
echo "Connection OK"
else
echo "Connection Failed"
exit 2;
fi


/usr/local/nagios/script/test.sql

SELECT distinct table1 acronym FROMtable_main where field="f1”

LINKS FOR NAGIOS INSTALLATION

http://www.thegeekstuff.com/2008/06/how-to-monitor-remote-linux-host-using-nagios-30/

http://www.thegeekstuff.com/2008/05/nagios-30-jumpstart-guide-for-red-hat-overview-installation-and-configuration/

http://www.thegeekstuff.com/2008/07/how-to-monitor-remote-windows-machine-using-nagios-on-linux/