How to update DB Session Store details without the smconsole ?

Document ID : KB000010637
Last Modified Date : 14/02/2018
Show Technical Document Details
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