Cfrgtkky

Been struggling with this for a while, so any help is really appreciated...

I have Pentaho reports loaded into Pentaho Server. These reports are called via an Iframe.

What I'm trying to do is have the user authenticate one time only, so he can run other reports without having to reauthenticate. For that, I use Pentaho Cookie-Based Authentication as documented here: https://help.pentaho.com/Documentation/8.0/Developer_Center/REST_API

My issues are:
1) I wrote a small php script that sends a POST request to /pentaho/j_spring_security_check. The scripts does not return any error, but does not redirect me to home page as expected.

<?php

$data = array("j_username"=>"admin", "j_password"=>"password", 

"locale"=>"en_US");

$string = http_build_query($data);

echo $string;

$ch = 

curl_init("http://localhost:8080/pentaho/j_spring_security_check");

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $string);

curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

echo $ch;

$return = curl_exec($ch);

echo $return;

if (curl_errno($ch)) {

   print curl_error($ch);

}

curl_close($ch);

?>  

2) I tried typing directly in the browser "http://localhost:8080/pentaho/j_spring_security_check?j_username=admin&j_password=admin", I get the "login_error=1" result, while both logins and passwords are correct (the expected behaviour is to be redirected to the home page).

It's the first time I'm using REST API, so I might be doing things wrong.

Many thanks

answered here: https://community.hitachivantara.com/thread/14811-pentaho-rest-api-issue-when-using-pentaho-cookie-based-authentication

I was missing the step where I would reuse that cookie.

Also, using "curl_setopt ($ch, CURLOPT_RETURNTRANSFER, true)" helped me understand mistakes in my script and solve it.

Correct script is:

<?php

$data = array("user"=>"admin", "password"=>"admin");

// $string = http_build_query($data);

// echo $string;



$cookie_jar = tempnam('/Users/pierre/Vrac','cookie');

    if (!file_exists(realpath($cookie_jar))) touch($cookie_jar);



$ch = curl_init("http://localhost:8080/pentaho/j_spring_security_check? 

j_username=admin&j_password=admin&locale=en_US");

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

curl_setopt($ch, CURLOPT_COOKIEJAR, $cookie_jar);

curl_setopt ($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_HEADER, true);



//echo $ch;

$return = curl_exec($ch);



echo "execution report";

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($ch, CURLOPT_COOKIEFILE, $cookie_jar);

curl_setopt($ch, CURLOPT_URL,'http://localhost:8080/pentaho/api/repos/:public:IframeDossier:IframeTest.prpt/viewer?label=fin');

$page = curl_exec($ch);

echo $page;





curl_close($ch);



?>