search cancel

No database connections open after 30 seconds; possible DB connection failure?

book

Article ID: 214713

calendar_today

Updated On:

Products

CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)

Issue/Introduction

Hi we are having issue with our gateway server -its starting with the error below and we cannot get it to work. 

We initially did a jdk upgrade, but had to revert it but still - the error persisted.

2021-05-04T15:31:27.564-0400 INFO    1 com.l7tech.server.boot.GatewayBoot: Starting CA API Gateway 9.4.00 build 8872, built 20181012143850 by teamcity at apim-teamcityagent19
2021-05-04T15:31:27.585-0400 INFO    1 com.l7tech.server.boot.GatewayBoot: Database type: mysql
2021-05-04T15:31:27.588-0400 INFO    1 com.l7tech.server.boot.GatewayBoot: Starting gateway in TRADITIONAL mode
2021-05-04T15:31:27.590-0400 INFO    1 com.l7tech.server.boot.GatewayBoot: Enabled component: [com/l7tech/server/resources/uddiRuntimeContext.xml, com/l7tech/server/resources/uddiAdminContext.xml, com/l7tech/server/resources/databaseReplicationMonitorRuntimeContext.xml, com/l7tech/server/resources/databaseReplicationMonitorAdminContext.xml, com/l7tech/server/resources/processControllerRuntimeContext.xml, com/l7tech/server/resources/processControllerAdminContext.xml]
2021-05-04T15:31:57.588-0400 SEVERE  11 com.l7tech.server.boot.GatewayBoot: WARNING: No database connections open after 30 seconds; possible DB connection failure?

 

Environment

Release : 9.4

Component : Integration with APM

Resolution

The issue is in the disabled jdk.tls.disabledApgotithms this was confirmed by view the /var/log/mysqld.log - SSL handshake errors 

java.security change needed 

jdk.tls.disabledAlgorithms=SSLv3, TLSv1, TLSv1.1, RC4, DES, MD5withRSA, \

    DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \

    include jdk.disabled.namedCurves

TO

jdk.tls.disabledAlgorithms=SSLv3, TLSv1, RC4, DES, MD5withRSA, \

    DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \

    include jdk.disabled.namedCurves