July 03, 2007, 03:40 PM
KentOMajid, Do you get you authentication working using the Windows user and password? I am also trying to do that, but I have not been able to get the Windows user name to come through when I use the function GETUSER. The name "SYSTEM ADMINISTRATOR" is always returned by GETUSER. I have enabled "Trusted" authentication as documented on pages 91 and 140-150 in the Security and Administration manual. What am I missing?
Kent
July 11, 2007, 05:25 AM
Majid JeddiHi Kento,
I just read that URL and I had the feeling that what I was looking for since it contains a lot of thing to understand.
But since I was in vacation I did not have time to implement that.
I will try next week and I will let you know if I succeed.
Regards
July 11, 2007, 06:09 AM
<JG>KentO,
My bet is that you missed this bit of page 91.
"It also requires the Reporting Server to be configured for operating system security"
Check that the windows envionment has EDAEXTSEC=ON otherwise it your WebFocus server is running
with security off and so it will not pass the ID
July 12, 2007, 08:50 AM
PrarieMy Admin Jeff...asks me to post this for him:
KentO,
AS JG states you will not be able to use GETUSER to return the id of the end user without running a secured reporting server.
You can however get it by passing the value of &REMOTE_USER to the reporting server. REMOTE_USER is the name of the
variable in the HTTP header that contains the users id. Within the WebFOCUS Client this value is passed to a parameter
called &WF_REMOTE_USER, which contains the id with the domain stripped off. Below are 2 ways of getting the id in your
reports:
1. Add the following in WebFOCUS Administration Console --> Client Settings --> Reporting Server
IBI_REPORT_USER = &WF_REMOTE_USER
IBI_REPORT_PASS =
In your program use CNCTUSR instead of GETUSER
-SET &USERID = CNCTUSR('A40');
CNCTUSR will return the value of the connected user when the reporting server is running with security off.
The advantage to setting IBI_REPORT_USER is that if you are using Resource Manager or Analyzer
the users id for Self Service reports will be captured in the tables.
2. Create a new parameter on the WebFOCUS Client and set it to &WF_REMOTE_USER
Add the following in WebFOCUS Administration Console --> Custom Settings
USERID=&WF_REMOTE_USER
This will make the users network id available to the reporting server in a variable called &USERID.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 14, 2007, 08:30 AM
KentOPrarie,
I understand how to get the Userid from the &Remote_User variable in the HTTP header. But is it possible to populate the &Remote_User variable directly from the Windows sign-on used to start the PC.
So far I have had to use a separate WebFOCUS sign on after the morning Windows sign-on.
Kent
Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
August 14, 2007, 09:46 AM
Jeff_1Kent,
Can you please let me know what Webserver and Application server you are using? Does your site have some security package like SiteMinder or RSA Cleartrust? What id are you seeing in your &Remote_User variable?
Jeff
August 17, 2007, 09:11 AM
KentOJeff_1
We use Tomcat 5.5 for Web Server and Windows Server 2003 on the Application Server. We do not have a security package since we only have 16 users on our internal intranet. &REMOTE_USER contains the default "Admin" on the Reporting server.
Is it possible to pickup the Windows logon password without doing a second WebFOCUS sign-on?
Kent
Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE