Could not locate unexpired trusted ticket

[java-guy]

Hi,

I have installed the confluence module and have whitelisted the IP of my confluence server in tableau server.
I get the mentioned error message: Could not locate unexpired trusted ticket
Any help would be appreciated.

At the moment no SSL cert is set for the tableau server. Confluence however is using SSL. Is it possible that this is the reason for the problem?

I'm using Confluence 6.8.2 and tableau 2018.1

BR, jg

[iheitlager]

@java-guy is this message shown in you browser or in the log? It seems like confluence was not able to authenticate. Every request to confluence triggers an authentication request to tableau (which is an expirable trusted ticket). That is passed to the client, the browser is than requesting content from Tableau client side based on that ticket.

Few steps to take into account:

• indeed make sure both are behind SSL otherwise you would end up with mixed content
• add the Tableau SSL cert to the Confluence certificate store
• make sure that both have the same users. The user logged into confluence is the user logged into tableau. The link is trusted between the two (confluence is adding the user) and both should have the same user (and domain in case of AD)
• make sure the user has access to the site in tableau

HTH

[ratkobucic]

Hi,
Atlassian Confluence 6.8.2 reporting your plugin is not compatible. Same with ver 6.9 of Confluence. Could this be cause of plugin not working with Confluence?
Anyway, that error "Could not locate unexpired trusted ticket" shows up on Confluence pages, even everything above you listed is fulfilled.
Only I'm not sure if I understand this correct - every user on Confluence must exist with same username on Tableau ? Or it is enough that user who create page and use plugin to fetch data from Tableau exist on both servers?

[ratkobucic]

Also, just found this.
When I open browser console on wiki page with embeded Tableau report...
It give interesting error:

Refused to execute script from 'https://tableau.server.com/vizql/v_201811805101418/javascripts/vizqlserver/hide-load-indicators.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.

and link which is posted to Tableau is:

https://tableau.server.com/trusted/%3C!DOCTYPE%20html%3E%3Chtml%3E%3Chead%3E%3Cmeta%20charset=

And that is not what should be posted to trusted link... So, instead to post https://tableau.server.com/trusted/username=admin... it POST beginning of HTML page code... and that can be cause Tableau return expired ticket, as username was not sent...

From doc:

The web server sends a POST request to the trusted Tableau Server (for example, https://tabaserver/trusted, not https://tabserver). That POST request must have a username parameter. The username value must be the username for a licensed Tableau Server user.

[ratkobucic]

Error from Tableau server (if helps):

2018-07-01 23:19:17.458 +0200 (,,-,WzlFVa7nnitKUiRPIi8uFQAAAW4) catalina-exec-135 : ERROR wgsessionId=sxVIHQmtTauWC6DQNRG8Cg com.tableausoftware.model.workgroup.service.TrustedTicketServiceImpl - an attempt was made to redeem a ticket with the wrong format for this server