Nagios-MySQL Status Map User Supplied?

[Jan Rasche]

Hi Stefan,

Nice Joke! Hey, hey, hey - I just did not think to much as it is looking. :-)
Simply thought x_2d and y_2d would be this coordinates, but now got it that it is
width and height - yes?

Thank you very much!

Jan

-----Original Message-----
From: Stefan Giesen [mailto:Stefan.Giesen at firstgate.de]
Sent: Mon 8/16/2004 8:51 AM
To: Jan Rasche
Cc: Nagios User Maillist; Andreas Ericsson
Subject: RE: [Nagios-users] Nagios-MySQL Status Map User Supplied?
 
Am So, den 15.08.2004 schrieb Jan Rasche um 22:33:

> mysql> select * from hostextinfo;
> +---------------------------+-----------+---------------+---------------
> +----------------+---------------------------+------+------+----------+-
> ---------+--------+----------------+----------------+
> | 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 |
> +---------------------------+-----------+---------------+---------------
> +----------------+---------------------------+------+------+----------+-
> ---------+--------+----------------+----------------+
> | Cat5-3550AccessSwitch     |           | my_switch.jpg | my_switch.jpg
> | my_switch.gd2  | Cat5-3550AccessSwitch     |   20 |  350 |  20.0000 |
> 350.0000 | 0.0000 |              0 |              0 |
> | Fibre-3508AccessSwitch    |           | my_switch.jpg | my_switch.jpg
> | my_switch.gd2  | Fibre-3508AccessSwitch    |  100 |  350 | 100.0000 |
> 350.0000 | 0.0000 |              0 |              0 |
> | Fibre-9/0/0AccessRouter   |           | my_router.jpg | my_router.jpg
> | my_router.gd2  | Fibre-9/0/0AccessRouter   |  180 |  350 | 180.0000 |
> 350.0000 | 0.0000 |              0 |              0 |
> 
> ...
> 
> | Level3                    |           | my_router.jpg | my_router.jpg
> | my_router.gd2  | Level3                    |  500 |  650 | 500.0000 |
> 650.0000 | 0.0000 |              0 |              0 |
> +---------------------------+-----------+---------------+---------------
> +----------------+---------------------------+------+------+----------+-
> ---------+--------+----------------+----------------+
> 15 rows in set (0.01 sec)
> 
> 
> As said Nagios recognized the images as defined here but not the other
> values for the cords.
> 
> It simply says: 'You have not supplied any host drawing coordinates...'

The solution is jumping at you... ever wondered why there is a column
"have_2d_coords"? And why it is a "0" (false) instead of a "1" (true)?

*grin*

Cheers,
Stefan
-- 
Stefan Giesen, Systemadministration Frankfurt
FIRSTGATE Internet AG, Im MediaPark 5, 50670 Koeln
Telefon: +49 (0) 2 21 / 45 45-745, Telefax: +49 (0) 2 21 / 45 45-710
Internet: www.firstgate.de         eMail: Stefan.Giesen at firstgate.de


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20040816/0a837a37/attachment.html>