MySQL
How to fix "Communication link failure The last packet sent successfully to the server"?
Issue: Communication link failure error message will trigger based on many reasons. Solution: Communication link failure error message is shown due to various reasons. Follow any of the steps mentioned below to resolve the issue: Insufficient user ...
How to view data under Session & Performance tab in MySQL monitor?
Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
How to install Sys Database on Maria DB Server?
Issue: Solution: Download the MariaDB-sys from the GitHub using this link Extract the downloaded zip. Based on your MariaDB version open the corresponding file [ sys_56.sql, sys_57.sql, sys_10.sql ] Change all the relative path entries to static path ...
How can I upgrade the MySQL connector.jar?
For all the following issues mentioned below, the solution is same. Invalid authorization specification message from server. Unknown character set index for field '255' received from server. Communication link failure: javax.net.ssl.SSLException. ...
How to import certificates for monitoring MariaDB/MySQL DB Server with SSL authentication?
To monitor the MariaDB/MySQL, the respective MariaDB or MySQL driver must be utilized. In Applications Manager, the required driver can be selected in the Monitor Add/Edit page. MariaDB Driver connection If the monitor was added using MariaDB for ...
How to fix "SSL Connection required, but not supported by server"?
Error Message: SSL Connection required, but not supported by server Reason: This error occurs when you are trying to add a server as SSL enabled but the server is not configured to use SSL. Solution: To overcome this issue: Solution 1: Configure SSL ...
Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Solution: To overcome this issue follow the steps given below: Execute the following query in the corresponding MySQL shell script: ALTER USER ...
How can I prevent false "Monitor down" alerts on a slow network?
Solution: For a problematic MySQL Monitor or a monitor over a slow connection, you can increase the count of consecutive Polls to try. Applications Manager will check the configured number of consecutive polls before generating an Alert. Go to ...
How to fix "Client does not support authentication protocol requested by server; consider upgrading MySQL client"?
Error Message: Data source rejected establishment of connection message from server: "Client does not support authentication protocol requested by server; consider upgrading MySQL client Reason: The Client does not support authentication protocol ...
When adding a new MySQL monitor, i get a message "The MySQL Server is not accessible from the Applications Manager Server host.Kindly add permissions ..."
Reason: In the MySQL database (that you are trying to monitor), the user name used to run Applications Manager should have the permission to access the MySQL database from the host where Applications Manager is running. Solution: A relevant user who ...