ndoutils1.4b3 issue with writing to mysql dbas e

[Evans, Drexter]

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: nagios-devel-bounces at lists.sourceforge.net
[mailto:nagios-devel-bounces at lists.sourceforge.net] 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 (Nagios at nagios.org)

[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.0a3/var/ndomod.tmp

 

Here is the output of the truss of the log2ndo -s
/opt/ACSnagios/var/log/ndo.dat.060042007 -d /opt/ACSnagios/var/ndo.sock -i
default -t unix

19222:  open("/opt/ACSnagios/var/xaa", O_RDONLY)        = 3

19222:  fstat(3, 0xFFBFF6D0)                            = 0

19222:      d=0x03D40000 i=262972 m=0100644 l=1  u=0     g=0     sz=6288849

19222:          at = Jun  6 09:43:39 CDT 2007  [ 1181141019 ]

19222:          mt = Jun  6 09:43:29 CDT 2007  [ 1181141009 ]

19222:          ct = Jun  6 09:43:29 CDT 2007  [ 1181141009 ]

19222:      bsz=8192  blks=12304 fs=ufs

19222:  mmap(0x00000000, 6288849, PROT_READ, MAP_PRIVATE, 3, 0) = 0xFE800000

19222:  so_socket(PF_UNIX, SOCK_STREAM, 0, "", SOV_DEFAULT) = 4

19222:  connect(4, 0xFFBFF6F8, 29, SOV_DEFAULT)         = 0

19222:          AF_UNIX  name = /opt/ACSnagios/var/ndo.sock

19222:  time()                                          = 1181142021

19222:  write(4, " H E L L O\n P R O T O C".., 178)     = 178

19222:  write(4, " 1 0 0 :\n 7 2 =\n 9 9 9".., 14)      = 14

 

.........snipet

 

19222:  write(4, " 1 0 0 :\n 7 2 = 3 = 0\n".., 17)      = 17

19222:  write(4, " 1 0 0 :\n 7 2 = 4 = 1 1".., 33)      Err#32 EPIPE

19222:      Received signal #13, SIGPIPE [default]


Thanks
Drex

 

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/