HPDM 4.4 Lost Root Password

[Slip7]

We recently let go  of one of the admins from the config management team.  This individual changed the root password to HP Device Manager and refused to give it to anyone before his dismissal.  

Is there a way we can recover the root password or reinstall HPDM 4.4 to get back in without losing the database?  We are using a PostgreSQL 8.3 installation.  We do not have access to any version above 4.4 since software changes above this version have not been approved by our software managers.  Any help you can provide is greatly appreciated.

[Chen_HPDM]

The recommand way would be:

1. Use Backup & Restore tool to backup current DB as well as the related files

2. Reinstall HPDM

3. Use Backup & Restore tool to restore the DB

Please try this in your test environment before implementing it to production.

[KNRK]

Dear Customer,
 
Welcome to HP Support Forum and we are glad to assist you.
 
It looks like you are trying to find if there is a way to reset or recover the root password for HP Device Manager 4.4

The Answer for you question is - NO

Hope this helps, for any further queries reply to the post and feel free to join us again
 
 **Click the White Thumbs Up Button on the right to say Thanks**
Make it easier for other people to find solutions by marking a Reply 'Accept as Solution' if it solves your problem.
 
Thank You,
K N R K
Although I am an HP employee, I am speaking for myself and not for HP

[ChrisS3]

This is unsupported, proceed at your own risk!

Take a backup (or two) before proceeding!

1. Stop the HPDM Server and HPDM PostgreSQL services.

2. Open "C:\Program Files (x86)\HP\HP Device Manager\Server\pgsql\data\pg_hba.conf" in Notepad or similar.

3. At the bottom of the file are two lines like this:

host all all 127.0.0.1/32 md5
host all all ::1/128      md5

Change the "md5" on the end to "trust". Save (you may have to edit the file's permissions to be able to save).

4. Start the HPDM PostgreSQL service. It will fail, this is correct.

5. From a command prompt navigate to "C:\Program Files (x86)\HP\HP Device Manager\Server\pgsql\bin", run the following command:

psql -h localhost --username=postgres -p 40006 -d hpdmdb

6. At the hpdmdb=# prompt, find the username of your administrator account(s) by running:

select user_id from dm_group_user where group_name = 'Administrators';

7. "Reset" the password for a user to "password" by running:

update dm_user set password='BF46D06915FB4352C6D087AA3378C380' where user_id='the username from #6'

8. Enter "\q" (without the quotes) to exit the psql prompt.

9. At the command prompt still, run the following:

"C:/Program Files (x86)/HP/HP Device Manager/Server/pgsql/bin/pg_ctl.exe" stop -m fast -D "C:/Program Files (x86)/HP/HP Device Manager/Server/pgsql/data"

10. Open the file from #3 again if you closed it. Undo the changes you made, returning "trust" to "md5".

11. Start the HPDM PostgreSQL and HPDM Server services again.