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 > Server & Application Monitor (SAM) > Monitor MySQL with SAM - Setup/Configuration

Monitor MySQL with SAM - Setup/Configuration

Updated March 1, 2017

Overview

For SAM to monitor MySQL, there are some prerequisites that need to be completed before the application monitor will work. 

Environment

All SAM versions

Steps

  1. Make sure that you have a user that can connect to the MySQL database and that your MySQL server is set to allow remote connections. Some installed MySQL only listen on 127.0.0.1 by default.
  2. Download both the 32 and 64 bit msi driver here.
  3. Install both on your main Orion server and any Additional Polling Engines you have.
  4. Once installed, open ODBC Data Source (32-bit) and click on the Drivers tab.

    c:\windows\syswow64\odbcad32.exe shows you 32-bit drivers and 

    c:\windows\system32\odbcad32.exe shows you 64-bit drivers

    Make note of the MySQL Driver name. In this screenshot,  it is MySQL ODBC 5.1 Driver. This may vary depending on the version of the MySQL driver installed.


1.png

CONFIGURATION

  1. Open SAM and find and edit the MySQL template.
  2. Expand the first component to test with.
  3. Edit the Connection String and insert Driver={} with the name of the MySQL Driver you noted in step 3 of prerequisites.
    1.png
  4. Make sure you define Credentials for monitoring too, those would be a MySQL user.
  5. Test the connection, as long as everything is in place the test should be successful. If not, then click details in the error and see what it gives and where you might need to start troubleshooting.
    1.png

 

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.

 

Last modified
14:23, 19 Jun 2017

Tags

Classifications

Public