Cisco Devices snmpv3 (sha/aes128) problem

[areast]

Dear All

Using Windows 2008R2 64bit and cacti 0.8.8c (php5.6.3 / net-snmp 5.6.1.1)
Some issue for few Cisco Devices could not work after SNMPV2 -> SNMPV3 (device could get snmp info and ping result but is shown status as "Down")
i am using cmd.php


Turn on debug mode and show below message ....What do that mean?
Downed Device Detection "Ping and SNMP Uptime"
Increase ping timeout value 3000 -> 15000
Ping Retry Count 2
Increase SNMP timeout 300 -> 15000
Maximum OID's Per Get Request 10
Would that be some kind of permission on those devices?

Log for snmpv3
05/16/2015 04:29:41 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.3.0'
05/16/2015 04:25:43 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.3.0'
05/16/2015 04:21:37 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.3.0'
05/16/2015 04:15:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'2006', SQL:"update host set status = '3', status_event_count = '1', status_fail_date = '2015-05-16 16:15:13', status_rec_date = '0000-00-00 00:00:00', status_last_error = 'SNMP not performed due to setting or ping result., ICMP ping Timed out', min_time = '9.99999', max_time = '2814.75500', cur_time = '30.10000', avg_time = '40.93326', total_polls = '17385', failed_polls = '136', availability = '99.217716422203' where hostname = '10.155.16.23''
05/16/2015 04:13:20 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.3.0'
05/16/2015 04:12:34 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.1.0'
05/16/2015 04:11:40 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.3.0'
05/16/2015 04:11:39 PM - CMDPHP: Poller[0] WARNING: SNMP Get Timeout for Host:'10.155.16.23', and OID:'.1.3.6.1.2.1.1.1.0'



LOG for snmpv2
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19411] Graphs['Cisco Router - Tunnel 10.169.121.7'] SNMP: v2: 10.155.16.23, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.7, output: 6822233
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19411] Graphs['Cisco Router - Tunnel 10.169.121.7'] SNMP: v2: 10.155.16.23, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.7, output: 13872185
.1.3.6.1.2.1.31.1.1.1.6.4, output: 22196602
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19409] Graphs['Cisco Router - LAN Gi0/1 - 10.155.16.23'] SNMP: v2: 10.155.16.23, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.3, output: 261080998
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19409] Graphs['Cisco Router - LAN Gi0/1 - 10.155.16.23'] SNMP: v2: 10.155.16.23, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.3, output: 394496769
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19408] Graphs['Cisco Router - $ETH-LAN$$ETH-S - Gi0/0 - 10.155.18.129'] SNMP: v2: 10.155.16.23, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.2, output: 150076309
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19408] Graphs['Cisco Router - $ETH-LAN$$ETH-S - Gi0/0 - 10.155.18.129'] SNMP: v2: 10.155.16.23, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.2, output: 94040751
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19407] Graphs['Cisco Router - Memory Usage - I/O Pool'] SNMP: v2: 10.155.16.23, dsname: poolUsed, oid: .1.3.6.1.4.1.9.9.48.1.1.1.5.2, output: 18404592
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19407] Graphs['Cisco Router - Memory Usage - I/O Pool'] SNMP: v2: 10.155.16.23, dsname: poolFree, oid: .1.3.6.1.4.1.9.9.48.1.1.1.6.2, output: 19344144
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19407] Graphs['Cisco Router - Memory Usage - I/O Pool'] SNMP: v2: 10.155.16.23, dsname: poolLargest, oid: .1.3.6.1.4.1.9.9.48.1.1.1.7.2, output: 15834364
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19406] Graphs['Cisco Router - Memory Usage - Processor Pool'] SNMP: v2: 10.155.16.23, dsname: poolUsed, oid: .1.3.6.1.4.1.9.9.48.1.1.1.5.1, output: 37926972
05/16/2015 03:48:52 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19406] Graphs['Cisco Router - Memory Usage - Processor Pool'] SNMP: v2: 10.155.16.23, dsname: poolFree, oid: .1.3.6.1.4.1.9.9.48.1.1.1.6.1, output: 286848612
05/16/2015 03:48:51 PM - CMDPHP: Poller[0] Host[1119] Description[Cisco Router] DS[19406] Graphs['Cisco Router - Memory Usage - Processor Pool'] SNMP: v2: 10.155.16.23, dsname: poolLargest, oid: .1.3.6.1.4.1.9.9.48.1.1.1.7.1, output: 245866872

[BSOD2600]

MySQL error 2006 = MySQL server has gone away. https://dev.mysql.com/doc/refman/5.5/en/gone-away.html

[areast]

Just weird why this error"2006' will fail to poll with snmpv3 but not v2
Does mysqlcheck.exe --repair --database will fix this? or some SQL command will able to fix individual device
This time i debug and lookup with ID"1119" and show below error.


