WARN: Establishing SSL connection without server's identity verification is not recommended

WARN: Establishing SSL connection without server's identity verification is not recommended

Summary

This articles provides a resolution for the warning: Establishing SSL connection without server's identity verification is not recommended.

Symptoms

WARN: Establishing SSL connection without server's identity verification is not recommended


Cause

MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requires SSL connections to be established by default if the option is not explicitly set.


Resolution

?For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false or set useSSL=true and provide truststore for server certificate verification.

To resolve this warning, follow these instructions:

  1. Modify the following core database configuration file:

    $palamida/config/core/core.db.properties
  2. Edit the db.url= line to append "&useSSL=false" as shown below without any spaces.

    db.url=jdbc:mysql://localhost:3306/palamida_6_10?autoReconnect=true&useSSL=false

Restart the server and error should go away.

If the installation of the database server is over SSL, then this setting needs to be changed to true.

Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Nov 06, 2018 06:19 PM
Updated by: