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

[Fogle, Derrick]

Wonderful news - I'VE GOT IT WORKING! 

* OS X Yosemite 10.10.2 
* FMS 13.05.520 
* FX.php 4.0 

Of course it turns out many of my problems were self-inflicted. Here's the rundown of issues and stupidities: 

1. Do NOT install the Server app package on Yosemite. I had to start from scratch & re-install

2. Be sure to use the latest & greatest FMS installer, not an earlier one plus a patch (I didn't actually make this mistake, it's just info passed on from another who has already felt the pain)

3. I originally did not copy the "datasource_classes" folder along with the rest of the FX.php 4.0 files. I only replaced the same files as were in my previous FX.php version install. I thought it was just another info/instructional directory at first. Be sure to copy all the necessary files and sub-folders when upgrading to FX.php 4.x.

4. In my previous FX.php install, I had my $webUN and $webPW variables in the main FX.php file; in FX.php 4.0, the variables are moved out to the server_data.php file. I didn't put those parameters in at all, at first; then, when I did, I ended up making a FREAKING TYPO in the password. It took me a long time to spot that mistake! 

5. Previous FX.php version did not require the "$query->SetDBUserPass($webUN, $webPW)" to be part of every query. The newest apparently does. I had to add that line of code to all my database queries. 

6. Of all the crazy things, the 2nd time I tried updating the server, earlier that same day someone else had accidentally put an extra carriage return at the end of a field that renders to a dynamic javascript-driven sub-select list. It took me a *LONG* time to figure out why my first-level list would render, and "view source" on the page appeared to show all the data for the sub-list, but the 2nd sub-drop down would not work at all. The one extra carriage return in one item in the javascript list data breaks the whole thing.


The vast majority of my time ended up being spent on items 3, 4, and 6 - all just stupid, some really stupid, mistakes. But, it works now. I've got it running, all my web connectivity is working OK. 

Thanks everyone who chimed in with help and suggestions! 

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





> On Feb 13, 2015, at 12:44 PM, Fogle, Derrick <fogled at missouri.edu> wrote:
> 
> This is how I've got my system set up: Filemaker Server is on one machine, my webserver with PHP and FX.php are on another machine, so FX.php on the web server makes XML calls to the FMS server's XML gateway. 
> 
> It makes sense, and the configuration has been working great for me with FM12 and previous versions. I'm just struggling to make it all work with FMS13. 
> 
> Thanks, 
> 
> Derrick Fogle
> Manager of Technical Services
> Academic Support Center
> 505 E Stewart Rd
> Columbia MO 65211
> 573-882-3322
> 
> 
> 
> 
> 
>> On Feb 13, 2015, at 12:21 PM, Troy Meyers <tcmeyers at troymeyers.com> wrote:
>> 
>> Derrick,
>> 
>> I don't know if anyone has touched on this, but I think it may be common practice to have the FMS machine set up as database server AND WPE AND web server, but to NOT use it as the actual web server, instead have a different machine with Apache and PHP set up, with FX.php and your PHP files on that, and direct the XML queries to the "web" server on the FMS machine. There is something I recall about whatever the FMS install does to Apache on the FMS machine making it so it won't work with FX.php, or maybe even PHP in general.
>> 
>> Does that make any sense?
>> 
>> -Troy
>> 
>> 
>>> I do have the latest version of FX.php, but I can't get it to work at
>>> all. I'm having much better luck with a previous version that's been
>>> working OK against my FM12 server (but it still doesn't seem to work
>>> completely). 
>>> 
>>> I will be taking another swing at this tonight and over the weekend. I'm
>>> pretty sure I'm gonna back-grade my server to OSX 10.8.x, fresh install
>>> of FMS 13.05.x, and see how that goes. 
>>> 
>>> 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