<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5296.0" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Here is a Visio I did of the ndo 1.2 database. There are certainly typos and who know if I reverse engineered if properly. The blue objects table is blue because it appears in multiple places (for readability), the instance_id column is green because it is a foreign key to the ndo_instances table (again for readability).</DIV>
<DIV> </DIV>
<DIV>You may have it or throw it away.</DIV>
<DIV> </DIV>
<DIV>Marlo<BR><BR>>>> "Mike Koponick" <mkoponick@redhawk.info> 02/21/06 12:28 pm >>><BR>Hello,<BR><BR>I'm in the process of (trying?) to map out the NDO to MySQL data. I have<BR>noted that the IP address is missing from the ndo_hosts table, which was<BR>pointed out on the list. From what I can tell at this point in my<BR>research, this is one of the few columns that are missing.<BR><BR>What should this column be named? If added, will Nagios also add the IP<BR>address information directly; much like it has with all other data.<BR><BR>The problem I'm seeing is that if I create a separate table, very few<BR>data items connect because the way the object_id's are defined, etc.<BR>This, btw is a good thing from my perspective, but is making development<BR>hard for a web interface.<BR><BR>A mapping of the NDO/Nagios/MySQL database would be nice, even if it<BR>were incomplete. I would look in the code myself, but my coding skills<BR>are not in "C" and would confuse anyone to drink heavily.<BR><BR>Thoughts?<BR><BR>Thanks in advance,<BR><BR>Mike<BR><BR><BR>-------------------------------------------------------<BR>This SF.net email is sponsored by: Splunk Inc. Do you grep through log files<BR>for problems? Stop! Download the new AJAX search engine that makes<BR>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!<BR>http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642<BR>_______________________________________________<BR>Nagios-devel mailing list<BR>Nagios-devel@lists.sourceforge.net<BR>https://lists.sourceforge.net/lists/listinfo/nagios-devel<BR><BR></DIV>
<P><pre wrap>------------------------------------------------------------------------------
<P><pre wrap><width=80>
NOTICE: This email message is for the sole use of the<br> intended recipient(s) and may contain confidential and<br> privileged information. Any unauthorized review, use,<br> disclosure or distribution is prohibited. If you are not the<br> intended recipient, please contact the sender by reply email<br> and destroy all copies of the original message.
</pre></P>
------------------------------------------------------------------------------
</pre></P></BODY></HTML>