Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

You must download and install the MySQL Connector/J drivers in a specific location.

Copying the MySQL JDBC driver in case of a new installation

Copy the MySQL JDBC driver to the RMsis home directory.

  1. Download the latest version of MySQL Connector/J driver from the following URL: MySQL Connector/J 8.0 driver (MySQL Connector/J driver v8.x works with MySQL Database v5.x as well as MySQL Database v8.x)

  2. Untar/Unzip the downloaded file and find the mysql-connector-j-8.x.x.jar file.

  3. Copy the MySQL Connector/J driver(Jar file) to the following directory:

    <Jira-home-directory>/rmsis/libs

Note for copying the MySQL JDBC driver while upgrading from RMsis v2.x to v3.x

If you are upgrading RMsis from RMsis v2.x to v3.x, you may get the error “Database connection failed.“ after copying the database driver.

Explanation

  • This issue occurs due to caching of data regarding database drivers which was used with RMsis v2.x.

    • Please note that the database drivers were changed in RMsis v3.x

    • Earlier MariaDB driver was bundled with RMsis, now MySQL drivers are required.

MySQL Connector/J v5.x is not supported. It will fail to connect with RMsis and show the error “Database connection failed.“ If you are using MySQL 5.x, you must use MySQL Connector/J v8.x with it.

According to Changes in the Connector/J API "The name of the class that implements java.sql.Driver in MySQL Connector/J has changed from com.mysql.jdbc.Driver to com.mysql.cj.jdbc.Driver. The old class name has been deprecated."

Resolution

Please follow the steps mentioned below to fix this issue:

  • Please take a backup of your RMsis database which can be restored later.

  • Shutdown Jira+RMsis server.

    • This is necessary to remove the cached data regarding database drivers.

  • Delete the jdbc.properties file from <jira_home>/rmsis/conf directory.

  • Download the MySQL Connector/J driver (v8.x only) and place the Jar file in <Jira-home-directory>/rmsis/libs directory.

    • Create the libs directory if it does not exist.

    • MySQL Connector/J driver v8.x works with MySQL Database v5.x as well as MySQL Database v8.x

  • Start Jira+RMsis server.

  • Switch to the RMsis Configuration [RMsis Menu > RMsis Configuration] page and click on the Re-Configure RMsis button.

    • This will re-initialize the installation/upgrade process.

    • Your existing data will remain preserved, it will only update RMsis configuration details.

  • When prompted for the database details, insert the details of your existing database.

  • Complete the upgrade process.

  • No labels