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

[Gjermund Gusland Thorsen]

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
>
>