<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hi Roberto,<br>
This is what I  have in my hostextinfo table.<br>
 <br>
mysql> select * from hostextinfo;<br>
+------------+-------------------+------------+------------+----------------+----------------+------+------+----------+---------+---------+----------------+----------------+<br>
| host_name  | notes_url         | icon_image | vrml_image |
gd2_icon_image | icon_image_alt | x_2d | y_2d | x_3d     | y_3d    |
z_3d    | have_2d_coords | have_3d_coords |<br>
+------------+-------------------+------------+------------+----------------+----------------+------+------+----------+---------+---------+----------------+----------------+<br>
| netmonitor | <a class="moz-txt-link-freetext" href="http://netmonitor">http://netmonitor</a> | debian.png | debian.png |
debian.gd2     | Debian         |  100 |  200 | 100.0000 | 50.0000 |
75.0000 |              5 |              5 |<br>
| gw198      | none              | debian.png | debian.png |
debian.gd2     | Debian         |  100 |  200 | 100.0000 | 50.0000 |
75.0000 |              5 |              5 |<br>
+------------+-------------------+------------+------------+----------------+----------------+------+------+----------+---------+---------+----------------+----------------+<br>
<br>
Thanks,<br>
Sudheer<br>
<br>
Balestra, Roberto wrote:<br>
<blockquote type="cite"
 cite="mid4E3FFB397E161940867E0B56F0B640D72044CA@excbebr203.europe.unity">
  <meta http-equiv="Content-Type" content="text/html; ">
  <title></title>
  <meta content="MSHTML 6.00.2800.1479" name="GENERATOR">
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">Hi,</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">I have hostextinfo and serviceextinfo on
mysql (3.23.58) on RH 7.3 using Nagios 1.2</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">In cgi.cfg I had comment hostextinfo and
serviextinfo rows and I have added host, post, db, user and password as
you.</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">I have insert into table parametres that I
want.</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">Nothing else.</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">If it doesn't work try to see your
configuration of mysql, permission or case character. Try to connect to
your mysql with:</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">mysql -u abc -pabc -D abc</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">and then run command</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">select * from hostextinfo;</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">Please, give me a feedback.</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">Bye</span></font></div>
  <div><font face="Arial" color="#0000ff" size="2"><span
 class="218465411-24012005">    Roberto</span></font></div>
  <blockquote dir="ltr"
 style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
    <div class="OutlookMessageHeader" dir="ltr" align="left"><font
 face="Tahoma" size="2">-----Original Message-----<br>
    <b>From:</b> <a class="moz-txt-link-abbreviated" href="mailto:nagios-users-admin@lists.sourceforge.net">nagios-users-admin@lists.sourceforge.net</a>
[<a class="moz-txt-link-freetext" href="mailto:nagios-users-admin@lists.sourceforge.net">mailto:nagios-users-admin@lists.sourceforge.net</a>]<b>On Behalf Of </b>Sudheer
Muddappa<br>
    <b>Sent:</b> venerdì 21 gennaio 2005 23.16<br>
    <b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a><br>
    <b>Subject:</b> Re: [Nagios-users] Hostext info] ANYBODY??????<br>
    <br>
    </font></div>
Any of you guys using hostextinfo and serviceextinfo with mysql?<br>
    <br>
Sudheer Muddappa wrote:<br>
    <blockquote cite="mid41F15353.60201@tgs-solutions.com" type="cite">I
have populated the hostextinfo table wit the data. Still its not
working.<br>
      <br>
      <br>
Marc Powell wrote:<br>
      <blockquote
 cite="mid349555FA607F3A4CBDA9326035D1A7FC83646B@mismail.ena.com"
 type="cite">
        <pre wrap="">  </pre>
        <blockquote type="cite">
          <pre wrap="">-----Original Message-----
From: <a class="moz-txt-link-abbreviated"
 href="mailto:nagios-users-admin@lists.sourceforge.net">nagios-users-admin@lists.sourceforge.net</a> [<a
 class="moz-txt-link-freetext" href="mailto:nagios-users">mailto:nagios-users</a>-
<a class="moz-txt-link-abbreviated"
 href="mailto:admin@lists.sourceforge.net">admin@lists.sourceforge.net</a>] On Behalf Of Sudheer Muddappa
Sent: Friday, January 21, 2005 9:20 AM
To: <a class="moz-txt-link-abbreviated"
 href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a>
Subject: [Nagios-users] Hostext info] ANYBODY??????

Guys,

Can some one help me on this?

I have these parameters in my cgi.cfg file
# DG EXTENDED DATA
# Note: These config directives are only used if you compiled
# in database support for extended data!
# The user you specify here only needs SELECT privileges on the
# 'hostextinfo' table in the database.

xeddb_host=localhost
xeddb_port=3306
xeddb_database=abc
xeddb_username=abc
xeddb_password=abc
    </pre>
        </blockquote>
        <pre wrap=""><!---->
If you've compiled Nagios with extended data in a database (as you
indicate above) then everything below is pointless. Nagios will look for
the extinfo definitions in the database, not hostextinfo.cfg.

<a class="moz-txt-link-freetext"
 href="http://nagios.sourceforge.net/docs/1_0/xdata-db.html#config_extinfo">http://nagios.sourceforge.net/docs/1_0/xdata-db.html#config_extinfo</a>

You'll need to create the appropriate tables and populate them with your
extinfo data.

--
Marc
  </pre>
        <blockquote type="cite">
          <pre wrap="">and

xedteplate_config_file=/etc/nagios/hostextinfo.cfg

in hostexetinfo.cfg i have this entry.

define hostextinfo{
                host_name netmonitor
                notes_url      none
                icon_image debian.png
                vrml_image debian.png
                gd2_icon_image debian.gd2
                icon_image_alt Debian Server
                statusmap_image debian.gd2
                2d_coords 100,200
                3d_coords 100.0,50.0,75.0
           }

Is this right? Do i need to configure anything else?

Other severvices of nagios are managed by mysql db.
    </pre>
        </blockquote>
        <pre wrap=""><!---->



-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at <a class="moz-txt-link-freetext"
 href="http://www.intelliview.com/go/osdn_nl">http://www.intelliview.com/go/osdn_nl</a>
_______________________________________________
Nagios-users mailing list
<a class="moz-txt-link-abbreviated"
 href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a>
<a class="moz-txt-link-freetext"
 href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


  </pre>
      </blockquote>
      <br>
    </blockquote>
  </blockquote>
</blockquote>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>