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.
- Client does not support authentication protocol requested by server.
- Communication link failure, message from server: "Got packets out of order."
Solution: To update the latest mysql connector, follow these steps:
- If the .jar file is not present, you can download it from here (for MYSQL versions older than 5.6) or here (for MYSQL version 5.6 and newer).
- Rename the file as mysql_connector.jar
- In the machine where Applications Manager is running, copy the downloaded mysql_connector.jar to AppManager_home/working/mysql/MMMySQLDriver/ directory.
- Restart Applications Manager.
If MySQL server configured with 'SSL configuration' or MySQL server hosted on any cloud service then make sure to use of latest mysql_connector.jar.
New to ADSelfService Plus?
Related Articles
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 ...Unable to upgrade Applications Manager - MySQL Deprecation
Problem: You encounter the following error while trying to install service pack for Applications Manager v16140 and above: Reason: This error occurs because MySQL backend database has been deprecated in Applications Manager. Solution: You have to ...Upgrade guide for OpManager v 12.7 and APM Plugin
After downloading the service pack for OpManager and the compatible service pack for Applications Manager Plugin (APM Plugin) to OpManager installed server, start the upgrade process for OpManager and APM Plugin by following the steps below: Note: If ...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 ...How to fix "Connections using insecure transport are prohibited while --require_secure_transport=ON" in MySQL?
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Reason: This error occurs when the user is trying to add a SSL-supported monitor(i.e --require_secure_transport option enabled) as a non-SSL ...