1 Reply Latest reply on Jan 28, 2020 7:04 AM by Matt Coles

    Email failed to send: [Errno 11001]

    YASIN CAN PARLAK

      Hi Everyone,

       

      I have a problem with setting up VizAlert in a SSL configured environment and I do not know what I am missing out on this;

       

       

       

      d:\VizAlert\vizalerts>vizalerts.exe

      2020-01-28 14:27:16 - [INFO] - Logging initialized, writing to .\logs\vizalerts.

      log_2020-01-28.log

      2020-01-28 14:27:16 - [INFO] - VizAlerts v2.1.1 is starting

      2020-01-28 14:27:16 - [DEBUG] - testing trusted ticket: tableau.sabancinet.com,

      Administrator, None, 192.168.229.59

      2020-01-28 14:27:16 - [DEBUG] - Generating trusted ticket. Request details: Serv

      er: tableau.sabancinet.com, Site: , Username: Administrator, Url: https://tablea

      u.sabancinet.com/trusted, Postdata: username=Administrator&client_ip=192.168.229

      .59.

      2020-01-28 14:27:16 - [DEBUG] - using SSL and verifying cert using certfile D:\T

      ayfun\sabancinet.pem

      2020-01-28 14:27:16 - [DEBUG] - Got ticket: yxVRPsMWQDa5UqSZoUTwYA==:87z3Z1alWpk

      7KwdV6yRNt5EA

      2020-01-28 14:27:16 - [DEBUG] - Generated test trusted ticket. Value is: yxVRPsM

      WQDa5UqSZoUTwYA==:87z3Z1alWpk7KwdV6yRNt5EA

      2020-01-28 14:27:16 - [DEBUG] - Pulling source viz data down

      2020-01-28 14:27:16 - [DEBUG] - Generating trusted ticket. Request details: Serv

      er: tableau.sabancinet.com, Site: , Username: Administrator, Url: https://tablea

      u.sabancinet.com/trusted, Postdata: username=Administrator&client_ip=192.168.229

      .59.

      2020-01-28 14:27:16 - [DEBUG] - using SSL and verifying cert using certfile D:\T

      ayfun\sabancinet.pem

      2020-01-28 14:27:17 - [DEBUG] - Got ticket: VY4w60-ZSC2xvadbIBlZpA==:PsIwGVnC5mr

      LUON64Nn0nqwy

      2020-01-28 14:27:17 - [DEBUG] - Getting vizdata from: https://tableau.sabancinet

      .com/trusted/VY4w60-ZSC2xvadbIBlZpA==:PsIwGVnC5mrLUON64Nn0nqwy/views/VizAlertsCo

      nfig/ScheduledTriggerViews?&:format=csv&:refresh=y

      2020-01-28 14:27:17 - [DEBUG] - Validating cert for this request using certfile

      D:\Tayfun\sabancinet.pem

      2020-01-28 14:27:17 - [DEBUG] - Starting new HTTPS connection (1): tableau.saban

      cinet.com

      2020-01-28 14:27:17 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /trusted

      /VY4w60-ZSC2xvadbIBlZpA==:PsIwGVnC5mrLUON64Nn0nqwy/views/VizAlertsConfig/Schedul

      edTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

      2020-01-28 14:27:17 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /views/V

      izAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1"

      200 2523

      2020-01-28 14:27:17 - [INFO] - Attempting to write to: .\temp\202001281427176060

      00_MainThread_VizAlertsConfig-ScheduledTriggerViews.csv

      2020-01-28 14:27:17 - [INFO] - Processing a total of 1 alerts

      2020-01-28 14:27:17 - [DEBUG] - Queueing subscription id -22 for processing

      2020-01-28 14:27:17 - [DEBUG] - Starting thread with name: 1

      2020-01-28 14:27:17 - [DEBUG] - Starting thread with name: 2

      2020-01-28 14:27:17 - [DEBUG] - Thread 1 is processing subscription_id -22, view

      _id 1290, site_name Default, customized_view_id None, view_name ScheduledTrigger

      Views

      2020-01-28 14:27:17 - [DEBUG] - Starting to download trigger data

      2020-01-28 14:27:17 - [DEBUG] - Generating trusted ticket. Request details: Serv

      er: tableau.sabancinet.com, Site: , Username: Administrator, Url: https://tablea

      u.sabancinet.com/trusted, Postdata: username=Administrator&client_ip=192.168.229

      .59.

      2020-01-28 14:27:17 - [DEBUG] - using SSL and verifying cert using certfile D:\T

      ayfun\sabancinet.pem

      2020-01-28 14:27:17 - [DEBUG] - Got ticket: GK4g1l7RQR-nX4_s-8xOBw==:UbkApF2MpYa

      2ylo0JtQY18oM

      2020-01-28 14:27:17 - [DEBUG] - Getting vizdata from: https://tableau.sabancinet

      .com/trusted/GK4g1l7RQR-nX4_s-8xOBw==:UbkApF2MpYa2ylo0JtQY18oM/views/VizAlertsCo

      nfig/ScheduledTriggerViews?&:format=csv&:refresh=y

      2020-01-28 14:27:17 - [DEBUG] - Validating cert for this request using certfile

      D:\Tayfun\sabancinet.pem

      2020-01-28 14:27:17 - [DEBUG] - Starting new HTTPS connection (1): tableau.saban

      cinet.com

      2020-01-28 14:27:17 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /trusted

      /GK4g1l7RQR-nX4_s-8xOBw==:UbkApF2MpYa2ylo0JtQY18oM/views/VizAlertsConfig/Schedul

      edTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

      2020-01-28 14:27:18 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /views/V

      izAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1"

      200 2523

      2020-01-28 14:27:18 - [INFO] - Attempting to write to: .\temp\202001281427181920

      00_1_VizAlertsConfig-ScheduledTriggerViews.csv

      2020-01-28 14:27:18 - [DEBUG] - Got trigger data, now parsing fields

      2020-01-28 14:27:18 - [DEBUG] - Parsing action fields

      2020-01-28 14:27:18 - [DEBUG] - searching for action fields

      2020-01-28 14:27:18 - [DEBUG] - Retrieving all errors found in field parse opera

      tion

      2020-01-28 14:27:18 - [DEBUG] - Validating trigger data

      2020-01-28 14:27:18 - [DEBUG] - Validating as a simple alert

      2020-01-28 14:27:18 - [DEBUG] - testing address derya.sahin@sabancidx.com agains

      t regex .*@sabancidx\.com

      2020-01-28 14:27:18 - [DEBUG] - Splitting Address: localpart, domainname, host,

      toplevel: derya.sahin,sabancidx.com,sabancidx,com

      2020-01-28 14:27:18 - [DEBUG] - Removing other characters from address: localpar

      t, host: deryasahin,sabancidx

      2020-01-28 14:27:18 - [DEBUG] - Performing alert actions

      2020-01-28 14:27:18 - [DEBUG] - Performing alert actions now

      2020-01-28 14:27:18 - [DEBUG] - Processing as a simple alert

      2020-01-28 14:27:18 - [DEBUG] - Generating trusted ticket. Request details: Serv

      er: tableau.sabancinet.com, Site: , Username: Administrator, Url: https://tablea

      u.sabancinet.com/trusted, Postdata: username=Administrator&client_ip=192.168.229

      .59.

      2020-01-28 14:27:18 - [DEBUG] - using SSL and verifying cert using certfile D:\T

      ayfun\sabancinet.pem

      2020-01-28 14:27:18 - [DEBUG] - Got ticket: -UZPnAoLSK20EAbh6PSsrQ==:WZJZDTGqpJJ

      _n2u3niOWJX51

      2020-01-28 14:27:18 - [DEBUG] - Getting vizdata from: https://tableau.sabancinet

      .com/trusted/-UZPnAoLSK20EAbh6PSsrQ==:WZJZDTGqpJJ_n2u3niOWJX51/views/VizAlertsCo

      nfig/ScheduledTriggerViews?&:format=png&:size=1500,1500&:refresh=y

      2020-01-28 14:27:18 - [DEBUG] - Validating cert for this request using certfile

      D:\Tayfun\sabancinet.pem

      2020-01-28 14:27:18 - [DEBUG] - Starting new HTTPS connection (1): tableau.saban

      cinet.com

      2020-01-28 14:27:18 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /trusted

      /-UZPnAoLSK20EAbh6PSsrQ==:WZJZDTGqpJJ_n2u3niOWJX51/views/VizAlertsConfig/Schedul

      edTriggerViews?&:format=png&:size=1500,1500&:refresh=y HTTP/1.1" 302 0

      2020-01-28 14:27:18 - [DEBUG] - https://tableau.sabancinet.com:443 "GET /views/V

      izAlertsConfig/ScheduledTriggerViews?&:format=png&:size=1500,1500&:refresh=y&:em

      bed=y HTTP/1.1" 200 83259

      2020-01-28 14:27:18 - [INFO] - Attempting to write to: .\temp\202001281427189140

      00_1_VizAlertsConfig-ScheduledTriggerViews.png

      2020-01-28 14:27:18 - [INFO] - Sending simple alert email to user derya.sahin@sa

      bancidx.com

      2020-01-28 14:27:18 - [DEBUG] - Processing 1 alert tasks for alert a36a4657-34b0

      -480f-9dd5-05342e563923

      2020-01-28 14:27:18 - [DEBUG] - Spinning up task threads

      2020-01-28 14:27:18 - [DEBUG] - New thread name will be a36a4657-34b0-480f-9dd5-

      05342e563923_0

      2020-01-28 14:27:18 - [DEBUG] - Starting task thread with name: a36a4657-34b0-48

      0f-9dd5-05342e563923_0

      2020-01-28 14:27:18 - [DEBUG] - All threads: [<_MainThread(MainThread, started 1

      7464)>, <TaskWorker(a36a4657-34b0-480f-9dd5-05342e563923_0, started 15944)>, <Vi

      zAlertWorker(1, started 15780)>]

      2020-01-28 14:27:18 - [DEBUG] - Thread a36a4657-34b0-480f-9dd5-05342e563923_0 is

      processing task_id c0598645-6e78-4f88-9d28-e2e33a316495, from subscription_id -

      22, view_id 1290, site_name Default, customized_view_id None, view_name Schedule

      dTriggerViews

      2020-01-28 14:27:18 - [DEBUG] - starting task execution for task c0598645-6e78-4

      f88-9d28-e2e33a316495

      2020-01-28 14:27:18 - [DEBUG] - Task is type email, sending now

      2020-01-28 14:27:18 - [INFO] - sending email: http://192.168.200.85,derya.sahin@

      sabancidx.com,derya.sahin@sabancidx.com,None,None,Alert triggered for ScheduledT

      riggerViews,[{'imagepath': u'.\\temp\\20200128142718914000_1_VizAlertsConfig-Sch

      eduledTriggerViews.png'}]

      2020-01-28 14:27:18 - [DEBUG] - email body: <a href="https://tableau.sabancinet.

      com/views/VizAlertsConfig/ScheduledTriggerViews"><img src="cid:20200128142718914

      000_1_VizAlertsConfig-ScheduledTriggerViews.png"></a><br><br><font size="2"><i>T

      his VizAlerts email generated on behalf of <a href="mailto:derya.sahin@sabancidx

      .com">Administrator</a>, from view <a href="https://tableau.sabancinet.com/views

      /VizAlertsConfig/ScheduledTriggerViews">ScheduledTriggerViews</a></i></font>

      2020-01-28 14:27:18 - [DEBUG] - TO ADDRESS: derya.sahin@sabancidx.com

      2020-01-28 14:27:18 - [DEBUG] - CC ADDRESS: None

      2020-01-28 14:27:18 - [DEBUG] - BCC ADDRESS: None

      2020-01-28 14:27:19 - [ERROR] - Email failed to send: [Errno 11001] getaddrinfo

      failed

      2020-01-28 14:27:19 - [ERROR] - Could not execute task c0598645-6e78-4f88-9d28-e

      2e33a316495:

      2020-01-28 14:27:19 - [ERROR] - Unable to process task c0598645-6e78-4f88-9d28-e

      2e33a316495 from alert ScheduledTriggerViews, error:

      2020-01-28 14:27:19 - [DEBUG] - All errors found:

      2020-01-28 14:27:19 - [DEBUG] - Unable to process task c0598645-6e78-4f88-9d28-e

      2e33a316495 from alert ScheduledTriggerViews, error:

      2020-01-28 14:27:19 - [INFO] - sending email: http://192.168.200.85,derya.sahin@

      sabancidx.com,derya.sahin@sabancidx.com,derya.sahin@sabancidx.com,None,VizAlerts

      was unable to process alert ScheduledTriggerViews,None

      2020-01-28 14:27:19 - [DEBUG] - email body: The following errors were encountere

      d trying to process your alert:<br /><br /><br /><br />General errors:<br /><br

      />Unable to process task c0598645-6e78-4f88-9d28-e2e33a316495 from alert Schedul

      edTriggerViews, error: <br><br><b>Alert Information:</b><br><br><b>View URL:</b>

      <a href="https://tableau.sabancinet.com/views/VizAlertsConfig/ScheduledTriggerV

      iews">https://tableau.sabancinet.com/views/VizAlertsConfig/ScheduledTriggerViews

      <a><br><b>Subscriber:</b> <a href="mailto:derya.sahin@sabancidx.com">Administrat

      or</a><br><b>View Owner:</b> <a href="mailto:derya.sahin@sabancidx.com">Administ

      rator</a><br><b>Site Id:</b> Default<br><b>Project:</b> VizAlert

      2020-01-28 14:27:19 - [DEBUG] - TO ADDRESS: derya.sahin@sabancidx.com

      2020-01-28 14:27:19 - [DEBUG] - CC ADDRESS: derya.sahin@sabancidx.com

      2020-01-28 14:27:19 - [DEBUG] - BCC ADDRESS: None

      2020-01-28 14:27:19 - [ERROR] - Email failed to send: [Errno 11001] getaddrinfo

      failed

      2020-01-28 14:27:19 - [ERROR] - Unknown error sending exception alert email:

      2020-01-28 14:27:21 - [DEBUG] - Task threads still in progress for alert a36a465

      7-34b0-480f-9dd5-05342e563923. Sleeping 3 seconds

      2020-01-28 14:27:21 - [DEBUG] - All threads: [<_MainThread(MainThread, started 1

      7464)>, <VizAlertWorker(1, started 15780)>]

      2020-01-28 14:27:21 - [DEBUG] - Task threads have completed for alert a36a4657-3

      4b0-480f-9dd5-05342e563923. Returning.

      2020-01-28 14:27:27 - [INFO] - Waiting on 0 worker threads. Currently active thr

      eads:: [<_MainThread(MainThread, started 17464)>]

      2020-01-28 14:27:27 - [INFO] - Worker threads have completed. Exiting

      d:\VizAlert\vizalerts>

       

      Thank you

      Best Regards

      Yasin