Nagios 2.10 + ndoutils-1.4b7
Carlos Pereira
cacovas at gmail.com
Fri Jan 18 20:18:14 CET 2008
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/
More information about the Developers
mailing list