Failed to connect to jdbc:mysql

Issue:

The NexOSS application cannot connect to the database. A SQLException message is logged. An email alert is sent.

Log message:

SQLException: Failed to connect to jdbc:mysql://<db_ip>/<db_name> as <user> and <password>

Troubleshoot:

NexOSS connection to a remote database can fail for the following reasons;

  1. Network issue
  2. The remote server is down
  3. The server is up but the database is down.