Layer7 Access Management

Tech Tip : How to update DB Session Store details without the smconsole ?

  • 1.  Tech Tip : How to update DB Session Store details without the smconsole ?

    Posted 08-25-2017 05:54 AM

    Introduction

    We try to setup Database Session Store with 12.52SP1 Policy Server on Linux but we aren't able to run the smconsole.

    Is there a way to do it ? We can't edit the sm.registry as it contains RC2 encrypted password.

    Instructions

    You can use XPSConfig to do this.

     

    XPSConfig / PRODUCTS MENU : SM 

     

    Parameters related to Session Store : 

    =========================== 

    34-DbSessionAdminName Type: String Scope: Managed 

    Desc: ODBC session store database 

    administrator's username. 

    Current Value:"smuser" 

    35-DbSessionAdminPassword Type: String Scope: Managed 

    Desc: ODBC session store database 

    administrator's password. 

    Current Value:(sensitive) 

    36-DbSessionDataSource Type: String Scope: Managed 

    Desc: The ODBC data source used by ODBC 

    session store. 

    Current Value:"sessionstore" 

    37-DbSessionMaxConnections Type: Numeric Scope: Managed 

    Desc: The maximal number of connections 

    to ODBC session store. 

    Current Value:"16" 

    38-DbSessionServerEnabled Type: Logical Scope: Managed 

    Desc: Indicates whether ODBC session 

    server is enabled. 

     

    > For example to modify the password.

     

    XPSConfig

    PRODUCTS MENU*************************************************************CA
    CDS  - CertificateDataStore                                        12 Parameters
    EPM  - Enterprise Policy Management                                3 Parameters
    FED  - Federation                                                  3 Parameters
    SM   - SiteMinder                                                  165 Parameters
    XPS  - Extensible Policy Store                                     25 Parameters

    -------------------------------------------------------------------
       X - xTrace
    -------------------------------------------------------------------
       Q - Quit
    -------------------------------------------------------------------
    Enter Option (id or X or Q): SM

    ....

    165-WorkerThreadPriorityRatio   Type: Numeric Scope: Managed
                                    Desc: The worker thread priority ratio,
                                    from -100 to 100.
                                  Current Value:"0"
    -------------------------------------------------------------------
       D - Hide Descriptions
       V - Hide Values
       F - Filter (currently none)
       Q - Quit
    -------------------------------------------------------------------
    Enter Option (D, V, F,  # or Q): 35


    PARAMETER MENU********************************CA.SM::$DbSessionAdminPassword

       Name:               DbSessionAdminPassword [CA.SM::$DbSessionAdminPassword]
       Type:               String (sensitive)
       Scope:              Managed
       Export?             yes
       Report?             no
       Remote Access:      None
       Description:        ODBC session store database administrator's password.
       License Type:       None
       Current Value:      (sensitive)

    -------------------------------------------------------------------

       C  - Change value
       Q  - Quit
    -------------------------------------------------------------------
    Enter Option (C, or Q):C
    Enter New Value:totot (password)

    PARAMETER MENU********************************CA.SM::$DbSessionAdminPassword
       Name:               DbSessionAdminPassword [CA.SM::$DbSessionAdminPassword]
       Type:               String (sensitive)
       Scope:              Managed
       Export?             yes
       Report?             no
       Remote Access:      None
       Description:        ODBC session store database administrator's password.
       License Type:       None
       Current Value:      (sensitive)

    -------------------------------------------------------------------
       C  - Change value
       Q  - Quit
    -------------------------------------------------------------------
    Enter Option (C, or Q): Q

    ....
    165-WorkerThreadPriorityRatio   Type: Numeric Scope: Managed
                                    Desc: The worker thread priority ratio,
                                    from -100 to 100.
                                Current Value:"0"

    -------------------------------------------------------------------

       D - Hide Descriptions
       V - Hide Values
       F - Filter (currently none)
       Q - Quit
    -------------------------------------------------------------------
    Enter Option (D, V, F,  # or Q): Q


    PRODUCTS MENU*************************************************************CA
    CDS  - CertificateDataStore                                        12 Parameters
    EPM  - Enterprise Policy Management                                3 Parameters
    FED  - Federation                                                  3 Parameters
    SM   - SiteMinder                                                  165 Parameters
    XPS  - Extensible Policy Store                                     25 Parameters

    -------------------------------------------------------------------
       X - xTrace
    -------------------------------------------------------------------
       Q - Quit
    -------------------------------------------------------------------
    Enter Option (id or X or Q): Q

     

    KD: TEC1232658