|[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. --Nathan On Thu, 13 Jan 2000, Velocet wrote: > Date: Thu, 13 Jan 2000 22:37:37 -0500 (EST) > From: Velocet <email@example.com> > To: firstname.lastname@example.org > 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. > email@example.com 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 ____________________________________________________________________ firstname.lastname@example.org www.winstar.com (v) 800-234-0002 ext.1109 email@example.com (f) 508-261-0430