<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>RE: [Nagios-users] Nagios-MySQL Status Map User Supplied?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>Hi Stefan,<BR>
<BR>
Nice Joke! Hey, hey, hey - I just did not think to much as it is looking. :-)<BR>
Simply thought x_2d and y_2d would be this coordinates, but now got it that it is<BR>
width and height - yes?<BR>
<BR>
Thank you very much!<BR>
<BR>
Jan<BR>
<BR>
-----Original Message-----<BR>
From: Stefan Giesen [<A HREF="mailto:Stefan.Giesen@firstgate.de">mailto:Stefan.Giesen@firstgate.de</A>]<BR>
Sent: Mon 8/16/2004 8:51 AM<BR>
To: Jan Rasche<BR>
Cc: Nagios User Maillist; Andreas Ericsson<BR>
Subject: RE: [Nagios-users] Nagios-MySQL Status Map User Supplied?<BR>
<BR>
Am So, den 15.08.2004 schrieb Jan Rasche um 22:33:<BR>
<BR>
> mysql> select * from hostextinfo;<BR>
> +---------------------------+-----------+---------------+---------------<BR>
> +----------------+---------------------------+------+------+----------+-<BR>
> ---------+--------+----------------+----------------+<BR>
> | host_name | notes_url | icon_image | vrml_image<BR>
> | gd2_icon_image | icon_image_alt | x_2d | y_2d | x_3d |<BR>
> y_3d | z_3d | have_2d_coords | have_3d_coords |<BR>
> +---------------------------+-----------+---------------+---------------<BR>
> +----------------+---------------------------+------+------+----------+-<BR>
> ---------+--------+----------------+----------------+<BR>
> | Cat5-3550AccessSwitch | | my_switch.jpg | my_switch.jpg<BR>
> | my_switch.gd2 | Cat5-3550AccessSwitch | 20 | 350 | 20.0000 |<BR>
> 350.0000 | 0.0000 | 0 | 0 |<BR>
> | Fibre-3508AccessSwitch | | my_switch.jpg | my_switch.jpg<BR>
> | my_switch.gd2 | Fibre-3508AccessSwitch | 100 | 350 | 100.0000 |<BR>
> 350.0000 | 0.0000 | 0 | 0 |<BR>
> | Fibre-9/0/0AccessRouter | | my_router.jpg | my_router.jpg<BR>
> | my_router.gd2 | Fibre-9/0/0AccessRouter | 180 | 350 | 180.0000 |<BR>
> 350.0000 | 0.0000 | 0 | 0 |<BR>
><BR>
> ...<BR>
><BR>
> | Level3 | | my_router.jpg | my_router.jpg<BR>
> | my_router.gd2 | Level3 | 500 | 650 | 500.0000 |<BR>
> 650.0000 | 0.0000 | 0 | 0 |<BR>
> +---------------------------+-----------+---------------+---------------<BR>
> +----------------+---------------------------+------+------+----------+-<BR>
> ---------+--------+----------------+----------------+<BR>
> 15 rows in set (0.01 sec)<BR>
><BR>
><BR>
> As said Nagios recognized the images as defined here but not the other<BR>
> values for the cords.<BR>
><BR>
> It simply says: 'You have not supplied any host drawing coordinates...'<BR>
<BR>
The solution is jumping at you... ever wondered why there is a column<BR>
"have_2d_coords"? And why it is a "0" (false) instead of a "1" (true)?<BR>
<BR>
*grin*<BR>
<BR>
Cheers,<BR>
Stefan<BR>
--<BR>
Stefan Giesen, Systemadministration Frankfurt<BR>
FIRSTGATE Internet AG, Im MediaPark 5, 50670 Koeln<BR>
Telefon: +49 (0) 2 21 / 45 45-745, Telefax: +49 (0) 2 21 / 45 45-710<BR>
Internet: www.firstgate.de eMail: Stefan.Giesen@firstgate.de<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>