Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > Resources are not displayed in the Web Console when attempting to add MySQL Instance

Resources are not displayed in the Web Console when attempting to add MySQL Instance

Created by Tiarnan Stacke, last modified by Melanie Boyd on Apr 17, 2017

Views: 7 Votes: 0 Revisions: 6

Overview

When attempting to add a MySQL Instance for monitoring, the page does not display any resource like in the following image:

Environment

DPA v10.0.x

Cause 

This is caused by a bug where DPA is attempting to make a call to an Amazon cloud address to test if it is running in the cloud. Typically, this call would return null. However, a Firewall or some other application returns an unexpected page.

Resolution

  • Upgrade DPA to version 10.1 or later.
  • Alternative Workaround for DPA 10.0.x
  1. Go to: <DPA_DIR>\iwc\tomcat\webapps\iwc\WEB-INF\classes\resources\database\MySQL\.
  2. Create a copy of the createMonUser.sql file and place it on your desktop (Do not leave the copy in the installation directory).
  3. Edit the createMonUser.sql file.
  4. Change all occurrences of <IP> to <IPx>.
  5. Save the file.
  6. Start the Wizard and attempt to register a MySQL Instance.

 

Last modified
13:12, 17 Apr 2017

Tags

Classifications

Public