1 Reply Latest reply on Aug 10, 2011 3:09 PM by TSGal

    Send Mail script step fails with SMTP Servers

    RichTea

      Summary

      Send Mail script step fails with SMTP Servers

      Product

      FileMaker Pro

      Version

      Filemaker Pro Advanced 11.0v3

      Operating system version

      WINDOWS XP SP3

      Description of the issue

      Send Mail script step fails to send a simple message with error 1506 when the SMTP server option is used with 2 different servers. The MAILIT plugin works with both these servers using their SIMPLE SENDING.FP7 example.

      One SMTP server requires no authentication throough port 2525.
      The other requires authentication through port 25.

      Using WIRESHARK to monitor the port traffic I have documented this in 4 cases.

      Case 1: MAILIT uses SMPT2GO.COM non-authenticated SMTP server on port 2525 and sends the email which reaches its destination.

      Case 2: Script step 'Send Mail' uses SMPT2GO.COM non-authenticated SMTP server on port 2525 and fails with error 1506.

      Case 3: MAILIT uses our mail server SENDMAIL on port 25 with authentication and send the email which reaches its destination.

      Case 4: Script step 'Send Mail' uses our mail server SENDMAIL on port 25 with authentication and fails with error 1506.

      The WIRESHARK log files summarising the protocol data are shown for the 4 cases in the expected and actual result notes.

      I have the detailed log files with all the frame data etc.

      In both cases FILEMAKER sends a FIN,ACK message after the initial 3-step handshake - why ?

      Steps to reproduce the problem

      You can use our SMTP2GO account with the following configuration:

      SMTP server:  smtp2go.com
      Email senders address:  testsmtp@reetec.co.uk
      Port 2525:
      No authentication or encryption required.

      Use the 'Send Email' with SMTP server option to send an email.

      Analyse the TCP port traffic.

      Expected result

      Case 1: the protocol progresses with PSH,ACK and ACK to the end.
      No.     Time        Source                Destination           Protocol Info
            1 0.000000    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [SYN] Seq=0 Win=65535 Len=0 MSS=1460
            2 0.102300    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [SYN, ACK] Seq=0 Ack=1 Win=5840 Len=0 MSS=1452
            3 0.102342    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [ACK] Seq=1 Ack=1 Win=65535 Len=0
            4 5.213918    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=1 Ack=1 Win=5840 Len=81
            5 5.214050    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=1 Ack=82 Win=65454 Len=26
            6 5.315578    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=82 Ack=27 Win=5840 Len=0
            7 5.315605    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=27 Ack=82 Win=65454 Len=2
            8 5.416363    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=82 Ack=29 Win=5840 Len=0
            9 5.417242    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=82 Ack=29 Win=5840 Len=176
           10 5.447363    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=29 Ack=258 Win=65278 Len=33
           11 5.586387    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=258 Ack=62 Win=5840 Len=0
           12 5.586432    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=62 Ack=258 Win=65278 Len=2
           13 5.687354    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=258 Ack=64 Win=5840 Len=0
           14 5.695441    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=258 Ack=64 Win=5840 Len=8
           15 5.696333    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=64 Ack=266 Win=65270 Len=27
           16 5.834713    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=266 Ack=91 Win=5840 Len=0
           17 5.834760    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=91 Ack=266 Win=65270 Len=2
           18 5.935929    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=266 Ack=93 Win=5840 Len=0
           19 5.936390    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=266 Ack=93 Win=5840 Len=14
           20 5.936654    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=93 Ack=280 Win=65256 Len=4
           21 6.074468    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=280 Ack=97 Win=5840 Len=0
           22 6.074503    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=97 Ack=280 Win=65256 Len=2
           23 6.176440    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=280 Ack=99 Win=5840 Len=0
           24 6.203545    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=280 Ack=99 Win=5840 Len=56
           25 6.203653    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=99 Ack=336 Win=65200 Len=30
           26 6.342283    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=336 Ack=129 Win=5840 Len=0
           27 6.342407    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=129 Ack=336 Win=65200 Len=955
           28 6.454480    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=336 Ack=1084 Win=7640 Len=0
           29 6.568283    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=336 Ack=1084 Win=7640 Len=28
           30 6.573640    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=1084 Ack=364 Win=65172 Len=4
           31 6.674685    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=364 Ack=1088 Win=7640 Len=0
           32 6.674727    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [PSH, ACK] Seq=1088 Ack=364 Win=65172 Len=2
           33 6.775912    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=364 Ack=1090 Win=7640 Len=0
           34 6.777236    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [PSH, ACK] Seq=364 Ack=1090 Win=7640 Len=36
           35 6.777248    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [FIN, ACK] Seq=400 Ack=1090 Win=7640 Len=0
           36 6.777270    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [ACK] Seq=1090 Ack=401 Win=65136 Len=0
           37 6.777338    192.168.0.30          207.58.142.213        TCP      trp > ms-v-worlds [FIN, ACK] Seq=1090 Ack=401 Win=65136 Len=0
           38 6.878908    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > trp [ACK] Seq=401 Ack=1091 Win=7640 Len=0

      Case 3: the process proceeds with TCP and SMTP to the end.
      No.     Time        Source                Destination           Protocol Info
            1 0.000000    192.168.0.30          213.198.57.14         TCP      umsp > smtp [SYN] Seq=0 Win=65535 Len=0 MSS=1460
            2 0.027641    213.198.57.14         192.168.0.30          TCP      smtp > umsp [SYN, ACK] Seq=0 Ack=1 Win=57344 Len=0 MSS=1452
            3 0.027665    192.168.0.30          213.198.57.14         TCP      umsp > smtp [ACK] Seq=1 Ack=1 Win=65535 Len=0
            4 5.072293    213.198.57.14         192.168.0.30          SMTP     S: 220 reetec.veriovps.co.uk ESMTP Sendmail 8.13.6.20060614/8.13.6; Mon, 25 Jul 2011 21:32:33 GMT
            5 5.072433    192.168.0.30          213.198.57.14         SMTP    
            6 5.198338    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=97 Ack=27 Win=58080 Len=0
            7 5.198356    192.168.0.30          213.198.57.14         SMTP     C: EHLO localhost.localdomain
            8 5.225489    213.198.57.14         192.168.0.30          SMTP     S: 250-reetec.veriovps.co.uk Hello reetec.plus.com [80.229.44.27], pleased to meet you | 250-ENHANCEDSTATUSCODES | 250-PIPELINING | 250-8BITMIME | 250-SIZE | 250-DSN | 250-ETRN | 250-AUTH PLAIN LOGIN | 250-DELIVERBY | 250 HELP
            9 5.226652    192.168.0.30          213.198.57.14         SMTP     C: AUTH LOGIN
           10 5.348842    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=313 Ack=39 Win=58080 Len=0
           11 5.348874    192.168.0.30          213.198.57.14         SMTP     C: AUTH LOGIN
           12 5.375938    213.198.57.14         192.168.0.30          SMTP     S: 334 VXNlcm5hbWU6
           13 5.375984    192.168.0.30          213.198.57.14         SMTP     C: cmljaGFyZA==
           14 5.498160    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=331 Ack=53 Win=58080 Len=0
           15 5.498202    192.168.0.30          213.198.57.14         SMTP     C: cmljaGFyZA==
           16 5.525240    213.198.57.14         192.168.0.30          SMTP     S: 334 UGFzc3dvcmQ6
           17 5.525292    192.168.0.30          213.198.57.14         SMTP     C: RW0xbHlQYXQ=
           18 5.648943    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=349 Ack=67 Win=58080 Len=0
           19 5.648959    192.168.0.30          213.198.57.14         SMTP     C: RW0xbHlQYXQ=
           20 5.680982    213.198.57.14         192.168.0.30          SMTP     S: 235 2.0.0 OK Authenticated
           21 5.700626    192.168.0.30          213.198.57.14         SMTP     C: MAIL FROM:
           22 5.818282    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=377 Ack=102 Win=58080 Len=0
           23 5.818326    192.168.0.30          213.198.57.14         SMTP     C: MAIL FROM:
           24 5.847284    213.198.57.14         192.168.0.30          SMTP     S: 250 2.1.0 ... Sender ok
           25 5.848017    192.168.0.30          213.198.57.14         SMTP     C: RCPT TO:
           26 5.968603    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=425 Ack=131 Win=58080 Len=0
           27 5.968639    192.168.0.30          213.198.57.14         SMTP     C: RCPT TO:
           28 5.996857    213.198.57.14         192.168.0.30          SMTP     S: 250 2.1.5 ... Recipient ok
           29 5.997116    192.168.0.30          213.198.57.14         SMTP     C: DATA
           30 6.118319    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=472 Ack=137 Win=58080 Len=0
           31 6.118362    192.168.0.30          213.198.57.14         SMTP     C: DATA
           32 6.146435    213.198.57.14         192.168.0.30          SMTP     S: 354 Enter mail, end with "." on a line by itself
           33 6.146526    192.168.0.30          213.198.57.14         SMTP     C: Content-Type: multipart/mixed;
           34 6.269161    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=522 Ack=169 Win=58080 Len=0
           35 6.269269    192.168.0.30          213.198.57.14         SMTP     C: Content-Type: multipart/mixed;
           36 6.313704    213.198.57.14         192.168.0.30          SMTP     S: 250 2.0.0 p6PLWXxH066741 Message accepted for delivery
           37 6.330467    192.168.0.30          213.198.57.14         SMTP     C: QUIT
           38 6.449004    213.198.57.14         192.168.0.30          TCP      smtp > umsp [ACK] Seq=578 Ack=1128 Win=58080 Len=0
           39 6.449037    192.168.0.30          213.198.57.14         SMTP     C: QUIT
           40 6.476695    213.198.57.14         192.168.0.30          SMTP     S: 221 2.0.0 reetec.veriovps.co.uk closing connection
           41 6.476801    192.168.0.30          213.198.57.14         TCP      umsp > smtp [FIN, ACK] Seq=1130 Ack=630 Win=64906 Len=0
           42 6.477172    213.198.57.14         192.168.0.30          TCP      smtp > umsp [FIN, ACK] Seq=630 Ack=1130 Win=58080 Len=0
           43 6.477200    192.168.0.30          213.198.57.14         TCP      umsp > smtp [ACK] Seq=1131 Ack=631 Win=64906 Len=0
           44 6.503688    213.198.57.14         192.168.0.30          TCP      smtp > umsp [FIN, ACK] Seq=630 Ack=1131 Win=58080 Len=0

      Actual result

      Case 2: After the initial 3-step SYN : SYN,ACK : ACK FILEMAKER sends a FIN,ACK message ?
      No.     Time        Source                Destination           Protocol Info
            1 0.000000    192.168.0.30          207.58.142.213        TCP      pearldoc-xact > ms-v-worlds [SYN] Seq=0 Win=65535 Len=0 MSS=1460
            2 0.102395    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > pearldoc-xact [SYN, ACK] Seq=0 Ack=1 Win=5840 Len=0 MSS=1452
            3 0.102434    192.168.0.30          207.58.142.213        TCP      pearldoc-xact > ms-v-worlds [ACK] Seq=1 Ack=1 Win=65535 Len=0
            4 5.105533    192.168.0.30          207.58.142.213        TCP      pearldoc-xact > ms-v-worlds [FIN, ACK] Seq=1 Ack=1 Win=65535 Len=0
            5 5.208832    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > pearldoc-xact [PSH, ACK] Seq=1 Ack=2 Win=5840 Len=81
            6 5.208971    192.168.0.30          207.58.142.213        TCP      pearldoc-xact > ms-v-worlds [RST, ACK] Seq=2 Ack=82 Win=0 Len=0
            7 5.209312    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > pearldoc-xact [PSH, ACK] Seq=82 Ack=2 Win=5840 Len=39
            8 5.209322    207.58.142.213        192.168.0.30          TCP      ms-v-worlds > pearldoc-xact [FIN, ACK] Seq=121 Ack=2 Win=5840 Len=0

      Case 4: After the initial 3-step SYN : SYN,ACK : ACK FILEMAKER sends a FIN,ACK message ?
      No.     Time        Source                Destination           Protocol Info
            1 0.000000    192.168.0.30          213.198.57.14         TCP      cypress > smtp [SYN] Seq=0 Win=65535 Len=0 MSS=1460
            2 0.027603    213.198.57.14         192.168.0.30          TCP      smtp > cypress [SYN, ACK] Seq=0 Ack=1 Win=57344 Len=0 MSS=1452
            3 0.027643    192.168.0.30          213.198.57.14         TCP      cypress > smtp [ACK] Seq=1 Ack=1 Win=65535 Len=0
            4 5.028296    192.168.0.30          213.198.57.14         TCP      cypress > smtp [FIN, ACK] Seq=1 Ack=1 Win=65535 Len=0
            5 5.056189    213.198.57.14         192.168.0.30          TCP      smtp > cypress [ACK] Seq=1 Ack=2 Win=58080 Len=0
            6 5.065158    213.198.57.14         192.168.0.30          SMTP     S: 220 reetec.veriovps.co.uk ESMTP Sendmail 8.13.6.20060614/8.13.6; Mon, 25 Jul 2011 21:21:41 GMT
            7 5.065288    192.168.0.30          213.198.57.14         TCP      cypress > smtp [RST, ACK] Seq=2 Ack=97 Win=0 Len=0
            8 5.066479    213.198.57.14         192.168.0.30          TCP      smtp > cypress [FIN, ACK] Seq=97 Ack=2 Win=58080 Len=0

        • 1. Re: Send Mail script step fails with SMTP Servers
          TSGal

          RichTea:

          Thank you for your post.

          There have been a number of reports of Send Mail through SMTP servers cause problems.  One common problem occurs if you include the name with the email address.  That is, if the name is removed and only the email address is sent, it completes correctly.

          Other times, an error has been received, but the email was actually sent.  Does this occur at all for you?

          Any other information you can provide about the email being sent (CC?  BCC?  Attachments? etc.) may be helpful.

          TSGal
          FileMaker, Inc.