Video Screencast Help

restore credentials PGP Universal Server

Created: 19 Oct 2012 • Updated: 02 Nov 2012 | 2 comments
rojopipe's picture
This issue has been solved. See solution.

Hello,

I don't know the username and password of the PGP Universal Server 3.2 to connect throught to web console , but i can connect to SSH with user root. Is possible restore the credentials..?

Thanks.

 

 

Comments 2 CommentsJump to latest comment

mwoj's picture

It is possible, if you have SSH access and if you have NO Ignition Key set on Universal Server.

First you have to find out which account name has has super user access:

For this you want to issue this command on SSH:

psql oviddb ovidr -c "SELECT name,roleid from omc_administrator;"

Then note down the user name which has the role "ROLE_SUPERUSER"

Then set a new password for this user by issuing this command where ADMIN in this example is your user name you noted down, and PASSWORD is your new password:

psql -U postgres -d oviddb -c "UPDATE omc_administrator SET passwordmd5='`slappasswd -s PASSWORD`' WHERE name='ADMIN';"

Once you have restored the password for a super user you can set/reset all passwords for all other users.

SOLUTION
rojopipe's picture

Excellent, worked perfect.

Thanks.