[Date Prev]   [Date Next] [Thread Prev]   [Thread Next] [Date Index]   [Thread Index]


     Re: [nocol-users] MySQL monitor?

I'd love to write a good Perl DBI monitor, where you could specify
username, password, port, and DBD type in the config file and have a SQL
statement to use to test it.

If anyone feels up to writing a FAQ on how to write a Perl based monitor,
I'll be happy to contribute it when complete. Otherwise, I'm too busy
working on the HUP situation to read the current Perl monitors and
determine what I need to do.


On Thu, 13 Jan 2000, Velocet wrote:

> Date: Thu, 13 Jan 2000 22:37:37 -0500 (EST)
> From: Velocet <mathboy@velocet.ca>
> To: nocol-users@navya.com
> Subject: Re: [nocol-users] MySQL monitor?
> then TTSG's all..
> > Hi,
> > 
> > 	Has anyone written a MySQL monitor?
> What do you want monitored? I for the most part am content with two
> monitors for Mysql - just looking at port 3306 on the server for
> a connection. The other way is I have a webpage setup to do some
> query via PHP on the Mysql database. Actually, it really justs tests
> the website that required Mysql in the first place, so finding a suitable
> webpage was easy.
> I am not sure about the success of these error warnings, however. I
> dont know if I've ever been paged with these (I have only been paged
> when the webpage couldnt be retrieved at all - not when a warning
> or error was reported via PHP):
> HOST blah  WWWmysql 80     Critical        GET /Some/Mysql/Page.html
> critical        <b>Warning</b>:  MySQL Connection Failed:
> critical        <b>Warning</b>:  Can't connect to local MySQL
> critical        <b>Warning</b>:  MySQL:
> info            <HTML>
> info            </HTML>
> TIME    5 25 40 </html>
> Anyone else have something like this setup - and seen it fail with a nice
> phat warning?
> /kc
> -- 
> Ken Chase, Director Operations                  Velocet Communications Inc.
> math@velocet.ca                                              Toronto CANADA
> --
> "Sometimes two [harmless] words, when put together, strike fear in the
>   hearts of men -- Microsoft Wallet."                           - Dave Gilbert

Nathan Clemons, Systems Engineer
WinStar Internet and Hosting Services

800 South Main St. Mansfield, MA  02048
nclemons@winstar.com    www.winstar.com    (v) 800-234-0002 ext.1109
nathan@ici.net                             (f) 508-261-0430