ndoutils1.4b3 issue with writing to mysql dbas e
Evans, Drexter
drexter.evans at acs-inc.com
Wed Jun 6 22:54:08 CEST 2007
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: 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: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: 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/
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel
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/
More information about the Developers
mailing list