cannot graph interface traffic with Version 0.8.6j

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

Moderators: Developers, Moderators

Post Reply
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

cannot graph interface traffic with Version 0.8.6j

Post by memphisto »

hi i recently updated my cacti to Version 0.8.6j.
but know when i'm adding devices and tried to create graph for
the devices it always shown this messages on the Data Query [SNMP - Interface Statistics] box and Data Query [ucd/net - Get Monitored Partitions] box:

Code: Select all

This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information.
and one thing i noticed, at my cacti log i see a lot of these messages:

Code: Select all


04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='4'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='5'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='5'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='6'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='6'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='7'"
04/25/2007 10:20:03 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select field_value from host_snmp_cache where host_id=3 and field_name='hrStorageAllocationUnits' and snmp_index='7'"
04/25/2007 10:20:08 AM - SYSTEM STATS: Time:5.1273 Method:cmd.php Processes:1 Threads:N/A Hosts:11 HostsPerProcess:11 DataSources:75 RRDsProcessed:51
04/25/2007 10:20:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select field_name,field_value from host_snmp_cache where host_id=11 and snmp_query_id=1 and snmp_index='2'"
04/25/2007 10:20:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select field_name,field_value from host_snmp_cache where host_id=11 and snmp_query_id=1 and snmp_index='2'"
the user for cacti database is root, so i assure you this is not permition / privileges issues.

this is frustrating me, before updated everything went fine.
Please help me with this issues

TIA

Zen

Code: Select all

Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Did you apply all patches?
Reinhard
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

i should patch the latest version?
well i guess not yet.
patching it right now.
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

i did the patch.
but the problem still remain.
any idea??
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please select "Verbose Query" of a failing Data Query and post the results
Reinhard
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

sure thing,
here it is :

Code: Select all

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/home/www/public_html/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ Located input field 'ifIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.1'
+ Found item [ifIndex='1'] index: 1 [from value]
+ Found item [ifIndex='2'] index: 2 [from value]
+ Found item [ifIndex='3'] index: 3 [from value]
+ Found item [ifIndex='4'] index: 4 [from value]
+ Found item [ifIndex='5'] index: 5 [from value]
+ Found item [ifIndex='6'] index: 6 [from value]
+ Located input field 'ifOperStatus' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.8'
+ Found item [ifOperStatus='Up'] index: 1 [from value]
+ Found item [ifOperStatus='Up'] index: 2 [from value]
+ Found item [ifOperStatus='Up'] index: 3 [from value]
+ Found item [ifOperStatus='Down'] index: 4 [from value]
+ Found item [ifOperStatus='Down'] index: 5 [from value]
+ Found item [ifOperStatus='Down'] index: 6 [from value]
+ Located input field 'ifDescr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
+ Found item [ifDescr='em0'] index: 1 [from value]
+ Found item [ifDescr='xl0'] index: 2 [from value]
+ Found item [ifDescr='lo0'] index: 3 [from value]
+ Found item [ifDescr='pfsync0'] index: 4 [from value]
+ Found item [ifDescr='pflog0'] index: 5 [from value]
+ Found item [ifDescr='tun5'] index: 6 [from value]
+ Located input field 'ifName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'
+ Located input field 'ifAlias' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.18'
+ Located input field 'ifType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.3'
+ Found item [ifType='ethernetCsmacd(6)'] index: 1 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 2 [from value]
+ Found item [ifType='softwareLoopback(24)'] index: 3 [from value]
+ Found item [ifType='247'] index: 4 [from value]
+ Found item [ifType='246'] index: 5 [from value]
+ Found item [ifType='ppp(23)'] index: 6 [from value]
+ Located input field 'ifSpeed' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.5'
+ Found item [ifSpeed='10000000'] index: 1 [from value]
+ Found item [ifSpeed='100000000'] index: 2 [from value]
+ Found item [ifSpeed='0'] index: 3 [from value]
+ Found item [ifSpeed='100000000'] index: 4 [from value]
+ Found item [ifSpeed='0'] index: 5 [from value]
+ Found item [ifSpeed='0'] index: 6 [from value]
+ Located input field 'ifHwAddr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.6'
+ Found item [ifHwAddr='00:00:04:23:B3:69:9C'] index: 1 [from value]
+ Found item [ifHwAddr='00:00:01:02:74:88:3E'] index: 2 [from value]
+ Found item [ifHwAddr=''] index: 3 [from value]
+ Found item [ifHwAddr=''] index: 4 [from value]
+ Found item [ifHwAddr=''] index: 5 [from value]
+ Found item [ifHwAddr=''] index: 6 [from value]
+ Located input field 'ifIP' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.4.20.1.2'
+ Found item [ifIP='127.0.0.1'] index: 3 [from regexp oid parse]
+ Found item [ifIP='172.64.14.1'] index: 2 [from regexp oid parse]
+ Found item [ifIP='202.57.0.93'] index: 1 [from regexp oid parse]
+ Found data query XML file at '/usr/home/www/public_html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/home/www/public_html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/home/www/public_html/cacti/resource/snmp_queries/interface.xml'
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please delete the storage Data Query from this host for testing purpose. Then, please select "Create Graphs for this Host" and post the screenshot. Do not forget to wipe out confidential information
Reinhard
Top
TechMason
Posts: 4
Joined: Thu Sep 28, 2006 9:46 pm
Location: Kitchener

