10 Replies Latest reply on Sep 25, 2019 2:04 PM by Matt Coles

    "HTTPError generating trusted ticket: Unauthorized" in log files and won't kick off any VizAlerts

    Brian Brooks

      Hi VizAlerts community,

      We have a successful installation of VizAlerts in our DEV environment which runs great. When trying to deploy this to our PROD environment, we have been running into a few snags that I'm hoping someone can give us some assistance with. It looks like we're finally generating the trusted tickets on the server, but we are now getting the HTTPError generating trusted ticket: Unauthorized error message. I've verified that we published the config workbook with the embedded password and also have ensured our yaml file has the server.ssl set to true. Any other thoughts on what to look for?

       

       

      MainThread - 2019-09-24 10:02:55 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2019-09-24.log

      MainThread - 2019-09-24 10:02:55 - [INFO] - main - VizAlerts v2.1.1 is starting

      MainThread - 2019-09-24 10:02:55 - [DEBUG] - trusted_ticket_test - testing trusted ticket: tableau.dns.com, domain\svc.serviceaccount, None, None

      MainThread - 2019-09-24 10:02:55 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: tableau.dns.com, Site: , Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount.

      MainThread - 2019-09-24 10:02:55 - [DEBUG] - get_trusted_ticket - using SSL and verifying cert using certfile C:\Certs\xxyycert.pem

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - Got ticket: C7A67RunTjyw6OlfS4S7Pw==:rxzjaaifX-U5Y8EMuLckakHB

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: C7A67RunTjyw6OlfS4S7Pw==:rxzjaaifX-U5Y8EMuLckakHB

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_alerts - Pulling source viz data down

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - using SSL and verifying cert using certfile C:\Certs\xxyycert.pem

      MainThread - 2019-09-24 10:02:56 - [ERROR] - get_trusted_ticket - HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [ERROR] - export_view - Generic exception trying to export the url https://tableau.dns.com/t/Primary/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y to csv, error: HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - using SSL and verifying cert using certfile C:\Certs\xxyycert.pem

      MainThread - 2019-09-24 10:02:56 - [ERROR] - get_trusted_ticket - HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [ERROR] - export_view - Generic exception trying to export the url https://tableau.dns.com/t/Primary/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y to csv, error: HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - get_trusted_ticket - using SSL and verifying cert using certfile C:\Certs\xxyycert.pem

      MainThread - 2019-09-24 10:02:56 - [ERROR] - get_trusted_ticket - HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [ERROR] - export_view - Generic exception trying to export the url https://tableau.dns.com/t/Primary/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y to csv, error: HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [ERROR] - download_trigger_data - Generic exception trying to export the url https://tableau.dns.com/t/Primary/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y to csv, error: HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [INFO] - send_email - sending email: relay.domain.com,vizalerts@pork.domain.com,serveradmin@pork.domain.com,None,None,ALERT: VizAlerts failed to execute properly,None

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - send_email - email body: Could not process source viz data from VizAlertsConfig/ScheduledTriggerViews for the following reasons:<br/><br/>Generic exception trying to export the url https://tableau.dns.com/t/Primary/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y to csv, error: HTTPError generating trusted ticket: Unauthorized  Request details: Server: tableau.dns.com, Site: Primary, Username: domain\svc.serviceaccount, Url: https://tableau.dns.com/trusted, Postdata: username=domain%5Csvc.serviceaccount&amp;amp;target_site=Primary.

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - send_email - TO ADDRESS: serveradmin@pork.domain.com

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - send_email - CC ADDRESS: None

      MainThread - 2019-09-24 10:02:56 - [DEBUG] - send_email - BCC ADDRESS: None

      MainThread - 2019-09-24 10:02:56 - [ERROR] - <module> - An unhandled exception occurred: Traceback (most recent call last):

        File "vizalerts.py", line 488, in <module>

        File "vizalerts.py", line 143, in main

        File "vizalerts.py", line 236, in get_alerts

        File "vizalerts.py", line 474, in quit_script

      SystemExit: 1

      Traceback (most recent call last):

        File "vizalerts.py", line 488, in <module>

        File "vizalerts.py", line 143, in main

        File "vizalerts.py", line 236, in get_alerts

        File "vizalerts.py", line 474, in quit_script

      SystemExit: 1