Install new Portalman in API Portal CR3 and above

Document ID : KB000077239
Last Modified Date : 23/04/2018
Show Technical Document Details
Introduction:
There is a newly written Portalman to help increase with some of the performance of on-prem API Portal.
Instructions:
If you aren't on CR3 or above, after you upgrade to one of these, you have to enable the new portalman to use JDBC instead (it’s not the default).

1. Login to your API Gateway via Policy Manager

2. Create a JDBC connection with the following details:

Connection Name: Local
Driver Class: com.l7tech.jdbc.mysql.MySQLDriver
JDBC URL: jdbc:mysql://<Primary DB Server Hostname-OR-IPaddy>,<Secondary DB Server Hostname-OR-IPaddy>:3306/ssg
Username: gateway
Password: <gateway user password set during initial setup>

3. Click “Test” button to ensure your configuration is valid

4. Open line 355 of the portalman policy (Perform JDBC Query Assertion) and set the drop down to:
JDBC Connection = Local

5. Save and Activate the policy.

6. Go to "Manage Cluster-Wide Properties" and create a new cluster-wide property named:
portal.useJDBCToQueryAPIs
and set the value to: true

***Note: make sure there isn't any white space in the cluster-wide property name or value***

7. Test the API Portal by going to Dashboard > APIs and ensure that you're getting a list of APIs returned.