Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomovangel
Partner - Specialist
Partner - Specialist

PostgreSQL secure connection error pg_hba file

Hello guys, 
I am trying to connect to my client's production database but it keeps returning the following error:

Where the marked with red lines after host are my own qlik sense server. 

Does this error mean, that my client should include something in his pg_hba file on the database

Or I should do it on my qliksense server's pg_hba file (under postgresql/9.6)

 
I am using Qlik Sense Enterprise

Screenshot_6.jpg

1 Solution

Accepted Solutions
Gysbert_Wassenaar

The user should be included in the pg_hba file of the postgresql installation that's managing the database you're trying to connect to.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

The user should be included in the pg_hba file of the postgresql installation that's managing the database you're trying to connect to.


talk is cheap, supply exceeds demand
tomovangel
Partner - Specialist
Partner - Specialist
Author

So, I have to add this text to the pg_hba file of the database that I want to connect to, right? 


host      databasename  postgres qliksense'sServeripaddress  trust

 

example:

host database1 postgres 123.435.222.12 trust

 

?

Gysbert_Wassenaar

I wouldn't use trust myself. Trust as auth-method allows any user connecting from 123.435.222.12 to connect as any user. That means the connecting user can basically do anything and everthing to any database. I'd use md5. See the postgres documentation for more information: https://www.postgresql.org/docs/9.6/auth-pg-hba-conf.html

talk is cheap, supply exceeds demand
tomovangel
Partner - Specialist
Partner - Specialist
Author

Okay, Thanks. 

I will send this to the admin of the database.

By the way, I see you know a lot of that stuff. 

I have been able to successfully install 3rd party certificate and the qliksense'server site, doesn't show certificate error. 


The certificate is installed on the computer, but when I log in with the user, that is used to run the qlik sense services, 
he hasn't applied the 3rd party certificate. 


From the local computer directory's mmc  I have givven full control and read rights to the QS Service account for managing private keys. 


When i try to connect to the postgresql using verify-ca it says that my crt file is missing.

Any insight?

Gysbert_Wassenaar

Nope, sorry. Never used ssl for connecting to postgresql.

talk is cheap, supply exceeds demand