ndo2db -- lots of empty tables

Frank J. Gómez frank at crop-circle.net
Wed Apr 9 18:34:58 CEST 2008


Hello again.  So I've got the ndo2db module installed and working, but now I
have some questions.

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.

What's interesting is that hosts and services seem to be stored together in
the nagios_objects table.  Hosts are stored with an objecttype_id of 1, with
the hostname stored in name1.  Services are stored with an objecttype_id of
2, with the hostname stored in name1 and the command stored in name2.  Also
worth noting is that the nagios_servicechecks table never refers to columns
from the nagios_hosts and nagios_services; instead it refers to the object
ids.

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?
   - 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?
   - Does anyone know what all of the objecttype_id codes mean?  So far I
   have 1 (hosts), 2 (services), 9, 10, and 12.
   - Why are those tables there if they are not being used?

I may think of more questions later; these are the ones that immediately
popped into my head.

Thanks,
-Frank

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


> -----Original Message-----
> From: Frank J. Gómez <frank at crop-circle.net>
> To: nagios-users at lists.sourceforge.net <nagios-users at lists.sourceforge.net
> >
> Sent: Tue Apr 08 15:48:42 2008
> Subject: [Nagios-users] stability of ndoutils-1.4b7 (ndomod and ndo2db)?
>
> Hi, I've just started using ndomod and ndo2db on a development server to
> have status checks logged to a MySQL database instead of flat files.  I am
> using Nagios v. 2.10 on the development server, v. 2.7 on the production
> server.  The one on production can probably be upgraded to 2.10...
>
> Anyway, the readme file in the ndoutils-1.4b7 says:
>
>
>
> This code is still an alpha/beta quality, so expect problems if you intend
> to use
> it.  Make sure that you aren't using it with your only production
> installation of
> Nagios, or it could take down the Nagios process if the NDOMOD module
> segfaults.
> Nagios could segfault silently and you might never know that Nagios
> crashed...
>
>
>
> However, I see from the SourceForge site that this code hasn't been
> changed since 10/31/2007.  Is this add-on relatively stable?  Are other
> folks using it in production?  Is there anything in particular I should be
> aware of?
>
> Thanks!
> -Frank
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080409/683e9a89/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


More information about the Users mailing list