my graph for availability doesn't work

[tecker2010]

hi,

i need a graph which shows the availability of a device, therefore i made the following script:

Code: Select all

<?php

mysql_connect( "localhost", "root", "mysqlroot" );
mysql_select_db("cacti");

$ausgabe = "SELECT status from host WHERE id=2";
$result = mysql_query( $ausgabe );
$datensatz = mysql_fetch_row ($result );

foreach ( $datensatz as $wert)

if ( $wert > 2 )
echo 1;

else echo 0;

?>

then i created a data input method with input type "script command" , output field and right string. and then a data template with these data input method and its outputfield. i have also a graph template which is associated to the devic and with status "is being graphed
2.
my debugs are ok. rrdtool says ok and there are no errors at the debug of my data source.

the graph is there but no values ... i get NaN. any ideas what i can do or where i have to start with searching?

greets

[gandalf]

Please try second link of my signature to debug NaN's
Reinhard