6 Replies Latest reply on Mar 24, 2017 5:43 AM by TSGal

    Opening shared databases remotely using a URL: password Issue

    robertnaud

      Summary

      Opening shared databases remotely using a URL: password Issue

      Product

      FileMaker Pro

      Version

      13.0v3

      Operating system version

      OS X (10.9.4)

      Description of the issue

      When using the fmp internet protocol to call a script within a file while providing the following:
      - user name
      - password
      - host address
      - file name
      - script name
      - script parameter

      If the password has a question mark "?" as one of its characters, it is impossible for the application to interpret the password correctly, regardless of if the password is encoded in the url (using %3F).

      Steps to reproduce the problem

      Host a file with a user and a script. Make sure the user's password includes a question mark "?". The position of the question mark in the password seems irrelevant.

      Attempt calling a script from within a filemaker file authenticated under a different user account, using openURL as part of a script. The URL should match what is documented in the help:
      https://fmhelp.filemaker.com/fmphelp_13/en/html/sharing_data.16.7.html#1033676
      http://www.filemaker.com/help/13/fmp/en/html/sharing_data.16.7.html#1033676

      fmp://account:password@netaddress/databasename?script=scriptname&param=scriptparameter

      Expected result

      The file opens without asking for credentials and the called script is performed before returning control over to the calling script.

      Actual result

      The application prompts the user for credentials since the ones provided do not allow the user to connect.

      Exact text of any error message(s) that appear

      None. Login dialog appears.

      Workaround

      No known workaround were identified.