ndo2db -- lots of empty tables

[Frank J. Gómez]

Thank you, Duncan.

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.

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:

# CONFIG OUTPUT OPTION
# This option determines what types of configuration data the NDO
# NEB module will dump from Nagios.  Values can be OR'ed together.
# Values:
#         0 = Don't dump any configuration information
#         1 = Dump only original config (from config files)
#         2 = Dump config only after retained information has been restored
#         3 = Dump both original and retained configuration

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?

In case it helps anyone else, my data_processing_options (same file) is set
to -1.  I didn't have to change this.

Thanks,
-Frank


On Thu, Apr 10, 2008 at 2:30 PM, Duncan Ferguson <
duncan.ferguson at altinity.com> wrote:

>
> 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/a12a6834/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