VSE servers not displayed in the Reports

Document ID : KB000008922
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.