[FX.php List] Monitoring WPE connection

[Bob Patin]

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