VSE servers not displayed in the Reports

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

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. 


All supported DevTest releases

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. 


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]


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


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