Options & overview of a remote RSSO DB

Version 4
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Operations Management


    COMPONENT:

    TSPS Integration with Remedy SSO


    APPLIES TO:

    TrueSight Operations Management 11.x



    QUESTION:

    Options & overview of a remote RSSO DB


    ANSWER:

     If you cannot use the bundled DB (e.g. HA environment), then here are your options:

    1) Use the TrueSight installer for RSSO. You'll need to specify a PostgreSQL DB
    2) Or use the RSSO installer. With this option, you'll need to separately install JRE and Tomcat, but it also supports MS SQLServer, Oracle, and PostgreSQL

    Q> I cannot find the database.properties file. Do I need to create it?
    A> Yes, manually create it.  Place it in any location where you have write access (e.g. /tmp)


    Q> What is the content of the database.properties file?
    A> Replace the angle entries with the actual values:
    database-type=<database_type>
    db-url=<database_jdbc_url>
    db-user-id=<db_user_name>
    db-password=<db_user_password>

    Example for MSSQL:
    database-type=MsSql
    db-url=jdbc:sqlserver://localhost:1433;instanceName=MSSQLSEVER;databaseName=rsso;
    db-user-id=RSSO_USER
    db-password=RSSO#Admin#

    Example for Oracle:
    database-type=Oracle
    db-url=jdbc:oracle:thin:@localhost:1521:orcl
    db-user-id=RSSO_USER
    db-password=RSSO#Admin#

    Example for PostgreSQL:
    database-type=Postgresql
    db-url=jdbc:postgresql://clm-aus-012232:5432/truesight
    db-user-id=RSSO_USER
    db-password=RSSO#Admin#

    High level overview of the above is here:
    https://docs.bmc.com/docs/TSOperations/110/deployment-options-for-remedy-sso-with-truesight-operations-management-740416621.html#DeploymentoptionsforRemedySSOwithTrueSightOperationsManagement-FunctionssupportedbytheRemedySSOinstallers

    DB version details are here:
    https://docs.bmc.com/docs/TSOperations/110/remedy-sso-system-requirements-for-truesight-operations-management-722059945.html

    External DB user permissions are here:
    https://docs.bmc.com/docs/TSOperations/110/preparing-to-install-remedy-sso-with-the-remedy-installer-752967772.html

    Steps to manually configure the Remedy DB:
    https://docs.bmc.com/docs/rsso91/manually-configure-database-for-remedy-sso-799091269.html

    Provides examples for MsSql & Oracle DBs:
    https://communities.bmc.com/people/jechrist/blog/2017/11/22/creating-database-for-rsso-installation-manually

     


    Article Number:

    000153686


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles