Nagios 2.10 + ndoutils-1.4b7

[Carlos Pereira]

Hi folks, could someone help with nagios + ndoutil. I'm having  a hard time
to sync nagios to dump its information throught ndo to a mysql database.



The scenerio is as follow:



Nagios installation is not a problem, I set up and it works fine with the
default value. ( Nagios 2.10).

Install every thing  obsvialy , Mysql 5.0 and client , Apache2 & PHP5.



Now when comes down to install  ndoutils-1.4b7, problems start to popup.

Obs: installing ndoutils-1.4b7 its not a problem but, writing to data sink
it is ( THE PROBLEM)



1 – Out put from  ./configure ( Parts that have "no" while running the
command ) :



checking for C compiler default output file name... a.out

checking whether the C compiler works... yes

checking whether we are cross compiling... no

checking for suffix of executables...

checking for suffix of object files... o





checking limits.h presence... yes

checking for limits.h... yes

checking ltdl.h usability... no

checking ltdl.h presence... no

checking for ltdl.h... no

checking math.h usability... yes

checking math.h presence... yes





checking signal.h presence... yes

checking for signal.h... yes

checking socket.h usability... no

checking socket.h presence... no

checking for socket.h... no

checking stdarg.h usability... yes

checking stdarg.h presence... yes





checking for main in -lnsl... yes

checking for socket in -lsocket... no

checking for main in -lwrap... yes

checking for strdup... yes

checking for strstr... yes



checking for compress in -lz... yes

checking for mysql_store_result in -lmysqlclient... yes

checking for mysql_connect in -lmysqlclient... no

checking mysql/mysql.h usability... yes

checking mysql/mysql.h presence... yes

checking for mysql/mysql.h... yes

MySQL library and include file(s) were found!

checking for PQconnectdb in -lpq... no







No problems while executing " MAKE"



I followed as the README doc recommends inside the ndoutils-1.4b7.

Copied all the files to the its  right places as well as the database,
create user and granted the permissions and  password.



I ran the command  ./installdb ( No problems).



I change the proper parameter in ndo2db.cfg ( user and password)



I execute the command :

/usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg





Output from ls –la (inside the directory)



xxxxx:/usr/local/nagios/var# ls -la

total 224

drwxrwsr-x 5 nagios nagios   4096 2008-01-18 15:15 .

drwxrwsr-x 8 nagios nagios   4096 2008-01-17 17:34 ..

drwxrwsr-x 2 nagios nagios   4096 2008-01-18 00:00 archives

-rw-r--r-- 1 nagios nagios      6 2008-01-18 12:39 nagios.lock

-rw-rw-r-- 1 nagios nagios 148605 2008-01-18 15:15 nagios.log

srwxrwxrwx 1 nagios nagios      0 2008-01-18 12:38 ndo.sock

-rw-r--r-- 1 nagios nagios  12943 2008-01-18 12:39 objects.cache

-rw------- 1 nagios nagios  14010 2008-01-18 14:39 retention.dat

drwxrwsr-x 2 nagios nagios   4096 2008-01-18 12:39 rw

drwxrwsr-x 3 nagios nagios   4096 2008-01-17 17:34 spool

-rw-rw-r-- 1 nagios nagios  14061 2008-01-18 15:15 status.dat



Every thing starts fine BUT………



That's the output, I got from nagios.log





[1200676718] ndomod: Error writing to data sink!  Some output may get
lost...

[1200676734] ndomod: Successfully reconnected to data sink!  0 items lost,
87 queued items to flush.

[1200676734] ndomod: Successfully flushed 87 queued items to data sink.

[1200676734] ndomod: Error writing to data sink!  Some output may get
lost...

[1200676750] ndomod: Successfully reconnected to data sink!  0 items lost,
74 queued items to flush.

[1200676750] ndomod: Successfully flushed 74 queued items to data sink.

[1200676750] ndomod: Error writing to data sink!  Some output may get
lost...

[1200676766] ndomod: Successfully reconnected to data sink!  0 items lost,
78 queued items to flush.

[1200676766] ndomod: Successfully flushed 78 queued items to data sink.

[1200676766] ndomod: Error writing to data sink!  Some output may get
lost...

[1200676782] ndomod: Successfully reconnected to data sink!  0 items lost,
90 queued items to flush.

[1200676782] ndomod: Successfully flushed 90 queued items to data sink.

[1200676782] ndomod: Error writing to data sink!  Some output may get
lost...

[1200676798] ndomod: Successfully reconnected to data sink!  0 items lost,
70 queued items to flush.

[1200676798] ndomod: Successfully flushed 70 queued items to data sink.

[1200676798] ndomod: Error writing to data sink!  Some output may get
lost...



That´s the output from ps –ef





root     20562     1  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20567 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20568 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20569 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20570 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20571 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20575 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20576 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

www-data 20577 20562  0 Jan17 ?        00:00:00 /usr/sbin/apache2 -k start

root     30899  2227  0 10:27 ?        00:00:08 sshd: root at pts/0

root     30901 30899  0 10:27 pts/0    00:00:05 -bash

root     31325  2227  0 10:49 ?        00:00:02 sshd: root at pts/1

root     31335 31325  0 10:49 pts/1    00:00:00 -bash

root      2822     1  0 11:10 ?        00:00:00 runsvdir -P /var/service
log: ................................................

root      2850  2822  0 11:10 ?        00:00:00 runsv socklog-klog

root      2851  2822  0 11:10 ?        00:00:00 runsv socklog-unix

log       2852  2851  0 11:10 ?        00:00:00 svlogd main/main main/auth
main/cron main/daemon main/debug main/ftp main/kern

log       2853  2850  0 11:10 ?        00:00:00 svlogd -tt main/main

root      2854  2850  0 11:10 ?        00:00:00 socklog ucspi

nobody    2855  2851  0 11:10 ?        00:00:00 socklog unix /dev/log

root     10421 30901  0 12:28 pts/0    00:00:00 mysql

root     10521 30901  0 12:37 pts/0    00:00:00 nano ndo2db.cfg

root     10591     1  0 12:38 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe

mysql    10628 10591  0 12:38 pts/0    00:00:02 /usr/sbin/mysqld
--basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-fi

root     10629 10591  0 12:38 pts/0    00:00:00 logger -p daemon.err -t
mysqld_safe -i -t mysqld

nagios   10693     1  0 12:38 ?        00:00:00 /usr/local/nagios/bin/ndo2db
-c /usr/local/nagios/etc/ndo2db.cfg

nagios   10736     1  0 12:39 ?        00:00:04 /usr/local/nagios/bin/nagios
-d /usr/local/nagios/etc/nagios.cfg





So, I have no idea how to solve the problem no data are being writing to the
database.Please somebody could help me or guide to the right place.



Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20080118/78f2034a/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel