Troubleshooting
Problem
When connecting to a MySQL 5.7.x data source using JDBC in Cognos Analytics 11.2.1 or higher, the connection fails with the following error:
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
No appropriate protocol, may be no appropriate cipher suite specified or protocols are deactivated.
No appropriate protocol, may be no appropriate cipher suite specified or protocols are deactivated.
Cause
This problem is caused by the security changes in the JRE that comes with 11.2.1. In this version of Java, the TLSv1.0 and TLSv1.1 protocols are disabled by default.
When connecting to MySQL 5.7.x using older MySQL JDBC drivers (pre version 8.0.26), the driver will attempt to connect using TLSv1.0 or TLSv1.1 unless explicitly told not to. This will fail since these protocols are disabled by the JRE.
Resolving The Problem
Use the Connector/J 8.0.26 JDBC driver or higher for MySQL. For Connector/J 8.0.26 and later, the TLSv1 and TLSv1.1 protocols have been deprecated so TLSv1.2 will be used.
Please consult MySQL's documentation (linked in the Related URL section below) for more information.
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration->Data Sources"}],"ARM Case Number":"TS007620898","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.1"}]
Was this topic helpful?
Document Information
Modified date:
07 December 2021
UID
ibm16524298