nagios and mysql 3d coordonates
victor
victor at ambra.ro
Mon Sep 6 11:29:19 CEST 2004
Nagios and mysql 2d coordinates work.
When I try set 3d coordinates for 1 host it works.
But when I insert 3d coordinates for a second host the "3d status map"
appears completly blank.
So, on short:
1) this works:
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60+&pos=0&session_max_rows=30&pos=0&disp_direction=horizontal&repeat_cells=100&goto=tbl_properties.php&dontlimitchars=1>
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
<http://192.168.250.99/mysql/tbl_change.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60host_name%60+%3D+%27370%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27370.gif%27+AND+%60vrml_image%60+%3D+%27370.gif%27+AND+%60gd2_icon_image%60+%3D+%27370.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+370%27+AND+%60x_2d%60+%3D+%271559%27+AND+%60y_2d%60+%3D+%271505%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271559.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271505.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27370.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%271%27&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60+&goto=sql.php>
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60hostextinfo%60+WHERE+%60host_name%60+%3D+%27370%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27370.gif%27+AND+%60vrml_image%60+%3D+%27370.gif%27+AND+%60gd2_icon_image%60+%3D+%27370.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+370%27+AND+%60x_2d%60+%3D+%271559%27+AND+%60y_2d%60+%3D+%271505%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271559.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271505.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27370.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%271%27+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Flang%3Den-iso-8859-1%26server%3D1%26db%3Dnagios%26table%3Dhostextinfo%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%2B%252A%2B%250AFROM%2B%2B%2560hostextinfo%2560%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_properties.php>
370 370.gif 370.gif 370.gd2 Cutia 370 1559 1505 1559.0000
1505.0000 370.0000 1 1
2)but this doesn't(the 3d map is blank)
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60+&pos=0&session_max_rows=30&pos=0&disp_direction=horizontal&repeat_cells=100&goto=tbl_properties.php&dontlimitchars=1>
host_name
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60host_name%60+ASC>
notes_url
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60notes_url%60+ASC>
icon_image
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60icon_image%60+ASC>
vrml_image
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60vrml_image%60+ASC>
gd2_icon_image
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60gd2_icon_image%60+ASC>
icon_image_alt
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60icon_image_alt%60+ASC>
x_2d
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60x_2d%60+ASC>
y_2d
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60y_2d%60+ASC>
x_3d
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60x_3d%60+ASC>
y_3d
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60y_3d%60+ASC>
z_3d
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60z_3d%60+ASC>
have_2d_coords
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60have_2d_coords%60+ASC>
have_3d_coords
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60++ORDER+BY+%60have_3d_coords%60+ASC>
<http://192.168.250.99/mysql/tbl_change.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60host_name%60+%3D+%27370%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27370.gif%27+AND+%60vrml_image%60+%3D+%27370.gif%27+AND+%60gd2_icon_image%60+%3D+%27370.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+370%27+AND+%60x_2d%60+%3D+%271559%27+AND+%60y_2d%60+%3D+%271505%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271559.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271505.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27370.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%271%27&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60+&goto=sql.php>
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60hostextinfo%60+WHERE+%60host_name%60+%3D+%27370%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27370.gif%27+AND+%60vrml_image%60+%3D+%27370.gif%27+AND+%60gd2_icon_image%60+%3D+%27370.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+370%27+AND+%60x_2d%60+%3D+%271559%27+AND+%60y_2d%60+%3D+%271505%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271559.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271505.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27370.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%271%27+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Flang%3Den-iso-8859-1%26server%3D1%26db%3Dnagios%26table%3Dhostextinfo%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%2B%252A%2B%250AFROM%2B%2B%2560hostextinfo%2560%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_properties.php>
370 370.gif 370.gif 370.gd2 Cutia 370 1559 1505 1559.0000
1505.0000 370.0000 1 1
<http://192.168.250.99/mysql/tbl_change.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60host_name%60+%3D+%27383%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27383.gif%27+AND+%60vrml_image%60+%3D+%27383.gif%27+AND+%60gd2_icon_image%60+%3D+%27383.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+383%27+AND+%60x_2d%60+%3D+%271179%27+AND+%60y_2d%60+%3D+%271289%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271179.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271289.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27383.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%27-1%27&sql_query=SELECT++%2A+%0AFROM++%60hostextinfo%60+&goto=sql.php>
<http://192.168.250.99/mysql/sql.php?lang=en-iso-8859-1&server=1&db=nagios&table=hostextinfo&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60hostextinfo%60+WHERE+%60host_name%60+%3D+%27383%27+AND+%60notes_url%60+%3D+%27%27+AND+%60icon_image%60+%3D+%27383.gif%27+AND+%60vrml_image%60+%3D+%27383.gif%27+AND+%60gd2_icon_image%60+%3D+%27383.gd2%27+AND+%60icon_image_alt%60+%3D+%27Cutia+383%27+AND+%60x_2d%60+%3D+%271179%27+AND+%60y_2d%60+%3D+%271289%27+AND+CONCAT%28%60x_3d%60%29+%3D+%271179.0000%27+AND+CONCAT%28%60y_3d%60%29+%3D+%271289.0000%27+AND+CONCAT%28%60z_3d%60%29+%3D+%27383.0000%27+AND+%60have_2d_coords%60+%3D+%271%27+AND+%60have_3d_coords%60+%3D+%27-1%27+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Flang%3Den-iso-8859-1%26server%3D1%26db%3Dnagios%26table%3Dhostextinfo%26pos%3D0%26session_max_rows%3D30%26disp_direction%3Dhorizontal%26repeat_cells%3D100%26dontlimitchars%3D0%26sql_query%3DSELECT%2B%2B%252A%2B%250AFROM%2B%2B%2560hostextinfo%2560%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_properties.php>
383 383.gif 383.gif 383.gd2 Cutia 383 1179 1289 1179.0000
1289.0000 383.0000 1 1
I hope there is no problem because I wrote html in this message.
Thank you.
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_idP47&alloc_id808&op=click
_______________________________________________
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
More information about the Users
mailing list