Share This:

The RSSO application needs to have its own database to function, some of the tables in this database will hold data for authentications such as SAML, LDAP and AR server as well as tables for user sessions and local internal users.

 

There are two ways to create the RSSO database

  • Let the installer create the database/tables (Preferred method)
  • Pre-Create the RSSO_USER user & database before running the installation

 

 

Letting the installer create the tables

 

Create New User Option

The preferred & quickest method of creating the database is to let the installer create the database, for this you will need a privileged account such as "sa" for MSSQL or "system" for Oracle

This account is only used during the installation and will not be required or used again. If possible during the user input portion of the installation ask the DBAs to enter in a privileged account user name & password if they can not share the account details with you (which is usually the case), so its best to have them at hand to enter in the database and password.  This is the fastest and most efficient way to run the RSSO installer. We need a privileged account to create the database, tables and the RSSO database user "RSSO_USER".

During the install you will be asked for the privileged account  when the "Create New User" option is selected (fig1)

 

Fig1. Showing Create new user (for Oracle)

 

Use Existing User Option

Another option you have is to ask the DBA to pre-create the "RSSO_USER" account in the database and use the "Use Existing User" option during the install.

 

For MSSQL: Ask the DBA to create the "RSSO_USER" user and the container database "rsso" its easier to create the container DB along with the user and make the "RSSO_USER" the owner of the "rsso" database, which in turn will give the user "dbo" access to the database (Schema) (fig2). The DBA will need to provide you with the user name, password and database name (in this case "rsso")

 

Fig2. Shows the RSSO_USER and the RSSO database configuration

 

For Oracle: Ask the DBA to create the "RSSO_USER" account in oracle with CONNECT & RESOURCE roles, "Unlimited Quota for the default user table space"  with "Password Expired" not selected (fig3). The DBA will need to provide you with the username, password, SID or Service Name, you will use this as the "SID" or "Service Name" during the install.

 

Fig3. Shows the user creation for the "RSSO_USER" in oracle along with the granted roles

 

After the RSSO_USER has been created, select the "Use Existing User" Option during the RSSO install. The installer will then create the tables for RSSO (fig4)

 

Fig4. Shows oracle used as the database and "Use Exiting User Option" selected for install

 

 

Pre-Creating User & Database Tables Before the Installer Runs

In some environments the only option available is to pre-create the database due to global policies. RSSO provides the files needed to create the database before running the installer. When the install run's it will connect to the DB for verification and only deploy the system files. The following procedure is a DBA function and these instructions should be sent to the DBA to action.

 

Summary of Steps

  • Copy the Disk1/lib/rsso-database-all.jar file from the installer into a temp directory on the local database
  • Create the RSSO database user
  • Create the database.properties file
  • Execute the rsso-database-all.jar file to create the database

 

NOTE: Its important the rsso-database-all.jar file is from the RSSO version you want to install and not from a previous version, so only use the file from the installer version you have downloaded and get the file from the installer, never use a rsso-database-all.jar that has been sent to you unless instructed to by BMC SUPPORT.

 

You will need java 7 and over to be able to complete this process successfully

 

The first thing we need to do is copy the Disk1/lib/rsso-database-all.jar and place it in a folder on the database. In the same folder create an empty file called "database.properties"

Open the "database.properties" file for edit

 

FOR MSSQL:

 

1. The first thing we need to do is create a database called "rsso" then run the following SQL to create te user and assign RSSO_USER as the DB owner. Change the password to meet your policy (highlighted in red)

 

CREATE LOGIN [RSSO_USER] WITH PASSWORD=N'RSSO#Admin#', DEFAULT_DATABASE=[rsso], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON

GO

ALTER LOGIN [RSSO_USER] ENABLE

GO

USE [rsso]

GO

EXEC sp_changedbowner 'RSSO_USER'; 

 

The database, user name and passwords are all changeable, the above are the default out of the box values.

 

2. Open the database.properties file and place the following lines in, change the file to reflect your environment

 

database-type=MsSql

db-url=jdbc:sqlserver://localhost:1433;instanceName=MSSQLSEVER;databaseName=rsso;

db-user-id=RSSO_USER

db-password=RSSO#Admin#

 

3. Save the file.

4. Open a command prompt and "cd" to the directory you saved the files in

5. confirm java is in the path and is version 7 and over "java -version"

6. Run the following command to begin the process of creating the tables  "java -jar rsso-database-all.jar database.properties"

 

If everything is successful you will see messages indicating that the tables have been created (fig5). Check in Microsoft SQL server Studio for the tables (see fig xx)

 

Fig5.

 

If there are any failures, check the information is correct in the "database.properties" file and the connection to the database, If the problem is still not resolvable contact BMC Support for further advice.

 

FOR ORACLE:

 

1. The first thing we need to do is create the RSSO database (RSSO_USER) user in the database. Run the following SQL to create the user.  Change the password to meet your policy (highlighted in red)

 

CREATE USER RSSO_USER IDENTIFIED BY RSSO#Admin#;

ALTER USER "RSSO_USER" QUOTA UNLIMITED ON USERS;

GRANT CONNECT, RESOURCE TO RSSO_USER;

COMMIT;

 

The database, user name and passwords are all changeable, the above are the default out of the box values.

 

2. Open the database.properties file and place the following lines in, change the file to reflect your environment

 

database-type=Oracle

db-url=jdbc:oracle:thin:@localhost:1521:orcl

db-user-id=RSSO_USER

db-password=RSSO#Admin#

 

3. Save the file.

4. Open a command prompt and "cd" to the directory you saved the files in

5. confirm java is in the path and is version 7 and over "java -version"

6. Run the following command to begin the process of creating the tables  "java -jar rsso-database-all.jar database.properties"

 

If everything is successful you will see messages indicating that the tables have been created (fig6). Check in Oracle Developer for the tables (see fig7)

 

Fig6.

 

If there are any failures, check the information is correct in the "database.properties" file and the connection to the database, If the problem is still not resolvable contact BMC Support for further advice.

 

After the user and tables have been created, the install of RSSO can continue by using the "Use Existing User" option on the installer.

 

Fig7 Shows the creation of the tables for MSSQL & Oracle (version 9.1 SP4 RSSO)