This is a multi-part message in MIME format.
--------------060602090608060903020206
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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
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:
> 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&k ... 86&dat1642
> _______________________________________________
> Nagios-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/lis ... gios-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 [email protected]
__________________________________________________
--------------060602090608060903020206
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
The ndo_hosts has the address a
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]