MySQL Mapping - NDO

[Alessandro Ren]

    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&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>. 
in the field name1.
    The field objecttype_id 
<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> 
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&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>
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
> _______________________________________________
> 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
*4*    fax 55(51)3061-3588
	*Q*   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/9a13e57d/attachment.html>