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