Connection to the registry database cannot be established

Products

• Service Virtualization

Issue/Introduction

Cannot connect to the Registry DB from Workstation.  Getting this Error from Workstation when Registry database is MySQL:

Connection to the registry database cannot be established. Please make sure the database is running and the credentials used to connect to the database is valid. Data will not be saved to the database. This will impact your reports. Do you want to continue?  

Environment

All Supported release and platforms of DevTest.

MySQL Database

Cause

Did a telnet to the server where MySQL is running, which is where the Registry is running, and the server is not allowing the Workstation to connect to the database. The MySQL is allowing only localhost connections, is not allowing to start Registry with either an IP or hostname in the JDBC URL connection string.

 

Can also get this message if the port to the Registry database is not open, regardless if MySQL.

Resolution

Allow MySQL instance to accept connections from any host.  NOTE: also make sure the MySQL Instance is case insensitive.

 

For other databases need to make sure the database ports are open from the Workstation.

Additional Information

Starting with DevTest 10.8.0 and later, these messages can be suppressed with uncommenting the below property in the site.properties file of where the Registry is running:

##lisadb.workstation.enabled=false

The Registry will have to be restarted.

There is an impact setting this property to false:

When site.properties is updated with lisadb.workstation.enabled=false, the Workstation will not connect to the remote registry database, and no warning message is displayed for the database driver. Note that any tests or test suites run locally on the workstation (for example, quick stage a test or quick stage a test suite) will not be sent to the registry database without a workstation connection and, therefore, will not display in Monitor tests.