-
Re: Change/add password to repository database
Bjorn Wedbratt Dec 2, 2015 7:43 AM (in response to Gergo Lukacsik)Hi Gergo,
You could try the following:
1. Stop Qlik Sense Repository Service (this should stop all other services as well, except Qlik Sense Repository Database service)
2. Stop Qlik Sense Repository Database service
3. Go to ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3
4. Backup pg_hba.conf and postgresql.conf in the above location
5. Open pg_hba.conf in notepad (or similar)
6. Change the METHOD from md5 to trust in the entry for IPv4:
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 md5
7. Open postgresql.conf in notepad
8. Locate #listen_addresses and remove the #-sign to uncomment the line, listen_addresses = 'localhost'.
9. Start Qlik Sense Repository Database service (only this!)
10. Go to Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin
11. Enter the following command to connect to Postgre
psql -h 127.0.0.1 -p 4432 -U postgres
12. In the postgres=# prompt, enter the following SQL command to reset the password
alter user postgres with encrypted password 'MyNewPassword';
13. Stop Qlik Sense Repository Database service
14. Replace the files pga_hba.conf and postgresql.conf with the backups created in .4
15. Start Qlik Sense Repository Database service
16. Start Qlik Sense Repository Service and the other Qlik Sense services
As a precaution I recommend creating a DB backup before performing the above steps. Look into the Online help for instructions on how to backup the DB
Best,
Bjorn
-
Re: Change/add password to repository database
Gergo Lukacsik Mar 2, 2015 10:59 AM (in response to Bjorn Wedbratt )Hi Bjorn,
Thanks for your quick response. It seems working, at the moment on the central node. Only question is - will it replicate to the rim node too or I need to do the same changes on the rim node?
Thanks,
G
-
Re: Change/add password to repository database
Joost Romijn May 31, 2015 7:45 AM (in response to Bjorn Wedbratt )Thank you Björn. This worked for me as well.
-
Re: Change/add password to repository database
Emmanuelle Bustos Jul 29, 2015 1:27 PM (in response to Bjorn Wedbratt )Hi sorry I think I misunderstood this step:
8. locate #listen_addresses and remove the # from listen_addresses = 'localhost'
In my postgresql.conf i found:
#listen_addresses = 'localhost' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost'; use '*' for all # (change requires restart) but if i remove any of this the Qlik Sense Repository Database service does not starts, is this what we are supposed to remove?
NOTE: I can't find the entry # from listen_addresses = 'localhost'
-
Re: Change/add password to repository database
Bjorn Wedbratt Sep 24, 2015 8:49 AM (in response to Emmanuelle Bustos )Hi Emmanuelle,
To clarify (to others as well), you're uncommenting the line by removing the #-sign from the line listen_addresses. You're not supposed to remove the whole line, only the #-sign infront of it.
-
-
Re: Change/add password to repository database
Nico Manro Oberholzer Sep 24, 2015 6:06 AM (in response to Bjorn Wedbratt )Hi bmw,
I have been trying your post. But i cannot start the Rep Database after i've made this changes...
Anything else i can try?
-
Re: Change/add password to repository database
michele candosin Dec 1, 2015 11:18 AM (in response to Nico Manro Oberholzer)Hi Nico,
please verify:
6. Change the METHOD from md5 to trust in the entry for IPv4:
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 md5
trust not equal TRUST
-
Re: Change/add password to repository database
Bjorn Wedbratt Dec 2, 2015 7:43 AM (in response to michele candosin)Thanks Michele for pointing it out. Updated it for future references.
-
-
-
Re: Change/add password to repository database
Steven Black Mar 8, 2016 11:36 AM (in response to Bjorn Wedbratt )Thank you! how to you stop the Qlik Sense Repository Service and Database?
-
Re: Change/add password to repository database
Lidia Vonk Jun 26, 2016 1:14 PM (in response to Bjorn Wedbratt )this works perfect.
tnx
-
Re: Change/add password to repository database
Virgilio Solis Jun 28, 2016 9:44 AM (in response to Bjorn Wedbratt )Hi, I have a Issue...
I don't have the Qlik Sense Repository Database service in my services list.
What can I do?
-
Re: Change/add password to repository database
Bertrand GAVROY Oct 4, 2016 12:43 PM (in response to Virgilio Solis)Hi Virgilio
I meet the same problem as you faced here : did you solve it ? how ?
thanks !!
-
-
Re: Change/add password to repository database
Gunnlaugur Briem Jul 25, 2016 3:14 PM (in response to Bjorn Wedbratt )Tiny fix: that should be “from trust to md5”, not “from md5 to trust”.
-
Re: Change/add password to repository database
Damian Aberbuj Nov 11, 2016 10:52 AM (in response to Bjorn Wedbratt )Thanks Björn! Works perfectly.
-
Re: Change/add password to repository database
Ryan Jones Jan 11, 2017 11:54 PM (in response to Bjorn Wedbratt )Huge help, thanks so much for the instructions.
The only thing that was unclear was step 10, specifically the instruction to "Go to" the folder. I finally decided to open Command Prompt and change the directory to that path, which then enabled step 11 to work.
It's a bit confusing when the same instruction to "Go to" the folder in step 3 means navigate to it with Windows Explorer to find the files in step 4 and 5.
But I can't emphasize enough how much of a life-saver this was!
-
Re: Change/add password to repository database
Greg Williams Jul 17, 2017 2:56 PM (in response to Bjorn Wedbratt )Worked. Thank you!
-
-
Re: Change/add password to repository database
Siva Veera Jan 25, 2016 2:20 PM (in response to Gergo Lukacsik)I do not find the file pg_hba.conf on the Qlik Sense server
All I see are 3 folders bin, lib and share
-
Re: Change/add password to repository database
Bjorn Wedbratt Jan 26, 2016 7:17 AM (in response to Siva Veera)Hi Siva,
make sure you're looking into C:\ProgramData\ and not C:\Program Files\
-
Re: Change/add password to repository database
Siva Veera Jan 26, 2016 12:08 PM (in response to Bjorn Wedbratt )Hi Bjorn
I do not have C:\ProgramData\ Qlik Sense was installed in C:\Program Files\Qlik\Sense
We have installed Qlik Sense on Windows Server 2012 R2
-
Re: Change/add password to repository database
Bjorn Wedbratt Jan 27, 2016 2:32 AM (in response to Siva Veera)Hi Siva,
ProgramData is a hidden folder and unless moved located on the C:\ drive.
Try the following in a Command Prompt:
CD %ProgramData%
That should get you into the folder, regardless of being hidden or moved (%ProgramData% is the environmental variable for the folder and is always pointing to the right location).
-
-
-