Interface graph is not generating

[vikasjnp]

Dear All,

when we are adding new graph. it is not generating graph, it is showing as attachment.

old graphs are plotting fine. we tried to rebuild poller cache but no success.

this issue started after adding one template, we have removed that template.

Cacti ver- 0.8.8a

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title='xx' \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit='0' \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/xx.rrd":'traffic_in':AVERAGE \
DEF:b="/var/www/html/rra/xx.rrd":'traffic_out':AVERAGE \
CDEF:cdefa='a,8,*' \
CDEF:cdeff='b,8,*' \
CDEF:cdefbe='a,UN,INF,UNKN,IF' \
CDEF:cdefbh='TIME,1360162445,GT,a,a,UN,0,a,IF,IF,TIME,1360162445,GT,b,b,UN,0,b,IF,IF,+' \
--watermark "Created using CactiEZ" \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" \
COMMENT:"Transfer\: 0 bytes" \
LINE1:cdeff#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Current\:%8.2lf%s" \
HRULE:|95\:bits\:0\:current|#00FF00FF:"95%\:" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf%s" \
COMMENT:"|95\:bits\:6\:current| mbit\n" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf%s\n" \
COMMENT:" \n" \
HRULE:0#FF0000FF:"95th Percentile" \
COMMENT:"(0 mbit in+out)" \
AREA:cdefbe#8F9286FF:"" \
COMMENT:"Transfer\: 0 bytes" \
HRULE:|95\:bits\:0\:current|#0000FFFF:"95%\:" \
COMMENT:"0 mbit" \
COMMENT:"Total Transfer\: 0 bytes\n"
RRDTool Says:






please assist

[gandalf]

Please copy that command to a file, e.g. foo.sh. Then run it like "sh foo.sh > foo.png". Any errors?
R.

[vikasjnp]

hi

i have copied command in test.sh and run sh test.sh

please see output.

sh test.sh > test.png
test.sh: line 34: 95:bits:0:current: command not found
test.sh: line 36: COMMENT:|95\:bits\:6\:current| mbit\n: command not found
test.sh: line 2: --imgformat=PNG: command not found
test.sh: line 40: 95:bits:0:current: command not found
test.sh: line 42: COMMENT:0.54 mbit: command not found


i have checked old graphs which are working fine

this is debug output.

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title=' yyy - Traffic - 22.1.73' \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit='0' \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/yyy1780.rrd":'traffic_out':AVERAGE \
DEF:b="/var/www/html/rra/yyy1780.rrd":'traffic_in':AVERAGE \
CDEF:cdefa='a,8,*' \
CDEF:cdefe='b,8,*' \
--watermark "Created using CactiEZ" \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf%s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf%s\n" \
COMMENT:" \n" \
HRULE:43319.53#FF0000FF:"95th Percentile" \
COMMENT:"(0.04 mbit in+out)"

RRDTool Says:

OK

i tried to restore this cacti backup to new cacti but getting error to restore database.

mysql cacti < cacti-backup.sql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I tried all possible ways to import but getting error.

Please help me.

Regards

[gandalf]

Try importing as cactiuser using the password defined in include/config.php
R.

[vikasjnp]

hi
thanks for reply

i mange to restore backup successfully.

but i can see data or graphs in new cacti.

please assist

Try importing as cactiuser using the password defined in include/config.php
R.

[gandalf]

but i can see data or graphs in new cacti.

You can or you can't? What do you get? Se e.g. Graph Management in Debug mode
R.