Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Qlikview WebTicket Issue

Hi,

I am having some issues when implementing Web Ticket. I am using membership database to authenticate user in My Web application. Then I am generating tickets and creating URL to redirect to my qlikview document. I need to know if need to change directory service connector to configurable ODBC to make it work.

Thanks.

48 Replies
Employee
Employee

Re: Qlikview WebTicket Issue

Authentication and authorisation are independent of each other in QlikView. This means that ticketing will work without a directory service connector but if you like to use any of the data in the membership database for authorisation then you need to connect to the database using a directory service connector to ODBC.

Regards

Fredrik

Not applicable

Re: Qlikview WebTicket Issue

I am connecting to Database using directory service connector to ODBC. Is there any other settings I need to take care?

Not applicable

Re: Qlikview WebTicket Issue

Webticket and Configurable ODBC must be configured independently.

The only relevant thing is that the format of the full username should be consistent.

In other words, if you create an Configurable ODBC, full username will "Directory label value" \ "Entity name row value."

Example:

DSC Configuration

Label Directory "DirectoryTest"

Entity name: "Name"

Entity table: "entity"

Groups table "groups"

entity Table

entityId    Name     descr         email

    1         User1    John    John@test.com

    2         User2    Amy     amy@test.com

The Qlikview usernames will: DirectoryTest\User1, DirectoryTest\User2.

Therefore tickets must be ordered for those usernames.

Pablo.

Not applicable

Re: Qlikview WebTicket Issue

I tried it. It does not work.

Cheers,

Rakhi Agrawal

Senior Tax Consultant| TMC

Deloitte Tax LLP

Tel/Direct: +1 (214) 840 7253 | Mobile: Tel/Direct: +1 469 502 0554

rakhiagrawal@deloitte.com<mailto:rakhiagrawal@deloitte.com> | www.deloitte.com

Please consider the environment before printing.

Not applicable

Re: Qlikview WebTicket Issue

You can test manually, in the browser, with the following URLs.

http://server/QvAjaxZfc/GetWebTicket.aspx?cmd=<Global method='GetWebTicket'><UserId>Test\User1</UserId></Global>

The server will return a ticket

<Global>

     <_retval_>pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC</_retval_>

</Global>

Then you must create a URL with a webticket and access to Qlikview Access Point or .qvw

(Access Point)

http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...

(Qvw )

http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...

Pablo.

brindlogcool
Contributor III

Re: Qlikview WebTicket Issue

Hi Rakhi,

What is the error you are getting?. Are the tickets getting generated or getting invalid error.

brindlogcool
Contributor III

Re: Qlikview WebTicket Issue

Hi Pablo,

I have an issue with the web ticket

1. I am getting the ticket generated for the user.

2.. when i tried to validate the ticket i am getting message as login failed . I have used the same URL

https://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/...

3. Also i am trying to pass values for list box. But the values are not getting selected . The url looks like

https://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/...

Any idea why the parameters are not getting selected in iFrame it would be really helpful if someone could share the information

Not applicable

Re: Qlikview WebTicket Issue

Brindlogcool,

is the user authorized to access the .qvw application?

Can you access to user Access Point? (http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...)

You can encode the TryURL. with http://meyerweb.com/eric/tools/dencoder/.

For example

TryUrl : /QvAJAXZfc/opendoc.htm?document=Application.qvw&select=LB1,1

TryEncodedUrl : %2FQvAJAXZfc%2Fopendoc.htm%3Fdocument%3DApplication.qvw%26select%3DLB1%2C1

General URL: http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...

Pablo

brindlogcool
Contributor III

Re: Qlikview WebTicket Issue

Hi Pablo,

Thanks for the quick response. Really appreciate it

I have access to all the documents.

Little bit improvement in it. When i try below url in browser it is redirecting to the Access point home page and not getting failed. But the same is getting redirecting correctly to the document in iframe. it is kind of confusing.

server/QvAJAXZfc/authenticate.aspx?typehtml&webticket=prsadasfdfdsf=/QvAJAXZfc/opendoc.htm?document=a.qvw&select

How to validate the ticket which is generated.  

I will check the encoder and confirm it.