Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fkeuroglian
Honored Contributor

Get the metada superuser pass installation qlik sense qmc

Hi expert

I have to upgrade the qmc in sense and first of all i have to re write the superuser password again, but i do not have it

is there any way to get or obtain this?

thank you a lot

Fernando K.

1 Solution

Accepted Solutions
fernando_tonial
Valued Contributor

Re: Get the metada superuser pass installation qlik sense qmc

How to reset forgotten postgreSQL password


Introduction

The installation of Qlik Sense allows for the the postgres USER in the postgreSQL database to be assigned a password.  This document outlines the steps to reset the password.

Process

1

Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services)

2

Open Notepad as an administrator (right click on Notepad and select Run as Administrator

3

From Notepad click File > Open

Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3

4

Click on All Files (*.*)

5

Take a backup of the files pg_hba.conf and postgresql.conf

6

Open the file pg_hba.conf

7

We need to change the METHOD from MD5 to TRUST in the first entry

# TYPE  DATABASE USER ADDRESS METHOD

Original

# IPv4 local connections:

host all all             127.0.0.1/32 md5

Amended

# IPv4 local connections:

host all all 127.0.0.1/32 TRUST

8

Save the file

9

Open the file postgresql.conf

Search for the #listen_addresses key words

Remove the # from listen_addresses = 'localhost'

Original

#listen_addresses = 'localhost'

Amended

listen_addresses = 'localhost'

10

Save the file

11

Start the Qlik Sense Repository Database Service

12

Launch Command Prompt and set the working directory as

C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin>

13

Enter the following command

psql -h 127.0.0.1 -p 4432 -U postgres

The following should be displayed

14

From the postgres=# prompt enter the following SQL

alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD';

The following should be displayed

15

Stop the Qlik Sense Repository Database Service

16

Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5

17

Start the Qlik Sense Repository Database Service

Don't Worry, be Qlik.

Tonial.

1 Reply
fernando_tonial
Valued Contributor

Re: Get the metada superuser pass installation qlik sense qmc

How to reset forgotten postgreSQL password


Introduction

The installation of Qlik Sense allows for the the postgres USER in the postgreSQL database to be assigned a password.  This document outlines the steps to reset the password.

Process

1

Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services)

2

Open Notepad as an administrator (right click on Notepad and select Run as Administrator

3

From Notepad click File > Open

Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3

4

Click on All Files (*.*)

5

Take a backup of the files pg_hba.conf and postgresql.conf

6

Open the file pg_hba.conf

7

We need to change the METHOD from MD5 to TRUST in the first entry

# TYPE  DATABASE USER ADDRESS METHOD

Original

# IPv4 local connections:

host all all             127.0.0.1/32 md5

Amended

# IPv4 local connections:

host all all 127.0.0.1/32 TRUST

8

Save the file

9

Open the file postgresql.conf

Search for the #listen_addresses key words

Remove the # from listen_addresses = 'localhost'

Original

#listen_addresses = 'localhost'

Amended

listen_addresses = 'localhost'

10

Save the file

11

Start the Qlik Sense Repository Database Service

12

Launch Command Prompt and set the working directory as

C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin>

13

Enter the following command

psql -h 127.0.0.1 -p 4432 -U postgres

The following should be displayed

14

From the postgres=# prompt enter the following SQL

alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD';

The following should be displayed

15

Stop the Qlik Sense Repository Database Service

16

Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5

17

Start the Qlik Sense Repository Database Service

Don't Worry, be Qlik.

Tonial.

Community Browser