Manually configuring database for Remedy SSO

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

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

• Troubleshooting common errors and issues