HTTP route configuration and URLs - table and column in SSG database
search cancel

HTTP route configuration and URLs - table and column in SSG database

book

Article ID: 139029

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

I am  working on a service to list the endpoint URLs in the route configuration for each service configured on the CA API gateway.

I need to know the table name from where I can fetch the details, also, it would be great help  you can point me to a document  for the mapping of the configurations and the ssg database.



Environment

Release : 9.2

Component : API GTW ENTERPRISE MANAGER

Resolution

Provide a sample policy when imported and setup for your environment will display all Service names and corresponding Routing URLs




Additional Information

 

When accessed browser will prompt for creds, use JDBC connection “localhost” then display service name and routing URLs

 

How to:

Need to create JDBC connection to localhost ssg database (NOTE name used in policy is localhost)

 

Connection Name: localhost

JDBC URL: jdbc:mysql://localhost:3306

User name: gateway

Password: xxxxxxxx

 

Create new service /RoutingURls, then import the sample-policy.xml  

 

MUST be access SSL, then provide the gateway ID/PW used in policy manager 

 

https://FQDNHost:8443/RoutingURls

 

Sample Results page 

 

 

Service Name

Routing URLs

Validate1

http://<Server Name Host><Domain>.net

Validate5

http://<Server Name Host><Domain>.net

Route-3

${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}, ${gateway.DM_host}${request.http.uri}${request.url.query}

Route-2

http://<Other Server Name Host><Domain>.net:81/site1

 



 

Attachments

1571932973082__RoutingURls.xml get_app