[FX.php List] Yosemite + FM13 Server vs. FX.php

Wed Feb 11 17:47:09 MST 2015

It's been way too long since I've had to deal with any of this stuff. I feel like my brain has been bulk-erased. I don't even know where to start anymore. I have no idea what I'm doing. I used to be good at this stuff, I used to understand it. Now, I just suck. I'm so frustrated. 

One thing I finally figured out is that I never copied over the "datasource_classes" subdirectory inside the FX directory. I copied that over, and now it seems to be trying to do something, not just stopping on a fatal error. But, from the browser's point of view, the server never completes the response, it keeps trying to access the site until the browser finally times out completely. 

I can still access the sample site at SERVERIP:16000/test OK

But, I've still got some kind of configuration error, probably in my FX.php files, that's killing me. 

Now my dev environment suddenly won't let me rename the FX directory, which I just did an hour ago. So, I can't swap over to my old files to see what I get. I don't know how many actual problems I'm trying to deal with at the same time, but it's definitely more than one. Someone just shoot me now. 

Sorry to ramble and complain. Just very frustrated, it's like not a single tiny thing I try to do can just be done, every single thing requires five other unclear/unknown steps, each step of which requires 5 other steps... 

Many thanks to anyone who is still sticking with me at this point.

Derrick Fogle
Manager of Technical Services
Academic Support Center
505 E Stewart Rd
Columbia MO 65211
573-882-3322

> On Feb 11, 2015, at 6:28 PM, Tim 'Webko' Booth <tim.webko at gmail.com> wrote:
> 
> 802 is the error code indicating the database can't be opened
> 
> 566 is the size in bytes of the response
> 
> Cheers
> 
> Webko
> 
> On 12 February 2015 at 11:21, Fogle, Derrick <fogled at missouri.edu> wrote:
> I had taken the Sample database off the server. When I put it back on, I can access it OK with the test page, although I'm still getting the "Not Secure" certificate error in my browser.
> 
> Before I put the sample database back on the server, the Log Viewer in FM13 would show an error trying to access the file: "[MachineIP] 127.0.0.1:49381 802 566 /fmi/xml/fmresultset.xml?-db=FMServer_Sample ..."
> 
> I figure the 802 566 part mostly means the database isn't available.
> 
> Thanks,
> 
> Derrick Fogle
> Manager of Technical Services
> Academic Support Center
> 505 E Stewart Rd
> Columbia MO 65211
> 573-882-3322
> 
> 
> 
> 
> 
> > On Feb 11, 2015, at 5:04 PM, Dale Bengston <dale.bengston at gmail.com> wrote:
> >
> > Derrick,
> >
> > I know this is one of those “is it plugged in?” annoying questions, but do you have PHP error reporting turned on? Further, can you check the Apache logs to see if there’s an error there? You can view Apache logs with Utilities -> Console.
> >
> > Just trying to take a different angle,
> >
> > Dale
> >
> >> On Feb 11, 2015, at 4:01 PM, Fogle, Derrick <fogled at missouri.edu> wrote:
> >>
> >> Bummer, it's still a NO-GO.
> >>
> >> I did a fresh install and update of Yosemite, did not install any server components.
> >> I Installed, configured, and deployed FMServer 13.05, single machine config.
> >> I updated my FX.php to the latest version on my web server.
> >>
> >> The PHP code simply locks up somewhere in the FX query:
> >>
> >> $jobquery = new FX($serverIP, $webCompanionPort, $dataSourceType);             // This line creates an instance of the FX class
> >> $jobquery->SetDBData($jobfile, "fx.jobs.billing");
> >> $jobquery->AddDBParam("JOB_KEY", "=".$job);
> >> $jobdata = $jobquery->FMFind();
> >>
> >> None of the code past this gets executed, it doesn't even return any error, it just stops executing code. It won't spit out the URL for me to copy/paste into a browser to  see if that will work. This time, I don't even see any logs in the FMS Log Viewer indicating anything is trying to touch the XML gateway (I was originally at least seeing errors in the logs).
> >>
> >> Curious thing, in the STATUS page, it reports that the Web Server is on the real IP address of the machine, but indicates the Web Publishing Engine is running on 127.0.0.1. Is that normal, or should the Web Publishing Engine be on the same IP as the Web Server?
> >>
> >> I've made sure the fmserver user is read/write on all folders and database files on the server. I just can't see anything particular that should be such a show-stopper.
> >>
> >> Does anyone know if I'll have this much trouble with FMS 13 on a previous OS version, like Mavericks? I don't really care that much what OS version the server is running, as long as it works.
> >>
> >> Thanks,
> >>
> >> Derrick Fogle
> >> Manager of Technical Services
> >> Academic Support Center
> >> 505 E Stewart Rd
> >> Columbia MO 65211
> >> 573-882-3322
> >>
> >>
> >>
> >>
> >>
> >>> On Feb 9, 2015, at 5:15 PM, Fogle, Derrick <fogled at missouri.edu> wrote:
> >>>
> >>> Thanks for the tips guys, it looks like my main problem is that I assumed I still needed the server OS version like in Mavericks / FM12. Will rebuild and report...
> >>>
> >>> Thanks!
> >>>
> >>> Derrick Fogle
> >>> Manager of Technical Services
> >>> Academic Support Center
> >>> 505 E Stewart Rd
> >>> Columbia MO 65211
> >>> 573-882-3322
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>> On Feb 9, 2015, at 5:10 PM, Troy Meyers <tcmeyers at troymeyers.com> wrote:
> >>>>
> >>>> Derrick,
> >>>>
> >>>> I'm seconding what Bob said. For FMS13 to work, Yosemite canNOT be OSX Server-ized. Here are the system requirements:
> >>>>
> >>>> http://www.filemaker.com/products/filemaker-server/server-13-specifications.html
> >>>>
> >>>> Notice that for OS X Yosemite it does NOT say "and OS X Server" the way it does with Mountain Lion.
> >>>>
> >>>> -Troy
> >>>>
> >>>>
> >>>>
> >>>>> Hi everyone, I'm just jumping back into the fray after not having done
> >>>>> much with this over the last couple of years.
> >>>>>
> >>>>> I'm currently trying to upgrade my FM server from FM12 to FM13. The
> >>>>> server is Mac OS X Yosemite with server app included. The FM13 install
> >>>>> is a single-machine installation, and I've told FM to install it's own
> >>>>> web server. The web server in Yosemite server is turned off. The FX.php
> >>>>> files themselves are on a different server but are making XML calls to
> >>>>> the FMServer machine. I can see the requests in the FMServer log, with
> >>>>> an error result, but the error code is 0.
> >>>>>
> >>>>> Everything else works, but I can't get my FX.php stuff to work. I
> >>>>> downloaded the latest version of FX.php from github, configured my
> >>>>> server_data file, but it still won't work.
> >>>>>
> >>>>> I tried searching the archives for answers but the only obvious thing I
> >>>>> could find was to use the latest version of FX.php from github, and
> >>>>> setting the file type to FMPro12. No satisfaction.
> >>>>>
> >>>>> Can anyone help orient me in the right direction here?
> >>>>>
> >>>>> Thanks,    Derrick Fogle
> >>>>
> >>>> _______________________________________________
> >>>> 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
> 
> 
> _______________________________________________
> 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