VSE servers not displayed in the Reports

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

Customer has the below configuration :

Registry, Portal and VSE are on Server1   and  Remote VSE on  Server 2. 

Database is  MYSQL 5.7 configured on Server1 , and customer has  mysql-connector-java-5.1.40-bin.jar  on both Servers. 

When you look at the VSE Metric Reports,  we see that local VSE is listed in the list of VSE's  but not the Remote VSE. 

 

 

Environment

All supported DevTest releases

Cause

In the site.properties file on the Registry server,  the connection strings were set to  localhost  for the hostname of mysql server. 

 

## lisadb.pool.common.driverClass=com.mysql.jdbc.Driver

## lisadb.pool.common.url=jdbc:mysql://localhost:3306/[DBNAME]

## lisadb.pool.common.user=[USER]

## lisadb.pool.common.password=[PASSWORD]

 

As a result the remote server could not connect to the database. 

Resolution

Replace the Hostname  for the connection string with the <IP address> of the MYSQL database server in your site.properties file. 

 

## lisadb.pool.common.url=jdbc:mysql://localhost:3306/[DBNAME]

to

## lisadb.pool.common.url=jdbc:mysql://<IPaddress>:3306/[DBNAME]

 

After the change,  the remote VSE was shown in the VSE Metric selection list.