Nagios 2.10 + ndoutils-1.4b7

Fulton, David dfulton at nuvox.com
Fri Jan 18 20:28:44 CET 2008


Run a truss/strace on the relative processes, It has been a long time since I set any of it up, but those usually will give you an idea what is happening. Also check your mysql log files. And enable debugging in nagios. How to do all that is in the documentation so I won't cover it here. But pick it to pieces and see what is really happening.

David Fulton
Systems Administrator
NuVox Communications
O:407-835-0470
C:321-246-2238
"Because Business is on the Line" 

> -----Original Message-----
> 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 2:18 PM
> To: nagios-devel at lists.sourceforge.net; cacovas at gmail.com
> Subject: Re: [Nagios-devel] Nagios 2.10 + ndoutils-1.4b7
> 
> Hi Fulton,				
> 
> I have checked that and I can access the database : mysql -u 
> nagios -p (no problem). Also the event broker is enabled with 
> -1 (broker everything).
> 
> Thansks.
> 
> 
> - Carlos Pereira (alex12)
> 
> -----------------------
> This thread is located in the archive at this URL:
> http://www.nagiosexchange.org/nagios-devel.33.0.html?&tx_maill
isttofaq_pi1[showUid]=8483
> 					
> > 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.
> > 
> > 
> > 
> ----------------------------------------------------------------------
> > --- 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/
> > _______________________________________________
> > Nagios-devel mailing list
> > Nagios-devel at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/nagios-devel
> > 
> 
> --------------------------------------------------------------
> -----------
> 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/
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
> 

-------------------------------------------------------------------------
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/




More information about the Developers mailing list