Nagios-MySQL Status Map User Supplied?

[Stefan Giesen]

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



-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null