Page Comparison

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

...

...

MySQL

1. Open a unix terminal or a windows command prompt whichever is relevant to you. And login to MySQL database using the command line client that is shipped with the MySQL. Use "root" (administrator) credentials to login.
2. Create a database to store RMSis data. Use any name for it. Example - "rmsis".
3. Create a database user and assign permissions to this user to access the database created above.
4. Exit MySQL

$ mysql -uroot -ppassword
mysql> create database rmsis character set utf8 ;
mysql> grant all on rmsis.* to 'username'@'hostname' identified by 'new_user_password';
mysql> exit;

Note (known issue) :

• Mysql database only supports 3 byte UTF8 characters if the default 'utf8' character set is chosen.

• For 4byte UTF8 support, 'utf8mb4' character set needs to be chosen in Mysql. However, 'utf8mb4' character set is not supported by RMsis at present.

• This issue is logged as RMI-3474 in our CRM.  

• Due to this issue, you may experience unexpected behaviour and/or failure to access RMsis if a 4 byte UTF8 character is entered in a field in RMsis.

PostgreSQL

1. Create a database user which RMsis will connect as (e.g. rmsisdbuser). This user will be used to configure RMsis's connection to this database in subsequent steps.

2. Create a database for RMsis (e.g. rmsis) with Unicode collation.

    

   Code Block
   CREATE DATABASE rmsis WITH ENCODING 'UNICODE';

   Or from the command-line:

   Code Block
   $ createdb -E UNICODE rmsis

   
   

3. Ensure that the user has permissions to connect to the database, and to create and write to tables in the database.

...

• Specify Database Connection : External
• Database Type : MS-SQL
• Hostname : <Hostname or the IP address of the database>
• Port : 1433 <TCP port number of the database server>
• Database : <RMsis_Database_Name>;instance=<Instance_name>
• Username : <Username to access the database>
• Password : <Password to access the database>
  Image Removed
  Image Added
• The above settings can also be used when using named instances in SQL Server on dynamic port. Please make sure that SQL Server Browser Service is running if you are using dynamic port.

Securely connect RMsis to a SQL Server database (Connecting to SQL Server database using SSL)

• 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.
  • Image Added
  • 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.SQLServer2005Dialect

      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.SQLServer2005Dialect

      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.

Connecting RMsis to Oracle

...

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

  
Image RemovedImage Added

Embedded H2 Database

Note : H2/ internal database has been discontinued from RMsis 1.8.9.2.

From version 1.3.0 onwards, RMsis is shipped with H2 as embedded database. This can be configured during the process of RMsis application deployment.

...