Problems getting FX.php working with FMSA 7 and PHP 4.3.x

[Steven Cappiello]

<?php

print_r($DatabaseData); // pint_r() is a PHP function used to diplay variables

// in human readable form. This is especially useful

// for arrays.

?>

Edited August 22, 2006 by Guest

[Steven Cappiello]

I found this from an old Advisor article:

if you type this into a URL, it should show you the databases that are available to serve XML output:

http:// /FMPro?-format=-fmp_xml&-dbnames

Is there something similar to this for FMSA 7 ??

[mlindal]

This may or may not be relevant.

I notice you are using https rather than http for your scheme. Do you have the https libraries turned on in Apache?

Standard checks like create a phpinfo(); page.

[Mikhail Edoshin]

Can you access the databases without PHP? Try http:///fmi/xml/fmresultset.xml?-dbnames. Does it give any results?

[Steven Cappiello]

I don't know if I have the https libraries enabled.. on the OS X box running Apache with FX & PHP it is pretty much the default installation configuration of Apache that comes with OS 10.3.9 (with the addition of PHP 4.3.x enabled)

I tried the suggestions..

do I have the syntax correct?

http://140.163.232.130:16080/fmi/xml/fmresultset.xml?-RTDB.fp7



gives:



Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.



Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.



More information about this error may be available in the server error log.



Apache/1.3.33 Server at 140.163.232.130 Port 16080



================== AND ===============



https://140.163.232.130:16080/fmi/xml/fmresultset.xml?-RTDB.fp7



gives:



The connection was interrupted



     The connection to 140.163.232.130:16080 was interrupted while the page was loading.        

        

    *   The site could be temporarily unavailable or too busy. Try again in a few

          moments.

    *   If you are unable to load any pages, check your computer's network

          connection.

    *   If your computer or network is protected by a firewall or proxy, make sure

          that Firefox is permitted to access the Web.

[mlindal]

change in your server_data.php file (part of FX)

from

$scheme = 'https';

to:

$scheme = 'http';

[Steven Cappiello]

Thanks for all your help everyone.. but it wasn't the server.data file ! that's fine.. the https is correct..

and the URLs must have been wrong..

because I through up another apache server, this time with PHP 5.1.4 running.. installed FX.php again with the same settings .. and voila !!

I *think* I got some XML back.. this is XML, right .. lol:

Array

(

[data] => Array

(

)

[linkNext] =>

[linkPrevious] =>

[foundCount] => -1

[fields] => Array

(

)

=> http://140.163.232.130:16080/fmi/xml/FMPXMLRESULT.xml?-db=RTDB.fp7&-max=50&-layoutnames

[query] =>

[errorCode] => 802

[valueLists] => Array

(

)

)