LI82869: DISABLE THE SSL IN STUDIO DATABASE ENDPOINT FOR MYSQL

App Connect Professional V7.5.5.0 cumulative ifix 031 for docker
App Connect Professional V7.5.5.0 cumulative ifix 031 docker image
App Connect Professional V7.5.5.0 cumulative ifix 031 Secure Connector 64bit upgrade for Windows
App Connect Professional V7.5.5.0 cumulative ifix 031 Secure Connector 32bit upgrade for Windows
App Connect Professional V7.5.5.0 cumulative ifix 031 Secure Connector 64bit upgrade for linux
App Connect Professional V7.5.5.0 cumulative ifix 031 Secure Connector 32bit upgrade for linux
App Connect Professional V7.5.5.0 cumulative ifix 031 for studio
App Connect Professional V7.5.5.0 cumulative ifix 029 for secure connector
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for 32 bit linux
App Connect Professional V7.5.5.0 cumulative ifix 028 for docker upgrade file
App Connect Professional V7.5.5.0 cumulative ifix 028 for docker image upgrade file
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for 32 bit linux
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for Windows
App Connect Professional V7.5.5.0 cumulative ifix 028 for secure connector upgrade file for 32 bit Windows
App Connect Professional V7.5.5.0 cumulative ifix 028 for studio
App Connect Professional V7.5.5.0 cumulative ifix 028 for 32 bit studio
App Connect Professional V7.5.5.0 cumulative ifix 024 for docker upgrade file
App Connect Professional V7.5.5.0 cumulative ifix 024 for studio
App Connect Professional V7.5.5.0 cumulative ifix 024 for secure connector upgrade file for Windows
App Connect Professional V7.5.5.0 cumulative ifix 024 for secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 024 for 32-bit studio
App Connect Professional V7.5.5.0 cumulative ifix 024 for full build docker upgrade file
App Connect Professional V7.5.5.0 cumulative ifix 024 for 32-bit secure connector upgrade file for Windows
App Connect Professional V7.5.5.0 cumulative ifix 024 for 32-bit secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 023 for 64-bit secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 023 for 64-bit studio
App Connect Professional V7.5.5.0 cumulative ifix 023 for 32-bit studio
App Connect Professional V7.5.5.0 cumulative ifix 023 for 32-bit secure connector upgrade file for linux
App Connect Professional V7.5.5.0 cumulative ifix 023 for 64-bit secure connector upgrade file for windows
App Connect Professional V7.5.5.0 cumulative ifix 023 for 32-bit secure connector upgrade file for windows
App Connect Professional V7.5.5.0 cumulative ifix 023 for docker upgrade file
App Connect Professional V7.5.5.0 cumulative ifix 023 for docker full build upgrade file
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.sc-linux.sh
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.sc-win
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.32bit.sc-win
7.5.5.0-WS-ACP-20231218-0812_H8_64-CUMUIFIX-022.studio
7.5.5.0-WS-ACP-20231218-0812_H8_64-CUMUIFIX-022.32bit.studio
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.docker
7.5.5.0-WS-ACP-20231222-0455_H31_64-CUMUIFIX-022.builtDockerImage
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.docker
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.sc-linux.sh
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.builtDockerImage
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.sc-win
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20230726-1453_H30_64-CUMUIFIX-021.32bit.sc-win
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.sc-linux.sh
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.docker
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.builtDockerImage
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.sc-win
7.5.5.0-WS-ACP-20230725-0508_H30_64-CUMUIFIX-021.32bit.sc-win
7.5.5.0-WS-ACP-20230725-0510_H8_64-CUMUIFIX-021.studio
7.5.5.0-WS-ACP-20230725-0510_H8_64-CUMUIFIX-021.32bit.studio
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.docker
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.builtDockerImage
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.sc-linux.sh
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.sc-win
7.5.5.0-WS-ACP-20230621-1153_H8_64-CUMUIFIX-020.studio
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20230621-1152_H30_64-CUMUIFIX-020.32bit.sc-win
7.5.5.0-WS-ACP-20230621-1153_H8_64-CUMUIFIX-020.32bit.studio
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.sc-win
7.5.5.0-WS-ACP-20230328-1650_H8_64-CUMUIFIX-019.studio
7.5.5.0-WS-ACP-20230328-1650_H8_64-CUMUIFIX-019.32bit.studio
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.sc-linux.sh
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.32bit.sc-win
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.docker
7.5.5.0-WS-ACP-20230328-1650_H31_64-CUMUIFIX-019.builtDockerImage
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.docker
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.builtDockerImage
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.sc-linux
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.32bit.sc-linux.sh
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.sc-win
7.5.5.0-WS-ACP-20230118-0619_H8_64-CUMUIFIX-018.studio
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.32bit.sc-win
7.5.5.0-WS-ACP-20230118-0619_H8_64-CUMUIFIX-018.32bit.studio
7.5.5.0-WS-ACP-20230118-0949_H30_64-CUMUIFIX-018.vcrypt2

APAR status

• Closed as new function.

Error description

• MySQL default will be SSL enabled and if we are not using then
  we need to disable SSL in ACP.
  Need to set the useSSL under additional properties in Studio
  Database Endpoint for MySQL 8.x. to disable the SSL.
  
  MYSQL 8.x onwards useSSL property enabled as true by default.
  
  For reference check the below doc
  https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-connp-p
  rops-security.html
  

Local fix

Problem summary

• DISABLE THE SSL IN STUDIO DATABASE ENDPOINT FOR MYSQL.In MYSQL
  8.x onwards Server enabled SSL as default.
  

Problem conclusion

• App Connect Professional introduced useSSL property in MYSQL
  Connection String.Customers need to add useSSL=false in App
  Connect Professional DB Endpoint for MYSQL for non-SSL
  connection.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  APP CONNECT PRO

• Fixed component ID

  5737B8200

Applicable component levels