[FX.php List] First try with WPE and FM Server 13... fail...

[Bob Patin]

Hey Dale,

I've always left the extension on database filenames, and I know they're not necessary, but it's an old habit... it didn't fix the issue, unfortunately.

print_r returns a lot though; when I try the URL

http://bob patin:password at 208.52.164.176:80/fmi/xml/FMPXMLRESULT.xml?-db=wpe_test&-lay=data&-max=50&-findall

I do get results though...

Here's what print_r returns (there's more, but...)

I'd love to get this working... :)

Thanks,

Bob


FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => 100 [message] => FX: cURL could not retrieve Post data in RetrieveFM7Data(). A bad URL is the most likely reason. [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => /Library/WebServer/Documents/longterm/FX/FX.php [line] => 649 [function] => FX_Error [class] => FX_Error [object] => FX_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => cURL could not retrieve Post data in RetrieveFM7Data(). A bad URL is the most likely reason. ) ) [1] => Array ( [file] => /Library/WebServer/Documents/longterm/FX/FX.php [line] => 1455 [function] => RetrieveFM7Data [class] => FX [object] => FX Object ( [dataServer] => 208.52.164.176 [dataServerType] => FMPro7 [dataPort] => 80 [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [database] => wpe_test [layout] => data [responseLayout] => [groupSize] => 3 [currentSkip] => 0 [defaultOperator] => bw [dataParams] => Array ( ) [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall [-findany] => -findany [-new] => -new [-view] => -view [-dbnames] => -dbnames [-layoutnames] => -layoutnames [-scriptnames] => -scriptnames [-sqlquery] => -sqlquery [delete] => -delete [duplicate] => -dup [update] => -edit [perform_find] => -find [show_all] => -findall [show_any] => -findany [new] => -new [view_layout_objects] => -view [view_database_names] => -dbnames [view_layout_names] => -layoutnames [view_script_names] => -scriptnames ) [primaryKeyField] => [modifyDateField] => [dataKeySeparator] => [fuzzyKeyLogic] => [genericKeys] => [selectColsSet] => [selectColumns] => [fieldInfo] => Array ( ) [currentData] => Array ( ) [valueLists] => Array ( ) [totalRecordCount] => -1 [foundCount] => -1 [dateFormat] => [timeFormat] => [dataURL] => http://bob patin:password at 208.52.164.176:80/fmi/xml/FMPXMLRESULT.xml?-db=wpe_test&-lay=data&-max=3&-findall [dataURLParams] => -db=wpe_test&-lay=data&-max=3&-findall [dataQuery] => [charSet] => [dataParamsEncoding] => [currentFlag] => [currentRecord] => [currentField] => [currentValueList] => [fieldCount] => 0 [columnCount] => -1 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1 [DBUser] => bob patin [DBPassword] => password [userPass] => bob patin:password@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [useCURL] => 1 [lastLinkPrevious] => [lastLinkNext] => [lastFoundCount] => -2 [lastFields] => Array ( ) [lastURL] => [lastQuery] => [lastQueryParams] => Array ( ) [lastErrorCode] => -2 [lastValueLists] => Array ( ) [lastDebugMessage] =>
Instantiating FX.php.

Configuring database connection...

Setting user name and password...

Unable to connect to FileMaker. Use the DEBUG constant and try connecting with the resulting URL manually.
You should also double check the user name and password used, the server address, and WPE configuration.




On Mar 17, 2014, at 10:18 PM, Dale Bengston <dale.bengston at gmail.com> wrote:

> Hi Bob,
> 
> You could try removing the extension from the database name. It’s not needed. Also, try 
> 
> print_r($qResult); 
> 
> … and see what the full error object tells you.
> 
> Dale
> 
> On Mar 17, 2014, at 10:14 PM, Bob Patin <bob at patin.com> wrote:
> 
>> I had no trouble when I moved web apps to FMSA 12, but with FMS 13 I've hit a brick wall.
>> 
>> Here's my test query:
>> 
>> <?php
>> 
>> include_once('FX/FX.php');
>> 
>> // perform query 
>> $q =new FX('xxx.xxx.xxx.xxx','80', 'FMPro7', 'http');
>> $q->SetDBData('wpe_test.fmp12','data' );
>> $q->SetDBPassword('password','bob patin');
>> $qResult = $q->FMFindAll();
>> 
>> echo 'Error: '.$qResult['errorCode'];
>> 
>> ?>
>> 
>> Anyone see a reason why this shouldn't work, assuming that
>> 
>> a) database exists, is online, and has XML enabled in priv. set;
>> b) web pub. engine is working and tests fine on FMS 13
>> c) username/password are valid
>> 
>> ?
>> 
>> Thanks,
>> 
>> Bob Patin
>> Longterm Solutions
>> bob at longtermsolutions.com
>> 615-333-6858
>> FileMaker 9, 10, 11 & 12 Certified Developer
>> http://www.longtermsolutions.com
>> -
>> iChat: bobpatin at me.com
>> Twitter: bobpatin
>> —
>> FileMaker Consulting 
>> FileMaker Hosting for all versions of FileMaker
>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>> 
>> 
>> _______________________________________________
>> 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/20140317/ae1d1f03/attachment.html