SNMP - Interface Statistics - Will not list them.

[skol]

I'm having the same issue with 0.8.7b.

[nihkiruks]

knock-knock... Anyone have a suggestions?

[gandalf]

ALL

please visit "System Utilities -> View Poller Cache", select the host in question and try to find data for your interfaces. Anything in there?
If not, please do the following

1. Truncate cacti.log
2. Switch Poller Verbosity to DEBUG
3. Hit the host and run "Verbose Query".
4. Copy cacti.log to debug.log and post findings
5. Revert Poller Verbosity

There should be a lot of SQL statements in the log and I'd like to see them
Reinhard

[nightfighter]

Reverted graph_new.php to 0.8.6k and it solved the issue, however, that's not the best way...

works well on me after downgrade to 0.8.6k
Thanks for Info

[kharford]

Hi All,
Was there ever a solved thread for this?

Cacti Version 0.8.7b
Cacti OS unix
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Hosts 505
Graphs 220
Data Sources Script/Command: 1
SNMP: 206
SNMP Query: 105
Script Query - Script Server: 60
Total: 372
Poller Information
Interval 60
Type spine
Items Action[0]: 410
Action[1]: 1
Action[2]: 108
Total: 519
Concurrent Processes 1
Max Threads 35
PHP Servers 5
Script Timeout 25
Max OID 8
Last Run Statistics Time:13.2529 Method:spine Processes:1 Threads:35 Hosts:504 HostsPerProcess:504 DataSources:519 RRDsProcessed:369
PHP Information
PHP Version 5.1.6
PHP OS Linux
PHP uname Linux 2.6.18-53.1.14.el5 #1 SMP Wed Mar 5 11:37:38 EST 2008 x86_64
PHP SNMP Installed
max_execution_time 30
memory_limit 16M



I turned on DEBUG for the verbose query on SNMP-Interface:



06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from host where id=650"

06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,name from host_template order by name"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_templates,host_g
raph) where graph_templates.id=host_graph.graph_template_id and host_graph.host_id=650 order by graph_templates.name"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT graph_templates.id, graph_templates.name FROM snmp_query_graph RIGHT JO
IN graph_templates ON (snmp_query_graph.graph_template_id = graph_templates.id) WHERE (((snmp_query_graph.name) Is Null)) ORDER BY graph_tem
plates.name"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=185 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=97 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=96 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=92 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=93 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=181 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=183 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=94 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=95 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=13 and host_id=650"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name, host_snmp_query.reindex_method from
(snmp_query,host_snmp_query) where snmp_query.id=host_snmp_query.snmp_query_id and host_snmp_query.host_id=650 order by snmp_query.name"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name from snmp_query order by snmp_query.
name"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=14))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=24))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=19))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=20))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=17))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=18))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=16))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=3))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=25))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=4))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=7))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=9))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=1))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=15))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=8))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=2))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=6))"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=1"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=1 group
by snmp_index"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=8"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=8 group
by snmp_index"
06/03/2008 05:31:38 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'host_ed
it_bottom'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
arrays'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
settings'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_h
ost_fields'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
form'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_al
ternate_realms'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/03/2008 05:31:41 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='3'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'device_
action_array'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (snmp_query,data_input) where snmp_query.data_input_
id=data_input.id and snmp_query.id=1"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "SELECT hostname, snmp_community, snmp_version, snmp_username, snmp_password, s
nmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout FROM host WHERE id='650'"

06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from host_snmp_cache where host_id='650' and snmp_query_id='1'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIndex','1','1','.1.3.6.1.2.1.2.2.1.1.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIndex','2','2','.1.3.6.1.2.1.2.2.1.1.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIndex','3','3','.1.3.6.1.2.1.2.2.1.1.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIndex','4','4','.1.3.6.1.2.1.2.2.1.1.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifOperStatus','Up','1','.1.3.6.1.2.1.2.2.1.8.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifOperStatus','Up','2','.1.3.6.1.2.1.2.2.1.8.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifOperStatus','Down','3','.1.3.6.1.2.1.2.2.1.8.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifOperStatus','Down','4','.1.3.6.1.2.1.2.2.1.8.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifDescr','lo','1','.1.3.6.1.2.1.2.2.1.2.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifDescr','eth0','2','.1.3.6.1.2.1.2.2.1.2.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifDescr','eth1','3','.1.3.6.1.2.1.2.2.1.2.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifDescr','sit0','4','.1.3.6.1.2.1.2.2.1.2.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifName','lo','1','.1.3.6.1.2.1.31.1.1.1.1.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifName','eth0','2','.1.3.6.1.2.1.31.1.1.1.1.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifName','eth1','3','.1.3.6.1.2.1.31.1.1.1.1.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifName','sit0','4','.1.3.6.1.2.1.31.1.1.1.1.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifAlias','','1','.1.3.6.1.2.1.31.1.1.1.18.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifAlias','','2','.1.3.6.1.2.1.31.1.1.1.18.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifAlias','','3','.1.3.6.1.2.1.31.1.1.1.18.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifAlias','','4','.1.3.6.1.2.1.31.1.1.1.18.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifType','softwareLoopback(24)','1','.1.3.6.1.2.1.2.2.1.3.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifType','ethernetCsmacd(6)','2','.1.3.6.1.2.1.2.2.1.3.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifType','ethernetCsmacd(6)','3','.1.3.6.1.2.1.2.2.1.3.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifType','tunnel(131)','4','.1.3.6.1.2.1.2.2.1.3.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifSpeed','10000000','1','.1.3.6.1.2.1.2.2.1.5.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifSpeed','1000000000','2','.1.3.6.1.2.1.2.2.1.5.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifSpeed','0','3','.1.3.6.1.2.1.2.2.1.5.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifSpeed','0','4','.1.3.6.1.2.1.2.2.1.5.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifHwAddr','','1','.1.3.6.1.2.1.2.2.1.6.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifHwAddr','00:00:1E:C9:3D:3D:8C','2','.1.3.6.1.2.1.2.2.1.6.2')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifHwAddr','00:00:1E:C9:3D:3D:8D','3','.1.3.6.1.2.1.2.2.1.6.3')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifHwAddr','','4','.1.3.6.1.2.1.2.2.1.6.4')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','127.0.0.1','1','.1.3.6.1.2.1.4.20.1.2.127.0.0.1')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.64','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.64')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.212','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.212')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.213','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.213')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.214','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.214')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.215','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.215')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.216','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.216')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.217','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.217')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.218','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.218')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.219','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.219')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.220','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.220')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snm
p_index,oid) values ('650','1','ifIP','192.168.202.221','2','.1.3.6.1.2.1.4.20.1.2.192.168.202.221')"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifIndex'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifOperStatus'"
06/03/2008 05:31:41 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifDescr'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifName'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifAlias'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifType'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifSpeed'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifHwAddr'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=650 and snmp_query_id=1 and
field_name='ifIP'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host_snmp_query set sort_field = 'ifDescr', title_format = '|query_ifDescr|'
where host_id = '650' and snmp_query_id = '1'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_au
th_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout from host where id=650"

