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