Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Network Performance Monitor (NPM) > Upgrade Multiple SolarWinds Products > SNMPv3 credentials are missing after upgrading to NPM 12

SNMPv3 credentials are missing after upgrading to NPM 12

Updated August 23, 2016

Overview

After upgrading from NPM 11.5 to 12, a warning appeared showing 900 and more nodes with SNMP issues. Upon further investigation, the Web Console did not have the necessary settings in the Node Details > Edit Node page.

The correct information was in the database.

Environment

NPM 12

Cause 

Rare - Bug / JIRA case CUST-25855

 

During the upgrade process separate tables are created to facilitate the transfer of credentials. A rare issue where the tables are created but the data is not transferred can cause this snmp issue

Resolution

Manually re-adding the credentials can resolve the issue though this is not feasible and is time consuming if there are 1000 nodes in question.

Development team has fixed this in the code.

 

For an immediate solution:

  1. Create a backup of the database.
  2. Run the following query:
    delete from NodeSettings
    where SettingName like 'ROSNMPCredentialID'
  3. Then run the following queries one by one:
    Update [dbo].[NodesData]
     SET SNMPV3PrivMethod = 'None'
     Where Len (SNMPV3PrivMethod) = 0 or SNMPV3PrivMethod is NULL
    
    Update [dbo].[NodesData]
     SET SNMPV3AuthMethod = 'None'
     Where Len (SNMPV3AuthMethod) = 0 or SNMPV3AuthMethod is NULL
    Update [dbo].[NodesData]
     SET RWSNMPV3PrivMethod = 'None'
     Where Len (RWSNMPV3PrivMethod) = 0 or RWSNMPV3PrivMethod is NULL
    Update [dbo].[NodesData]
     SET RWSNMPV3AuthMethod = 'None'
     Where Len (RWSNMPV3AuthMethod) = 0 or RWSNMPV3AuthMethod is NULL
  4. Complete the Configuration Wizard and it will re-migrate the credentials.

 

Note:-  If the credentials have migrated successfully then the SNMPV2PrivMethod, SNMPV3AuthMethod etc columns will be removed from the NodesData table.

   

 

 

Last modified

Tags

Classifications

Internal Use Only