How can I execute a MySQLDebug.bat / MySQLDebug.sh file?

How can I execute a MySQLDebug.bat / MySQLDebug.sh file?

This file is used to check if the connectivity and the Discovery of the MySQL Server is possible from the Applications Manager installed server.  This standalone program is a excerpt of the same process we use to add the MySQL Server monitor. The usage to run this file is as below

Via command prompt goto AppManager/bin/troubleshooting directory and execute the MySQLDebug file with the usage below.

Usage: MySQLDebug.bat [HostName / Ip] [Port Number] [Database Name]  [Username] [password] [useSSL] [apmkeystore password]

[HostName / Ip]                      HostName or Ipaddress of the machine where MySQL server is running
[Port Number]                         Port number of the MySQL server
[Database Name]                   Database Name for connecting to the MySQL server
[Username]                             User name for connecting to MySQL
[Password]                              Password for connecting to MySQL. If no password enabled, leave it as blank
[useSSL]  useSSL is true if the MySQL server is configured for forceful SSL authentication. It will be false for the respective MySQL server's default SSL behavior.
[apmkeystore password]  APM Keystore password is required if useSSL is true to verify the certificates which are used to make a secure connection.

This will initiate the process to discover the MySQL Server and on success will also fetch the data for the default attributes monitored and shown as the output.  From this, you will be able to find If discovery is possible If data is returned for all attributes or not.  In case there is any issue for an attribute data it'll be shown as null.  This infers that the data is not available in that server and has to be checked on the MySQL installed server.

For more info or assistance, do send us the output of the above command for analysis along with Support Information File.


          • Related Articles

          • How to execute ServerSSHTroubleshoot.bat or sh file ?

            Solution: Execute the file ServerSSHTroubleshoot.bat or sh from the <AppManager_home>\bin\troubleshooting folder (<AppManager_home>\bin in older versions of Applications Manager). Via command Prompt Execute the ServerSSHTroubleshoot.bat or sh file. ...
          • How to execute ServerSSHTroubleshoot.bat or sh file ?

            Execute the file ServerSSHTroubleshoot.bat or sh from the <AppManager_home>\bin\troubleshooting folder (<AppManager_home>\bin in older versions of Applications Manager). Via command Prompt Execute the ServerSSHTroubleshoot.bat or sh file. It will ...
          • How can I execute UpdateHostnameandIP.bat/sh ?

            Here are the steps to execute UpdateHostnameandIP.bat/sh: 1) Execute <AppManager_Home>\bin\troubleshooting\UpdateHostaneandIP.bat/sh file. For example,  updateHostNameAndIp.bat/sh [Previous HostName/IpAddress] [new HostName/IpAddress] ...
          • How can I execute the popTest.bat / popTest.sh file?

            This file is used to check if the connectivity and the Discovery of the POP Server is possible from the Applications Manager installed server.  This standalone program is a excerpt of the same process we use to add the POP Server monitor. The usage ...
          • How can I execute a SharePoint.bat / SharePoint.sh file?

            This file is used to check if the connectivity and the Discovery of the Sharepoint Server is possible from the Applications Manager installed server.  This standalone program is a excerpt of the same process we use to add the Sharepoint Server ...