Create ALM encrypted password for the dbid.xml file

1. Locate dbid.xml file
For example). C:\ProgramData\HP\ALM\repository\qc\Default\demo\dib.xml
It is need dbid.xml file backup

2 . In Site admin->Site projects tab->domain_name->project_name select “DB user Password” link under Project details tab.
Project is deactivated and you can type the new password
3. Remove the project
4. In Oracle Enterprise Manager edit project_db (project_name) user and type the new password (same as from step 1)
5. Restore and activate the project
The password for qcsiteadmin schema may need to be changed with a new one when using Oracle as a database in Application Lifecycle Management (ALM) 11. This can be achieved by following the next steps.
Note that the new password will be only applied to ALM user password for qcsiteadmin schema (different from project schema) and the projects password will not be affected.

Response

Before proceeding with the following steps and making any changes in site administration, the best would be backing up the DB_USER_PASS value that is located in the qcsiteadmin database/schema DBSERVERS table, or ideally backup the whole siteadmin database(qcsiteadmin_db).

Steps to change the default ALM user password for ALM qcsiteadmin_db:

1. First the “Application Lifecycle Management User password” from Site Administration -> DB Servers Tab should be changed with the new one.
This operation updates the DB_USER_PASS column (new password encryption) in the DBSERVERS table in qcsiteadmin_db (Site Administration database/schema)
2. In Oracle Enterprise Manager edit qcsiteadmin_db user and type the new password (same as one)
3. Go and display the contents of DB_USER_PASS column (new password encryption) in the DBSERVERS table in qcsiteadmin_db (Site Administration database/schema) and copy the encrypted value.
Save it somewhere.
4. On the application Server go to the ALM deployment location. For example it would be:

C:\ProgramData\HP\ALM\jboss\server\default\deploy\20qcbin.war\WEB-INF\

There you will find the siteadmin.xml file preserving information for the created siteadmin schema.
Backup this file just in case.

Update:
<DefaultUserPassword>put_here_encrypted_password</DefaultUserPassword>
with the new (updated) DB_USER_PASS value from the DBSERVERS table

5. Save the changes in the siteadmin.xml file.
6. Go to the following location on your Server:
C:\ProgramData\HP\ALM\conf and edit the “qcConfigFile.properties”

Find the places where the old Encryption of the password is written and change it with the new one. You need to focus over:

DefaultUserPassword=QCC\:PDvevcW2I7swsx85ave5GQ\=\=
7. Restart the HP ALM Service from Services.
8. Try logging to ALM Site Admin page and to any ALM project.
Note that this change does not affect projects’ user password and they will keep the old ones.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s