歡迎您光臨本站 登入註冊首頁

cacti snmp error

←手機掃碼閱讀     火星人 @ 2014-03-04 , reply:0

cacti snmp error

vi /etc/snmp/snmpd.conf
更改

com2sec notConfigUser default public
改為

com2sec notConfigUser 127.0.0.1 public
2、更改

access notConfigGroup "" any noauth exact systemview none none
改為

access notConfigGroup "" any noauth exact all none none

3、#view all included .1 80
將前面的 # 註釋 去掉。
保存退出


snmp埠號和進程都正常。

root@testtt [~]# snmpwalk -c public -v1 127.0.0.1 .1.3.6.1.2.1.25.2.3.1
HOST-RESOURCES-MIB::hrStorageIndex.1 = INTEGER: 1
HOST-RESOURCES-MIB::hrStorageIndex.2 = INTEGER: 2
HOST-RESOURCES-MIB::hrStorageIndex.3 = INTEGER: 3
HOST-RESOURCES-MIB::hrStorageIndex.4 = INTEGER: 4
HOST-RESOURCES-MIB::hrStorageIndex.5 = INTEGER: 5
HOST-RESOURCES-MIB::hrStorageIndex.6 = INTEGER: 6
HOST-RESOURCES-MIB::hrStorageIndex.7 = INTEGER: 7
HOST-RESOURCES-MIB::hrStorageType.1 = OID: HOST-RESOURCES-TYPES::hrStorageOther
HOST-RESOURCES-MIB::hrStorageType.2 = OID: HOST-RESOURCES-TYPES::hrStorageRam
HOST-RESOURCES-MIB::hrStorageType.3 = OID: HOST-RESOURCES-TYPES::hrStorageVirtualMemory
HOST-RESOURCES-MIB::hrStorageType.4 = OID: HOST-RESOURCES-TYPES::hrStorageFixedDisk
HOST-RESOURCES-MIB::hrStorageType.5 = OID: HOST-RESOURCES-TYPES::hrStorageFixedDisk
HOST-RESOURCES-MIB::hrStorageType.6 = OID: HOST-RESOURCES-TYPES::hrStorageRemovableDisk
HOST-RESOURCES-MIB::hrStorageType.7 = OID: HOST-RESOURCES-TYPES::hrStorageFixedDisk
HOST-RESOURCES-MIB::hrStorageDescr.1 = STRING: Memory Buffers





04/19/2009 08:09:32 PM - CMDPHP: Poller ERROR: SQL Cell Failed!, Error:'2006', SQL:"select count(*) from poller_command"  
04/19/2009 08:09:32 PM - CMDPHP: Poller ERROR: A DB Exec Failed!, Error:'2006', SQL:"replace into settings (name,value) values ('stats_poller','Time:298.6668 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0')'  
04/19/2009 08:09:32 PM - SYSTEM STATS: Time:298.6668 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
04/19/2009 08:09:32 PM - POLLER: Poller Maximum runtime of 298 seconds exceeded. Exiting.  
04/19/2009 08:09:32 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"  
04/19/2009 08:09:32 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"  
04/19/2009 08:09:31 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"  
04/19/2009 08:09:31 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"  
04/19/2009 08:09:30 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"  
04/19/2009 08:09:30 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"  
04/19/2009 08:09:29 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"  
04/19/2009 08:09:29 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"  
04/19/2009 08:09:28 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"  
04/19/2009 08:09:28 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"  





Host: localhost , SNMP Query: Unix - Get Mounted Partitions  
Index: /dev/sda1 , Field Name: dskDevice , Field Value: /dev/sda1  
OID:  
Host: localhost , SNMP Query: Unix - Get Mounted Partitions  
Index: /dev/sda3 , Field Name: dskDevice , Field Value: /dev/sda3  
OID:  
Host: openvz , SNMP Query: Unix - Get Mounted Partitions  
Index: /usr/tmpDSK , Field Name: dskMount , Field Value: /tmp  
OID:  
Host: openvz , SNMP Query: Unix - Get Mounted Partitions  
Index: /dev/sda1 , Field Name: dskMount , Field Value: /boot  
OID:  
Host: openvz , SNMP Query: Unix - Get Mounted Partitions  
Index: /dev/sda3 , Field Name: dskMount , Field Value: /  
OID:  
Host: openvz , SNMP Query: Unix - Get Mounted Partitions  
Index: /usr/tmpDSK , Field Name: dskDevice , Field Value: /usr/tmpDSK  
OID:  
Host: openvz , SNMP Query: Unix - Get Mounted Partitions  
Index: /dev/sda1 , Field Name: dskDevice , Field Value: /dev/sda1  
OID:











