[FX.php List] Monitoring WPE connection

[Bob Patin]

Hi,

That's sort of what I wrote; I have a simple FIND that looks for a field and a value of 1 in it. Then, if the query fails, I should get an error message and that would run the branch that emails me with the server name.

Earlier tonight though, the page just never finished loading, so I was thinking my method wouldn't work...

I'll give it another night and see how it goes...

I was hoping there might be some FX command I wasn't aware of, that would tell me whether a connection to the DB could be made...


Bob Patin
Longterm Solutions LLC
P.O. Box 3408
Brentwood, TN 37024
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
--
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting
On Aug 24, 2011, at 7:23 PM, List at NicheIT wrote:

> Hi Bob,
> 
> We have some monitors in place like that and they actually check for known text on a page that is pulled from the database. So if the text expected isn't there, the page hasn't loaded and we get an email and sms. You could just have a simple database with a basic page that displays text from a field that won't change and check for that.
> 
> We found that sometimes the WPE will lose the connection to FMS and the page will still load but be blank. So monitors that check for errors in the header don't report anything as everything looks ok to them.
> 
> Hope that helps.
> 
> Regards
> 
> Andrew
> 
> 
> Andrew McCallum
> 
> Niche IT Pty Ltd
> Suite 3a . 124 Forest Rd . Hurstville . NSW . 2220
> PO Box 255 . Oatley . NSW . 2223
> [p] 02 9585 1648 . [m] 0407 482 609 . [f] 02 9570 6221
> http://www.nicheit.com.au
> 
> FileMaker Training Partner for Australia and New Zealand
> FileMaker Business Alliance Member
> FileMaker 11 Certified
> 
> 
> 
> 
> 
> On 25/08/2011, at 10:08 AM, Bob Patin wrote:
> 
>> I'm having trouble w/ one of my server pairs losing connection between the WPE and the FM Server machine. Neither of the machines crash, but it just loses connection; redeploying the WPE always fixes it.
>> 
>> I tried writing a simple query, and having it run on a robot, meta-refreshing every 5 minutes. However, when the WPE failed just now, my page just failed to load.
>> Is there a command I can put into a page that would tell me whether the WPE/FM Server connection is working? It appears that if the WPE loses connection, FX won't return anything.
>> 
>> I'm going to reinstall the database server in the morning, but would like to have a monitor in place tonight if possible...
>> Ideas appreciated,
>> 
>> 
>> Bob Patin
>> Longterm Solutions LLC
>> P.O. Box 3408
>> Brentwood, TN 37024
>> bob at longtermsolutions.com
>> 615-333-6858
>> http://www.longtermsolutions.com
>> iChat: bobpatin
>> AIM: longterm1954
>> Twitter: bobpatin
>> Google+: http://www.longtermsolutions.com/plus
>> --
>> FileMaker 9, 10 & 11 Certified Developer
>> Member of FileMaker Business Alliance and FileMaker TechNet
>> --
>> FileMaker hosting and consulting 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