<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>NagMIN</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff size=2>Eric,
et.al:</FONT></SPAN></DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff size=2>I've
been able to recreate the NULL problem on FreeBSD that doesn't happen on RedHat
7.3.</FONT></SPAN></DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2>I built a FreeBSD(4.8) server with MySQL
4.0.10-gamma and now see the NULL values in the configuration
files.</FONT></SPAN></DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff size=2>I'm
also using the FreeBSD Nagios package and see why some of you wanted better
control over directories. </FONT></SPAN></DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff size=2>What I
don't know is why it worked with RedHat 7.3 and not RedHat 9.0. I'm not
going to find out either since I'm also having memory management
problems with RedHat and have no plans to use RedHat 9.0.</FONT></SPAN></DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=600245619-23052003><FONT face=Arial color=#0000ff size=2>I'll
hopefully have this fixed by early next week.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<P><FONT face="Century Schoolbook"
size=2>-------------------------------------------------</FONT> <BR><FONT
face="Century Schoolbook" size=2>Fred Reimers (CCIE #1469, CCSA)</FONT>
<BR><FONT face="Century Schoolbook" size=2>Senior Network Consultant</FONT>
<BR><FONT face="Century Schoolbook" size=2>Info Systems, Inc.</FONT> <BR><FONT
face="Century Schoolbook" size=2>freimers@infosysinc.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Eric Austin <BR><B>Sent:</B>
Tuesday, May 13, 2003 12:56 PM<BR><B>To:</B> Fred Reimers<BR><B>Subject:</B>
RE: NagMIN<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Fred,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
Glad to help. FYI, none of the system calls appear to be working
either. This may be a configuration issue on my part but the rest of the
WebMIN tools seem to be working OK. I hacked my way around it for
now. I see it try to do an “ssh service nagios restart” but nothing
happens. Should the IP address be included in the command after
ssh? No big rush, like I said I’ve got a work around.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Eric</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Fred
Reimers <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, May
12, 2003 4:25 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Eric
Austin<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">This will be a big help. I'll get
back to you soon.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">-----Original
Message----- <BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Eric
Austin <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon 5/12/2003
9:56 AM <BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in"><DIV>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">-----Original
Message----- <BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Fred
Reimers <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon
5/12/2003 9:49 AM <BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
Eric Austin <BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">This appears to be a MySQL problem
with RH9. </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">NagMIN is handling NULL values per
the MySQL ntation and works fine with any RedHat version up to RH9.
</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Per MySQL, you have to enter the
word NULL or you get an empty string instead of a true NULL
character.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">This will require some more
investigation. </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Could you email me your
nagmin_load.sql file and a dump of your database?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Thanks,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message----- <BR><B><SPAN
style="FONT-WEIGHT: bold">From:</SPAN></B> Eric Austin <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon 5/12/2003 9:16 AM
<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">They are
NULL from the get go. I reran setup, created a new database and
did a SELECT * FROM Service.Template; and it showed NULL
values.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric</SPAN></FONT></P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message----- <BR><B><SPAN
style="FONT-WEIGHT: bold">From:</SPAN></B> Fred Reimers <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon 5/12/2003 9:01 AM
<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Eric Austin
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Thanks,
starting to nail this one down, although I'm not sure how to fix
it.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">One more
question. Does the initial loading of the database show NULL
values, or only after you edit something with
NagMIN?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message----- <BR><B><SPAN
style="FONT-WEIGHT: bold">From:</SPAN></B> Eric Austin <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon 5/12/2003 7:58 AM
<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> <BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Yes, the
NagMINdatabase tables show a value of NULL unless I set it to
"".</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric</SPAN></FONT></P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message----- <BR><B><SPAN
style="FONT-WEIGHT: bold">From:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon
5/12/2003 7:57 AM <BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Eric Austin <BR><B><SPAN
style="FONT-WEIGHT: bold">Cc:</SPAN></B> <BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">This problem appears to only be happening
with people using freebsd and now RH9. The difference is
probably with perl and the MySQL DBD modules. I'm looking
for values to ignore and not write the objects. The perl DBD
module appears to now be returning a string "NULL" instead of a
null value since you are seeing "NULL" as the object value.
In that case ( if $object eq undef ), the perl way of checking for
a null value, won't work. I may have to check for ( if
$object eq "NULL" ).</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Are you seeing the value "NULL" in the
NagMIN database tables?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message----- <BR><B><SPAN
style="FONT-WEIGHT: bold">From:</SPAN></B> Eric Austin
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon
5/12/2003 6:40 AM <BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> I'm using RH9
anf MySQL 3.23.54. If I do a mysqldump on any database
with null values, the SQL output has a value of NULL
rather than "". I guess the easiest way to handle it would
be to have your cgi script check IF NULL THEN VALUE = ""; when
dumping values to cfg files.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric</SPAN></FONT></P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----
<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Fred
Reimers <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Sat 5/10/2003 7:21
AM <BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Eric
Austin <BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE:
NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">I'm trying to get a handle on the NULL
value problem. In the version of MySQL I'm using,
NULL is the only way to enter a null
value.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">What OS and version of MySQL are you
using?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----
<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Eric
Austin <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Sat 5/10/2003
6:54 AM <BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
RE: NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Fred,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> Thanks, that's
just what I did. I'm having some issues with the
verification not liking NULL values but if I replace them
with "" in the database, all seems
good.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Eric</SPAN></FONT></P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----
<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
Fred Reimers <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Sat 5/10/2003
5:05 AM <BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Eric Austin
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
RE: NagMIN</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt">Eric,</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Not everyone,
probably most, do not install Nagios with MySQL
support. If you have, then choose a different
database name when installing NagMIN. It will drop
whatever database with the name you select to create its
own.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt">Fred</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE
style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT
face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----
<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
Eric Austin <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri 5/9/2003
2:59 PM <BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> Fred Reimers
<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B>
NagMIN</SPAN></FONT></P></DIV>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Fred,<BR> I'm
trying to get NagMIN setup and running and have run into
a problem. Here's what I've done:<BR><BR>Installed
and Configured Nagios w/ MySQL support database name
'nagios'<BR>Monitored 1 object for testing - works
OK<BR>Discovered NagMIN (Recommended by Chris
Patterson)<BR>Installed NagMIN and
prerequisits<BR>Allowed NagMIN setup routine to
drop/create database called 'nagios'<BR>Nagios no longer
runs<BR><BR>Should I have given my NagMIN database a
different name? Should I not have used MySQL with
the initial Nagios installation? Please
advise.<BR><BR>Thanks,<BR>Eric</SPAN></FONT></P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>