8 Replies Latest reply on May 12, 2015 7:09 AM by TSGal

    Insert from URL fails for SNI

    JohnArmstrong

      Summary

      Insert from URL fails for SNI

      Product

      FileMaker Pro

      Version

      13.0v3

      Operating system version

      OSX 10.9.3

      Description of the issue

      We recently upgraded from FMP 11 to FMP 13 (hooray!) and are attempting to replace our webscrape workflows with Insert from URL workflows.

      The problem is that Insert from URL is not providing proper host headers so SNI fails (SNI is how a single IP can server multiple SSL certificates, very common now).

      The oddity here is that the WebViewer DOES support SNI properly on the same URLs.

      This is making transition a pain.

      Any insight or is anyone else seeing this? Am I doing it wrong or is this an FMP bug?

      Tx!

      John-

      Steps to reproduce the problem

      NOTE: I can provide endpoints to test this issue with.
      ----------
      If you want to setup your own:

      Setup a virtualhost using SSL on a shared IP (SNI).

      Try to connect to it over SSL using Insert from URL, observe it fails (you will see this in the server logs, not in FMP). Observe also that the field you insert into has an error sent back by the webserver.

      Try to connect to it using a WebViewer, observe it succeeds (the WebViewer will populate properly).

      Expected result

      Insert from URL should send host header so that SNI works. SNI is pretty common now.

      Actual result

      SNI fails since it does not send the Host header.

      Exact text of any error message(s) that appear

      FMP makes an invalid request so the error that returns is the webserver error.

      Workaround

      Use WebViewers and Loop and Scrape, exactly the workflow Insert from URL was meant to replace.