lists.netmrg.net lists.netmrg.net
NetMRG discussion and support
 
FAQ :: Search :: Memberlist :: Usergroups :: Register
Profile :: Log in to check your private messages :: Log in

No interface graph

 
Post new topic   Reply to topic    lists.netmrg.net Forum Index -> Support
Author Message
pigster
Beginner


Joined: 06 Apr 2004
Posts: 4

PostPosted: Tue Apr 06, 2004 5:50 pm    Post subject: No interface graph Reply with quote

I have problem displaying graph for whole network iface (template graph) here comes the return value
Code:
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


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

please help
Back to top
balleman
Site Admin


Joined: 20 Jan 2003
Posts: 282

PostPosted: Tue Apr 06, 2004 10:48 pm    Post subject: Reply with quote

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.
Back to top
pigster
Beginner


Joined: 06 Apr 2004
Posts: 4

PostPosted: Thu Apr 08, 2004 8:45 am    Post subject: Reply with quote

here it goes (it seems ther is something missing)

Code:
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

Back to top
silfreed
Site Admin


Joined: 19 Jan 2003
Posts: 394
Location: Shippensburg, PA, USA

PostPosted: Thu Apr 08, 2004 1:36 pm    Post subject: Reply with quote

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.

-Doug
Back to top
pigster
Beginner


Joined: 06 Apr 2004
Posts: 4

PostPosted: Mon Apr 12, 2004 11:29 pm    Post subject: Reply with quote

recreated whole database but still nothing

debug seems OK
Code:

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
Back to top
balleman
Site Admin


Joined: 20 Jan 2003
Posts: 282

PostPosted: Tue Apr 13, 2004 2:55 pm    Post subject: Reply with quote

What happens if you paste the rrdtool command to a terminal?
Back to top
pigster
Beginner


Joined: 06 Apr 2004
Posts: 4

PostPosted: Tue Apr 13, 2004 8:59 pm    Post subject: Reply with quote

if i paste command to terminal and redirect output to .png file it generates correct image
Back to top
Display posts from previous:   
Post new topic   Reply to topic    lists.netmrg.net Forum Index -> Support All times are GMT
Page 1 of 1

 



smartBlue Style © 2002 Smartor
Powered by phpBB © 2001, 2002 phpBB Group