<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</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. Here is the analysis.cfg section for the SQL server:</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div>
<div style="color: rgb(0, 0, 0); "># 4/3/12 - Added Port and Service monitoring for SQL and Web</div>
<div style="color: rgb(0, 0, 0); "># OUR SQL SERVER</div>
<div style="color: rgb(0, 0, 0); "> HOST=OURHOST GROUP=DBA</div>
<div style="color: rgb(0, 0, 0); "> SVC ReportServer status=started startup=automatic</div>
<div style="color: rgb(0, 0, 0); "> <span class="Apple-tab-span" style="white-space:pre">
</span>SVC MSSQLSERVER status=started startup=automatic</div>
<div style="color: rgb(0, 0, 0); "> SVC SQLBrowser status=started startup=automatic</div>
<div style="color: rgb(0, 0, 0); "> SVC SQLSERVERAGENT status=started startup=automatic</div>
<div style="color: rgb(0, 0, 0); "> <span class="Apple-tab-span" style="white-space:pre">
</span>SVC SQLWriter status=started startup=automatic</div>
<div><font class="Apple-style-span" color="#ff2500"> PORT STATE=LISTENING LOCAL=1433 MIN=1 Test=SQLServer</font></div>
<div style="color: rgb(0, 0, 0); "> PROC ReportingServicesService.exe 1 1</div>
<div style="color: rgb(0, 0, 0); "> PROC sqlservr.exe 1 1</div>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">Can you clarify where I should grab the section of the client report ? I went to the target agent in Xymon, clicked on the alert that was flashing, then it showed the info as below. Then I went in and clicked on the "Client
Detail" link, but that's a very long report. If it's a section of the client detail link, I can grab what you think is relevent, or if it's in another report or link, just let me know.</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<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>
<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>