[FX.php List] Monitoring FM Server 9/10 Advance

[Steve Winter]

Hi John,

Here's an example of what I do 'inline'... with the first db call that  
will be made to any particular solution...

Cheers
Steve

   $productQuery = new FX($serverIP, $serverPort, $dataSourceType);
   $productQuery->SetDBUserPass($webUN, $webPW);
   $productQuery->SetDBData("schedules", "productAreas");
   $productQuery->AddSortParam('productSortOrder', 'ascend');	
   $productQuery->AddDBParam('productAreaDisplay','no','neq');
   $productData = $productQuery->FMFind();

   if(isset($productData) && is_array($productData) &&  
isset($productData['data'])) {

	// do the regular stuff

   else {
   	$errorData = $productData;
   	include('assets/includes/errorReporter.php');
   }

Then errorReporter.php says;


//display user message
echo '<h2>An error has occured</h2>' .
   	   '<p>An error has occured conneecting to the host database. The  
site administrator has been notified. Please try your query again at a  
later time.</p>' .
   	   '<p>We apologise for this inconvienience<br />The '.$siteName.'  
web team</p>';



    // send me an email
   require_once('assets/includes/phpMailer/mailer.php');
   $staffMailer = new Mailer();
   $staffMailer->Subject = $sitename.' site error';
   $staffMailer->FromName = $sitename;
   $staffMailer->From = 'database at matatirosolutions.co.uk';
   $staffMailer->Body = '<p>The '.$sitename.' site is currently  
reporting an error</p>
			<p>The error data is '.showMe($errorData).'<p />;
   $staffMailer->isHTML(true);
   $staffMailer->AddAddress('steve at matatirosolutions.co.uk', 'Steve  
Winter');
   if(!$staffMailer->Send()) $mailError = 'error';
   $staffMailer->ClearAddresses();
   $staffMailer->ClearAttachments();

On 5 Feb 2009, at 23:16, John Funk wrote:

> Thanks Steve,
> I will check the email on the server part. I do not know if this  
> gives the detail my customer wants. I may end up reading the FMSA  
> log files(s)
> A sample PHP script would be nice to see.
> Thanks again
> John
>
>
> On 2/5/09 5:03 PM, "Steve Winter" <steve at bluecrocodile.co.nz> wrote:
>
>> Hi John,
>>
>> FMS itself can send automated emails when it detects any issue with  
>> the server situation...
>>
>> The other thing that I've done is to write a simple php script,  
>> which is then run on a win2k3 server scheduled task every 5 min  
>> which attempts to do a findAny() using fx on a series of database  
>> tables which should be accessible... if it fails on any of those,  
>> then that PHP script sends me an email with the name of the table  
>> in the message... I also have similar code in all of the web  
>> solutions I develop such that if a user ever attempts to connect to  
>> a db and that call fails then I get an email which tells me that...
>>
>> All of the above email go into an account which my mobile phone  
>> also monitors so that I get notification almost in real time by  
>> email and alert on my mobile...
>>
>> Hope this helps... if you want code examples let me know...
>>
>> Cheers
>> Steve
>>
>>
>> On 5 Feb 2009, at 22:56, criticalsolution at comcast.net wrote:
>>
>>> Has anybody written or used any kind of script or app to monitor  
>>> FMSA 9 or 10? My client wants a pro-acitive solution to tell tech  
>>> support when there is trouble (or not) on an FMServer. I thought  
>>> that there might be some ways to do this in FX/PHP?
>>>
>>> Thank you,
>>>
>>> John Funk
>>> Critical Solution
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>> Steve Winter
>> steve at bluecrocodile.co.nz <mailto:steve at matatirosolutions.co.uk>
>> m: +44 77 7852 4776
>> 3 Calshot Court, Channel Way
>> Ocean Village, Southampton SO14 3GR
>>
>>
>>
>> _______________________________________________
>> 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


Steve Winter
steve at bluecrocodile.co.nz
m: +44 77 7852 4776
3 Calshot Court, Channel Way
Ocean Village, Southampton SO14 3GR

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20090205/8c579b00/attachment-0001.html