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