Getting error "The server name in the certificate (xxx) does not match the value specified in the hostNameInCertificate connect option" when connecting to SSL enabled database Server

Getting error "The server name in the certificate (xxx) does not match the value specified in the hostNameInCertificate connect option" when connecting to SSL enabled database Server

book

Article ID: KB0071055

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 7.3.1

Description

The TIBCO ActiveMatrix BusinessWorks Plug-in for Database is failed to start with the following error when connecting to an SSL enabled database server:
=======================================================
The server name in the certificate (xxx) does not match the value specified in the hostNameInCertificate connect option.
=======================================================

The above error occurs when the driver has failed to validate the server certificate. It is more common after migrating to the TRA 5.12 due to the SSL changes in JRE 11.

Issue/Introduction

Getting error "The server name in the certificate (xxx) does not match the value specified in the hostNameInCertificate connect option" when connecting to SSL enabled database Server

Environment

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database Version:7.3.1 OS: All Supported Operating Systems

Resolution

To resolve the above problem, the user can add "HostNameInCertificate=xxx" to the JDBC URL to specify the host name or add "ValidateServerCertificate=false" to the JDBC URL to disable the validation of the server certificate.