Unable to monitor Windows 2003 /XP PCs-----------please help

[Shivaraj05]

I successfully added two windows 2003 servers for monitoring a few days back.But now i am not able to add new hosts. Its showing "SNMP error"

I have SNMP services running in the PCs.Agent,Trap,security tabs of SNMP service are provided with Community string and IP of cacti server. Still its not working. Please help me out.

I am getting the following error in the log

Log File [Total Lines: 22 - Non-Matching Items Hidden]
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select graph_template_id from host_template_graph where host_template_id=7"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from data_local where host_id = '14' and snmp_query_id = '9'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from data_local where host_id = '14' and snmp_query_id = '9'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from graph_local where host_id = '14' and snmp_query_id = '9'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"delete from poller_reindex where host_id=14 and data_query_id=9'
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select xml_path from snmp_query where id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select data_input.type_id from (data_input,snmp_query) where data_input.id=snmp_query.data_input_id and snmp_query.id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'2006', SQL:"select reindex_method, sort_field from host_snmp_query where host_id=14 and snmp_query_id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'2006', SQL:"select hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout from host where id=14"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"update host_snmp_query set sort_field = '', title_format = '|query_|' where host_id = '14' and snmp_query_id = '9''
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select xml_path from snmp_query where id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select xml_path from snmp_query where id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select data_input.type_id from (snmp_query,data_input) where snmp_query.data_input_id=data_input.id and snmp_query.id=9"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"replace into host_snmp_query (host_id,snmp_query_id,reindex_method) values (14,9,1)'
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from data_local where host_id = '14' and snmp_query_id = '8'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from data_local where host_id = '14' and snmp_query_id = '8'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select id from graph_local where host_id = '14' and snmp_query_id = '8'"
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"insert into poller_reindex (host_id,data_query_id,action,op,assert_value,arg1) values (14,8,0,'<','','.1.3.6.1.2.1.1.3.0')'
10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"delete from poller_reindex where host_id=14 and data_query_id=8'
10/04/2008 12:34:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability, graph_tree_items.graph_tree_id from host left join graph_tree_items on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id IS NULL and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 order by host.description"
10/04/2008 12:34:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=1 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
10/04/2008 12:34:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.id, host.description, host.status, host.hostname, host.cur_time, host.status_rec_date, host.status_fail_date, host.availability from graph_tree_items left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=2 and ((host.disabled = '' and host.monitor = 'on') or (title != ''))and host.status < 2 and host.id > 0 and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"



please help

[khufure]

I successfully added two windows 2003 servers for monitoring a few days back.But now i am not able to add new hosts. Its showing "SNMP error"

SNMP error means Cacti can't poll system level information, which is the SNMP equivelant of a ping. You can test with snmpwalk from the command line with system. E.g.

snmpwalk -c public -v 1 hostname system

10/10/2008 06:04:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2006', SQL:"select graph_template_id from host_template_graph where host_template_id=7"

SQL 2006 errors are connection drops. That means Cacti can't talk to the database server. Something is quite wrong if you are getting these errors. You should check your mysql server for errors.

[TheWitness]

There have been some posts of late relative to the MySQL Server crashing. You should, as mentioned, check to see if that is happening. Also, please verify that you have enough connections.

TheWitness