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.

Manually configuring 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