Manually installing Remedy SSO

Task 1: To deploy Remedy SSO on Tomcat web server

1. Install Tomcat.

2. Deploy rsso.war to <Tomcat>/webapps/rsso folder.

Task 2: Manually create a database for Remedy SSO

The database is usually configured through the installer. When you install Remedy SSO by running scripts or automation tools, you must configure the database manually.

Perform one of the following steps to create a database:

CREATE DATABASE "<database>";
CREATE ROLE "<user>" WITH LOGIN PASSWORD '<pwd>';
GRANT ALL PRIVILEGES ON DATABASE "<database>" TO "<user>";
GRANT ALL ON ALL TABLES IN SCHEMA public TO "<user>";

Task 3: To set up a database for Remedy SSO

After you create the database, perform the following steps to set up your database:

1. Copy rsso-database-all.jar  from Disk1/lib to some place on your system,  for example, copy to C:\ directory.

2. Create the database.properties file with the following content:

   database-type=<database_type>
   db-url=<database_jdbc_url>
   db-user-id=<db_user_name>
   db-password=<db_user_password>
   #db-password must be plain text value

   The database-type value and db-url format are specific to a database type. The following examples show how to properly set values for these parameters: 

   Example: SQL Server database

   database-type=MsSql
   #db-url=jdbc:sqlserver:// <DB_server_hostname>:<Port> ;instanceName= <instance_name> ;databaseName=<database_name> 
   db-url=jdbc:sqlserver://AMS3-SQ-DEV01:1433;instanceName=DEV01;databaseName=whthat_dev_ar

   Example: Oracle database

   database-type=Oracle
   #db-url=jdbc:oracle:thin:@[host][:port]:SID
   db-url=jdbc:oracle:thin:@localhost:1521:XE

   Example: PostgreSQL database

   database-type=Postgres
   #db-url=jdbc:postgresql://[host]:[port]/[database]
   db-url=jdbc:postgresql://localhost:5432/rsso

3. Ensure that the correct version of Java (Java 8, 11, or higher) is in the system path.

4. Navigate to the directory where the rsso-database-all.jar and database.propeties files are located, and run the following command: 

   java -jar rsso-database-all.jar database.properties

   The output displayed in the console with no errors encountered  indicates that Remedy SSO database tables are successfully created or upgraded. You can log in to the database management tool to verify that the tables exist.

Task 4: To encrypt the database password

To configure Remedy SSO with the database settings, it is recommended to encrypt the database password. To generate an encrypted password, perform the following steps:

1. Open the command line window, and navigate to the <TOMCAT_HOME>/rsso/WEB-INF/lib.

2. Run the following command:

   java -jar rsso-ds.jar <password_to_encrypt> <key_to_encrypt_the_password>

Task 5: To configure the Remedy SSO web server

1. Go to the Remedy SSO Tomcat folder and stop the Tomcat server.

2. Edit the <Tomcat>/webapps/rsso/META-INF/context.xml and configure the following parameters:

   Parameter	Description
   url	Set to the value of the db-url parameter that you used to set up your database.
   username	Set to the value of the db-user-id parameter that you used to create your database.
   password	Set to the value of the db-password parameter that you used to set up your database. Best practice: BMC recommends that use the encrypted password value. The format of the encrypted password value is the following: AES:<encrypted password>.
   driverClass	This value depends on your database. (Microsoft SQL Server) Set the value to com.microsoft.sqlserver.jdbc.SQLServerDriver (Oracle) Set the value to oracle.jdbc.driver.OracleDriver  (PostgreSQL) Set the value to org.postgresql.Driver

3. Copy the following jdbc driver libraries to the <tomcat>/lib folder:

   • sqljdbc4-4.0.jar

   • ojdbc6-11.2.0.2.0.jar

   • postgresql-9.4.1207.jre7.jar

4. Restart the Tomcat server.