ndo2db -- lots of empty tables

[Duncan Ferguson]

On 10 Apr 2008, at 16:52, Frank J. Gómez wrote:
>
> 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.

Check your setting of 'config_output_options' in the ndomod.cfg file -  
it may be incorrectly set for the information you want.

>
> So I guess those are mostly observations, not questions...  Some  
> questions then:
> Did I do something wrong/different during the install process, or  
> are these tables empty by default for everyone else?

Check your setting of 'data_processing_options' in the ndomod.cfg file.
> 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?
Nagios only writes to the ndo database, it doesn't read from it.
>
> Does anyone know what all of the objecttype_id codes mean?  So far I  
> have 1 (hosts), 2 (services), 9, 10, and 12.

The PDF may help with this (link below).  If you feel it is lacking in  
information I am sure Ethan will accept updates.
>
> Why are those tables there if they are not being used?

Check your setting of 'data_processing_options' in the ndomod.cfg file.

>
> PS: I have not seen much documentation about ndo2db.  If anyone has  
> a good resource, please share!

http://nagios.sourceforge.net/docs/ndoutils/NDOUtils_DB_Model.pdf and  
also the source code itself.

   Duncs

-- 
Duncan Ferguson
Senior Developer, Altinity Limited

http://www.altinity.com
Tel: +44 (0)870 787 9243
US:  +1 866 879 9184
Fax: +44 (0)845 280 1725
Skype: duncan_j_ferguson
MSN: duncan.ferguson at altinity.com

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.
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.
Any unauthorised copying, disclosure or distribution of the material  
in this e-mail is strictly prohibited.

Altinity Limited | 404 Seven Sisters Road | London | N4 2LX | United  
Kingdom
Registered in England and Wales under company number 4743767

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080410/869e0174/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null