Hitachi Vantara Pentaho Community Forums
Results 1 to 14 of 14

Thread: how to pass username and password to url when calling report

  1. #1

    Default how to pass username and password to url when calling report

    Hello everyone,
    I would like to ask whether it is possible to call a report from a browser just by typing this in the url without the need to login:
    http://productionserver:8080/pentaho...s&action=Sales by Sales Agent.xaction

    Is it possible that I can add in the parameter for username and password to the url so that it does not prompt me to login? If yes, then how to do it? I am using Pentaho BI Platform 1.7.1.1117. Thks in advance.
    Last edited by Chong Thau Syn; 03-24-2009 at 10:48 PM.

  2. #2
    pstoellberger Guest

    Default

    yes, there are two parameters userid and password so your url should look like : http://productionserver:8080/pentaho...sword=password

    find more information about authentication here: http://wiki.pentaho.com/display/Serv...Authentication

  3. #3

    Default

    Hi pstoellberger,
    Thks a lot. It works.

  4. #4
    Join Date
    Jul 2009
    Posts
    9

    Default Pass username and password to url

    Hi,
    I am facing a similar requirement of passing the userid and password along with the URL.

    The given solution doesnt seem to work for me. It is taking me to the user login page.

    Please help me in this regard,
    Thanks in advance.

  5. #5
    pstoellberger Guest

    Default

    it should work if you haven't changed the default user / password
    the action/path variable however isn't one that works default. you need to adapt the url to a working path/xaction

    -paul

  6. #6

    Default

    I believe that the URL parameter in the URL should be "...&userid=joe&password=password", not "...&user=joe&password=password".

    I am serious that it's not a good and safe method to add user/password in the URL, any one has any other good suggestion to let user access report URL without login?

    --
    thanks,
    Justin

  7. #7
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    you can use all the options that ACEGI has to offer. Maybe this Wiki page is a good starting point: http://wiki.pentaho.com/display/Serv...y+Applications

  8. #8
    pstoellberger Guest

    Default

    exactly

    you can even implement your own security algorithm and tell acegi (i think its upgraded to spring in the new version) to use it

  9. #9

    Default

    hi pstoellberger and ingo.klose,

    SSO is what I want to implement, but I found the related documents are not quite clear for me, do you have any good document or link to share?

    now I have a liferay portal deployed in a Glassfish server, and pentaho server in a Tomcat, I want to realize the SSO, I just want to know:

    1. Do I need to deploy two of them into one single AS, like glassfish?
    2. I need a CAS server or only client?

    --
    thanks,
    Justin

  10. #10
    Join Date
    Mar 2008
    Posts
    364

    Default

    you neeed a cas-server. it can be deployed into the same tomcat as pentaho

  11. #11
    Join Date
    Mar 2009
    Posts
    112

    Default

    What we did was using an ajax call and passed the user and password information like a post submit.
    The code snippet we used (uses jQuery):
    Code:
    jQuery.ajax({   
    	type: "GET",
    	url: "/pentaho/Pivot", // this url is something inside pentaho that requires login
    	data: "solution=Test&path=Analysis&action=test.analysisview.xaction" ,
    	success: function(msg){
    		if(msg.indexOf("Welcome")>0) // if the content of the page shows we are not logged in
    		jQuery.ajax({   
    			type: "POST",
    			url: "/pentaho/j_spring_security_check",
    			data: "j_username=myuser&j_password=mypassword",
    			success: function(){	
    				var iframeName = jQuery("iframe").attr("id");		
    				parent.frames[iframeName].location.reload();
    			}
    		});
    	}
    });
    Something like this could work for you.

    Greetings from Chile,
    José Ignacio

  12. #12
    Join Date
    Oct 2006
    Posts
    33

    Default

    would it not be easier to put the user/password in the url as "&userid=name&password=secret"
    http://wiki.pentaho.com/display/Serv...tion+2.x-3.0.x
    See my CDE HowTo quick-start tutorial
    Meet us on ##pentaho freenode IRC channel

  13. #13
    Join Date
    Dec 2011
    Posts
    11

    Default

    HI jsanta,

    Can you plz tell me where to place ur ajax call.

    Regards
    Prasath

  14. #14
    Join Date
    Dec 2014
    Posts
    1

    Default https://help.pentaho.com/Documentation/6.1/0P0/000/090

    Quote Originally Posted by Chong Thau Syn View Post
    Hello everyone,
    I would like to ask whether it is possible to call a report from a browser just by typing this in the url without the need to login:
    http://productionserver:8080/pentaho...s&action=Sales by Sales Agent.xaction

    Is it possible that I can add in the parameter for username and password to the url so that it does not prompt me to login? If yes, then how to do it? I am using Pentaho BI Platform 1.7.1.1117. Thks in advance.

    https://help.pentaho.com/Documentation/6.1/0P0/000/090

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.