Cacti doesn't generate graphic for extreme switch in stack

[rogermurao]

My Cacti is working fine.
I use the Cacti 0.8.7b and rrdtool rrdtool-1.2.28-bin-w32.

I have many extreme switches 450X and the graphs are right, but I installed 4 extreme switches 450X in stack and added the graphs on the Cacti, but the graphs doesn't work.
The management of the stack switch it's ok.

I use the software Getif and the graphs are rights.

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Switch - BRCTADC204 - Traffic - |query_ifName|" \
--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: \
DEF:a="C\:/wamp/www/cacti/rra/switch_-_brctadc204_traffic_in_2646.rrd":traffic_in:AVERAGE \
DEF:b="C\:/wamp/www/cacti/rra/switch_-_brctadc204_traffic_in_2646.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,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:cdefe#002A97FF:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"
RRDTool Says:

ERROR: opening 'C:/wamp/www/cacti/rra/switch_-_brctadc204_traffic_in_2646.rrd': No such file or directory

[BSOD2600]

I strongly suggest you use rrdtool 1.2.26 WIN32. .28 has bugs.

You should also read http://forums.cacti.net/viewtopic.php?t=11747 on how to troubleshoot this issue.

[rogermurao]

I did a downgrade to rrdtool 1.2.26 WIN32 version. But the problem remains.

I read the documentation that you recommended. I will do others tests.

[rogermurao]

Hi,

I created a new graph with SNMP - Generic OID Template and the Cacti got to create the rrd file.

But when I use the SNMP - Interface Statistics for generate the graphs. The Cacti doesn't create the rrd files.

[BSOD2600]

But when I use the SNMP - Interface Statistics for generate the graphs. The Cacti doesn't create the rrd files.

Does verbose query of the ' SNMP - Interface Statistics ' return data? Post it here.

Did you follow the link I posted? what are the errors in the cacti.log?

[rogermurao]

When I click in "Verbose Query" the internet explorer page doesn't any data. It follows below the screen attached.


Associated Data Queries

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



