[SOLVED] RRD Graph problem since the 3/17/11 build.

[geeknik]

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

[Jonb]

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.

[loddington]

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.

[Jonb]

Although a fix I would rather not loose old data.

[geeknik]

@Jonb:

Although a fix I would rather not loose old data.

Yeah, I'm kind of partial to my data. =)

[AudiAddict]

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)

[Jonb]

Does any of the Devs have an idea on this one.

[bardelot]

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>

[mentalhemroids]

I don't think that helped; is there something I'm missing?

[Jonb]

Cool thanks that did the trick.

[geeknik]

Thanks, that got me all fixed up. =)

[jimp]

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