Database Setup
For RMsis 1.3.0 onwards
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.
| Panel |
|---|
Caution : Please use H2 embedded Database only for evaluation and it is not recommended for use in a production system. |
For all versions of RMsis
MySQL
- 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
| Code Block |
|---|
$ mysql -uroot -ppassword
mysql> create database rmsis;
mysql> grant all on rmsis.* to 'username'@'hostname' identified by 'new_user_password';
mysql> exit;
|
Microsoft SQL Server 2005 / 2008
...
Microsoft SQL Server Authentication Modes
...
- If you want to connect RMsis with MSSQL database running using windows authentication mode,
- then leave the username and password fields blank while configuring RMsis database during RMsis installation.
- Make sure that the logged in user of windows machine (on which RMsis server is running or will run) has required credentials for RMsis database.
- Download the SQL Server JDBC driver (v1.2.4) from JTDS and place the ntlmauth.dll (shipped with jtds driver) file in the system path
...
| Include Page | ||||
|---|---|---|---|---|
|