Nagios Support Forum

This is a multi-part message in MIME format.

------_=_NextPart_001_01C6372C.B13F1933
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Alessandro,

=20

I'm using Nagios 2.0 - NDOMOD 1.2.=20

=20

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

=20

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.

=20

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.=20

=20

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

=20

Thanks in advance,

=20

Mike

=20

=20

In the table creation script I have the following:

=20

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=3DMyISAM DEFAULT CHARSET=3Dascii COMMENT=3D'Host definitions';

=20

-----Original Message-----
From: Alessandro Ren [mailto:[email protected]]=20
Sent: Tuesday, February 21, 2006 12:40 PM
To: Mike Koponick
Cc: [email protected]
Subject: Re: [Nagios-devel] MySQL Mapping - NDO

=20


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
. in the field name1.
The field objecttype_id
<https://192.168.10.30/phpMyAdmin/sql.ph ... =3D1&coll=
ati
on_connection=3Dutf8_general_ci&db=3Dnagios&table=3Dndo_objects&pos=3D0&s=
ession_

...[email truncated]...


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