Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
?
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?