Take a backup (or two) before proceeding!
- Stop the HPDM Server and HPDM PostgreSQL services.
- Open "C:\Program Files (x86)\HP\HP Device Manager\Server\pgsql\data\pg_hba.conf" in Notepad or similar.
- 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 md5Change the "md5" on the end to "trust". Save (you may have to edit the file's permissions to be able to save).
- Start the HPDM PostgreSQL service. It will fail, this is correct.
- 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
- 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';
- "Reset" the password for a user to "password" by running:
update dm_user set password='BF46D06915FB4352C6D087AA3378C380' where user_id='the username from #6';
- Enter "\q" (without the quotes) to exit the psql prompt.
- 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"
- Open the file from #3 again if you closed it. Undo the changes you made, returning "trust" to "md5".
- Start the HPDM PostgreSQL and HPDM Server services again.