<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> 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: <blockquote cite="mid8C18BAD1F46B2245B0A08BCF1A823DD4109C33@raptor.redhawk.info" type="cite"> <meta http-equiv="Content-Type" content="text/html; "> <meta name="Generator" content="Microsoft Word 10 (filtered)"> <title>OpSign</title> <style>  </style> <div class="Section1"> 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 [<a class="moz-txt-link-freetext" href="mailto:alessandro.ren@opservices.com.br">mailto:alessandro.ren@opservices.com.br</a>] Sent: Tuesday, February 21, 2006 12:40 PM To: Mike Koponick Cc: <a class="moz-txt-link-abbreviated" href="mailto:nagios-devel@lists.sourceforge.net">nagios-devel@lists.sourceforge.net</a> 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 <a href="https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collation_connection=utf8_general_ci&db=nagios&table=ndo_hosts&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2AFROM+%60ndo_hosts%60++ORDER+BY+%60host_object_id%60+ASC" title="Sort">host_object_id</a>. in the field name1. The field <a href="https://192.168.10.30/phpMyAdmin/sql.php?lang=en-utf-8&server=1&collation_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" title="Sort">objecttype_id</a> 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; Mike Koponick wrote: <pre style="margin-left: 0.5in;" wrap="">Hello,</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">I'm in the process of (trying?) to map out the NDO to MySQL data. I have</pre> <pre style="margin-left: 0.5in;">noted that the IP address is missing from the ndo_hosts table, which was</pre> <pre style="margin-left: 0.5in;">pointed out on the list. From what I can tell at this point in my</pre> <pre style="margin-left: 0.5in;">research, this is one of the few columns that are missing.</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">What should this column be named? If added, will Nagios also add the IP</pre> <pre style="margin-left: 0.5in;">address information directly; much like it has with all other data.</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">The problem I'm seeing is that if I create a separate table, very few</pre> <pre style="margin-left: 0.5in;">data items connect because the way the object_id's are defined, etc.</pre> <pre style="margin-left: 0.5in;">This, btw is a good thing from my perspective, but is making development</pre> <pre style="margin-left: 0.5in;">hard for a web interface.</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">A mapping of the NDO/Nagios/MySQL database would be nice, even if it</pre> <pre style="margin-left: 0.5in;">were incomplete. I would look in the code myself, but my coding skills</pre> <pre style="margin-left: 0.5in;">are not in "C" and would confuse anyone to drink heavily.</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">Thoughts?</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">Thanks in advance,</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">Mike</pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;"> </pre> <pre style="margin-left: 0.5in;">-------------------------------------------------------</pre> <pre style="margin-left: 0.5in;">This SF.net email is sponsored by: Splunk Inc. Do you grep through log files</pre> <pre style="margin-left: 0.5in;">for problems? Stop! Download the new AJAX search engine that makes</pre> <pre style="margin-left: 0.5in;">searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!</pre> <pre style="margin-left: 0.5in;"><a href="http://sel.as-us.falkag.net/sel?cmd=k&kid%103432&bid#0486&dat%121642">http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642</a></pre> <pre style="margin-left: 0.5in;">_______________________________________________</pre> <pre style="margin-left: 0.5in;">Nagios-devel mailing list</pre> <pre style="margin-left: 0.5in;"><a href="mailto:Nagios-devel@lists.sourceforge.net">Nagios-devel@lists.sourceforge.net</a></pre> <pre style="margin-left: 0.5in;"><a href="https://lists.sourceforge.net/lists/listinfo/nagios-devel">https://lists.sourceforge.net/lists/listinfo/nagios-devel</a></pre> <pre style="margin-left: 0.5in;"> </pre> <div> -- __________________________________________________ <table class="MsoNormalTable" style="width: 262.5pt; margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td style="padding: 0in; width: 97.5pt;" valign="top" width="130"> Alessandro Ren </td> <td style="padding: 0in; width: 165pt;" valign="top" width="220"> OpServices Luciana de Abreu, 471 - Sala 403 Porto Alegre, RS - CEP 90570-060 </td> </tr> </tbody> </table> <table class="MsoNormalTable" style="width: 262.5pt; margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td style="padding: 0in; width: 111.1pt;" width="148"> ( phone 55(51)3061-3588 4 fax 55(51)3061-3588 </td> <td style="padding: 0in; width: 151.4pt;" width="202"> Q mobile 55(51)8151-8212 : email <a href="mailto:%22alessandro.ren@opservices.com.br%22">alessandro.ren@opservices.com.br</a> </td> </tr> </tbody> </table> __________________________________________________ </div> </div> </blockquote> <div class="moz-signature">-- <title>OpSign</title> __________________________________________________ <table border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td valign="top" width="130"> Alessandro Ren </td> <td valign="top" width="220"> OpServices Luciana de Abreu, 471 - Sala 403 Porto Alegre, RS - CEP 90570-060 </td> </tr> </tbody> </table> <table border="0" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr> <td valign="middle" width="180"> ( phone 55(51)3061-3588 4 fax 55(51)3061-3588 </td> <td valign="middle" width="200"> Q mobile 55(51)8151-8212 : email <a href="mailto:%22alessandro.ren@opservices.com.br%22">alessandro.ren@opservices.com.br</a> </td> </tr> </tbody> </table> __________________________________________________ </div> </body> </html>