[FX.php List] Help with error message

[Jon Montgomery]

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

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> 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
> 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/20151103/cbe9cb2e/attachment-0001.html