Qlik Sense server May 2024 setup failure on "Qlik Sense Service Dispatcher" psql ndauth: no password supplied
Hi,
We have a blocking setup error of Qlik Sense server May 2024 on our single node recovery server (luckily we test on it before upgrading development then production servers).
As we had multiple setup failures (with and without QPI tool), even trying to go back to our August 2022 version after full de-installation, the support adviced us to restore the machine, which is very costly so I am here for some help !
Here is is the error log part and attached the full setup logs :
CAQuietExec: DataPrepService configuration started. CAQuietExec: WARNING: Skiping the database initialization. No superuser or password specified. CAQuietExec: Creating schema 'dataprep_service'. CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema_name = 'dataprep_service'": CAQuietExec: psql: error: connection to server at "localhost" (127.0.0.1), port 4432 failed: fe_sendauth: no password supplied CAQuietExec: At C:\Program Files\Qlik\Sense\DataPrepService\install\install-utils\Postgres.ps1:109 char:9 CAQuietExec: + throw "Error executing database command "" ... CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema CAQuietExec: _name = 'dataprep_service'": psql: error: connection to server at "localhost" (127.0.0.1), port 4432 failed: fe_se CAQuietExec: ndauth: no password supplied CAQuietExec: CAQuietExec: Error 0x80070001: Command line returned an error. CAQuietExec: Error 0x80070001: QuietExec Failed CAQuietExec: Error 0x80070001: Failed in ExecCommon method CustomAction CA_SetupDPS returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Yes we succeeded but it was stressful & time consuming, on the recovery server the first setup had been badly done without QPI, we finally succeeded by cleaning the windows registry database on Postgresql entries, but :
- On DEV using QPI then Qlik Sense May 2024 Installer everything was fine, no errors.
- On PROD doing the same (QPI then Qlik Sense May 2024 Installer), Qlik Sense May 2024 Installer had an error on QlikSense Service Dispatcher setup :
+ FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema CAQuietExec: _name = 'dataprep_service'": psql: error: connection to server at "OUR SERVER" (OUR IP), po CAQuietExec: rt 4432 failed: fe_sendauth: no password supplied
It worked after uninstalling postgresql program, deleting Programdata postgre folder & cleaning windows registry on postgresql entries, then a setup on new cluster and importing manually the QPI successfully migrated/exported base.
Qlik really needs to improve the postgresql management & debugging in installation.
Hi, I would uninstall postgre sql and retry to setup QS, if KO uninstall postgre sql again + delete postgre SQL entries on windows registry data base (you should backup it before changing it).
i will check that postgresql entries on windows. At the same time i try to install QS with single node installationmode. I get the same error at that point too. I can successfully install older version like 2023-2022. But new versions after 2024 throw up this error. Is there anything that i can check on a singlenode installation? because there are no postgresql installed on it.
On new QS version postgresql is decorellated of the qlik sense setup (to ease postgresql upgrade alone), and installing an old version of QS means also installating old versions of postgresql which is included in the Qlik sense setups, old and new versions.
Hello there we managed to install with the following instructions.
Install postgresql manuelly > install Qlik and use dedicated repository > Uninstall Qlik Sense > Stop Postgresql Service > Install Qlik Sense > Uninstall PostgreSQL
