[Nagios-devel] ndoutils1.4b3 issue with writing to mysql dbase

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Guest

[Nagios-devel] ndoutils1.4b3 issue with writing to mysql dbase

Post by Guest »

When Nagios is running and I run the ndomod daemon. This is what netstat -a
shows:
*.5668 *.* 0 0 49152 0 LISTEN
*.5668 *.* 0 0 49152 0 LISTEN
*.5668 *.* 0 0 49152 0 LISTEN
msutil1.56264 msutil1.5668 2069 0 49152 0
CLOSE_WAIT
msutil1.5668 msutil1.56264 49152 0 2069 0
FIN_WAIT_2
msutil1.56264 msutil1.5668 2069 0 49152 0
CLOSE_WAIT

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Evans,
Drexter
Sent: Wednesday, June 06, 2007 12:45 PM
To: Nagios Developers List
Subject: Re: [Nagios-devel] ndoutils1.4b3 issue with writing to mysql dbas e

This is what the ndo.dat file looks like:



HELLO

PROTOCOL: 2

AGENT: NDOMOD

AGENTVERSION: 1.4b3

STARTTIME: 1181151503

DISPOSITION: REALTIME

CONNECTION: FILE

CONNECTTYPE: INITIAL

INSTANCENAME: default

STARTDATADUMP



...snipet



300:

4=1181151504.98808

21=/opt/ACSnagios/etc/nagios.cfg

22=cfg_file=/opt/ACSnagios/etc/host_templates.cfg

22=cfg_file=/opt/ACSnagios/etc/hosts.cfg

22=cfg_file=/opt/ACSnagios/etc/commands.cfg

22=cfg_file=/opt/ACSnagios/etc/timeperiods.cfg

22=cfg_file=/opt/ACSnagios/etc/contactgroups.cfg

22=cfg_file=/opt/ACSnagios/etc/contacts.cfg

22=cfg_file=/opt/ACSnagios/etc/hostgroups.cfg

22=cfg_file=/opt/ACSnagios/etc/service_templates.cfg

22=cfg_file=/opt/ACSnagios/etc/services.cfg

22=cfg_file=/opt/ACSnagios/etc/servicegroups.cfg



...snipet



202:

1=300

2=0

3=0

4=1181151504.103504

73=1181151504

74=64

72=Finished daemonizing... (New PID=3875)

999



...snipet



212:

1=1201

2=0

3=0

4=1181151504.115547

53=acsmsvtf01

95=DISK OK - free space: / 5063 MB (54% inode=90%): /boot 84 MB (60%
inode=99%): /fx_work0 18361 MB (98% inode=99%): /de

v/shm 928 MB (100% inode=99%):

99=/=4280MB;9823;9833;0;9843 /boot=54MB;126;136;0;146
/fx_work0=325MB;19667;19677;0;19687 /dev/shm=0MB;908;918;0;928

27=0

51=1

115=1

25=1

76=10

58=1178921034



_____

From: [email protected]
[mailto:[email protected]] On Behalf Of Evans,
Drexter
Sent: Wednesday, June 06, 2007 12:20 PM
To: Nagios Developers List
Subject: [Nagios-devel] ndoutils1.4b3 issue with writing to mysql dbase



Hi,

I am having issue with ndoutils 1.4b3 writing to mysql dbase. I receive a
"Broke pipe" error when running log2ndo or file2sock. Once the error is
generated the ndo2db is killed.

I am using ndo.sock for my unix domain socket. The perms on the socket are
:

srwxr-xr-x 1 apache apache 0 Jun 6 10:46
/opt/ACSnagios/var/ndo.sock



I have changed the perms to 777 and get the same results.



Netstat -P tcp:

Address Type Vnode Conn Local Addr Remote Addr

60002af8560 stream-ord 60012ee1d40 00000000 /opt/ACSnagios/var/ndo.sock



I am running Nagios as apache because I am using fruity webinterface for
configuration. The Nagios part works great.

I startup the ndomod daemon:

apache 23128 1 0 10:46:35 ? 0:00 /opt/ACSnagios/bin/ndo2db
-c /opt/ACSnagios/etc/ndo3db.cfg



The ndo2db is actually ndo2db-3x renamed.

In the Nagios.log file you can see the data sink is connected:

[1181140722] Nagios 3.0a3 starting... (PID=18095)

[1181140722] LOG VERSION: 2.0

[1181140722] ndomod: NDOMOD 1.4b3 (04-10-2007) Copyright (c) 2005-2007 Ethan
Galstad ([email protected])

[1181140722] ndomod: Successfully connected to data sink. 0 queued items to
flush.

[1181140722] Event broker module '/opt/ACSnagios/bin/ndomod.o' initialized
successfully.



Some of the variables in ndo3db.cfg

ndo2db_user=apache

ndo2db_group=apache

db_host=localhost

db_name=Nagios

db_user=nagios

db_pass=xxxxx



Some of the variables in ndomod.cfg...I have tried output_type unixsocket
and output = /opt/ACSnagios-3.0a3/var/ndo.sock

instance_name=default

output_type=file

output=/opt/ACSnagios-3.0a3/var/ndo.dat

buffer_file=/opt/ACSnagios-3.0

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]
Locked