Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Connect to external repository database

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

1 Solution

Accepted Solutions
Highlighted

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!

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.

View solution in original post

1 Reply
Highlighted

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!

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.

View solution in original post