05/19/2015 02:41:35 AM - CMDPHP: Poller[0] Host[1119] Description['Cisco Router] ERROR: HOST EVENT: Host is DOWN Message: Host did not respond to SNMP, ICMP Ping Success (28 ms)
05/19/2015 02:41:35 AM - CMDPHP: Poller[0] Host[1119] Description['Cisco Router] SNMP: Host did not respond to SNMP
05/19/2015 02:41:35 AM - CMDPHP: Poller[0] Host[1119] Description['Cisco Router] PING: ICMP Ping Success (28 ms)
05/19/2015 02:32:49 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM manage_host where id='1119' limit 1"

[BSOD2600]

MySQL error 1146 = table doesnt exist. Looks like you need to reinstall the manage plugin...

MySQL error 2006 - please take a read of the link and see if any of the suggestions apply to your environment.

[areast]

I basically do "repair" for cacti and below is the result

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

c:\Program Files\MySQL\MySQL Server 5.6\bin>mysqlcheck.exe -u root -p --repair --database cacti
Warning: Using unique option prefix database instead of databases is deprecated
and will be removed in a future release. Please use the full name instead.
Enter password: **********
cacti.cdef OK
cacti.cdef_items OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_source_stats_daily OK
cacti.data_source_stats_hourly OK
cacti.data_source_stats_hourly_cache
note : The storage engine for the table doesn't support repair
cacti.data_source_stats_hourly_last
note : The storage engine for the table doesn't support repair
cacti.data_source_stats_monthly OK
cacti.data_source_stats_weekly OK
cacti.data_source_stats_yearly OK
cacti.data_template OK
cacti.data_template_data OK
cacti.data_template_data_rra OK
cacti.data_template_rrd OK
cacti.gpsmap_templates OK
cacti.graph_local OK
cacti.graph_template_input OK
cacti.graph_template_input_defs OK
cacti.graph_templates OK
cacti.graph_templates_gprint OK
cacti.graph_templates_graph OK
cacti.graph_templates_item OK
cacti.graph_tree OK
cacti.graph_tree_items OK
cacti.host OK
cacti.host_graph OK
cacti.host_snmp_cache OK
cacti.host_snmp_query OK
cacti.host_template OK
cacti.host_template_graph OK
cacti.host_template_snmp_query OK
cacti.mac_track_interface_graphs OK
cacti.manage_admin_link OK
cacti.manage_alerts OK
cacti.manage_groups OK
cacti.manage_poller_output OK
cacti.manage_process OK
cacti.manage_services OK
cacti.manage_sites OK
cacti.manage_tcp OK
cacti.manage_templates OK
cacti.manage_uptime_method OK
cacti.plugin_aggregate_color_template_items OK
cacti.plugin_aggregate_color_templates OK
cacti.plugin_aggregate_graph_templates OK
cacti.plugin_aggregate_graph_templates_graph OK
cacti.plugin_aggregate_graph_templates_item OK
cacti.plugin_aggregate_graphs OK
cacti.plugin_aggregate_graphs_graph_item OK
cacti.plugin_aggregate_graphs_items OK
cacti.plugin_config OK
cacti.plugin_db_changes OK
cacti.plugin_fix64bit OK
cacti.plugin_flowview_devices OK
cacti.plugin_flowview_dnscache
note : The storage engine for the table doesn't support repair
cacti.plugin_flowview_ports OK
cacti.plugin_flowview_queries OK
cacti.plugin_flowview_schedules OK
cacti.plugin_hmib_hrdevices OK
cacti.plugin_hmib_hrprocessor OK
cacti.plugin_hmib_hrstorage OK
cacti.plugin_hmib_hrswinstalled OK
cacti.plugin_hmib_hrswrun OK
cacti.plugin_hmib_hrswrun_ignore OK
cacti.plugin_hmib_hrswrun_last_seen OK
cacti.plugin_hmib_hrsystem OK
cacti.plugin_hmib_hrsystemtypes OK
cacti.plugin_hmib_processes
note : The storage engine for the table doesn't support repair
cacti.plugin_hmib_types OK
cacti.plugin_hooks OK
cacti.plugin_realms OK
cacti.plugin_rrdclean OK
cacti.plugin_rrdclean_action OK
cacti.plugin_snmpagent_cache OK
cacti.plugin_snmpagent_cache_notifications OK
cacti.plugin_snmpagent_cache_textual_conventions OK
cacti.plugin_snmpagent_managers OK
cacti.plugin_snmpagent_managers_notifications OK
cacti.plugin_snmpagent_mibs OK
cacti.plugin_snmpagent_notifications_log OK
cacti.plugin_thold_contacts OK
cacti.plugin_thold_log OK
cacti.plugin_thold_template_contact OK
cacti.plugin_thold_threshold_contact OK
cacti.plugin_transporter_poller_output_archive OK
cacti.plugin_usersettings OK
cacti.poller OK
cacti.poller_command OK
cacti.poller_item OK
cacti.poller_output OK
cacti.poller_output_boost OK
cacti.poller_output_boost_processes
note : The storage engine for the table doesn't support repair
cacti.poller_output_rt OK
cacti.poller_reindex OK
cacti.poller_time OK
cacti.reports OK
cacti.reports_data OK
cacti.rra OK
cacti.rra_cf OK
cacti.settings OK
cacti.settings_graphs OK
cacti.settings_graphs_group OK
cacti.settings_tree OK
cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.thold_data OK
cacti.thold_template OK
cacti.transporter_table OK
cacti.user_auth OK
cacti.user_auth_group OK
cacti.user_auth_group_members OK
cacti.user_auth_group_perms OK
cacti.user_auth_group_realm OK
cacti.user_auth_guests
note : The storage engine for the table doesn't support repair
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_log OK
cacti.version OK
cacti.weathermap_auth OK
cacti.weathermap_data OK
cacti.weathermap_groups OK
cacti.weathermap_maps OK
cacti.weathermap_settings OK

c:\Program Files\MySQL\MySQL Server 5.6\bin>

[BSOD2600]

still receiving both errors?
did you review the solutions in the 2006 linked page?