Service Virtualization

 View Only

Sample DevTest 10.7.2 iam.properties file with database connection properties

  • 1.  Sample DevTest 10.7.2 iam.properties file with database connection properties

    Broadcom Employee
    Posted Mar 29, 2023 12:12 PM
    Edited by Marcy Nunns Apr 05, 2023 11:22 AM

    Sample DevTest 10.7.2 iam.properties file with database connection properties.

    DevTest 10.7.2

    N/A

    ################################################################################
    ###                                                                          ###
    ### This file contains configuration for IAM                                 ###
    ### Plain text passwords added here will be added to vault on system startup ###
    ### and it will be replaced with corresponding vault entry                   ###
    ###                                                                          ###
    ################################################################################

    iam.keystore=${IAM_HOME}certs/webreckeys.ks
    iam.keystore.password=${VAULT::IAM::IAM_KEYSTORE_PASSWORD::1}
    iam.truststore=${IAM_HOME}certs/iam-truststore.ks
    iam.truststore.password=${VAULT::IAM::IAM_TRUSTSTORE_PASSWORD::1}

    ## =====================================================================================================================
    # Database configuration
    # -----------------------
    # iam.db.vendor - Database vendor. IaAM supports [mysql,oracle,mssql,postgres].
    #
    # iam.db.url - Database URL
    #
    # iam.db.user - Database User
    #
    # iam.db.password - Database password.
    #
    # iam.db.jdbc.driver.class - JDBC driver class. 

    # iam.db.jdbc.driver.path -  JDBC driver jar path. By default looks for particular driver based on the db vendor
    #                            mysql - ${IAM_HOME}/database/drivers/mysql-connector-java-5.1.47.jar
    #                            oracle - ${IAM_HOME}/database/drivers/ojdbc8-12.2.0.1.jar
    #                            mssql - ${IAM_HOME}/database/drivers/mssql-jdbc-8.2.0.jre8.jar
    #                            postgres - ${IAM_HOME}/database/drivers/postgresql-42.2.20.jar
    #                            You can either add the jar based on your database vendor or add a different jar and specify the path.
    #                            {IAM_HOME} will resolved at runtime.
    ## =====================================================================================================================
    ##
    ##
    ## Alternative database connection string templates with sample driver path examples
    ##
    ## ==================================================================================
    ## Oracle
    ## ==================================================================================
    ##iam.db.vendor=oracle
    ##iam.db.jdbc.driver.class=oracle.jdbc.driver.OracleDriver
    ## Select one of the two connection URLs depending on usage of SID or SERVICE
    ##iam.db.url=jdbc:oracle:thin:@[HOST]:1521:[SID] <== uncomment if Oracle using a SID (Oracle System ID)
    ##iam.db.url=jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE <== uncomment if Oracle using a SERVICE (Oracle Database TNS Alias, the Service name is recorded in the tnsnames file.)
    ##iam.db.user=[USER]
    ##iam.db.password={PASSWORD]
    ## For Windows
    ##iam.db.jdbc.driver.path=C:/DevTest10.7.2/IdentityAccessManager/database/drivers/ojdbc8-12.2.0.1.jar
    ## For Linux
    ##iam.db.jdbc.driver.path=/opt/CA/DevTest10.7.2/IdentityAccessManager/database/drivers/ojdbc8-12.2.0.1.jar
    ##
    ## ==================================================================================
    ## MS SQL Server
    ## ==================================================================================
    ##iam.db.vendor=mssql
    ##iam.db.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
    ##iam.db.url=jdbc:sqlserver://[SERVER]:[PORT];databaseName=[DATABASENAME]
    ##iam.db.user=[USER]
    ##iam.db.password=[PASSWORD]
    ## For Windows
    ##iam.db.jdbc.driver.path=C:/DevTest10.7.2/IdentityAccessManager/database/drivers/mssql-jdbc-8.2.0.jre8.jar
    ## For Linux
    ##iam.db.jdbc.driver.path=/opt/CA/DevTest10.7.2/IdentityAccessManager/database/drivers/mssql-jdbc-8.2.0.jre8.jar
    ##
    ## ==================================================================================
    ## MySQL 5.7
    ## ==================================================================================
    ##iam.db.vendor=mysql
    ##iam.db.jdbc.driver.class=com.mysql.jdbc.Driver
    ##iam.db.url=jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]
    ##iam.db.user=[USER]
    ##iam.db.password=[PASSWORD]
    ## For Windows
    ##iam.db.jdbc.driver.path=C:/DevTest10.7.2/IdentityAccessManager/database/drivers/mysql-connector-java-5.1.48.jar
    ## For Linux
    ##iam.db.jdbc.driver.path=/opt/CA/DevTest10.7.2/IdentityAccessManager/database/drivers/mysql-connector-java-5.1.48.jar
    ##
    ## ==================================================================================
    ## MySQL 8
    ## ==================================================================================
    ##iam.db.vendor=mysql
    ##iam.db.jdbc.driver.class=com.mysql.jdbc.Driver
    ##iam.db.url=jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]
    ##iam.db.user=[USER]
    ##iam.db.password=[PASSWORD]
    ## For Windows
    ##iam.db.jdbc.driver.path=C:/DevTest10.7.2/IdentityAccessManager/database/drivers/mysql-connector-java-8.0.29.jar
    ## For Linux
    ##iam.db.jdbc.driver.path=/opt/CA/DevTest10.7.2/IdentityAccessManager/database/drivers/mysql-connector-java-8.0.29.jar
    ##
    ## ==================================================================================
    ## PostgreSQL
    ## ==================================================================================
    ##iam.db.vendor=postgres
    ##iam.db.jdbc.driver.class=org.postgresql.Driver
    ##iam.db.url=jdbc:postgresql://[SERVER]:[PORT]/[DATABASE]
    ##iam.db.user=[USER]
    ##iam.db.password=[PASSWORD]
    ## For Windows
    ##iam.db.jdbc.driver.path=C:/DevTest10.7.2/IdentityAccessManager/database/drivers/postgresql-42.3.2.jar
    ## For Linux
    ##iam.db.jdbc.driver.path=/opt/CA/DevTest10.7.2/IdentityAccessManager/database/drivers/postgresql-42.3.2.jar
    ##