Invalid API KEY when calling policy

Products

• CA API Gateway

Issue/Introduction

A "No connections available for 'OAuth'" message was seen in the SSG logs, causing an 'Invalid_api_key' error from Postman.

Environment

API Gateway 10.1, 11.X

Cause

WARNING 569 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since No connections available for 'OAuth' No connections available for 'OAuth'
WARNING 569 com.l7tech.external.assertions.jdbcquery.server.ServerJdbcQueryAssertion: 9104: "Perform JDBC Query" assertion failed due to: Cannot retrieve a C3P0 DataSource: No connections available for 'OAuth' No connections available for 'OAuth'
WARNING 569 com.l7tech.server.message: Message was not processed: Assertion Falsified (600)

Resolution

1. Log into the server where you can access the OTK DB and execute a statement like this: mysql -u otk_user -p otk_db -e "show tables;"

2. Log in to the Policy Manager and go to Tasks > Data Sources > Manage JDBC Connections

3. Go to the JDBC connection the for the OTK DB and select the "Test" Button

4. Change the hostname in JDBC URL from localhost to the IP address

The user will be granted proper permissions to access the Gateway DB.