Connecting Presto Onprem with self-signed certificate
Hi
I am facing an issue while connecting Adding a Presto Datasource. My presto engine is in Onprem with a self-signed certificate , but when trying to add it here with self signed .pem file uploaded , its throwing error as below.
"Connection failed: Please check the values for Username‚ Password‚ Host and other properties."
Hi! it seeams a bit generic isssue, I'll try to help
Did you check that the self-signed certificate (.pem file) is properly trusted by the Qlik Sense server? The Qlik server must trust the certificate authority (CA) that issued the self-signed certificate. You can add the self-signed certificate to the trusted certificates store on the Qlik server.
Did you see if the Common Name (CN) or Subject Alternative Name (SAN) in the certificate match the hostname of the Presto server? Ensure that the hostname you're using in the connection string is the same as the one in the certificate.
The .pem file is in the correct format? It should contain both the certificate and the private key in PEM format:
Did you try connecting to the Presto server using another tool (like curl, psql, or any other Presto client) with the same .pem file and credentials? just to to ensure that the certificate and server setup are correct.
Are you sure that there are no firewall or network restrictions that might be blocking the connection to the Presto server from the Qlik Sense server?
