Applications Systems

Unable to connect to any specified MySQL hosts

This article provides information about the following error message received in the SolarWinds website: Unable to connect to any specified MySQL hosts (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 285). Server & Application Monitor SAM 6.X versions error

First published date

10/10/2018 1:40 PM

Last published date

5/1/2020 11:37 AM

Overview

The following error message is received in the SolarWinds website:

Unable to connect to any specified MySQL hosts

(C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 2XX)

Product section

Server Application Monitor

Cause

This is due to an error in the Mysql connector installation and is non-SolarWinds related. 

Resolution

DISCLAIMER: Please note this is not an issue regarding the SolarWinds software but is an issue caused by the MySQL connector on the server. You can uninstall the MySQL connector from the server and it will resolve the issue. If you cannot do so then you may attempt to do the steps below which several of our customers have used in the past from sites like TechNet and Stack Overflow, but it is at your own risk. 

  1. Stop all SolarWinds Services.
  2. Go to:
    1. C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
    2. C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
  3. Open the machine.config file in any text editor.
  4. Comment out the config in machine.config file. The following lines: 
    Line 2XX:    <!-- <siteMap>
    Line 2XX:      <providers>
    Line 2XX:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
    Line 2XX:      </providers>

    Line 2XX:    </siteMap> -->

    5.  Restart all SolarWinds Services.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.