[SOLVED] RRD Graph problem since the 3/17/11 build.
-
I started having issues with the RRD Graphs (traffic only) with the 3/17 build. I just upgraded to the 3/20 build, and the same issue is happening.
Everytime I go to the RRD Graphs for Traffic, the system log gets filled up with the following errors:
Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-4year.png --start 1174193867 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - WAN :: Traffic - 4 years - 1 day average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8,*" CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8,*" CDEF:"wan-in_bits_block=wan-in_bytes_block,8,*" CDEF:"wan-out_bits_block=wan-out_bytes_block,8,*" CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_block,+" CDEF:"wan-in_bits=wan-in_ Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/ipsec-traffic.rrd-year.png --start 1269061067 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - IPsec :: Traffic - 1 year - 1 day average" --height 200 --width 620 DEF:ipsec-in_bytes_pass=/var/db/rrd/ipsec-traffic.rrd:inpass:AVERAGE DEF:ipsec-out_bytes_pass=/var/db/rrd/ipsec-traffic.rrd:outpass:AVERAGE DEF:ipsec-in_bytes_block=/var/db/rrd/ipsec-traffic.rrd:inblock:AVERAGE DEF:ipsec-out_bytes_block=/var/db/rrd/ipsec-traffic.rrd:outblock:AVERAGE CDEF:"ipsec-in_bits_pass=ipsec-in_bytes_pass,8,*" CDEF:"ipsec-out_bits_pass=ipsec-out_bytes_pass,8,*" CDEF:"ipsec-in_bits_block=ipsec-in_bytes_block,8,*" CDEF:"ipsec-out_bits_block=ipsec-out_bytes_block,8,*" CDEF:"ipsec-in_bytes=ipsec-in_bytes_pass,ipsec-in_bytes_block,+" CDEF:"ipsec-out_bytes=ipsec-out_bytes_pass,ipse Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/lan-traffic.rrd-year.png --start 1269061067 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - LAN :: Traffic - 1 year - 1 day average" --height 200 --width 620 DEF:lan-in_bytes_pass=/var/db/rrd/lan-traffic.rrd:inpass:AVERAGE DEF:lan-out_bytes_pass=/var/db/rrd/lan-traffic.rrd:outpass:AVERAGE DEF:lan-in_bytes_block=/var/db/rrd/lan-traffic.rrd:inblock:AVERAGE DEF:lan-out_bytes_block=/var/db/rrd/lan-traffic.rrd:outblock:AVERAGE CDEF:"lan-in_bits_pass=lan-in_bytes_pass,8,*" CDEF:"lan-out_bits_pass=lan-out_bytes_pass,8,*" CDEF:"lan-in_bits_block=lan-in_bytes_block,8,*" CDEF:"lan-out_bits_block=lan-out_bytes_block,8,*" CDEF:"lan-in_bytes=lan-in_bytes_pass,lan-in_bytes_block,+" CDEF:"lan-out_bytes=lan-out_bytes_pass,lan-out_bytes_block,+" CDEF:"lan-in_bits=lan-in_bi Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/opt1-traffic.rrd-week.png --start 1300078667 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - WAN2 :: Traffic - 1 week - 1 hour average" --height 200 --width 620 DEF:opt1-in_bytes_pass=/var/db/rrd/opt1-traffic.rrd:inpass:AVERAGE DEF:opt1-out_bytes_pass=/var/db/rrd/opt1-traffic.rrd:outpass:AVERAGE DEF:opt1-in_bytes_block=/var/db/rrd/opt1-traffic.rrd:inblock:AVERAGE DEF:opt1-out_bytes_block=/var/db/rrd/opt1-traffic.rrd:outblock:AVERAGE CDEF:"opt1-in_bits_pass=opt1-in_bytes_pass,8,*" CDEF:"opt1-out_bits_pass=opt1-out_bytes_pass,8,*" CDEF:"opt1-in_bits_block=opt1-in_bytes_block,8,*" CDEF:"opt1-out_bits_block=opt1-out_bytes_block,8,*" CDEF:"opt1-in_bytes=opt1-in_bytes_pass,opt1-in_bytes_block,+" CDEF:"opt1-out_bytes=opt1-out_bytes_pass,opt1-out_bytes_block,+" CD Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/lan-traffic.rrd-week.png --start 1300078667 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - LAN :: Traffic - 1 week - 1 hour average" --height 200 --width 620 DEF:lan-in_bytes_pass=/var/db/rrd/lan-traffic.rrd:inpass:AVERAGE DEF:lan-out_bytes_pass=/var/db/rrd/lan-traffic.rrd:outpass:AVERAGE DEF:lan-in_bytes_block=/var/db/rrd/lan-traffic.rrd:inblock:AVERAGE DEF:lan-out_bytes_block=/var/db/rrd/lan-traffic.rrd:outblock:AVERAGE CDEF:"lan-in_bits_pass=lan-in_bytes_pass,8,*" CDEF:"lan-out_bits_pass=lan-out_bytes_pass,8,*" CDEF:"lan-in_bits_block=lan-in_bytes_block,8,*" CDEF:"lan-out_bits_block=lan-out_bytes_block,8,*" CDEF:"lan-in_bytes=lan-in_bytes_pass,lan-in_bytes_block,+" CDEF:"lan-out_bytes=lan-out_bytes_pass,lan-out_bytes_block,+" CDEF:"lan-in_bits=lan-in_b Mar 20 23:57:49 php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/opt1-traffic.rrd-year.png --start 1269061067 --end 1300683467 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - WAN2 :: Traffic - 1 year - 1 day average" --height 200 --width 620 DEF:opt1-in_bytes_pass=/var/db/rrd/opt1-traffic.rrd:inpass:AVERAGE DEF:opt1-out_bytes_pass=/var/db/rrd/opt1-traffic.rrd:outpass:AVERAGE DEF:opt1-in_bytes_block=/var/db/rrd/opt1-traffic.rrd:inblock:AVERAGE DEF:opt1-out_bytes_block=/var/db/rrd/opt1-traffic.rrd:outblock:AVERAGE CDEF:"opt1-in_bits_pass=opt1-in_bytes_pass,8,*" CDEF:"opt1-out_bits_pass=opt1-out_bytes_pass,8,*" CDEF:"opt1-in_bits_block=opt1-in_bytes_block,8,*" CDEF:"opt1-out_bits_block=opt1-out_bytes_block,8,*" CDEF:"opt1-in_bytes=opt1-in_bytes_pass,opt1-in_bytes_block,+" CDEF:"opt1-out_bytes=opt1-out_bytes_pass,opt1-out_bytes_block,+" CDE
-
I am seeing the same problem on the 22/03/11 build 32bit as well. Seems to of happened when the 95th percentile was committed to the snapshots.
-
I had the same issue.
today I logged into my firewall and deleted the rrd files /var/db/rrd/ (careful not to delete the updaterrd.sh script in there).
The result of that was I lost all of my historic data. On the plus side my graphs started working again.
Hope this helps.
-
Although a fix I would rather not loose old data.
-
-
Same problem here.. rdd graphs fail to work. System logs show :
php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Could not parse color in ''/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/wan-traffic.rrd-quarter.png --start 1293383835 --end 1301419035 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - WAN :: Traffic - 3 months - 1 day average" --height 200 --width 620 DEF:wan-in_bytes_pass=/var/db/rrd/wan-traffic.rrd:inpass:AVERAGE DEF:wan-out_bytes_pass=/var/db/rrd/wan-traffic.rrd:outpass:AVERAGE DEF:wan-in_bytes_block=/var/db/rrd/wan-traffic.rrd:inblock:AVERAGE DEF:wan-out_bytes_block=/var/db/rrd/wan-traffic.rrd:outblock:AVERAGE CDEF:"wan-in_bits_pass=wan-in_bytes_pass,8,*" CDEF:"wan-out_bits_pass=wan-out_bytes_pass,8,*" CDEF:"wan-in_bits_block=wan-in_bytes_block,8,*" CDEF:"wan-out_bits_block=wan-out_bytes_block,8,*" CDEF:"wan-in_bytes=wan-in_bytes_pass,wan-in_bytes_block,+" CDEF:"wan-out_bytes=wan-out_bytes_pass,wan-out_bytes_block,+" CDEF:"wan-in_bits=wan-
Since I don't really care about the data.. I did try deleting all the files in the /var/db/rrd folder except for the .sh file.. and after trying to access rrd I get the same error again (see above)
-
Does any of the Devs have an idea on this one.
-
Check which theme you are using and then add the missing color to 'usr\local\www\themes<your theme="">\rrdcolors.inc.php'
$colortraffic95 = array("660000", "FF0000"); ```</your>
-
I don't think that helped; is there something I'm missing?
-
Cool thanks that did the trick.
-
Thanks, that got me all fixed up. =)
-
Most of those should be fixed in new snapshots, but I did find a couple issues with theme colors (in the corporate and nervecenter themes).
https://rcs.pfsense.org/projects/pfsense/repos/mainline/commits/0ef48aed8b6b9098c924229f725e12b3f7ec7013