No interface graph


06-04-2004 13:50:07

I have problem displaying graph for whole network iface (template graph) here comes the return value [code1b23ad881f0]Notice: Undefined index: test_id in /home/pigster/web/netmrg/lib/graphing.php on line 27

Notice: Undefined index: test_type in /home/pigster/web/netmrg/lib/graphing.php on line 27
DB_ERROR: Sorry, a database error occured. We cannot continue. Please contact the administrator and let them know what you were doing when the problem occured[/code1b23ad881f0]

separate tests works OK (like inbound traffic ....)

please help


06-04-2004 18:48:04

Please try setting the "dbdebug" option in config.php to true. You should then get a more detailed error message, which should help us help you fix the problem.


08-04-2004 04:45:55

here it goes (it seems ther is something missing)

[code1bd5bad44bf]Notice: Undefined index: test_id in /home/pigster/web/netmrg/lib/graphing.php on line 27

Notice: Undefined index: test_type in /home/pigster/web/netmrg/lib/graphing.php on line 27
DB_ERROR: Couldn't execute query:

SELECT id FROM monitors WHERE sub_dev_id=14 AND test_id= AND test_type= AND test_params=''

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND test_type= AND test_params=''' at line 1



08-04-2004 09:36:07

Did you delete your template group or template host? Without these, there isn't a way to apply an interface graph.

We'll take care of the errors so they don't show up in the next release.



12-04-2004 19:29:26

recreated whole database but still nothing

debug seems OK
Resource id #25
Resource id #27
/usr/local/rrdtool-1.0.47/bin/rrdtool graph - -s -108000 -e -360 --title "kosmuz53k - eth0" -w 575 -h 100 -b 1000 -v "bytes / sec" --imgformat PNG DEF:zero=/usr/local/var/lib/netmrg/rrd/zero.rrd:mon_25:AVERAGE DEF:data1=/usr/local/var/lib/netmrg/rrd/mon_17.rrd:mon_17:AVERAGE DEF:data1l=/usr/local/var/lib/netmrg/rrd/mon_17.rrd:mon_17:LAST DEF:data1m=/usr/local/var/lib/netmrg/rrd/mon_17.rrd:mon_17:MAX AREA:data1#00CC00:"Inbound " GPRINT:data1l:LAST:"Current\:%8.2lf %s" GPRINT:data1:AVERAGE:"Average\:%8.2lf %s" GPRINT:data1m:MAX:"Maximum\:%8.2lf %s" COMMENT:"\n" DEF:data2=/usr/local/var/lib/netmrg/rrd/mon_18.rrd:mon_18:AVERAGE DEF:data2l=/usr/local/var/lib/netmrg/rrd/mon_18.rrd:mon_18:LAST DEF:data2m=/usr/local/var/lib/netmrg/rrd/mon_18.rrd:mon_18:MAX LINE2:data2#0000CC:"Outbound" GPRINT:data2l:LAST:"Current\:%8.2lf %s" GPRINT:data2:AVERAGE:"Average\:%8.2lf %s" GPRINT:data2m:MAX:"Maximum\:%8.2lf %s" COMMENT:"\n" VRULE:1081807200#F00000 COMMENT:"\n" COMMENT:"Interface: eth0" COMMENT:"\n" COMMENT:" IP: %ifIP%\n"

Script execution debug information:Marker Time Diff
Start 1081812516.08802100 -
before headers 1081812516.08812000 9.9E-05
before auth 1081812516.08824800 0.000128
after auth 1081812516.08971400 0.001466
before get command 1081812516.08980500 9.1E-05
after get command 1081812516.09559700 0.005792
before exec command 1081812516.09568400 8.7E-05
after exec command 1081812516.12560500 0.029921
Stop 1081812516.12571700 0.000112
Start to Stop 0.037696


13-04-2004 10:55:23

What happens if you paste the rrdtool command to a terminal?


13-04-2004 16:59:58

if i paste command to terminal and redirect output to .png file it generates correct image