[RESOLVED] RRD files are not being created on gigabit switch

[iggi]

I have checked, snmpget returns a value, no errors in cacti.log, I own the rrd directory, rrd files created and updated with my old Cisco catalyst 2900 but not with my new Linksys SGE2000. Trying to figure out why it will not update as this install worked with my previous switch.

[iggi]

when I run debug on data sources I get:

/usr/local/rrdtool-1.2.27/bin/rrdtool create \
/usr/local/apache/htdocs/cacti/rra/testsw_traffic_in_119.rrd \
--step 300 \
DS:traffic_in:DERIVE:600:0:100000000 \
DS:traffic_out:DERIVE:600:0:100000000 \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

I run the command manually and it makes a file but graph has all nan's

[iggi]

I ran "php -q cmd.php 114" and the script returns -1. Not sure if this helps, not quite sure what it means to me.

[iggi]

fresh install on windows machine and getting same problem (no rrd files being created)

[iggi]

I checked and the files for other hosts are being created through RRDtool correctly. I also check and the switch can be pulled using PRTG, so this seems to be an issue with cacti poller and the switch.

[iggi]

Any ideas? Im trying to give all of the information I can, I really at the point I can no longer afford to use cacti (3 different switches 2 different models, no graph) even though I would love to contine because it has not done me wrong yet. Help is much appreciated

[iggi]

quote from error log:

11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g20' where host_id='16' and data_query_id='1' and arg1='$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.r$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g21=g21' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g21' where host_id='16' and data_query_id='1' and arg1='$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g22=g22' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g22' where host_id='16' and data_query_id='1' and arg1='$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g23=g23' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g23' where host_id='16' and data_query_id='1' and arg1='$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g24=g24' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g24' where host_id='16' and data_query_id='1' and arg1='$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g3=g3' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g3' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g4=g4' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g4' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g5=g5' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g5' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] ASSERT: '= g6=g6' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g6' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] ASSERT: '= g7=g7' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g7' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] ASSERT: '= g8=g8' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g8' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] ASSERT: '= g9=g9' failed. Recaching host '208.13.144.10', data query #1
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '16:1')"
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='g9' where host_id='16' and data_query_id='1' and arg1='.$
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] Host[16] DS[120] SNMP: v2: 208.13.144.10, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 1906771352
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (120, 'traffic_in', '20$
11/19/2008 09:22:07 PM - CMDPHP: Poller[0] Host[16] DS[120] SNMP: v2: 208.13.144.10, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 2604264813


Seems like cacti doesnt like the = signs every where, somehow cacti put those in there though.

[iggi]

removed = signs from data sources and now I get the non-unicast packets graph (small steps!) but the other graph of bandwdith still isnt working.

edit: bandwidth graph now showing up, but with nan's (woot small steps)

[iggi]

Well graphing now! all I did was run php -q 16(hostid) 117 (graph id) and that jumpstarted it for some reason.

Well thanks for listening to me talk to myself... atleast its well documented for the rest.