<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif; ">
<div style="color: rgb(0, 0, 0); ">Hi folks . I wanted to provide an update on the question I had about port monitoring for SQL servers. I went into the analysis.cfg file and change the entry as follows:</div>
<div style="color: rgb(0, 0, 0); ">It was: <span class="Apple-style-span" style="color: rgb(255, 37, 0); "> PORT STATE=LISTENING LOCAL=1433 MIN=1 Test=SQLServer</span></div>
<div style="color: rgb(0, 0, 0); "><span class="Apple-style-span" style="color: rgb(255, 37, 0); "><br>
</span></div>
<div><font class="Apple-style-span" color="#ff2500"><br>
</font></div>
<div style="color: rgb(0, 0, 0); ">
<div> I changed it to:</div>
<div><br>
</div>
<div>PORT STATE=LISTENING LOCAL=%[.:](1433)$ MIN=1 TEXT=SQLServer Listener</div>
</div>
<div style="color: rgb(0, 0, 0); "> and it seems to be working now for the 1433 port.</div>
<div style="color: rgb(0, 0, 0); ">Maybe I had the "LOCAL=1433" syntax wrong for the analysis.</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">The "Test=SQLServer" was probably the wrong syntax as well – as the "TEXT=SQLServer Listener" is doing what I wanted it to do which is report "SQLServer Listener" in the web page reports.</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">If I am missing something please let me know, otherwise, I believe this will do the job. So I'm off to learn more xymon stuff :)</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Thanks for the support!</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Don K</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<span id="OLK_SRC_BODY_SECTION" style="color: rgb(0, 0, 0); ">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>David Baldwin <<a href="mailto:david.baldwin@ausport.gov.au">david.baldwin@ausport.gov.au</a>><br>
<span style="font-weight:bold">Date: </span>Thu, 12 Apr 2012 16:54:24 +1000<br>
<span style="font-weight:bold">To: </span>Don Kuhlman <<a href="mailto:don.kuhlman@schawk.com">don.kuhlman@schawk.com</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:xymon@xymon.com">xymon@xymon.com</a>" <<a href="mailto:xymon@xymon.com">xymon@xymon.com</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Xymon] Xymon Service alert not showing proper status for stopped service - windows<br>
</div>
<div><br>
</div>
<div>
<div bgcolor="#FFFFFF" text="#000000">Don,<br>
<br>
It would help if you could post the relevant sections of your analysis.cfg file as well as the section of the client report.<br>
<br>
David.<br>
<blockquote cite="mid:CBA9A25D.2633%25don.kuhlman@schawk.com" type="cite">
<div style="color: rgb(0, 0, 0); ">Hi David. Thanks for the information. I checked the webpage and it's running 4.3.7</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Now, I am also getting similar port errors on the same server that appear to be false alarms. I setup a port 1433 (SQL) monitor and it's also telling me that isn't listening, but I see a port 1433 listens or connections.</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div>
<div style="color: rgb(0, 0, 0); font-family: Consolas;
font-size: medium; ">
red Tue Apr 10 08:00:07 2012 - Ports NOT ok</div>
<div style="font-family: Consolas; font-size: medium; ">&<font class="Apple-style-span" color="#ff2500">red local=1433 state=LISTENING</font> : (found 0, req. 1 or more)</div>
<div style="color: rgb(0, 0, 0); font-family: Consolas;
font-size: medium; ">
&green Listen (found 51, req. none)</div>
<div style="color: rgb(0, 0, 0); font-family: Consolas;
font-size: medium; ">
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas"><br>
</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas; min-height: 14.0px">
<br>
</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">Active Connections</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas; min-height: 14.0px">
<br>
</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">Proto Local Address Foreign Address State</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:80 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:111 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:135 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:445 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:803 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:2383 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP 0.0.0.0:2799 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:139 0.0.0.0:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:1850 ESTABLISHED</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:1214 ESTABLISHED</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:1483 ESTABLISHED</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:4308 ESTABLISHED</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:4389 ESTABLISHED</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP xx.xx.xx.nn:1433 xx.xx.xx.nn:4937 ESTABLISH</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP [::]:80 [::]:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP [::]:135 [::]:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP [::]:445 [::]:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas">TCP [::]:1433 [::]:0 LISTENING</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px
Consolas"><br>
</p>
</div>
</div>
<span id="OLK_SRC_BODY_SECTION" style="color: rgb(0, 0, 0); ">
<div style="font-family:Calibri; font-size:11pt;
text-align:left; color:black; BORDER-BOTTOM: medium none;
BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT:
0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid;
BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>David Baldwin <<a moz-do-not-send="true" href="mailto:david.baldwin@ausport.gov.au">david.baldwin@ausport.gov.au</a>><br>
<span style="font-weight:bold">Date: </span>Tue, 10 Apr 2012 12:22:53 +1000<br>
<span style="font-weight:bold">To: </span>Don Kuhlman <<a moz-do-not-send="true" href="mailto:don.kuhlman@schawk.com">don.kuhlman@schawk.com</a>><br>
<span style="font-weight:bold">Cc: </span>Xymon Email List <<a moz-do-not-send="true" href="mailto:xymon@xymon.com">xymon@xymon.com</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Xymon] Xymon Service alert not showing proper status for stopped service - windows<br>
</div>
<div><br>
</div>
<div>
<div bgcolor="#FFFFFF" text="#000000">Don,
<blockquote cite="mid:CBA49A56.24FF%25don.kuhlman@schawk.com" type="cite">
<div style="color: rgb(0, 0, 0); ">Hi folks. I just received this alert and am trying to figure out why it's showing this way.</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">It's alerting on a service on a windows sql box - the service that looks stopped is </div>
<div><font class="Apple-style-span" color="#0034ff">SQLSERVERAGENT automatic stopped SQL Server Agent (MSSQLSERVER)</font></div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div>but the alert text shows <font class="Apple-style-span" color="#0034ff">&red SQLSERVERAGENT is started/automatic - want started/automatic</font></div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Is this a time delay, or is there something I'm missing that's causing the disconnect ?</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Will Xymon try to restart this service or do we manually code something to do that?</div>
<div style="color: rgb(0, 0, 0); ">My goal is to setup specific MYSQL and MS SQL server monitoring on a DB page, but I hope to get a better understanding of how to watch and validate these items.</div>
<div style="color: rgb(0, 0, 0);"><br>
</div>
</blockquote>
What version are you running? This was definitely an issue with 4.2.0 and fixed in 4.3.x<br>
<br>
David.<br>
<blockquote cite="mid:CBA49A56.24FF%25don.kuhlman@schawk.com" type="cite">
<div style="color: rgb(0, 0, 0); ">Thanks</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Don K</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<blockquote id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE" style="border-left-color: rgb(181, 196, 223);
border-left-width: 5px; border-left-style: solid;
padding-top: 0px; padding-right: 0px; padding-bottom:
0px; padding-left: 5px; margin-top: 0px; margin-right:
0px; margin-bottom: 0px; margin-left: 5px; ">
<div style="color: rgb(0, 0, 0); ">red Fri Apr 06 13:02:17 2012 - Services NOT ok</div>
<div style="color: rgb(0, 0, 0); ">&green MSSQLSERVER is started/automatic - want started/automatic</div>
<div style="color: rgb(0, 0, 0); ">&green SQLBrowser is started/automatic - want started/automatic</div>
<div><font class="Apple-style-span" color="#0034ff">&red SQLSERVERAGENT is started/automatic - want started/automatic</font></div>
<div style="color: rgb(0, 0, 0); ">&green SQLWriter is started/automatic - want started/automatic</div>
<div style="color: rgb(0, 0, 0); ">&green BBWin is started/automatic - want started/automatic</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Name StartupType Status DisplayName</div>
<div style="color: rgb(0, 0, 0); ">MSSQLSERVER automatic started SQL Server (MSSQLSERVER)</div>
<div style="color: rgb(0, 0, 0); ">MSSQLServerOLAPService automatic started SQL Server Analysis Services (MSSQLSERVER)</div>
<div style="color: rgb(0, 0, 0); ">SQLBrowser automatic started SQL Server Browser</div>
<div><font class="Apple-style-span" color="#0034ff">SQLSERVERAGENT automatic stopped SQL Server Agent (MSSQLSERVER)</font></div>
<div style="color: rgb(0, 0, 0); ">SQLWriter automatic started SQL Server VSS Writer</div>
<div style="color: rgb(0, 0, 0); ">BBWin automatic started Big Brother Xymon Client</div>
</blockquote>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
David Baldwin - Senior Systems Administrator (Datacentres + Networks)
Information and Communication Technology Services
Australian Sports Commission <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://ausport.gov.au">http://ausport.gov.au</a>
Tel 02 62147830 Fax 02 62141830 PO Box 176 Belconnen ACT 2616
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:david.baldwin@ausport.gov.au">david.baldwin@ausport.gov.au</a> Leverrier Street Bruce ACT 2617
</pre>
<br>
<hr>
Keep up to date with what's happening in Australian sport visit <a moz-do-not-send="true" href="http://www.ausport.gov.au">
www.ausport.gov.au</a><br>
<br>
<font face="arial" size="-2">This message is intended for the addressee named and may contain confidential and privileged information. If you are not the intended recipient please note that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you receive this message in error, please delete it and notify the sender.</font>
<hr>
</div>
</div>
</span></blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
David Baldwin - Senior Systems Administrator (Datacentres + Networks)
Information and Communication Technology Services
Australian Sports Commission <a class="moz-txt-link-freetext" href="http://ausport.gov.au">http://ausport.gov.au</a>
Tel 02 62147830 Fax 02 62141830 PO Box 176 Belconnen ACT 2616
<a class="moz-txt-link-abbreviated" href="mailto:david.baldwin@ausport.gov.au">david.baldwin@ausport.gov.au</a> Leverrier Street Bruce ACT 2617
</pre>
</div>
</div>
</span>
</body>
</html>