<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word" xmlns:st1 = "urn:schemas-microsoft-com:office:smarttags"><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR><o:SmartTagType name="PostalCode" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType name="State" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType name="City" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType name="place" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType name="PersonName" namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType> <STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: purple; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US vLink=purple link=blue> <DIV>Nagios will read xdata from MySQL DB tables so you have to insert your xdata in hostextinfo table in your MySQL DB</DIV> <DIV> </DIV> <DIV>you have to connect to your DB, you should find a table called hostextinfo (and also serviceextinfo)</DIV> <DIV> </DIV> <DIV>mysql> describe hostextinfo; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | host_name | varchar(75) | | | | | | notes_url | varchar(128) | | | | | | icon_image | varchar(32) | | | | | | vrml_image | varchar(32) | | | | | | gd2_icon_image | varchar(32) | | | | | | icon_image_alt | varchar(128) | | | | | | x_2d | int(11) | | | -1 | | | y_2d | int(11) | | | -1 | | | x_3d | double(16,4) | | | -1.0000 | | | y_3d | double(16,4) | | | -1.0000 | | | z_3d | double(16,4) | | | -1.0000 | | | have_2d_coords | tinyint(4) | | | 0 | | | have_3d_coords | tinyint(4) | | | 0 | | +----------------+--------------+------+-----+---------+-------+ 13 rows in set (0.02 sec)</DIV> <DIV> </DIV> <DIV>then you have to insert your xdata for all your hosts</DIV> <DIV> </DIV> <DIV>this is an example of insert command for one of my hosts</DIV> <DIV>mysql> insert into hostextinfo values ('PESM0005','http://xxx.xxx.xxx.xxx/cgi-bin/PESM0005-rrd.cgi/PESM0005_se00_locIfInOutBitsSec/','router40.png','','router40.gd2','PESM0005',200,200,100.0,100.0,300.0,100,100);</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>if you have lots of hosts I suggest you to write a text file with insert commands for all your hosts and input it to mysql</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>hope this helps</DIV> <DIV> </DIV> <DIV>Antonella</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> --------------------------------------------- Antonella Andreoni System Engineer KSOLUTIONS S.p.A. Via Lenin, 132/26 56017 San Martino Ulmiano (PI) - Italy Tel. +39 50 898111 Fax +39 50 861200 E-mail: andreoni@ksolutions.it <A href="http://www.ksolutions.it/" target=_blank>http://www.ksolutions.it</A> ---------------------------------------------</DIV> <DIV> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-----Messaggio originale----- Da: Christopher D. Chandler [mailto:chris@dhinnovations.com] Inviato: martedė 3 agosto 2004 23.57 A: nagios-users@lists.sourceforge.net Oggetto: [Nagios-users] Icon disappear after using MYSQL for XDATA </DIV> <DIV class=Section1> To Nagios Support:<o:p></o:p> <o:p> </o:p> I have recently complied the nagios bin to use MYSQL for xdata upon doing so I have lost all my icons for my status map. All the host have a black question mark on top of them. Can anyone help get my icons back. Below are the configuration files that I am using. <o:p></o:p> <o:p> </o:p> Thanks - Chris<o:p></o:p> <o:p> </o:p> CONFIG.STATUS<o:p></o:p> <o:p> </o:p> ./configure --disable-statuswrl --enable-embedded-perl --with-perlcache --with-file-perfdata --with-mysql-xdata<o:p></o:p> <o:p> </o:p> CGI.CFG<o:p></o:p> <o:p> </o:p> xedtemplate_config_file=/usr/local/nagios/etc/hostextinfo.cfg<o:p></o:p> <o:p> </o:p> HOSTEXTINFO.CFG<o:p></o:p> <o:p> </o:p> # DH01 Description<o:p></o:p> define hostextinfo{<o:p></o:p> host_name dh01<o:p></o:p> icon_image win40.jpg<o:p></o:p> icon_image_alt DH01<o:p></o:p> vrml_image win40.jpg<o:p></o:p> statusmap_image win40.jpg<o:p></o:p> gd2_image win40.jpg<o:p></o:p> register 1<o:p></o:p> }<o:p></o:p> <o:p> </o:p> # DH02 Description<o:p></o:p> define hostextinfo{<o:p></o:p> host_name dh02<o:p></o:p> icon_image win40.jpg<o:p></o:p> icon_image_alt DH02<o:p></o:p> vrml_image win40.jpg<o:p></o:p> statusmap_image win40.jpg<o:p></o:p> gd2_image win40.jpg<o:p></o:p> register 1<o:p></o:p> }<o:p></o:p> <o:p> </o:p> # DH03 Description<o:p></o:p> define hostextinfo{<o:p></o:p> host_name dh03<o:p></o:p> icon_image redhat.jpg<o:p></o:p> icon_image_alt DH03<o:p></o:p> vrml_image redhat.jpg<o:p></o:p> statusmap_image redhat.jpg<o:p></o:p> gd2_image redhat.jpg<o:p></o:p> register 1<o:p></o:p> }<o:p></o:p> <o:p> </o:p> # DH04 Description<o:p></o:p> define hostextinfo{<o:p></o:p> host_name dh04<o:p></o:p> icon_image redhat.jpg<o:p></o:p> icon_image_alt DH01<o:p></o:p> vrml_image redhat.jpg<o:p></o:p> statusmap_image redhat.jpg<o:p></o:p> gd2_image redhat.jpg<o:p></o:p> register 1<o:p></o:p> }<o:p></o:p> <o:p> </o:p> <TABLE class=MsoNormalTable style="WIDTH: 248.25pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=331 border=0> <TBODY> <TR style="HEIGHT: 66pt" height=88> <TD style="PADDING-RIGHT: 3pt; PADDING-LEFT: 3pt; PADDING-BOTTOM: 3pt; WIDTH: 161.25pt; PADDING-TOP: 3pt; HEIGHT: 66pt" width=215 height=88> <st1:PersonName w:st="on">Christopher D. Chandler</st1:PersonName> Managing Partner<o:p></o:p> Office: 919-481-9876 <st1:City w:st="on"><st1:place w:st="on">Mobile</st1:place></st1:City>: 919-274-7684 <o:p></o:p> <o:p></o:p> <A href="mailto:chris@dhinnovations.com">chris@dhinnovations.com</A><o:p></o:p></TD> <TD style="PADDING-RIGHT: 3pt; PADDING-LEFT: 3pt; PADDING-BOTTOM: 3pt; WIDTH: 80.25pt; PADDING-TOP: 3pt; HEIGHT: 66pt" vAlign=bottom width=107 height=88> <o:p></o:p></TD></TR> <TR style="HEIGHT: 18.75pt" height=25> <TD style="PADDING-RIGHT: 3pt; PADDING-LEFT: 3pt; PADDING-BOTTOM: 3pt; WIDTH: 242.25pt; PADDING-TOP: 3pt; HEIGHT: 18.75pt" vAlign=bottom width=323 colSpan=2 height=25> DH Innovations, LLC Post Office Box 5335 | <st1:place w:st="on"><st1:City w:st="on">Cary</st1:City>, <st1:State w:st="on">North Carolina</st1:State> <st1:PostalCode w:st="on">27512</st1:PostalCode></st1:place><o:p></o:p></TD></TR></TBODY></TABLE> <o:p> </o:p></DIV></BLOCKQUOTE></BODY></HTML>