Unable to export to csv certain graphs

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
xminos
Cacti User
Posts: 63
Joined: Wed Apr 26, 2006 8:10 am

Unable to export to csv certain graphs

Post by xminos »

I have a problem with a specific kind of graph. This used to work before we upgraded to the latest and great version of cacti. Cacti specific information found below.

For the most part export to csv works fine. However on this specific graph template it never works. It will always return no data. The is obviously data so I can't figure out what the problem is. I tried to re-create the graph assuming maybe it was due to this graph was created on an older version of cacti but even the brand new graph using this template fails to export properly.

Image

When exported this is what I get:
Image


Suggestions of things to check/do?

Tech support data here:

Code: Select all

Technical Support
General Information
Date 	Tue, 29 Mar 2011 07:58:22 -0700
Cacti Version 	0.8.7g
Cacti OS 	unix
SNMP Version 	NET-SNMP version: 5.3.2.2
RRDTool Version 	RRDTool 1.2.x
Hosts 	1295
Graphs 	17100
Data Sources 	Script/Command: 1774
SNMP: 5961
SNMP Query: 13909
Script Query: 79
Script - Script Server (PHP): 4
Script Query - Script Server: 489
Total: 22216
Poller Information
Interval 	300
Type 	spine
Items 	Action[0]: 30546
Action[1]: 1879
Action[2]: 962
Total: 33387
Concurrent Processes 	5
Max Threads 	60
PHP Servers 	5
Script Timeout 	298
Max OID 	60
Last Run Statistics 	Time:139.5188 Method:spine Processes:5 Threads:60 Hosts:1293 HostsPerProcess:259 DataSources:33387 RRDsProcessed:22110
PHP Information
PHP Version 	5.1.6
PHP OS 	Linux
PHP uname 	Linux hostname-1 2.6.18-194.8.1.el5 #1 SMP Thu Jul 1 19:04:48 EDT 2010 x86_64
PHP SNMP 	Installed
max_execution_time 	120
memory_limit 	512M
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Unable to export to csv certain graphs

Post by gandalf »

Please select the wrench next to that graph and post the whole rrdtool statement
R.
xminos
Cacti User
Posts: 63
Joined: Wed Apr 26, 2006 8:10 am

Re: Unable to export to csv certain graphs

Post by xminos »

gandalf wrote:Please select the wrench next to that graph and post the whole rrdtool statement
R.
My apologies for the delayed response.

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='<removed> - IP mapping' \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label= \
--slope-mode \
--font TITLE:8: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/san1/www/html/cacti/rra/removed_sdv-pts-1_current_subs_32006.rrd":Current_Subs:AVERAGE \
DEF:b="/san1/www/html/cacti/rra/removed_sdv-pts-1_mapped_ips_32007.rrd":Mapped_IPs:AVERAGE \
DEF:c="/san1/www/html/cacti/rra/removed_sdv-pts-1_unmapped_ips_32008.rrd":UnMapped_IPs:AVERAGE \
LINE2:a#7EE600FF:"Total Active \n" \
GPRINT:a:LAST:"Current\:%8.2lf %s" \
GPRINT:a:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:a:MAX:"Max\:%8.2lf %s\n" \
LINE2:b#4444FFFF:"IPs Mapped \n" \
GPRINT:b:LAST:"Current\:%8.2lf %s" \
GPRINT:b:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:b:MAX:"Max\:%8.2lf %s\n" \
LINE2:c#FF0000FF:"IPs UnMapped \n" \
GPRINT:c:LAST:"Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:c:MAX:"Max\:%8.2lf %s\n"
noname
Cacti Guru User
Posts: 1566
Joined: Thu Aug 05, 2010 2:04 am
Location: Japan

Re: Unable to export to csv certain graphs

Post by noname »

xminos wrote:RRDTool Version RRDTool 1.2.x
FYI:
- http://forums.cacti.net/viewtopic.php?f=21&t=30810
- http://forums.cacti.net/viewtopic.php?f=21&t=32029

In summary,
1.2.29 NG --> 1.2.27 OK (downgraded)
1.3.6 NG --> 1.3.7 OK (upgraded)
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests