[SOLVED] Graphs not being made, getting red crosses ?

[defiancenl]

Hi all im having trouble getting graphs to be generated

Im using :
rrdtool-1.2.9
cacti-0.8.7b

Im trying to read out my switch, i can see the switch is sending the snmp info to the server, ia i can see a response :

Code: Select all

SNMP Information
System: DGS-1224T 4.10.02
Uptime: 2678930 (0 days, 7 hours, 26 minutes)
Hostname: core1.thuis.lan
Location: Rack1
Contact: 

Code: Select all

Associated Data Queries 
 
Data Query Name Debugging Re-Index Method Status 
1) SNMP - Interface Statistics  (Verbose Query)  Uptime Goes Backwards  Success [151 Items, 25 Rows]  

So when i try to generate data im getting a rrdtool error, but i cant figure out whats wrong, perhaps anyone here can shed some light on it.

the error :

Code: Select all

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="D-Link DGS-1224T Rev D1 - Traffic - GbE_18/18" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/switch1_traffic_in_35.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/cacti/rra/switch1_traffic_in_35.rrd":traffic_out:AVERAGE \
AREA:a#00CF00FF:"Inbound"  \
GPRINT:a:LAST:" Current\:%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:a:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total In\:  0 bytes\n"  \
LINE1:b#002A97FF:"Outbound"  \
GPRINT:b:LAST:"Current\:%8.2lf %s"  \
GPRINT:b:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:b:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total Out\: 0 bytes" 
RRDTool Says:

ERROR: invalid text property format

Thnx in advance

ok i did a manual run of poller.php, now i get empty graphs instead of crosses
what would be the best way to add the poller.php in the cron ?

[gandalf]

Please upgrade rrdtool. I just copied your command to my laptop and it runs well (including my data sources instead of yours)
Reinhard

[defiancenl]

thnx for your response,
i wasnt aware i had an outdated version ,
the NL ftp makes it seem as if the version i was using was the latest.
anyway i updated rrdtool to 1.2.23 and now i get another error

Code: Select all

/usr/local/rrdtool-1.2.23/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="D-Link DGS-1224T Rev D1 - Traffic - GbE_18/18" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/var/www/html/cacti/rra/switch1_traffic_in_35.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/cacti/rra/switch1_traffic_in_35.rrd":traffic_out:AVERAGE \
AREA:a#00CF00FF:"Inbound"  \
GPRINT:a:LAST:" Current\:%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:a:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total In\:  0 bytes\n"  \
LINE1:b#002A97FF:"Outbound"  \
GPRINT:b:LAST:"Current\:%8.2lf %s"  \
GPRINT:b:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:b:MAX:"Maximum\:%8.2lf %s"  \
COMMENT:"Total Out\: 0 bytes" 
RRDTool Says:

ERROR: opening '/var/www/html/cacti/rra/switch1_traffic_in_35.rrd': No such file or directory

and yes /rra is empty

[gandalf]

Your poller is running via crontab? Is there any entry in ./log/cacti.log?
Reinhard

[defiancenl]

uhmmm

my poller running via crontab ?
i wasnt aware i should set up the poller via cron ? i was under the impression that cacti did this by itself

cacti log

Code: Select all

02/17/2008 05:26:19 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')"

[defiancenl]

when i manually run

Code: Select all

/usr/bin/php -q /var/www/html/cacti/cmd.php

and then

Code: Select all

/usr/bin/php -q /var/www/html/cacti/cmd.php
02/17/2008 10:06:42 PM - CMDPHP: Poller[0] Host[5] DS[28] SNMP: v1: core1.thuis.lan, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.11, output: 0
02/17/2008 10:06:42 PM - CMDPHP: Poller[0] Host[5] DS[28] SNMP: v1: core1.thuis.lan, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.11, output: 0
02/17/2008 10:06:42 PM - CMDPHP: Poller[0] Time: 0.2965 s, Theads: N/A, Hosts: 1

Code: Select all

 /usr/bin/php /var/www/html/cacti/cmd.php
Content-type: text/html
X-Powered-By: PHP/4.3.11

02/17/2008 10:33:41 PM - CMDPHP: Poller[0] Host[5] DS[30] SNMP: v1: core1.thuis.lan, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.13, output: 0
02/17/2008 10:33:41 PM - CMDPHP: Poller[0] Host[5] DS[30] SNMP: v1: core1.thuis.lan, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.13, output: 0
02/17/2008 10:33:41 PM - CMDPHP: Poller[0] Host[5] DS[60] SNMP: v1: core1.thuis.lan, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.17, output: 976294
02/17/2008 10:33:41 PM - CMDPHP: Poller[0] Host[5] DS[60] SNMP: v1: core1.thuis.lan, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.17, output: 151169
02/17/2008 10:33:41 PM - CMDPHP: Poller[0] Time: 0.9047 s, Theads: N/A, Hosts: 1

i get empty graphs .. at least its something lol !
anyway, howcome the graphs are empty, and how would i go about putting poller in crontab

[defiancenl]

Fixed - Graphs are showing up now, thnx for the support m8
(never reading somewhere that poller.php should be set up via cron kinda caused the entire problem)

[SoftDux]

Would you mind telling me how you got the D-Link DGS-1224T working with Cacti?

[mlum]

Would you mind telling me how you got the D-Link DGS-1224T working with Cacti?

Which version of switch (see link below) and firmware are you using? You may want to upgrade your firmware.

http://www.dlink.com/products/support.asp?pid=329&sec=0

I assume you are able to log into the switch.

[mlum]

Use SNMP v1.

I have two of these DGS-1224T's and even after upgrading the firmware on one, I still couldn't get any Interface Stats.

However, change the SNMP version to 1 and you should get 25 rows of data (24 ports and 1 VLAN)

mlum