MySQL Mapping - NDO

[Mike Koponick]

Alessandro,

 

I'm using Nagios 2.0 - NDOMOD 1.2. 

 

If I read this correctly, the object_id connects all the appropriate
tables to names, etc.

 

The ndo_hosts table has no IP information, nor does it have an ID for
the hostgroup_name. I would suspect for the hostgroup_name information
it should also have "hostgroup_id", but it is not there either.

 

At this point I wonder if it would be better to try to use the
"built-in" database functionality, rather than NDO until NDO is more
firm. 

 

All I need is host status information, and from what I can tell that
information is available with the built-in functionality.

 

Thanks in advance,

 

Mike

 

 

In the table creation script I have the following:

 

CREATE TABLE IF NOT EXISTS `ndo_hosts` (

  `host_id` int(11) NOT NULL auto_increment,

  `instance_id` smallint(6) NOT NULL default '0',

  `config_type` smallint(6) NOT NULL default '0',

  `host_object_id` int(11) NOT NULL default '0',

  `check_command_object_id` int(11) NOT NULL default '0',

  `check_command_args` varchar(255) NOT NULL default '',

  `eventhandler_command_object_id` int(11) NOT NULL default '0',

  `eventhandler_command_args` varchar(255) NOT NULL default '',

  `notification_timeperiod_object_id` int(11) NOT NULL default '0',

  `check_timeperiod_object_id` int(11) NOT NULL default '0',

  `failure_prediction_options` varchar(64) NOT NULL default '',

  `check_interval` smallint(6) NOT NULL default '0',

  `max_check_attempts` smallint(6) NOT NULL default '0',

  `notification_interval` smallint(6) NOT NULL default '0',

  `notify_on_down` smallint(6) NOT NULL default '0',

  `notify_on_unreachable` smallint(6) NOT NULL default '0',

  `notify_on_recovery` smallint(6) NOT NULL default '0',

  `notify_on_flapping` smallint(6) NOT NULL default '0',

  `stalk_on_up` smallint(6) NOT NULL default '0',

  `stalk_on_down` smallint(6) NOT NULL default '0',

  `stalk_on_unreachable` smallint(6) NOT NULL default '0',

  `flap_detection_enabled` smallint(6) NOT NULL default '0',

  `low_flap_threshold` double NOT NULL default '0',

  `high_flap_threshold` double NOT NULL default '0',

  `process_performance_data` smallint(6) NOT NULL default '0',

  `freshness_checks_enabled` smallint(6) NOT NULL default '0',

  `freshness_threshold` smallint(6) NOT NULL default '0',

  `passive_checks_enabled` smallint(6) NOT NULL default '0',

  `event_handler_enabled` smallint(6) NOT NULL default '0',

  `active_checks_enabled` smallint(6) NOT NULL default '0',

  `retain_status_information` smallint(6) NOT NULL default '0',

  `retain_nonstatus_information` smallint(6) NOT NULL default '0',

  `notifications_enabled` smallint(6) NOT NULL default '0',

  `obsess_over_host` smallint(6) NOT NULL default '0',

  `failure_prediction_enabled` smallint(6) NOT NULL default '0',

  PRIMARY KEY  (`host_id`),

  UNIQUE KEY `instance_id`
(`instance_id`,`config_type`,`host_object_id`)

) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Host definitions';

 

-----Original Message-----
From: Alessandro Ren [mailto:alessandro.ren at opservices.com.br] 
Sent: Tuesday, February 21, 2006 12:40 PM
To: Mike Koponick
Cc: nagios-devel at lists.sourceforge.net
Subject: Re: [Nagios-devel] MySQL Mapping - NDO

 


    The ndo_hosts has the address as far as I know, in version 1.3, it
does't have the hostname. The hostname is in ndo_objects table and its
referenced by the field host_object_id
<https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collati
on_connection=utf8_general_ci&db=nagios&table=ndo_hosts&pos=0&session_ma
x_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sq
l_query=SELECT+%2AFROM+%60ndo_hosts%60++ORDER+BY+%60host_object_id%60+AS
C> . in the field name1.
    The field objecttype_id
<https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collati
on_connection=utf8_general_ci&db=nagios&table=ndo_objects&pos=0&session_
max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&
sql_query=SELECT+%2AFROM+%60ndo_objects%60++ORDER+BY+%60objecttype_id%60
+ASC>  in ndo_objects sets what type of object it is according to table
bellow:

    I hope that I could help.

NDO2DB_OBJECTTYPE_HOST=1;
NDO2DB_OBJECTTYPE_SERVICE=2;
NDO2DB_OBJECTTYPE_HOSTGROUP=3;
NDO2DB_OBJECTTYPE_SERVICEGROUP=4;
NDO2DB_OBJECTTYPE_HOSTESCALATION=5;
NDO2DB_OBJECTTYPE_SERVICEESCALATION=6;
NDO2DB_OBJECTTYPE_HOSTDEPENDENCY=7;
NDO2DB_OBJECTTYPE_SERVICEDEPENDENCY=8;
NDO2DB_OBJECTTYPE_TIMEPERIOD=9;
NDO2DB_OBJECTTYPE_CONTACT=10;
NDO2DB_OBJECTTYPE_CONTACTGROUP=11;
NDO2DB_OBJECTTYPE_COMMAND=12;
NDO2DB_OBJECTTYPE_HOSTEXTINFO=13;
NDO2DB_OBJECTTYPE_SERVICEEXTINFO=14;
<https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collati
on_connection=utf8_general_ci&db=nagios&table=ndo_objects&pos=0&session_
max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&
sql_query=SELECT+%2AFROM+%60ndo_objects%60++ORDER+BY+%60objecttype_id%60
+ASC> 
Mike Koponick wrote: 

Hello,
 
I'm in the process of (trying?) to map out the NDO to MySQL data. I have
noted that the IP address is missing from the ndo_hosts table, which was
pointed out on the list. From what I can tell at this point in my
research, this is one of the few columns that are missing.
 
What should this column be named? If added, will Nagios also add the IP
address information directly; much like it has with all other data.
 
The problem I'm seeing is that if I create a separate table, very few
data items connect because the way the object_id's are defined, etc.
This, btw is a good thing from my perspective, but is making development
hard for a web interface.
 
A mapping of the NDO/Nagios/MySQL database would be nice, even if it
were incomplete. I would look in the code myself, but my coding skills
are not in "C" and would confuse anyone to drink heavily.
 
Thoughts?
 
Thanks in advance,
 
Mike
 
 
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642
<http://sel.as-us.falkag.net/sel?cmd=k&kid%103432&bid#0486&dat1642> 
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel
  

 

-- 
__________________________________________________

Alessandro Ren

OpServices
Luciana de Abreu, 471 - Sala 403
Porto Alegre, RS - CEP 90570-060

 

*   phone 55(51)3061-3588
*    fax 55(51)3061-3588

*   mobile 55(51)8151-8212
*   email alessandro.ren at opservices.com.br
<mailto:%22alessandro.ren at opservices.com.br%22> 

__________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20060221/428f6edb/attachment.html>