AnsweredAssumed Answered

Opening shared databases remotely using a URL: password Issue

Question asked by robertnaud on Aug 5, 2014
Latest reply on Mar 24, 2017 by TSGal

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.

Outcomes