[FX.php List] Help with error message
Malcolm Fitzgerald
malcolm at notyourhomework.net
Tue Nov 3 13:14:30 MST 2015
Hi Jon,
Your problem is simple. You are using "HTTPS" but you are insisting that
it communicate on port 80. That's a common gotcha! I'm also seeing the
SSL certificate error. I'm not sure what you've done wrong with the
installation but that is fixable and will not stop you from connecting.
Just click all the buttons to continue. The URL that I just tried,
successfully, is this:
https://www.igsmasouth.org/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_Membership&-lay=login&-max=50&Login_ID=5501.1&Password=music4u&-find
<https://127.0.0.1:80/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_Membership&-lay=login&-max=50&Login_ID=5501.1&Password=music4u&-find>
Using that URL I get to see an authentication box, asking me to provide
a user account.
Malcolm
On 4/11/2015 6:55 am, Jon Montgomery wrote:
> Gentlemen:
>
> I have tried all variations and suggestions you have posted for me.
> Thank you. Unfortunately, none of those helped much if at all?
>
> I get this with “http”:
>
> Accessing FileMaker Server 7+ data.
>
> Using FileMaker URL:
> http://127.0.0.1:80/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_Membership&-lay=login&-max=50&Login_ID=5501.1&Password=music4u&-find
> <http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_Membership&-lay=login&-max=50&Login_ID=5501.1&Password=music4u&-find>
>
> FX: ExecuteQuery XML error: SYSTEM or PUBLIC, the URI is missing
> at line 1
>
>
>
> Changing the server_data.php ( $scheme = 'https’; ) yields:
>
> Accessing FileMaker Server 7+ data.
>
> Using FileMaker URL:
> https://127.0.0.1:80/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_Membership&-lay=login&-max=50&Login_ID=5501.1&Password=music4u&-find
>
> FX: cURL could not retrieve Post data in RetrieveFM7Data(). A bad
> URL is the most likely reason.
>
>
> Copy and pasting the FileMaker URL using “http" into browser page
> and/or clicking the link yields:
>
> The requested URL /fmi/xml/FMPXMLRESULT.xml was not found on this
> server.
>
>
> Copy and pasting the FileMaker URL using “https” into browser page
> and/or clicking the link yields:
>
>
> SSL connection error
>
>
> ERR_SSL_PROTOCOL_ERROR
>
>
>
>
> I do not have SSL set up for anything on this machine.
>
> I am thinking that there is something WRONG with my FileMaker Server
> 14 installation. When I have tried to do the update to version 14v3
> from version 14v2 I get this:
>
> ! This update cannot be installed while FileMaker Server is still
> running. Please stop FileMaker Server and try again.
>
> Following the instructions for the update: Closed all databases,
> turned on WEP, turned off Server in Admin Console. Quite Admin
> Console and then when to Terminal and did: fmsadmin stop server and
> got this error message: Error: 10502 (Host unreachable) thinking that
> means the server IS turned off. But when I run the updater file it
> tells me it is still running.
>
> HELP?
>
> Jon Montgomery - Illinois Grade School Music Assoication
>
>
> On Nov 1, 2015, at 4:14 PM, Malcolm Fitzgerald
> <malcolm at notyourhomework.net <mailto:malcolm at notyourhomework.net>> wrote:
>
>> Before you do anything else, try using HTTPS instead of HTTP.
>>
>> Malcolm
>>
>> On 1/11/2015 4:49 pm, Jon Montgomery wrote:
>>> Hey Chris,
>>>
>>> Thanks for the info. I put the code in and this is what it yielded:
>>>
>>> FX: ExecuteQuery XML error: SYSTEM or PUBLIC, the URI is missing at
>>> line 1
>>>
>>> Could this be a Filemaker Server 14 port conflict? When I installed
>>> (or deployed, I don’t remember) but got the message that ports 80
>>> and 443 were in use click to disable those other applications using
>>> those ports (or something to that effect). I did.
>>>
>>> After that, the FMS tests all worked but I had no PHP (in
>>> phpinfo.php) running. Poked around in terminal and got Appache
>>> running and got PHP info page up. But then get these FX_Errors as
>>> in original post.
>>>
>>> Could my server set up be what is causing my problem since I cannot
>>> get any XML data from the link?
>>>
>>> Thanks!
>>>
>>> Jon
>>>
>>>
>>> On Oct 31, 2015, at 10:26 PM, Chris Hansen <chris at iViking.org> wrote:
>>>
>>>> Hey Jon,
>>>>
>>>> Are you sure that XML sharing is enabled on FileMaker Server on
>>>> your local machine? Basically, the URL that you see there is
>>>> (semi) equivalent of the request being made to FileMaker. You
>>>> should be able to click on that link and get back the XML that
>>>> FileMaker outputs. For some reason, the connection to your locally
>>>> running FileMaker isn't working, and that's the bit that you need
>>>> to debug.
>>>>
>>>> At any rate, when you get an FX error object, it means that FX was
>>>> never able to connect to the server for one reason or another.
>>>> Something that even experienced developers tend not to do, that
>>>> they should be doing, is trap for errors. So, that would look
>>>> something like this:
>>>>
>>>> // the rest of your query code would be above this
>>>> $qResult = $q->FMFind();
>>>> if (FX::isError($qResult)) {
>>>> echo $qResult->getMessage();
>>>> }
>>>> elseif ($qResult[‘errorCode’] != 0) {
>>>> echo "A FileMaker error occurred ({$qResult[‘errorCode’]})";
>>>> }
>>>> else {
>>>> // your data set logic goes here
>>>> }
>>>>
>>>> FYI, the curly braces inside the FileMaker error quotes help PHP to
>>>> parse where the variable begins and ends.
>>>>
>>>> HTH
>>>>
>>>> --Chris
>>>
>>>
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org <mailto:FX.php_List at mail.iviking.org>
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20151104/25e7df3f/attachment-0001.html
More information about the FX.php_List
mailing list