Julien_Nitot

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

Discussion created by Julien_Nitot Employee on Aug 25, 2017

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

Outcomes