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.
--Nathan
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 192.168.0.0 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
|