Nagios 2.10 + ndoutils-1.4b7

Hendrik Bäcker andurin at process-zero.de
Fri Jan 18 20:51:09 CET 2008
Previous message: Nagios 2.10 + ndoutils-1.4b7
Next message: patch for nagios 3rc1 - move broker pre call down below macro processing
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,

did you recognized the debug options in your ndo2db.cfg?

May be they will tell you more?

-
Hendrik

Am Freitag, den 18.01.2008, 20:18 +0100 schrieb Carlos Pereira:
> 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_maillisttofaq_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/
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel
Previous message: Nagios 2.10 + ndoutils-1.4b7
Next message: patch for nagios 3rc1 - move broker pre call down below macro processing
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Developers mailing list