Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
We have our postgre database on a separate server and we want to change the password of the qrsowner account which is the user of the database.
We have done the following actions:
- modification on password on the postgre database
- modification in the [InstallFolder]\Qlik\Sense\Repository\Repository.exe.config with the QlikSenseUtil.exe
- use of scripts :
cd "C:\Program Files\Qlik\Sense\AppDistributionService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\HybridDeploymentService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\Licenses"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
but we still have the following error on the postgre base:
023-02-14 14:41:25 CET;6641;qsrowner;SenseServices;28P01;DETAIL: Password does not match for user "qsrowner".
Connection matched pg_hba.conf line 83: "host SenseServices qsrowner 0.0.0.0/0 md5"
2023-02-14 14:41:26 CET;6654;qsrowner;SenseServices;28P01;FATAL: password authentication failed for user "qsrowner"
2023-02-14 14:41:26 CET;6654;qsrowner;SenseServices;28P01;DETAIL: Password does not match for user "qsrowner".
Connection matched pg_hba.conf line 83: "host SenseServices qsrowner 0.0.0.0/0 md5"
so we tried to do the following script:
cd "C:\Program Files\Qlik\Sense\NotifierService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\MobilityRegistrarService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\PrecedentsService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\NLAppSearch\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\NLBroker\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
cd "C:\Program Files\Qlik\Sense\DataPrepService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword
I have the error when running the script:
Can you help me to know why I have an error on the postgre database and why I can't make the changes in the other databases.
Thanks in advanced
Hi Diane, depending upon certain versions it may not be available to change the password.
Please use this link to change your password:
https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-i...