Post by TechMason »

I have a similar problem. All of my device data queries used to work fine but now any data queries shows 0 Items, 0 Rows

Here is an example of a Win2k3 device that is currently graphing CPU stats:

Code: Select all

2) SNMP - Get Processor Information  (Verbose Query)  Uptime Goes Backwards  Success [0 Items, 0 Rows]
and when I do a Verbose Query (with names changed to protect the innocent):

Code: Select all

Data Query Debug Information 
 
+ Running data query [9].
+ Found type = '6 '[script query].
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /srv/www/intel/cacti/scripts/ss_host_cpu.php 192.168.1.61 91 1:161:500:public:::MD5::[None] index'
+ Executing script query '/usr/bin/php -q /srv/www/intel/cacti/scripts/ss_host_cpu.php 192.168.1.61 91 1:161:500:public:::MD5::[None] query index'
+ Found item [hrProcessorFrwID='0'] index: 0
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
Cacti Version 0.8.6h
PHP Version 4.4.0
Apache/2.0.54
SLES 10

See also http://forums.cacti.net/viewtopic.php?p=98533#98533
Last edited by TechMason on Wed May 02, 2007 4:12 pm, edited 1 time in total.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please snmpwalk the target for OID .1.3.6.1.2.1.25.3.3.1 and post the results
Reinhard
Top
TechMason
Posts: 4
Joined: Thu Sep 28, 2006 9:46 pm
Location: Kitchener

Post by TechMason »

snmpwalk -Os -c public -v 1 hostname .1.3.6.1.2.1.25.3.3.1

Code: Select all

hrProcessorFrwID.2 = OID: zeroDotZero
hrProcessorFrwID.3 = OID: zeroDotZero
hrProcessorFrwID.4 = OID: zeroDotZero
hrProcessorFrwID.5 = OID: zeroDotZero
hrProcessorLoad.2 = INTEGER: 0
hrProcessorLoad.3 = INTEGER: 0
hrProcessorLoad.4 = INTEGER: 0
hrProcessorLoad.5 = INTEGER: 0
and a verbose device query on SNMP - Get Processor Information for the host:

Code: Select all

+ Running data query [9].
+ Found type = '6 '[script query].
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /srv/www/intel/cacti/scripts/ss_host_cpu.php hostname 110 1:161:500:public:::MD5::[None] index'
+ Executing script query '/usr/bin/php -q /srv/www/intel/cacti/scripts/ss_host_cpu.php PMtl2InPP01.fednet.ca 110 1:161:500:1nsp1reD:::MD5::[None] query index'
+ Found item [hrProcessorFrwID='0'] index: 0
+ Found item [hrProcessorFrwID='1'] index: 1
+ Found item [hrProcessorFrwID='2'] index: 2
+ Found item [hrProcessorFrwID='3'] index: 3
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
+ Found data query XML file at '/srv/www/intel/cacti/resource/script_server/host_cpu.xml'
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

gandalf wrote:Please delete the storage Data Query from this host for testing purpose. Then, please select "Create Graphs for this Host" and post the screenshot. Do not forget to wipe out confidential information
Reinhard
ok i'll do that...
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

gandalf wrote:Please delete the storage Data Query from this host for testing purpose. Then, please select "Create Graphs for this Host" and post the screenshot. Do not forget to wipe out confidential information
Reinhard
ok here we go,
but FYI i'm not sure what is "delete the storage Data Query".
but this what i did, i deleted the device and remove the rrd file from the box.
than i readded the device again.
and this is the result when i tried to create graphs from the device:

Image

i hope the steps is right...

TIA
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

1) Click the Cacti and show if you have php_snmp installed
2) Post the output of this command from a mysql window: "show tables;"

Look for issues with Checksums. You might want to run a "myisamchk". Or you may be missing a table. I am guessing it's just damaged.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
memphisto
Posts: 12
Joined: Mon Apr 23, 2007 3:31 am

Post by memphisto »

ok here it is:

Cacti Variables
Operating System: unix
PHP SNMP Support: no

and the tables:

mysql> show tables;
+---------------------------+
| Tables_in_cacti |
+---------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
+---------------------------+
48 rows in set (0.00 sec)

mysql>
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

This is what you get when you are working too many hours. The command is/or was supposed to be:

show table status;

Sorry,

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 5 guests