Page Comparison

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

...

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

...

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

...