root@testtt [~]# cat /usr/local/apache/htdocs/cacti/log/cacti.log
04/18/2009 03:37:20 PM - CMDPHP: Poller WARNING: sockets support not enabled in PHP, falling back to SNMP ping
04/18/2009 03:37:27 PM - CMDPHP: Poller WARNING: sockets support not enabled in PHP, falling back to SNMP ping
04/18/2009 03:37:40 PM - CMDPHP: Poller WARNING: sockets support not enabled in PHP, falling back to SNMP ping
04/18/2009 03:41:26 PM - AUTH LOGIN: User 'admin' Authenticated
04/18/2009 03:52:11 PM - CMDPHP: Poller WARNING: sockets support not enabled in PHP, falling back to SNMP ping
04/18/2009 04:41:37 PM - AUTH LOGIN: User 'admin' Authenticated
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Row Failed!, Error:'1064', SQL:"select id,description,hostname,host_template_id from host where id="
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT     snmp_query.id,     snmp_query.name,     snmp_query.xml_path     FROM (snmp_query,host_snmp_query)     WHERE host_snmp_query.snmp_query_id=snmp_query.id     AND host_snmp_query.host_id=     ORDER BY snmp_query.name"
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_template_id from host_graph where host_id="
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   graph_templates.id AS graph_template_id,   graph_templates.name AS graph_template_name   FROM (host_graph,graph_templates)   WHERE host_graph.graph_template_id=graph_templates.id   AND host_graph.host_id=   ORDER BY graph_templates.name"
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   graph_local.graph_template_id   FROM (graph_local,host_graph)   WHERE graph_local.graph_template_id=host_graph.graph_template_id   AND graph_local.host_id=host_graph.host_id   AND graph_local.host_id=   GROUP BY graph_local.graph_template_id"
04/18/2009 04:43:23 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   snmp_query.id,   snmp_query.name,   snmp_query.xml_path   FROM (snmp_query,host_snmp_query)   WHERE host_snmp_query.snmp_query_id=snmp_query.id   AND host_snmp_query.host_id=   ORDER BY snmp_query.name"
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Row Failed!, Error:'1064', SQL:"select id,description,hostname,host_template_id from host where id="
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT     snmp_query.id,     snmp_query.name,     snmp_query.xml_path     FROM (snmp_query,host_snmp_query)     WHERE host_snmp_query.snmp_query_id=snmp_query.id     AND host_snmp_query.host_id=     ORDER BY snmp_query.name"
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_template_id from host_graph where host_id="
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   graph_templates.id AS graph_template_id,   graph_templates.name AS graph_template_name   FROM (host_graph,graph_templates)   WHERE host_graph.graph_template_id=graph_templates.id   AND host_graph.host_id=   ORDER BY graph_templates.name"
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   graph_local.graph_template_id   FROM (graph_local,host_graph)   WHERE graph_local.graph_template_id=host_graph.graph_template_id   AND graph_local.host_id=host_graph.host_id   AND graph_local.host_id=   GROUP BY graph_local.graph_template_id"
04/18/2009 04:43:25 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT   snmp_query.id,   snmp_query.name,   snmp_query.xml_path   FROM (snmp_query,host_snmp_query)   WHERE host_snmp_query.snmp_query_id=snmp_query.id   AND host_snmp_query.host_id=   ORDER BY snmp_query.name"
04/18/2009 05:38:06 PM - AUTH LOGIN: User 'admin' Authenticated
04/18/2009 06:23:41 PM - AUTH LOGIN: User 'admin' Authenticated
04/18/2009 09:15:41 PM - AUTH LOGIN: User 'admin' Authenticated
04/19/2009 11:35:16 AM - AUTH LOGIN: User 'admin' Authenticated
04/19/2009 04:24:58 PM - AUTH LOGIN: User 'admin' Authenticated
04/19/2009 07:45:44 PM - AUTH LOGIN: User 'admin' Authenticated
04/19/2009 07:54:38 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:38 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:39 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:39 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:40 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:40 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:41 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:41 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:42 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:42 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:43 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:43 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:44 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:44 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:45 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"
04/19/2009 07:54:45 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  LIMIT 10000"
04/19/2009 07:54:46 PM - CMDPHP: Poller ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select poller_id,end_time from poller_time where poller_id=0"

[ 本帖最後由 liang3391 於 2009-4-19 20:35 編輯 ]
《解決方案》

若然是有錯誤呀
《解決方案》

原帖由 kns1024wh 於 2009-4-19 20:44 發表 http://bbs2.chinaunix.net/images/common/back.gif
若然是有錯誤呀


什麼意思  聽不明白,我感覺好像是資料庫的問題,但是不清楚如何修改?
《解決方案》

WARNING: sockets support not enabled in PHP

是不是你編譯php的時候沒有 --enable-socket這個參數選項呢?

[火星人 ] cacti snmp error已經有755次圍觀

http://coctec.com/docs/service/show-post-21916.html