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.