topic Re: SuperUser Password in Management & Governance

SuperUser Password

adlisval — Wed, 02 May 2018 11:46:29 GMT

What password to enter for the SuperUser?

Is the "repository database" the same thing as Postgres database? Cause I have Postgres credentials, but no one know what is this "repository database" and its "SuperUser".

I followed the documentation to upgrade and at some point there are indications on how to get the password for the "database" (doesn't say if it's the Postgres database or the "repository" database), but when I use that password for the SuperUser, Qlik Sense doesn't work (error log: Can't access database), even though ini the documentation says:

"The password string you extracted is not the actual password, it is encrypted, but you can paste this string into the database password dialog when installing the rim nodes."

So my questions still remain:

What password to enter for the SuperUser?

Is the "repository database" the same thing as Postgres database? I have the Postgres credentials, but don't understand what's with this SuperUser thing and "repository database".

Re: SuperUser Password

YoussefBelloum — Wed, 02 May 2018 12:06:00 GMT

Hi,

this super uper password is the one used on the first install and it is the Postgres super user password

Re: SuperUser Password

thomaslg_wq — Wed, 02 May 2018 12:31:25 GMT

You should definitely search for the password in your installation sum-up.
Also did you try to not enter any character (blank password) ?

Finally : do not know if this still works on current version but already made it work on older versions :

Change/add password to repository database

Make sure to backup !

Re: SuperUser Password

adlisval — Thu, 03 May 2018 15:03:22 GMT

Thanks. What/where is the "installation sum-up"?

I have a Postgres user named "postgres" and its password, so I can access the database.

I didn't install QS and there's little to no documentation of what was made when it was first installed.

So I'll have to try to upgrade again, using the password the user named "postgres" uses, and assume the user named "postgres" is the Repository Super User.

Re: SuperUser Password

adlisval — Thu, 03 May 2018 15:04:05 GMT

Thanks.

I have a Postgres user named "postgres" and its password, so I can access the database.

I didn't install QS and there's little to no documentation of what was made when it was first installed.

So I'll have to try to upgrade again, using the password the user named "postgres" uses, and assume the user named "postgres" is the Repository Super User.

Re: SuperUser Password

thomaslg_wq — Mon, 07 May 2018 08:46:33 GMT

Hi,

By installation sum-up I mean documentation of what was made when installed, hehe.

Let us know how it ended !

Regards,

Thomas

Re: SuperUser Password

adlisval — Wed, 09 May 2018 08:19:32 GMT

So the upgrade worked this time and these are the answers to my questions:

Q: What password to enter for the SuperUser?

A: the Super User seems to be the user named "postgres", so use the password corresponding to the user "postgres".

Q: Is the "repository database" the same thing as Postgres database?

A: Apparently YES.

Here are some resources that could help, but not give the answer:

Migrating from synchronized to shared persistence - Qlik Sense - YouTube

STT - Moving to Shared Persistence - YouTube

Re: SuperUser Password

YoussefBelloum — Wed, 09 May 2018 10:17:27 GMT

what's the answer you did not get yet ?