Page Comparison

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

Info

title	Important note regarding Unicode support

A word before you start your DataBase Configuration ...

Please make sure that you create Unicode compliant database, so that you will not need an explicit migration anytime in future.
The suggested MySQL example in next section, creates a UTF-8 compliant Database.
Regarding SQL Server, please refer to the Atlassian Guide for suggestions on configuring the character encoding.

Embedded H2 Database

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.

...

Caution :

...

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.
Create a database to store RMSis data. Use any name for it. Example - "rmsis".
Create a database user and assign permissions to this user to access the database created above.
Exit MySQL

...

Currently, RMsis supports Oracle 11G and later versions.

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>;

Attribute	Value
Database Type	select "Oracle"
Hostname	Enter hostname or the IP address of the database
Port	TCP port number of the database server (by default 1521 for Oracle)
Database	Enter the name of the database/SID to connect (The Oracle "System Identifier". The default value for most Oracle servers is 'ORCL'. If you are using the Oracle Express Edition, this will be 'XE'.)
Username	Enter username to access the database
Password	Password to access the database.

...

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.

Panel

Caution :

Please use H2 embedded Database only for evaluation and it is not recommended for use in a production system.
Use of H2 Database in RMsis connected with a large JIRA deployment (large number of issues, projects and users) may cause deadlock errors in H2, posing serious problems to RMsis usability.
Support for H2 Database is likely to be discontinued in near future.