Thank you, Duncan.<br><br>This is very useful documentation. The tables make so much more sense now! I made some changes to the configuration files and got the desired results, but I don't really understand the configuration options and I'd like to. I hope you'll bear with me for a bit longer.<br>
<br>I changed config_output_options in the ndomod.cfg file from 2 to 1. When I restarted Nagios, I found the config tables had been populated. (Victory!) The available options are:<br><br># CONFIG OUTPUT OPTION<br># This option determines what types of configuration data the NDO<br>
# NEB module will dump from Nagios. Values can be OR'ed together.<br># Values:<br># 0 = Don't dump any configuration information<br># 1 = Dump only original config (from config files)<br># 2 = Dump config only after retained information has been restored<br>
# 3 = Dump both original and retained configuration<br><br>I guess I don't understand what is meant by "retained information," nor where it is being restored from. For that matter, I don't know what it means to "OR" values together... Can someone explain what these options mean?<br>
<br>In case it helps anyone else, my data_processing_options (same file) is set to -1. I didn't have to change this.<br><br>Thanks,<br>-Frank<br><br><br><div class="gmail_quote">On Thu, Apr 10, 2008 at 2:30 PM, Duncan Ferguson <<a href="mailto:duncan.ferguson@altinity.com">duncan.ferguson@altinity.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style=""><br><div><div class="Ih2E3d">On 10 Apr 2008, at 16:52, Frank J. Gómez wrote:<blockquote type="cite">
<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div><br>The results of my service checks are being logged to the nagios_servicechecks table, which is very cool. However, I have a bunch of tables in the nagios database which are not populated. I won't list them all, but I'm most interested in nagios_hosts and nagios_services.</div>
</div></blockquote></div></blockquote><div><br></div></div>Check your setting of 'config_output_options' in the ndomod.cfg file - it may be incorrectly set for the information you want.</div><div><div class="Ih2E3d">
<br><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div><br>So I guess those are mostly observations, not questions... Some questions then:<br>
<ul><li>Did I do something wrong/different during the install process, or are these tables empty by default for everyone else?</li></ul></div></div></blockquote></div></blockquote><div><br></div></div>Check your setting of 'data_processing_options' in the ndomod.cfg file.<div class="Ih2E3d">
<br><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div><ul><li>Say I want to monitor a new host, should I edit my config files as in the past or add the information to the database? If I add it to the database, should I use the nagios_objects table or mess with the nagios_hosts and nagios_services tables?</li>
</ul></div></div></blockquote></div></blockquote></div>Nagios only writes to the ndo database, it doesn't read from it.<div class="Ih2E3d"><br><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="gmail_quote"><div><ul><li><br> </li><li>Does anyone know what all of the objecttype_id codes mean? So far I have 1 (hosts), 2 (services), 9, 10, and 12.</li></ul></div></div></blockquote></div></blockquote><div>
<br></div></div>The PDF may help with this (link below). If you feel it is lacking in information I am sure Ethan will accept updates.<div class="Ih2E3d"><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="gmail_quote"><div><ul><li>Why are those tables there if they are not being used?</li></ul></div></div></blockquote></div></blockquote><div><br></div></div>Check your setting of 'data_processing_options' in the ndomod.cfg file.</div>
<div><br></div><div><div class="Ih2E3d"><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote">
<div><br>PS: I have not seen much documentation about ndo2db. If anyone has a good resource, please share!</div></div></blockquote></div></blockquote><br></div><div><a href="http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf" target="_blank">http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf</a> and also the source code itself.</div>
<div><br></div><div> Duncs</div><div><br></div><div>-- </div></div><div><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div style="">
<span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><div>
Duncan Ferguson</div><div>Senior Developer, Altinity Limited</div><div><br></div><div><a href="http://www.altinity.com" target="_blank">http://www.altinity.com</a></div><div style="margin: 0px;">Tel: +44 (0)870 787 9243</div>
<div style="margin: 0px;">US: +1 866 879 9184</div><div style="margin: 0px;">Fax: +44 (0)845 280 1725</div><div style="margin: 0px;">Skype: duncan_j_ferguson</div><div style="margin: 0px;">MSN: <a href="mailto:duncan.ferguson@altinity.com" target="_blank">duncan.ferguson@altinity.com</a></div>
</span></span></span></span></span></span></span></span><div><div><br></div><div>The contents of this email and any files transmitted with it are confidential and intended solely for the use of the individuals to whom it is addressed. </div>
<div>If you are not the intended recipient or have received this e-mail in error please notify the sender and delete this e-mail immediately. </div><div>Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly prohibited.</div>
<div><br></div><div>Altinity Limited | 404 Seven Sisters Road | London | N4 2LX | United Kingdom</div><div>Registered in England and Wales under company number 4743767</div></div></div></span> </div><br></div></blockquote>
</div><br>