Nagios 2.10 + ndoutils-1.4b7
Fulton, David
dfulton at nuvox.com
Fri Jan 18 20:04:45 CET 2008
The first place I would look is to make sure that the username and password you are using to connect to mysql are correct. Try connecting with the command line client using them. If that works, check that your event brokering is enabled (broker everything).
David Fulton
Systems Administrator
NuVox Communications
O:407-835-0470
C:321-246-2238
"Because Business is on the Line"
________________________________
From: nagios-devel-bounces at lists.sourceforge.net [mailto:nagios-devel-bounces at lists.sourceforge.net] On Behalf Of Carlos Pereira
Sent: Friday, January 18, 2008 1:24 PM
To: nagios-devel at lists.sourceforge.net
Subject: [Nagios-devel] Nagios 2.10 + ndoutils-1.4b7
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 everything , Mysql 5.0 and client , Apache2 & PHP5.
Now when comes down to install ndoutils-1.4b7, problems start to popup.
Obs: installing its not a problem but, writing to data sink it is ( THE PROBLEM)
1 - Out put from ./configure ( Parts that have "no" while running command the problems ( I think ) ) :
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"
Followed as the README doc recommends inside the ndoutils-1.4b7.
Copied all the files to the right places as well as the database, create users grant permission and create the password.
I ran the command ./installdb ( No problems).
I change the proper parameter on 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 written to the database. Please somebody could help me 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/4837eac7/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
More information about the Developers
mailing list