SNMP cache log

Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1004 , Field Name: ifAlias , Field Value:
OID: .1.3.6.1.2.1.31.1.1.1.18.1004
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1003 , Field Name: ifAlias , Field Value:
OID: .1.3.6.1.2.1.31.1.1.1.18.1003
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1001 , Field Name: ifAlias , Field Value:
OID: .1.3.6.1.2.1.31.1.1.1.18.1001
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000 , Field Name: ifAlias , Field Value: MgmtPort
OID: .1.3.6.1.2.1.31.1.1.1.18.1000
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1007 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1007
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1006 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1006
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000016 , Field Name: ifName , Field Value: NET_EBT
OID: .1.3.6.1.2.1.31.1.1.1.1.1000016
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1005 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1005
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1004 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1004
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1003 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1003
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1002 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1002
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000017 , Field Name: ifIndex , Field Value: 1000017
OID: .1.3.6.1.2.1.2.2.1.1.1000017
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1001 , Field Name: ifOperStatus , Field Value: Up
OID: .1.3.6.1.2.1.2.2.1.8.1001
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000 , Field Name: ifOperStatus , Field Value: Down
OID: .1.3.6.1.2.1.2.2.1.8.1000
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000019 , Field Name: ifIndex , Field Value: 1000019
OID: .1.3.6.1.2.1.2.2.1.1.1000019
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000019 , Field Name: ifName , Field Value: rtif(10.128.1.3/24)
OID: .1.3.6.1.2.1.31.1.1.1.1.1000019
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000015 , Field Name: ifIndex , Field Value: 1000015
OID: .1.3.6.1.2.1.2.2.1.1.1000015
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000016 , Field Name: ifIndex , Field Value: 1000016
OID: .1.3.6.1.2.1.2.2.1.1.1000016
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000017 , Field Name: ifName , Field Value: GERENCIA
OID: .1.3.6.1.2.1.31.1.1.1.1.1000017
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000014 , Field Name: ifIndex , Field Value: 1000014
OID: .1.3.6.1.2.1.2.2.1.1.1000014
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000012 , Field Name: ifIndex , Field Value: 1000012
OID: .1.3.6.1.2.1.2.2.1.1.1000012
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000013 , Field Name: ifIndex , Field Value: 1000013
OID: .1.3.6.1.2.1.2.2.1.1.1000013
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000011 , Field Name: ifIndex , Field Value: 1000011
OID: .1.3.6.1.2.1.2.2.1.1.1000011
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000010 , Field Name: ifIndex , Field Value: 1000010
OID: .1.3.6.1.2.1.2.2.1.1.1000010
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000005 , Field Name: ifIndex , Field Value: 1000005
OID: .1.3.6.1.2.1.2.2.1.1.1000005
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000004 , Field Name: ifIndex , Field Value: 1000004
OID: .1.3.6.1.2.1.2.2.1.1.1000004
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000003 , Field Name: ifIndex , Field Value: 1000003
OID: .1.3.6.1.2.1.2.2.1.1.1000003
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000002 , Field Name: ifIndex , Field Value: 1000002
OID: .1.3.6.1.2.1.2.2.1.1.1000002
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000001 , Field Name: ifIndex , Field Value: 1000001
OID: .1.3.6.1.2.1.2.2.1.1.1000001
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5049 , Field Name: ifIndex , Field Value: 5049
OID: .1.3.6.1.2.1.2.2.1.1.5049
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5048 , Field Name: ifIndex , Field Value: 5048
OID: .1.3.6.1.2.1.2.2.1.1.5048
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5050 , Field Name: ifIndex , Field Value: 5050
OID: .1.3.6.1.2.1.2.2.1.1.5050
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1002 , Field Name: ifAlias , Field Value:
OID: .1.3.6.1.2.1.31.1.1.1.18.1002
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000015 , Field Name: ifName , Field Value: NET_BRT
OID: .1.3.6.1.2.1.31.1.1.1.1.1000015
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000014 , Field Name: ifName , Field Value: rtif(128.1.1.100/16)
OID: .1.3.6.1.2.1.31.1.1.1.1.1000014
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000013 , Field Name: ifName , Field Value: DMZ
OID: .1.3.6.1.2.1.31.1.1.1.1.1000013
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000012 , Field Name: ifName , Field Value: BKP
OID: .1.3.6.1.2.1.31.1.1.1.1.1000012
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000011 , Field Name: ifName , Field Value: JDE
OID: .1.3.6.1.2.1.31.1.1.1.1.1000011
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000010 , Field Name: ifName , Field Value: VMOTION
OID: .1.3.6.1.2.1.31.1.1.1.1.1000010
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000005 , Field Name: ifName , Field Value: Mgmt
OID: .1.3.6.1.2.1.31.1.1.1.1.1000005
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000004 , Field Name: ifName , Field Value: Default
OID: .1.3.6.1.2.1.31.1.1.1.1.1000004
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000003 , Field Name: ifName , Field Value: VirtualRouter1
OID: .1.3.6.1.2.1.31.1.1.1.1.1000003
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000002 , Field Name: ifName , Field Value: VirtualRouter2
OID: .1.3.6.1.2.1.31.1.1.1.1.1000002
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000019 , Field Name: ifDescr , Field Value: rtif(10.128.1.3/24)
OID: .1.3.6.1.2.1.2.2.1.2.1000019
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000017 , Field Name: ifDescr , Field Value: VLAN 00100 (GERENCIA)
OID: .1.3.6.1.2.1.2.2.1.2.1000017
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5045 , Field Name: ifIndex , Field Value: 5045
OID: .1.3.6.1.2.1.2.2.1.1.5045
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5047 , Field Name: ifIndex , Field Value: 5047
OID: .1.3.6.1.2.1.2.2.1.1.5047
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5046 , Field Name: ifIndex , Field Value: 5046
OID: .1.3.6.1.2.1.2.2.1.1.5046
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000016 , Field Name: ifDescr , Field Value: VLAN 04088 (NET_EBT)
OID: .1.3.6.1.2.1.2.2.1.2.1000016
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000015 , Field Name: ifDescr , Field Value: VLAN 04089 (NET_BRT)
OID: .1.3.6.1.2.1.2.2.1.2.1000015
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 5044 , Field Name: ifIndex , Field Value: 5044
OID: .1.3.6.1.2.1.2.2.1.1.5044
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000014 , Field Name: ifDescr , Field Value: rtif(128.1.1.100/16)
OID: .1.3.6.1.2.1.2.2.1.2.1000014
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000013 , Field Name: ifDescr , Field Value: VLAN 04090 (DMZ)
OID: .1.3.6.1.2.1.2.2.1.2.1000013
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000012 , Field Name: ifDescr , Field Value: VLAN 04091 (BKP)
OID: .1.3.6.1.2.1.2.2.1.2.1000012
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000011 , Field Name: ifDescr , Field Value: VLAN 00099 (JDE)
OID: .1.3.6.1.2.1.2.2.1.2.1000011
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000010 , Field Name: ifDescr , Field Value: VLAN 04093 (VMOTION)
OID: .1.3.6.1.2.1.2.2.1.2.1000010
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000005 , Field Name: ifDescr , Field Value: VLAN 04095 (Mgmt)
OID: .1.3.6.1.2.1.2.2.1.2.1000005
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000004 , Field Name: ifDescr , Field Value: VLAN 00001 (Default)
OID: .1.3.6.1.2.1.2.2.1.2.1000004
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000003 , Field Name: ifDescr , Field Value: VirtualRouter1
OID: .1.3.6.1.2.1.2.2.1.2.1000003
Host: Switch - BRCTADC204 , SNMP Query: SNMP - Interface Statistics
Index: 1000002 , Field Name: ifDescr , Field Value: VirtualRouter2
OID: .1.3.6.1.2.1.2.2.1.2.1000002


Poller cache log

