This documentation supports the 9.0 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Setting up database for Remedy Single Sign-On

Execute the following steps to set up a database for Remedy Single Sign-On (RSSO):

Database is usually configured through installer. However, if installation is driven by scripts or automation tools, database is configured manually.
  1. Make sure a database is created for RSSO. The database name is used in the database.properties file.
  2. Copy rsso-database-all.jar and database.properties from distribution/target/rsso-agent to some place on your system. For example, C:\ drive.
  3. Edit database.properties and update the values of properties. Here is an example of the properties file, assuming MSSQL server is installed on the local machine and the database name created for RSSO is 'rsso'.
    * database-type=MsSql
    * db-url= jdbc:jtds:sqlserver://<DB Server HostName>:<PORT>/<DBName>;instance= <INSTANCEName>
    For example, db-url=jdbc:jtds:sqlserver://MA-SQL-SERVER001:1433/whitehat_rsso;instance=MSSQLSERVER for base64 encoding. base64encode.org can be used to encode password.
    * db-user-id=RSSOAdmin
    * db-password=password
    Here is another example:
    * database-type=Oracle
    * db-url=jdbc:oracle:thin:@localhost:1521:RSSO
    * db-user-id=RSSOAdmin
    * db-password=password

    Note: db-password value is expected to be Base64 encoding of plain-text password.
  4. Ensure that correct version of Java (1.8.45 or higher) is in the path. Open a command line console go to the directory where rsso-database-all.jar and database.propeties files are located. Run following command:
    java -jar rsso-database-all.jar database.properties
  5. If you see some outputs in the console as shown below, it indicates the successful creation of RSSO database tables. You can also login to the database management tool to verify if the tables exist.
    * JarClassLoader: Warning: Null manifest from input stream associated with: lib/thirdparty-libraries-1.0-SNAPSHOT.pom
    * sqlUrl = jdbc:jtds:Sqlserver://localhost/RSSO
    * sqlUserId = RSSOAdmin
    * Connecting to a selected database
    * Connected database successfully
    * Creating table RelayState in given database
    * Created table RelayState in given database
    * Creating table IssuedTokens in given database
    * Created table IssuedTokens in given database
    * SAML Tables are created successfully!
Was this page helpful? Yes No Submitting... Thank you

Comments