Nagios Support Forum

This is a multi-part message in MIME format.
--------------060208030204020303030301
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


There is the field "address" on the table ndo_hosts, this is the IP
address of the host.
In the table ndo_hoststatus you have the field current_state, that
ranges from 0 to 2, 0 is UP, 1 is DOWN and 2 is UNREACHABLE.
For services, from 0 to 3, as defined int eh nagios.h

#define STATE_OK 0
#define STATE_WARNING 1
#define STATE_CRITICAL 2
#define STATE_UNKNOWN 3 /* changed from -1 on 02/24/2001 */

[]s.

Mike Koponick wrote:
>
> 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:[email protected]]
> *Sent:* Tuesday, February 21, 2006 12:40 PM
> *To:* Mike Koponick
> *Cc:* [email protected]
> *Subject:* Re: [Nagios-devel] MySQL Mapping - NDO
>
>
>
>

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]