06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select reindex_method, sort_field from host_snmp_query where host_id=650 and snmp_qu
ery_id=1"

06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (data_input,snmp_query) where data_input.id=snmp_que
ry.data_input_id and snmp_query.id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_reindex where host_id=650 and data_query_id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_reindex (host_id,data_query_id,action,op,assert_value,arg1) valu
es (650,1,0,'<','227155131','.1.3.6.1.2.1.1.3.0')"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where host_id = '650' and snmp_query_id = '1'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '650' and snmp_query_id = '1'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '650' and snmp_query_id = '1'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
arrays'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
settings'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_h
ost_fields'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
form'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_al
ternate_realms'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/03/2008 05:31:42 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='3'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'device_
action_array'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_hea
der'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_ti
tle'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_he
ad'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_hea
der_tabs'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_na
vigation_text'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_
arrays'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM plugin_realms"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'host_ed
it_top'"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from host where id=650"

06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,name from host_template order by name"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_templates,host_g
raph) where graph_templates.id=host_graph.graph_template_id and host_graph.host_id=650 order by graph_templates.name"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT graph_templates.id, graph_templates.name FROM snmp_query_graph RIGHT JO
IN graph_templates ON (snmp_query_graph.graph_template_id = graph_templates.id) WHERE (((snmp_query_graph.name) Is Null)) ORDER BY graph_tem
plates.name"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=185 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=97 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=96 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=92 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=93 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=181 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=183 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=94 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=95 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where graph_template_id=13 and host_id=650"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name, host_snmp_query.reindex_method from
(snmp_query,host_snmp_query) where snmp_query.id=host_snmp_query.snmp_query_id and host_snmp_query.host_id=650 order by snmp_query.name"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query.id, snmp_query.name from snmp_query order by snmp_query.
name"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=14))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=24))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=19))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=20))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=17))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=18))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=16))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=3))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=25))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=4))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=7))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=9))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=1))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=15))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=8))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=2))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT snmp_query_id FROM host_snmp_query WHERE ((host_id=650) and (snmp_query_id
=6))"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=1"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=1 group
by snmp_index"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=8"
06/03/2008 05:31:42 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_index from host_snmp_cache where host_id=650 and snmp_query_id=8 group
by snmp_index"

[vertigo23]

ALL

please visit "System Utilities -> View Poller Cache", select the host in question and try to find data for your interfaces. Anything in there?
If not, please do the following

1. Truncate cacti.log
2. Switch Poller Verbosity to DEBUG
3. Hit the host and run "Verbose Query".
4. Copy cacti.log to debug.log and post findings
5. Revert Poller Verbosity

There should be a lot of SQL statements in the log and I'd like to see them
Reinhard

I'm having exactly the same problem - Cacti Version 0.8.7b, totally generic install on Ubuntu 8.04 from packages. When I create a device entry for another linux net-snmp host, it gives me "Success [26 Items, 3 Rows]" in the device page for "SNMP - Interface Statistics", but when I go to create graphs, I get "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.".

Gandalf, attached is the debug log as you requested. There is nothing for that host in the poller cache.

[vertigo23]

Reverted graph_new.php to 0.8.6k and it solved the issue, however, that's not the best way...

works well on me after downgrade to 0.8.6k
Thanks for Info

Works for me also, just copying the 0.8.6k version of graphs_new.php into the 0.8.7b install.

[rs26]

I have a similar problem with Cacti.

I have installed Cacti 0.8.7b on Ubuntu 8.04. I want to monitor HP ProCurve Switch. I can add a switch without problem, but when i want to add graphs (SNMP Interfaces), Cacti doesn't add input/output data or error. I have 218 items (Index, Status, Description, Name, Alias, Type, Speed, Hardware Address) but the next items aren't added.

Have you a solution for this problem ?

EDIT : The OID in the interface.xml are goods! And I arrived to monitor all datas with Zabbix (or Getif), an other supervision system.

[rs26]

Verbose Query ...

[TheWitness]

Those information does not appear in the query, but rather during graphing operations. The query is simply to return human readable information for inclusion on the graphs and to help you decide what to graph. When polling takes place, the graphable numeric values are polled. The verbose query attached looks just fine.

TheWitness