MySQL
Resolving MySQL Authentication Issues related to caching_sha2_password
The following errors are commonly encountered while connecting to MySQL databases: Public Key Retrieval is not allowed. Client does not support authentication protocol requested by server.plugin type was-'sha256_password'. RSA public key is not ...
How to resolve Table 'performance_schema.global_status' doesn't exist error?
This error may occur because the MySQL user given in Applications Manager for monitoring lacks SELECT privileges on performance_schema. To fix this error, ensure performance_schema is enabled and grant SELECT on performance_schema.* to the user. ...
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?
For MariaDB Server Go to AppManager UI --> Settings --> Manage Certificates --> Trust Certificates --> Keystore/Truststore --> Select cacerts Restart Applications Manager to verify SSL connectivity while using the MariaDB monitor. For MySQL DB Server ...
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 ...