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這個參數選項呢?