HP Systems Insight Manager - Manual (Page 96)

Procedure 22 Changing the database authorizations for Matrix OE and HP Operations Orchestration
1. Update the gwlmdb.properties file by executing the following command from the command
line:
vseinitconfig -a
2. Open a Windows command prompt and navigate to ..\Program Files\HP\Operations
Orchestration\Central\tools
.
3. Execute the following commands from the command prompt:
mxpassword -m -x MxDBUserPassword=<New Password>
mxpassword -m -x io.db.password=<New Password>
4. Execute change-db-props.bat to change the Operations Orchestration database password.
Type the following and press Enter:
For example:
C:\Program Files\HP\Operations Orchestration\Central\
tools>change-db-props.bat <dbuser> <New password>
The command, change-db-props must be executed passing only the user name and not
domain, even if this is a domain account.
5. Update jdbc.properties file located under IO_install_directory\conf. Update
the following line:
jdbc.username = <new_user>
6. Update chargeback service jdbc.properties file located under
IO_install_directory\chargeback\conf
. Update the following line:
jdbc.username = <new_user>
NOTE: If HP Capacity Advisor Data Service is not running after executing dbauth, you must
update the hosts file under Windows\System32\drivers\etc and add <cms_name>, where
<cms_name> is the hostname of CMS. Be sure to save the file and restart HP Capacity Advisor
Data Service if it was stopped.
Reconfiguring the CMS to use a different database
Use the mxreconfig —m sqlredirect -s <dbserver> -b <dbname> -a
<dbuserDomain\dbuser> [-p <dbport>]
command to reconfigure the CMS to use a different
database.
Where:
•
-a <dbuser>
Name of the database user with administrative privileges, must include domain name.
•
<-b dbname>
Name of the new database.
•
-s <dbserver>
Name of the new database server
•
-p <dbport>
Port number to access the new database server
This command updates the CMS to associate itself with a new Microsoft SQL database residing
on a different server. If the database previously associated with HP SIM or HP Insight Control must
be changed, use this command to specify the new database server and database name. You can
optionally specify the database port number on which HP SIM or HP Insight Control communicates
96 CMS Reconfigure Tool