This documentation supports the 9.1 version of Remedy Single Sign-On.

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

2018-03-08_23-44-35_Manually configure database for Remedy SSO

You can manually set up a database for Remedy Single Sign-On (Remedy SSO) using the following steps:

Note

The database is usually configured through the installer. However, if the installation is driven by scripts or automation tools, the database can be configured manually too.

  1. Make sure that you used a separate DB schema to create a database for Remedy SSO. The database must not contain any Remedy SSO table. The database name is specified in the database.properties file.
  2. Copy rsso-database-all.jar and database.properties from the rsso-database to some place on your system. For example, copy to C:\ drive.
  3. Edit database.properties and update the values of properties as follows.

    database-type=<database_type>
    db-url=<database_jdbc_url>
    db-user-id=<db_user_name>
    db-password=<db_user_password>
    • Example when database is MSSQL, which is installed on a local machine.

    database-type=MsSql

     Version 9.1.01

    db-url=jdbc:sqlserver:// <DB_server_hostname>:<Port> ;instanceName= <instance_name> ;databaseName=<database_name>
    Example, db-url=jdbc:sqlserver://AMS3-SQ-DEV01:1433;instanceName=DEV01;databaseName=whthat_dev_ar

     Versions earlier than 9.1.01

    db-url=jdbc:jtds:sqlserver://<DB_server_hostname>:<PORT>/< database_name >;instance=<instance_name>
    db-url=jdbc:jtds: sqlserver://MA-SQL-SERVER001:1433/whitehat_rsso;instance=MSSQLSERVER


    • Example when database is Oracle and the database name created for Remedy SSO is 'rsso'.

      database-type=Oracle
      db-url=jdbc:oracle:thin:@localhost:1521:XE

      Note

      db-password value is expected to be plain-text password.


    • Example when database is PostgreSQL.

    jdbc:postgresql://[host]:[port]/[database]
    example, jdbc:postgresql://localhost:5432/rsso

  4. Ensure that correct version of Java (Java 7 or higher version) is in the path.

  5. Open a command line console and go to the directory where rsso-database-all.jar and database.propeties files are located.

  6. Run the following command:
    java -jar rsso-database-all.jar database.properties

  7. The outputs displayed in the console indicate if Remedy SSO database tables are successfully created or upgraded.

    1. For new installation, If you see some outputs in the console and if you do not see any errors, it indicates the successful creation of Remedy SSO database tables. You can also login to the database management tool to verify if the tables exist.
    2. For upgrade, If you see some outputs in the console and if you do not see any errors, they indicate that Remedy SSO database tables are successfully upgraded.

Related topics



Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Sankeerth Jalapu

    Does this apply to 9.1.03 on 12 C?

    I am not able to find the database.properties file in the install directories? I manually created the file with the parameters specified; however, it did not finish with a success message?

    Oct 06, 2017 04:58
    1. Kamalakannan Srinivasan

      Hi Sankeerth,

      Thank you for your comment. I will discuss with the technical team and keep you informed.

      Regards,
      Kamal

      Oct 09, 2017 03:18
    1. Kamalakannan Srinivasan

      Hi Sankeerth,

      Thank you for your comment.

      Assuming that by 12C you meant Oracle DB, yes this applies to 12C.

      rsso-database-all.jar is shipped as part of the installer. Unzip BMCRemedySSO-9.1.03.zip and take this file from \BMCRemedySSO\Disk1\lib\.

      database.properties should be created manually.

      Regards,
      Kamal


      Oct 11, 2017 01:02
      1. Thomas Miskiewicz

        Manually? Is this an enterprise product or open source? Why the former than why do we have to create things manually when the installer could do it for us?

        Jan 09, 2018 01:43
        1. Aleksey Vyazovsky

          Hi Thomas

          You don't need to created RSSO database manually if you use RSSO installer.

          It requires only if you deploy RSSO server manually for some reason.


          Database is used by RSSO for two purposes - storing the configuration and keeping authentication data. It contains RSSO server configuration including Server Settings, Realms and authentication configuration, OAuth settings, etc. And also it keeps the sessions data like RSSO authentication tokens, OAuth access and refresh tokens.

          Having one database all RSSO server nodes can share the configuration and authentication data working as high-availability cluster.



          Regards, Aleksey 

          Jan 09, 2018 02:59
  2. Thomas Miskiewicz

    What information does RSSO store in the database?

    Jan 09, 2018 01:43
    1. Kamalakannan Srinivasan

      Hi Thomas,

      Thank you for your comment. Aleksey's above comment addresses both your comments in this document. Please let us know in case you are looking for more information.

      Regards,

      Kamal

      Jan 09, 2018 04:53