topic Re: Connect to external repository database in Management & Governance

Connect to external repository database

philip_radovich — Mon, 07 Jan 2019 13:52:17 GMT

Good Morning,

I am having an issue with installing Qlik using an external repository database. I have installed and configured a PostgreSQL database on an external server configured per the knowledge base articles but when I attempt to install Qlik, on the shared persistence database connection settings in the installation it is not accepting my credentials. I have tested the login with pgAdmin and can connect up to the database from the server I want Qlik installed but when I enter in my information and hit next the screen flashes and then removes the password. I am not receiving an error of any kind. I am attempting to install Qlik Sense November 2017(I know it is an old version). I am running PostgreSQL 9.6.11. I am listening on all ports and have defined the correct subnet in the conf settings. Any help would be greatly appreciated.

Thanks,

Phil Radovich

Re: Connect to external repository database

Bastien_Laugiero — Tue, 08 Jan 2019 08:47:55 GMT

Hello,

When you tried PGAdmin, did you use the same Database Hostname as entered in the Qlik Sense installer?

If you ping the database hostname from the Qlik Sense machine, does it return an IPV4 or IPV6? I have seen cases where it returns IPV6 and there are setting to configures on Postgres side to allow client using IPV6 to connect.

Finally, if none of this helps, I would suggest enabling logging in Postgres and check why Qlik Sense is denied when you try to connect.

To do that, you need to:

Stop Postgres
Open the file postgres.conf and locate the section ERROR REPORTING AND LOGGING
Uncomment and set to ON logging_collector
Uncomment log_directory and log_filename
Save, close and start Postgres

You should get a new directory called pg_log at the same place postgres.conf is located with a log file.

Try to connect again from the installer and check the exception in the log files.

Hope this helps!