No Graphs or RRD files

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

marciab
Posts: 16
Joined: Fri Jan 04, 2008 4:25 pm
Location: Oregon

No Graphs or RRD files

Post by marciab »

I just installed Cacti 8.7 on a windows server 2003 and am not getting any graphs to show. No rrd files are being produced. I have checked permissions and followed all the troubleshooting I can find on your site. So here is what I have:

OS: Windows Server 2003
WebServer: IIS 6
Cactid: N/A
MySQL: 5.0
PHP: 5
RRDTool: 1.2 win-32 -perl58
Net-SNMP
Cygwin-N/A

LOG:
12/28/2007 02:03:29 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"

When I run the "Graph Debugging" RRDTool Says: ERROR: invalid text property format

Please, any help will be appreciated.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

You running cacti 0.8.7 or 0.8.7a? If not 0.8.7a, you need to upgrade to it. Also need to install the patches for it; documentation on the main cacti site.

What rrdtool version do you have specified in cacti's settings?
What specific version of rrdtool do you have?
marciab
Posts: 16
Joined: Fri Jan 04, 2008 4:25 pm
Location: Oregon

no graphs or RRD

Post by marciab »

In the directions for upgrading, it doesnt say where to extract the tar files.
Do I extract them to C:\Inetpub\wwwroot\cacti
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: no graphs or RRD

Post by BSOD2600 »

marciab wrote:In the directions for upgrading, it doesnt say where to extract the tar files.
Do I extract them to C:\Inetpub\wwwroot\cacti
You can extract them anywhere you want. But eventually they need to be moved to the \cacti\ folder. Good idea to backup your cacti installation before you upgrade.
marciab
Posts: 16
Joined: Fri Jan 04, 2008 4:25 pm
Location: Oregon

Post by marciab »

Do I extract all of the files into the cacti root? It seems like there are alot more files.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

yes
Coloprovider
Posts: 6
Joined: Sun Oct 15, 2006 5:34 am

Post by Coloprovider »

I have exactly the same error but then on a CentOS 5 installation.
Everythis is working, but not the graphs. (allso applied the patches)

RRDtool:
ERROR: invalid text property format

Version:
RRDtool 1.2.9

Allso specified 1.2.x

Hope there are any solutions
Coloprovider
Posts: 6
Joined: Sun Oct 15, 2006 5:34 am

Post by Coloprovider »

Update:
An update to rrdtool 1.2.26 has solved the problem
marciab
Posts: 16
Joined: Fri Jan 04, 2008 4:25 pm
Location: Oregon

Post by marciab »

Where did you get the RRDTool 1.2.26? When I try to unzip the one I found, I get an error.
marciab
Posts: 16
Joined: Fri Jan 04, 2008 4:25 pm
Location: Oregon

Post by marciab »

I upgraded to 8.7a and still have the same error. For the updates, can I just copy and paste them or do I have to run the commands?
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

you mean patching cacti 0.8.7a? You can either download the pre-patched files or manually patch them yourself. The instructions are in my installation guide.
hejohnson3
Posts: 2
Joined: Tue Jan 15, 2008 1:37 pm

Post by hejohnson3 »

Operating System: Windows Server 2003 Standard Edition
Webserver: IIS 6.0
Cacti: 8.7a
Cactid: N/A
MySQL: 5.0.45 Win32
PHP: 5.2.5 Win32
RRDTool: 1.2.15 Win32-perl58
Net-SNMP: 5.4.1-3 Win32
Cygwin: N/A

I am also having the same problem and after turning on the graph debug:

RRDTool Command:

c:/rrdtool/rrdtool/release/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="localhost - Traffic" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
CDEF:cdefa=a,8,* \
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:cdefa#002A97FF:"Outbound" \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s"

RRDTool Says:

ERROR: invalid rpn expression in: a,8,*
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

hejohnson3: Same questions apply to you as the other posters. Have you patched cacti yet?
hejohnson3
Posts: 2
Joined: Tue Jan 15, 2008 1:37 pm

Post by hejohnson3 »

BSOD2600 wrote:hejohnson3: Same questions apply to you as the other posters. Have you patched cacti yet?
Yes. I downloaded the pre-patched (cmd.php and functions.php) and replaced the files.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Did you edit your graph templates or something? That graph expression is missing the DEF fields, which tell rrdtool the rrd file to get the data from.

Try deleting and recreating the graph.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests