Warning SSL MySql connection errors in API gateway logs
search cancel

Warning SSL MySql connection errors in API gateway logs

book

Article ID: 138479

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

After migrating our production platform API Gateway from 9.3 CR2 to 9.4 CR3. we see the log filled with . 

WARNING 77 STDERR: Fri Oct 11 08:17:00 CEST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. 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.


 

Environment

Release : 9.4

Component : API GTW ENTERPRISE MANAGER

Resolution

Please ensure that your etc/my.cnf contains # Comment 'skip_ssl' to enable SSL. skip_ssl

If that is set, please check on all MySQL data sources under Policy Manager -> Tasks -> DataSources -> JDBC

That the connection string contains verifyServerCertificate=false&useSSL=false

It must look like JDBC URL: jdbc:mysql://localhost:3306/ssg?verifyServerCertificate=false&useSSL=false