Page Comparison

RMsis requires it's own independent database. This section contains instructions for setting up all the supported versions of Databases.

...

• You can follow the steps mentioned below to securely connect RMsis to a SQL Server database :
  • Switch to the database configuration page RMsis Menu > RMsis Configuration > Database Configuration
  • Select MS-SQL (Microsoft Driver) from the drop down menu while selecting Database Type.
  • 
  • Fill appropriate values for other fields in the database configuration page (as mentioned above in this page) and click on TEST AND SAVE CONFIGURATION page.
  • Once the configuration is saved, stop JIRA. This will stop RMsis as well. 

    • Kill all processes related to JIRA / RMsis (they are typically named as Tomcat*, java). 

    • This is important because sometimes stopping JIRA does not terminate all the processes.

    • Detailed description about killing RMsis is available at: https://docs.optimizory.com/x/iA_7

  • Locate <JIRA_HOME>/rmsis/conf/jdbc.properties file.

    • The contents of the file will be similar to:

      db.name=rmsisDbName

      jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

      jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name}

      jdbc.username=sa

      jdbc.password=sa123

      hibernate.dialect=org.hibernate.dialect.SQLServerDialectSQLServer2005Dialect

      jdbc.dataSourceClassName=com.microsoft.sqlserver.jdbc.SQLServerDataSource

    • Add the desired additional parameters to the jdbc.url. For example, in order to add HTTPS/ SSL, append encrypt=true;trustServerCertificate=true; to the existing URL.

    • The updated file will be

      db.name=rmsisDbName

      jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

      jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name};encrypt=true;trustServerCertificate=true;

      jdbc.username=sa

      jdbc.password=sa123

      hibernate.dialect=org.hibernate.dialect.SQLServerDialectSQLServer2005Dialect

      jdbc.dataSourceClassName=com.microsoft.sqlserver.jdbc.SQLServerDataSource

  • Save the contents of <JIRA_HOME>/rmsis/conf/jdbc.properties file.

  • Restart JIRA. This will automatically start RMsis with the updated configuration.

...

Currently, RMsis supports Oracle 11G and later versions.

Database Setup using Oracle

• Ensure that you have a database instance available for RMsis (either create a new one or use an existing one).
• Within that database instance, create a user which RMsis will connect as (e.g. rmsisuser).
  • create user <rmsisuser> identified by <user_password> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;
  • Notes :
    • When you create a user in Oracle, Oracle will create a 'schema' automatically.
    • When you create a user, the tablespace for the table objects must be specified.
• Ensure that the user has the following permissions:
  • grant connect to <rmsisuser>;
  • grant create table to <rmsisuser>;
  • grant create sequence to <rmsisuser>;
  • grant create trigger to <rmsisuser>;

Database Configuration for Oracle

...