How to connect from external userID with qlik QAP.

Anonymous — Fri, 20 Apr 2018 07:05:19 GMT

i Team ,

We are faciing issue while connecting QAP Qlik sense for external users.

I have read blogs and on qlik community but haven't got concrete solution for that.

Here is java code for this: I am running this from command prompt.

import javax.net.ssl.*;

import java.io.*;

import java.net.URL;

import java.security.*;

import java.security.cert.X509Certificate;

public class Ticket {

static {

disableSslVerification();

}

private static void disableSslVerification() {

try {

// Create a trust manager that does not validate certificate chains

TrustManager[] trustAllCerts = new TrustManager[] { new X509TrustManager() {

public java.security.cert.X509Certificate[] getAcceptedIssuers() {

return null;

}

public void checkClientTrusted(X509Certificate[] certs, String authType) {

}

public void checkServerTrusted(X509Certificate[] certs, String authType) {

}

} };

// Install the all-trusting trust manager

SSLContext sc = SSLContext.getInstance("SSL");

sc.init(null, trustAllCerts, new java.security.SecureRandom());

HttpsURLConnection.setDefaultSSLSocketFactory(sc.getSocketFactory());

// Create all-trusting host name verifier

HostnameVerifier allHostsValid = new HostnameVerifier() {

public boolean verify(String hostname, SSLSession session) {

return true;

}

};

// Install the all-trusting host verifier

HttpsURLConnection.setDefaultHostnameVerifier(allHostsValid);

} catch (NoSuchAlgorithmException e) {

e.printStackTrace();

} catch (KeyManagementException e) {

e.printStackTrace();

}

public String createConnection(HttpsURLConnection connection, String reqBody) throws Exception {

if(reqBody!=null) {

OutputStreamWriter wr = new OutputStreamWriter(connection.getOutputStream());

wr.write(reqBody);

wr.flush(); // Get the response from the QPS BufferedReader

}

BufferedReader in = new BufferedReader(new InputStreamReader(connection.getInputStream()));

StringBuilder builder = new StringBuilder();

String inputLine;

while ((inputLine = in.readLine()) != null) {

builder.append(inputLine);

}

in.close();

String result = builder.toString();

return result;

}

public String getQlikTicket(String userID, String userDir) {

String qlikTicketNo = "";

String xrfkey = "7rBHABt65vFflaZ7"; // Xrfkey to prevent cross-site issues

String host = "xxxxxxx"; // Enter the Qlik Sense Server hostname here

String vproxy = "hdr"; // Enter the prefix for the virtual proxy configured in Qlik Sense Steps Step 1

try {

/************** BEGIN Certificate Acquisition **************/

String certFolder = "C:\\Users\\xxxxxxx\\Desktop\\qlik\\"; // This is a folder reference to the location of

// the jks files used for securing ReST

// communication

String proxyCert = certFolder + "client.jks"; // Reference to the client jks file which includes the client

// certificate with private key

String proxyCertPass = "xxxxxx"; // This is the password to access the Java Key Store information

String rootCert = certFolder + "root.jks"; // Reference to the root certificate for the client cert.

// Required in this example because Qlik Sense certs are used.

String rootCertPass = "xxxxxx"; // This is the password to access the Java Key Store information

/************** END Certificate Acquisition **************/

/**************

* BEGIN Certificate configuration for use in connection

**************/

KeyStore ks = KeyStore.getInstance("JKS");

ks.load(new FileInputStream(new File(proxyCert)), proxyCertPass.toCharArray());

KeyManagerFactory kmf = KeyManagerFactory.getInstance(KeyManagerFactory.getDefaultAlgorithm());

kmf.init(ks, proxyCertPass.toCharArray());

SSLContext context = SSLContext.getInstance("SSL");

KeyStore ksTrust = KeyStore.getInstance("JKS");

ksTrust.load(new FileInputStream(rootCert), rootCertPass.toCharArray());

TrustManagerFactory tmf = TrustManagerFactory.getInstance(TrustManagerFactory.getDefaultAlgorithm());

tmf.init(ksTrust);

context.init(kmf.getKeyManagers(), tmf.getTrustManagers(), null);

SSLSocketFactory sslSocketFactory = context.getSocketFactory();

/**************

* END Certificate configuration for use in connection

**************/

/************** BEGIN JSON Message to Qlik Sense Proxy API **************/

String body = "{ 'UserId':'" + userID + "','UserDirectory':'" + userDir + "',";

body += "'Attributes': []}";

System.out.println("Payload: " + body);

/************** END JSON Message to Qlik Sense Proxy API **************/

HttpsURLConnection connection = null;

String result;

/************** BEGIN HTTPS Connection **************/

/*System.out.println("Browsing to: " + "https://" + host + ":4243/qps/" + vproxy + "/ticket?xrfkey=" + xrfkey);

URL url = new URL("https://" + host + ":4243/qps/" + vproxy + "/ticket?xrfkey=" + xrfkey);

connection = (HttpsURLConnection) url.openConnection();

connection.setSSLSocketFactory(sslSocketFactory);

connection.setRequestProperty("X-Qlik-Xrfkey", xrfkey);

connection.setRequestProperty("hdr-usr", userDir + "\\" + userID);

connection.setDoOutput(true);

connection.setDoInput(true);

connection.setRequestProperty("Content-Type", "application/json");

connection.setRequestProperty("Accept", "application/json");

connection.setRequestMethod("GET");

//connection.connect();

//Call GET request

result = createConnection(connection, null);

System.out.println("The response from GET call: " + result);*/

//Call POST request

URL postUrl = new URL("https://" + host + ":4243/qps/" + vproxy + "/ticket?xrfkey=" + xrfkey);

connection = (HttpsURLConnection) postUrl.openConnection();

connection.setSSLSocketFactory(sslSocketFactory);

connection.setRequestProperty("X-Qlik-Xrfkey", xrfkey);

//connection.setRequestProperty("hdr-usr", userDir + "\\" + userID);

connection.setDoOutput(true);

connection.setDoInput(true);

connection.setRequestProperty("Content-Type", "application/json");

connection.setRequestProperty("Accept", "application/json");

connection.setRequestMethod("POST");

result = createConnection(connection, body);

System.out.println("The response from POST call: " + result);

if (result != null && result.contains("Ticket\":")) {

qlikTicketNo = result.replaceAll("\\r\\n", "").replaceAll("\"", "").split("Ticket:")[1].split(",")[0].replaceAll("\\r\\n", "");

}

/************** END HTTPS Connection **************/

/************** Start Test Report call **************/

URL reportUrl = new URL("https://xxxxxxx/<<<<<<Some html page>>>>>>>?qlikTicket=" + qlikTicketNo);

connection = (HttpsURLConnection) reportUrl.openConnection();

connection.setRequestProperty("Content-Type", "text/html");

connection.setDoOutput(true);

connection.setRequestProperty("User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36");

connection.setRequestMethod("GET");

connection.connect();

result = createConnection(connection, null);

System.out.println("Response Code : " + connection.getResponseCode());

System.out.println("Result : " + result);

/************** End Test Report call **************/

} catch (Exception e) {

e.printStackTrace();

}

return qlikTicketNo;

}

public static void main(String[] args) throws Exception {

Ticket ticket = new Ticket();

String qlikTicket = ticket.getQlikTicket(args[0],args[1]);

System.out.println("Ticket::" + qlikTicket);

}

I am sending request uid as some external users and and these entries I have made in excel sheet in QAP.

I am able to get get ticket response but when I am opening this in browser I can't open this and getting response as "access_denied".

Please help me to resolve access denied issue.

topic How to connect from external userID with qlik QAP. in Integration, Extension & APIs

How to connect from external userID with qlik QAP.