ndoutils not sending data to db?

Trask trasko at gmail.com
Wed Feb 7 00:05:28 CET 2007


Hello, I am a long time nagios user but first time NDOutils
experimenter.  The summary of my problem is thus: no data is being
sent to the db.  When I watch the detailed mysql log, I see the ndo
user log in and run a few preliminary SQL statements ("INSERT INTO
nagios_conninfo" ...), but there is no more activity until I shut down
nagios, at which point it seems to make another mark in the "conninfo"
table.

What's going on?  Below is all the information I can think to give --
let me know if I should include more.

Thanks,

Trask



-------------------------------------------------
Fedora Core 4 -  2.6.13-1.1532_FC4
Nagios 2.7.1
NDOutils 1.4b2
(plugins, nrpe, ncsa were all updated in the past few days)

This particular nagios instance reports its settings passively (is
this a problem?) to another nagios server.  Outside of the NDOutils,
everything is functioning normally.

-------------------------------------------------------
# snippet from nagios.log

[1170791061] Nagios 2.7 starting... (PID=13124)
[1170791061] LOG VERSION: 2.0
[1170791061] ndomod: NDOMOD 1.4b2 (01-19-2007) Copyright (c) 2005-2007
Ethan Galstad (nagios at nagios.org)
[1170791061] ndomod: Successfully connected to data sink.  0 queued
items to flush.
[1170791061] Event broker module '/usr/local/nagios/bin/ndomod.o'
initialized successfully.

-------------------------------------------------------
# perms

-rw-r--r--  1 nagios nagios 2.8K Feb  6 12:12 /usr/local/nagios/etc/ndo2db.cfg
-rw-r--r--  1 nagios nagios 4.4K Feb  6 12:32 /usr/local/nagios/etc/ndomod.cfg
-rw-rw-r--  1 nagios nagios 0 Feb  6 14:23 /usr/local/nagios/var/ndomod.tmp
srwxr-xr-x  1 nagios nagios 0 Feb  6 15:00 /usr/local/nagios/var/ndo.sock

-------------------------------------------------------
# ndo2db.cfg

ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/usr/local/nagios/var/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=localhost
db_port=3306
db_name=ndo_test
db_prefix=nagios_
db_user=ndouser
db_pass=ndolalaladontlook
# I have experimented with other "age" values...
max_timedevents_age=0
max_systemcommands_age=0
max_servicechecks_age=0
max_hostchecks_age=0
max_eventhandlers_age=0

-------------------------------------------------------
# ndomod.cfg

instance_name=default
output_type=unixsocket
output=/usr/local/nagios/var/ndo.sock
tcp_port=5668
output_buffer_items=5000
buffer_file=/usr/local/nagios/var/ndomod.tmp
file_rotation_interval=14400
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=15
data_processing_options=-1
config_output_options=3


-------------------------------------------------------
# output of mysql logging -- from nagios start to nagios stop
7 Connect     ndouser at localhost on ndo_test
                      7 Query       SELECT instance_id FROM
nagios_instances WHERE instance_name='default'
                      7 Query       INSERT INTO nagios_conninfo SET
instance_id='1', connect_time=NOW(), last_checkin_time=NOW(),
bytes_processed='0', lines_pro
cessed='0', entries_processed='0', agent_name='NDOMOD',
agent_version='1.4b2', disposition='REALTIME',
connect_source='UNIXSOCKET', connect_type='INITIAL', data
_start_time=FROM_UNIXTIME(1170800728)
                      7 Query       SELECT object_id, objecttype_id,
name1, name2 FROM nagios_objects WHERE instance_id='1'
                      7 Query       SELECT
UNIX_TIMESTAMP(status_update_time) AS latest_time FROM
nagios_programstatus WHERE instance_id='1' ORDER BY status_upd
ate_time DESC LIMIT 0,1
                      7 Query       SELECT
UNIX_TIMESTAMP(status_update_time) AS latest_time FROM
nagios_hoststatus WHERE instance_id='1' ORDER BY status_update
_time DESC LIMIT 0,1
                      7 Query       SELECT
UNIX_TIMESTAMP(status_update_time) AS latest_time FROM
nagios_servicestatus WHERE instance_id='1' ORDER BY status_upd
ate_time DESC LIMIT 0,1
                      7 Query       SELECT
UNIX_TIMESTAMP(status_update_time) AS latest_time FROM
nagios_contactstatus WHERE instance_id='1' ORDER BY status_upd
ate_time DESC LIMIT 0,1
                      7 Query       SELECT UNIX_TIMESTAMP(queued_time)
AS latest_time FROM nagios_timedeventqueue WHERE instance_id='1' ORDER
BY queued_time DES
C LIMIT 0,1
                      7 Query       SELECT UNIX_TIMESTAMP(entry_time)
AS latest_time FROM nagios_comments WHERE instance_id='1' ORDER BY
entry_time DESC LIMIT 0
,1
070206 14:44:52       7 Query       UPDATE nagios_conninfo SET
disconnect_time=NOW(), last_checkin_time=NOW(),
data_end_time=FROM_UNIXTIME(0), bytes_processed='
180', lines_processed='14', entries_processed='0' WHERE conninfo_id='7'
                      7 Quit




Thanks again for any clues!

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list