MONITOR MARIADB WITH SAM - SETUP/CONFIGURATION STEPS

Version 5

    OVERVIEW

    For SAM to monitor MariaDB there are some prerequisites that need to be completed. I'm outlining this here for future reference. is a little different from MySQL, but same School.

     

    PREREQUISITES

    1. Make sure that you have a user that can connect to the Maria DB and that your MariaDB server is set to allow remote connections.
    2. Download both the 32 and 64 bit MSI driver from here
      • Your will need the driver for your SAM Server
      • The Driver file for your database server if it's Linux or the MSI installer for windows installation.
    3. Once installed open ODBC Data Source (64-bit) and click on the Drivers tab. Make note of the MySQL Driver name, in this screenshot it's 'MariaDB 3.0 Driver(x64).' Yours may vary depending of the version of the MariaDB driver that you install. Note try to match your driver name with your ODBCINST.ini

     

    CONFIGURATION

     

    1. Create a Copy of the MySQL template.
    2. Expand the first component to test with.
    3. Edit the Connection String and insert Driver={} with the name of the MariaDB Driver you noted in step 3 of prerequisites.
    4. Make sure you define Credentials for monitoring too, those would be a MariaDB user.
    5. Important in Maria DB use information_schema

     

    TESTING ERROR

    1. When I try to use some performance queries doesn't work with mariaDB and I got test failed unknown
      • Try to change the Sql query to SELECT 1
    2. Data source name not found, and no default driver specified, when this happen make sure that your Driver name from your connection String is the same that you have in your Data base server.