Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Managed Reporting URL with embedded username/password

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Managed Reporting URL with embedded username/password
 Login/Join
 
ABT
Master
posted
Is it possible to include a username/password in a query string when launching a Managed Reporting FEX from another server? We do the same thing in Crystal Reports/Business Objects, but I am wanting to do something similar in WebFOCUS.

Thinking of something like this:
<a href="http://server.uhseast.com:8080/ibi_apps/Controller?WORP_REQUEST_TYPE=WORP_LAUNCH_CGI&IBIMR_action=MR_RUN_FEX&IBIMR_domain=pulsefin/pulsename.htm&IBIMR_fex=app/fexname.fex&IBIMR_sub_action=MR_STD_REPORT&WORP_MRU=true&IBIMR_random=61330&USER=username&PASS=password">View Report</a><br />


- ABT

This message has been edited. Last edited by: ABT,


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Enigma006
Master
posted Hide Post
I used this before.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
ABT
Master
posted Hide Post
What's the secret? The above didn't work for me.

I get the following whenever I try to run any combination of the above:

Error Number 19402 
Severity Error 
Description Illegal request attempt. 


Possible causes Your session has expired or been invalidated. 


Actions Please signon again. 


--------------------------------------------------------------------------------
Public Views  | Login  | ViewBuilder Login  | Home



- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
susannah
Expert
posted Hide Post
A, front-end fexes are pretty much designed to require that you be logged in to mre, unless your security is totally turned off.
If you put your fexes on the backend (that means in the apps directories), then you can launch them from anywhere you want...
but passing login credentials to an mre fex via a url is not something i've ever seen. Pretty much designed to protect against such things.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Brian Suter
Platinum Member
posted Hide Post
quote:
Controller?WORP_REQUEST_TYPE=WORP_LAUNCH_CGI
is a BID servlet that requires you to already be logged in and errors if not.
Use a drill down style call that uses WFServlet Can't post the details off the top of my head... just build a drill down to an MR fex, run the main report and see what you have. But remember that if you do NOT see the MR_Domain in the drilldown to add it (if it is not on the URL, it uses the last one you used from your cookie - since there is no cookie here, you need to be explicit).


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Report This Post
ABT
Master
posted Hide Post
Brian,
I forgot all about that. I robbed the URL syntax from the Dashboard launched fex (right-click, copy/paste the address bar). I forgot that the time I did something kind of similar before, I used drill-down (that or I didn't connect the dots).

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Waz
Expert
posted Hide Post
This is a huge security hole.

Clear User/password text.

I would not recommend it.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
ABT
Master
posted Hide Post
Agreed, intention was to use a view/execute only user on an intranet.
quote:
Originally posted by Waz:
This is a huge security hole.

Clear User/password text.

I would not recommend it.


@Brian - Thanks for the reminder, this seems to work perfectly.

<a href="http://server:8080/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIMR_drill=X,domain/domain.htm&IBIF_ex=app/bubble.fex">View</a><br />



- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Managed Reporting URL with embedded username/password

Copyright © 1996-2020 Information Builders