Hello Scott, You are probably aware that you can creates a custom TCP service that connects to port 3306. This will tell you that MySQL is running on the machine.
We use MRTG in Denika to actually quary the database to confirm SQL operation. MRTG: Target[somixcrc-stats-licenses]: `c:\webnm\cgi-bin\dbinfo mysql SomixCRC 10.1.1.250 3306 root S0m1x.r00T count licenses` MaxBytes[somixcrc-stats-licenses]: 10000 Options[somixcrc-stats-licenses]: gauge, nopercent WithPeak[somixcrc-stats-licenses]: wmy YLegend[somixcrc-stats-licenses]: Licenses ShortLegend[somixcrc-stats-licenses]: Licenses Generated Colours[somixcrc-stats-licenses]: GREEN#00eb0c,BLUE#0000ff,GRAY#AAAAAA,VIOLET#ff00ff Legend1[somixcrc-stats-licenses]: Number of Licenses Generated Legend2[somixcrc-stats-licenses]: . Legend3[somixcrc-stats-licenses]: Number of Licenses Generated Legend4[somixcrc-stats-licenses]: . LegendI[somixcrc-stats-licenses]: Licenses: LegendO[somixcrc-stats-licenses]: . See the attached graph. Michael Patterson http://www.whatsupgold.net to see Denika running with WhatsUp Gold. (207)324-8805 x222 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Roberts Sent: Monday, December 02, 2002 12:50 PM To: [EMAIL PROTECTED] Subject: [WhatsUp Forum] Monitoring MySQL Services I am fairly new to using WhatsUp Gold, and I have a customer that wants me to add some additional monitored services to his WhatsUp Gold system. He wants to add MySql monitoring to a few of his servers. I see how to enter the port, but not sure what "expression" to put in. In addition is it possible to set it up to monitor certain MySql databases rather than just the entire service. Any help would be greatly appreciated. ------------------------------------------------ Scott Roberts T & R Communications of Florida [EMAIL PROTECTED] Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
<<attachment: example-mysql.png>>
