[FX.php List] Making sure servers are responding to FX queries

[Steven Thoms]

It seems the strongest assurance would come from putting the wpe test code in the /* DO A QUERY NOW */ statement block...

Steve
207 798-0171

On Sep 25, 2013, at 12:50 PM, Bob Patin wrote:

> I found Webko's example, which I added here:
> 
> if( !fsockopen ($server, 80, $errno, $errstr, 2) ){
> 		$color = "#FFADA7";
> 		$body = $machine." IS NOT RESPONDING.";
> }else{
> 	/* DO A QUERY NOW */
> }
> 
> Works great... not sure why I never implemented it before now... :)
> 
> BP
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9, 10, 11& 12 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Twitter: bobpatin
> AIM: longterm1954
> iChat: bobpatin
> --
> Expert FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> 
> On Sep 25, 2013, at 10:32 AM, Steven Thoms <sthoms at wavecomm.com> wrote:
> 
>> Bob,
>> 
>> The simplest solution I have found is to test each required file with a -findany request.
>> If you get an error, the server isn't responding.
>> 
>> Before version 11, I think, but maybe sooner the FMDBNames() stopped working in FX. But I used to use this code to test and it was very quick and worked a charm:
>> 
>> 
>> // confirmDatabases
>> $strError = '';
>> $resultError = 0;
>> $query = fmConnect(); // does not require a dbname, for obvious reasons; see below...
>> $result = $query -> FMDBNames();
>> //print_r($result);
>> if ( $query->lastErrorCode != 0 ) {
>>   AddError("The databases are not available.<br />The Web Publishing Engine is not responding. ErrorCode:" . $query->lastErrorCode , $strError);
>> } else {
>>   $searchDbs  = explode("," , REQUIRED_DBS);
>>   $dataString = serialize($result['data']);
>>   foreach ( $searchDbs as $key=>$dbName ) {
>>       if ( strpos($dataString , $dbName) === false ) {
>>           $newError = "The " .  $dbName . " database was not available.";
>>           AddError($newError , $strError);
>>       }
>>   }
>> }
>> if ( $strError != '' )
>>   include_once "{$AppLoc}src/error.php";
>> 
>> 
>> With these settings at the top of the page...
>> 
>> // db access files
>> require_once "{$_SERVER['DOCUMENT_ROOT']}/FX/FX.php";
>> require_once "{$_SERVER['DOCUMENT_ROOT']}/FX/FM_Errors.php";
>> require_once "{$_SERVER['DOCUMENT_ROOT']}/FX/FX_Error.php";
>> require_once "{$_SERVER['DOCUMENT_ROOT']}/FX/server_data.php";
>> 
>> // db defaults
>> define ("REQUIRED_DBS", "File1, File2, etc.");
>> define ("GROUP_SIZE", "all");
>> define ("ERROR_SPACE", "<br />&nbsp;&nbsp;&nbsp;");
>> 
>> // fx interface functions
>> 
>> function fmConnect($layout = '' , $groupSize = GROUP_SIZE, $responseLayout='') {
>>   $query = new FX(FM_IP, FM_PORT, FM_VERSION);
>>   if ( $layout != '' )
>>       $query -> SetDBData(FMDB, $layout, $groupSize, $responseLayout);
>>   $query -> SetDBUserPass(FM_USERNAME, FM_PASSWORD);
>>   return $query;
>> }
>> 
>> I hope that helps,
>> 
>> Steve
>> 
>> 
>> On Sep 25, 2013, at 11:03 AM, Bob Patin wrote:
>> 
>>> A while back someone posted their code for monitoring whether a web server is responding to FX queries. 
>>> 
>>> I have a little test database on each of my FM servers and wrote a page that does a quick query every N minutes, but I don't think it's really telling me the truth.
>>> 
>>> I say that because I retired one of my FM servers, and yet my page still reports that it's functioning normally... :)
>>> 
>>> I'd love to get a copy of that code; I think it might've been Webko?
>>> 
>>> Thanks,
>>> 
>>> Bob Patin
>>> Longterm Solutions LLC
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>> FileMaker 9, 10, 11& 12 Certified Developer
>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>> --
>>> Twitter: bobpatin
>>> AIM: longterm1954
>>> iChat: bobpatin
>>> --
>>> Expert FileMaker Consulting 
>>> FileMaker Hosting for all versions of FileMaker
>>> 
>>> _______________________________________________
>>> 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
>