Forgotten PGP Server Admin Password

To reset admin password you will need physical access to server

1. Log into the server with root account
2. psql -d oviddb -U postgres
3. UPDATE omc_administrator SET passwordmd5=’some new password’ WHERE name=’username’;
4. \q

You should now be able to login with the newly set password and be prompted to create a new password