Invalid API KEY when calling policy

Products

• CA API Gateway

Issue/Introduction

No connections available for 'OAuth' No connections available for 'OAuth' was coming in SSG logs,causing Invalid_api_key error from postman

Environment

Gateway 10.1 , 11

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 machine and execute a statement like this: mysql -u otk_user -p otk_db -e "show tables;"

2/ Then - in the PM and for the OTK DB - select the "Test" Button

3. the jdbc url from localhost to ip and then the user gateway was granted proper permission to access the Gateway db  to solve the issue .