Page 1 of 1

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

Posted: Wed Jun 06, 2007 12:54 pm
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]