Hi,
I'm trying to edit the PostgreSQL database in VRA 7 in order to erase the existing license key so i would be able to use the Eval License key
i'm using the solution specified in one of the posts here for this issue:
the thing is i cannot login the database using psql
im using the following syntax:
/opt/vmware/vpostgres/current/bin/psql vcac vcac
and im getting a password promt, even though there shouldn't be any password
i've tried specifying a -w flag which enabled a passwordless login but it failed with an error
psql.bin: fe_sendauth: no password supplied
it looks like there is a password in the VRA 7 posgresql db, does someone know what it is? I've tried all the defaults
VMware1!, vmware, admin , password
The following steps should do it:
SSH into the vRA appliance as root.
su - postgres
cd /opt/vmware/vpostgres/current/bin
./psql
\c vcac
At this point you should be connected to the vcac DB with the ability to execute SQL commands.
Hi,
Just for a POC or Test environment (due to security reasons):
Add following line to /storage/db/pgdata/pg_hba.conf
host vcac vcac 0.0.0.0/0 trust
login as root, then
su - postgres
/opt/vmware/vpostgres/current/bin/pg_ctl reload -D /var/vmware/vpostgres/current/pgdata/
Now you are able to access the DB even from remote with an (windows) tool like pgAdmin
DB:vcac
User:vcac
PW:empty
The vcac user account password is encrypted in v7. See the following for instructions on how to decrypt it: vRealize Automation vPostgres password | virtual devops.