[FX.php List] Help with error message
Jon Montgomery
fxphp at igsmasouth.org
Tue Nov 3 17:01:49 MST 2015
Chris, Bob, Tim “Webco”, Malcolm, Ted, Steve V. and anyone else who commented and I missed:
Thank you for your help! I have fixed the problem with my development computer and can proceed.
Bob Patin was the first one to notice that something was not right on my computer during a tutoring session on FX a week ago.
You all gave me great advice and what to do to track down the problem. I have learned a lot!
Chris Hansen, what an honor to have you chime in! You pointed me the right way on RE-installing FMS14 as well as a LOT of things before I even got to that.
Since FileMaker Server demands total control over ports 80 and 443, I had to move my website inside the FileMakerServer folder—> HTTPServer—> htdocs folder. Then pointed Dreamweaver site information to point to that folder. NOW it all works. FileMaker web server just has to handle all the webpages.
I have a high regard for everyone on this site and even though I was not using FX at the time, I gained knowledge from all you geniuses!
Thanks again! You WILL get more questions from me in the near future I am sure. This is so much FUN!
Jon Montgomery, vice president, RETIRED (as of 11/2/2015, but the hired me to keep doing their website and music contest site)
Illinois Grade School Music Association - Southern Division
igsmasouth.org
On Nov 3, 2015, at 2:14 PM, Malcolm Fitzgerald <malcolm at notyourhomework.net> wrote:
> 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
>
> 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
>>
>> 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
>>
>>
>>
>> _______________________________________________
>> 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/c05168f6/attachment-0001.html
More information about the FX.php_List
mailing list