Page 1 of 1

NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 12:17 pm
by rnygren
I installed ndoutils1.5.1 against nagios 3.2.3 on Debian 2.6.32.5.
I get the following in the nagios.log file:
[1338829587] ndomod: NDOMOD 1.5.1 (05-15-2012) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1338829587] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...
[1338829587] Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.
[1338829588] Finished daemonizing... (New PID=6854)

I set debug levels to maximun and it creates the log gile as 0 bytes:
root@nagios:/usr/local/nagios/var# ls -l
total 5512
drwxrwsr-x 3 nagios nagios 16384 Jun 4 00:00 archives
-rwxr-xr-x 1 root nagios 301 Mar 12 08:14 cnvt.sh
-rw-r--r-- 1 nagios nagios 5 Jun 4 10:06 nagios.lock
-rw-r--r-- 1 nagios nagios 185869 Jun 4 10:09 nagios.log
-rw-r--r-- 1 nagios nagios 0 Jun 4 10:10 ndo2db.debug
-rw-r--r-- 1 nagios nagios 6 Jun 4 10:11 ndo2db.lock
srwxr-xr-x 1 nagios nagios 0 Jun 4 10:11 ndo.sock
-rw-r--r-- 1 nagios nagios 1256694 Jun 4 10:06 objects.cache
-rw------- 1 nagios nagios 2097082 Jun 4 10:06 retention.dat
drwxrwsr-x 2 nagios nagios 4096 Jun 4 10:06 rw
drwxr-sr-x 3 root nagios 4096 Oct 4 2011 spool
-rw-rw-r-- 1 nagios nagios 2046647 Jun 4 10:11 status.dat

Everything seems to be configured Ok so I dont know what is the problem.
There is no data in any of the SQL tables (mySQL 5.1)

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 1:29 pm
by rnygren
I move the correcr ndo2db-3x nito the correct directory and restart everythin but still no debug data in file
or nagios in database.

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 2:17 pm
by mguthrie
Check the system log and see if you have any system errors from ndo2db.

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 3:35 pm
by rnygren
I searched for ndo2db in /var/log/syslog and nothing was found.

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 5:54 pm
by rnygren
I tried log2ndo as root to std out and it lising records to screen.
The initial database for ndo has only one record in table nagios_dbversion (1.5)
When I ran log2ndo it added 2 records:
nagios_conninfo
nagios_instances
but none of the data transactions.

This proves the db connection is working but no data is being loaded. the user in the db has full rights.

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Mon Jun 04, 2012 6:43 pm
by jsmurphy
First and most obvious of all is double check the configuration in nagios/etc/ndo2db.cfg assuming you've already done that then set the debug_level to 1 and ensure that a debug_file is set (I believe the default is: /usr/local/nagios/var/ndo2db.debug). It's weird you have nothing in syslog (unless you told it not to in the config file) but somewhere in the debug output it will tell you why it's failing to connect to the database.

Something else you can try if you are absolutely sure you have configured everything correctly prior to digging through the debug log is
1. Stop nagios and the ndo2db processes.
2. Start ndo2db first!
3. Then start Nagios
I had a problem on my old SLES 10 Nagios server where it would shit bricks, show the same ndomod message and refuse to sync if the Nagios process was already started when ndo2db was started.

Re: NDO Utils 1.5.1 and no data or debug info

Posted: Tue Jun 05, 2012 11:57 am
by rnygren
I have the system now working, Thanks for the help.
The prblem was int ndo2db.cfg permissions file. Once I set to +rw and restarted then everything went fine.
It was strange that the log2ndo added records. Thats why I was confused.