Important: Due to MySQL limitations, the projects_root directory should not be located on NFS. It has a special file locking implementation which is not fully supported by MySQL. See also the warning in the MySQL documentation.

If you see the following error:

Error occurred while connecting to database: Database connection to <database> refused: Communications link failure due to underlying exception

Check the host name in the error message. If the host name is not a fully qualified host name that includes the domain (for example, server1.klocwork.com), you need to set the fully qualified domain name for the Database Server.

To do this:

Stop the Database Server:

kwservice --projects-root <projects_root> stop database

Run the following command:

kwservice --projects-root <projects_root> set-service-property database host <fully-qualified-host-name>

For example:

kwservice --projects-root C:\Klocwork\projects_root set-service-property database host server1.klocwork.com

Start the Database Server:

kwservice --projects-root <projects_root> start database