<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD> <BODY> <DIV dir=ltr align=left>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).</DIV> <DIV> </DIV> David Fulton Systems Administrator NuVox Communications O:407-835-0470 C:321-246-2238 "Because Business is on the Line" <DIV> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> From: nagios-devel-bounces@lists.sourceforge.net [mailto:nagios-devel-bounces@lists.sourceforge.net] On Behalf Of Carlos Pereira Sent: Friday, January 18, 2008 1:24 PM To: nagios-devel@lists.sourceforge.net Subject: [Nagios-devel] Nagios 2.10 + ndoutils-1.4b7 </DIV> <DIV></DIV> 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 <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: 6.75pt double"> <P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none"> </DIV> 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 <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: 6.75pt double"> <P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none"> </DIV> 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 <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: 6.75pt double"> <P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none"> </DIV> 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 <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: 6.75pt double"> <P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none"> </DIV> 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 <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: 6.75pt double"> <P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none"> </DIV> 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@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@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.</BLOCKQUOTE></BODY></HTML>