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

Wed Aug 19 00:35:04 MDT 2009

http://127.0.0.1:80/fmi/xml/FMPXMLRESULT.xml?-db=Customer&-layoutnames

returns 956

As soon as layouts are involved something weird is happening with my
FMS10A install.

ggt

2009/8/19 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
> I installed FMS10A yesterday and have the following to report on this 956 error
>
> This query works: http://127.0.0.1/fmi/xml/FMPXMLRESULT.xml?-dbnames
>
> However doing a query where layout is specified gives me 956 error.
>
> Did anyone solve this? Is there some new casesensitivity stuff for
> layout naming?
>
> ggt
>
>
> 2009/2/6 John Funk <jfunk at criticalsolution.com>:
>> Thanks Steve.
>> I found out that my client wants the MYSQL type data collections where there
>> is an actual table for server stats. I may end up building a PHP/MySql data
>> collector and let his third party monitoring app read the tables. Thos IT
>> guys are really a pain sometimes....
>> Thanks for the discussion.
>> John Funk
>>
>>
>> On 2/5/09 5:28 PM, "Steve Winter" <steve at bluecrocodile.co.nz> wrote:
>>
>> 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 <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
>>
>>
>