Switch - BRCTADC204 - SNMP Version: 2, Community: 57e74n1n1, OID: 1.3.6.1.2.1.2.2.1.10.1001
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_snmp_oid_2660.rrd
Switch - BRCTADC204 - CPU Usage - Nice SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.11.51.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_cpu_nice_2661.rrd
Switch - BRCTADC204 - CPU Usage - System SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.11.52.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_cpu_system_2662.rrd
Switch - BRCTADC204 - CPU Usage - User SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.11.50.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_cpu_user_2663.rrd
Switch - BRCTADC204 - Memory - Buffers SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.4.14.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_mem_buffers_2664.rrd
Switch - BRCTADC204 - Memory - Cache SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.4.15.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_mem_cache_2665.rrd
Switch - BRCTADC204 - Memory - Free SNMP Version: 2, Community: 57e74n1n1, OID: .1.3.6.1.4.1.2021.4.6.0
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_mem_free_2666.rrd
Switch - BRCTADC204 - Ping Host Script: perl C:/wamp/www/cacti/scripts/ping.pl 128.1.1.100
RRD: C:\wamp\www\cacti\rra\switch_-_brctadc204_ping_2625.rrd

Technical Support
Technical Support

General Information
Date Mon, 19 Jan 2009 15:57:59 -0200
Cacti Version 0.8.7b
Cacti OS win32
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Hosts 197
Graphs 749
Data Sources Script/Command: 149
SNMP: 49
SNMP Query: 615
Total: 813
Poller Information
Interval 300
Type cmd.php
Items Action[0]: 1661
Action[1]: 146
Total: 1807
Concurrent Processes 30
Max Threads 30
PHP Servers 7
Script Timeout 30
Max OID 30
Last Run Statistics Time:23.1900 Method:cmd.php Processes:30 Threads:N/A Hosts:191 HostsPerProcess:7 DataSources:1807 RRDsProcessed:738
PHP Information
PHP Version 5.2.6
PHP OS WINNT
PHP uname Windows NT BRGABS091 5.2 build 3790
PHP SNMP Installed
max_execution_time 30
memory_limit 128M


Cacti log

01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('remove_verification', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_retries', '3')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_port', '161')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_timeout', '500')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_priv_protocol', 'DES')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_priv_passphrase', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_auth_protocol', 'MD5')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_password', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_username', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_community', '57e74n1n1#3lux')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_ver', '2')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('rrdtool_version', 'rrd-1.2.x')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('snmp_version', 'net-snmp')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_perror', 'on')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_pwarn', 'on')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_pstats', 'on')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_verbosity', '2')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_export', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_graph', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_snmp', '')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('log_destination', '2')"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
01/19/2009 04:00:19 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"

[BSOD2600]

Ah, that switch has a ton of interfaces which is why the verbose query doesn't do anything. You need to increase the timeout values in php.ini -- then iisreset.

Have you followed the debugging guide yet?

[rogermurao]

It below the content of the cacti.log

01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2660] WARNING: Result from SNMP not valid. Partial Result: No Such Instance cur
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2665] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2663] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2662] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2661] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2666] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
01/19/2009 05:32:03 PM - CMDPHP: Poller[0] Host[388] DS[2664] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail


I will check on the debbuging documentation.

Thanks a lot.

[BSOD2600]

Is Host[388] the switch in question? That name is clickable from the cacti log viewer.

Click the links for DS[2665], etc. What are they for? Do you see that DS in the snmp/poller cache for that device? What are the OIDs? When you snmpwalk those OIDs, do they work? Post the output.

[rogermurao]

In the cacti log doesn't exist any for the 2672, 2674 and 2671 IDs.

[BSOD2600]

Alright so back to the original problem... traffic graphs still not working for that switch? Tried to delete the data sources/graphs for it and re-creating?

The fact those errors don't repeat in the cacti log means they're intermittent.

[rogermurao]

I deleted the data source and re-created the graphs. Ow God, the problem remains.

The cacti canot create the graphs.

[BSOD2600]

*sigh* you're manually creating these graphs, which is the WRONG way to do it.

Delete them again and the associated data sources.

Go to devices, click on the switch. Top right corner, click on 'create graphs for device'. On the following page, click the various interfaces you want to create graphs for. Bottom of the page, click create. Wait 10 min and then check the graphs.

[rogermurao]

Oh no! I did exactly that you recommended. I didn't create the graphs manually.

The images debugmode.JPG and Datasourcedebug.JPG I generated after I created the graphs. I perfomed the debug mode for you see it that the Cacti doesn't generate the graphs for this host.

Sorry I not posted the graphs in order.

I used the "STG - SNMP Traffic Grapher - version 1.4.5" and the traffic graph is working fine.

The problem is on the SNMP or RRDTOOL?

[BSOD2600]

Oh no! I did exactly that you recommended. I didn't create the graphs manually.

Really. The fact the graph names or index fields are not automatically populated makes me think otherwise. Thats a strong sign cacti is unable to snmp query that device.