November 2014 - Xymon - Xymon mailman web

XymonPSclient
by SKreien＠la-z-boy.com 11 Feb '15

11 Feb '15

Hey everyone, I'm trying out the PS client again after using it 1-2 years ago and it causing too many problems. I'm hoping the impact on the clients will have been lessened since I tried it last. I have the PS client installed and configured, but I never show any connection to the xymon server while monitoring with tcpdump. Also, I never get any files created in the temp directory. Here's the dump of the config below: PS C:\Xymon> .\xymonclient.ps1 config XymonPSClient config: servers : xymon.internal.hq loopinterval : 60 maxlogage : 30 clientlower : 1 Settable Params and values: clientbbwinmembug=1 clientconfigfile=C:\Users\skreien\AppData\Local\Temp\xymonconfig.cfg clientfqdn=1 clientlogfile=C:\Users\skreien\AppData\Local\Temp\xymonclient.log clientlower=1 clientname=corpvskreien.na.lzb.hq clientremotecfgexec=0 loopinterval=60 maxlogage=30 reportevt=1 servers= xymon.internal.hq slowscanrate=72 wanteddisks=3 wantedlogs=Application System Security The Xymon server is running as it is receiving messages from hundreds of other clients. This is an internal only server so iptables is off, Windows firewall is off, and I can successfully telnet from the client to the Xymon server port so there is nothing standing in the way. The server is Redhat 5.5, client is Win7. Any ideas? Scot Kreienkamp This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.

9 12

local mode client
by gendalia＠iastate.edu 02 Feb '15

02 Feb '15

One of my co-workers has installed xymon 4.3.7, and wants to use local mode for configuration. The display server is not receiving anything from his machine if things run normally, but when run by hand, xymon can send data from his server (Solaris) to the display server. I enabled xymond_client --debug in xymonclient.sh: if test "$LOCALMODE" = "yes"; then echo "@@" >> $MSGTMPFILE $XYMONHOME/bin/xymond_client --debug --local --config=$XYMONHOME/etc/localclient .cfg <$MSGTMPFILE And now I'm getting this: + ../bin/xymond_client --debug --local --config=../etc/localclient.cfg 11655 2012-02-14 16:20:29 Want msg 1, startpos 0, fillpos 0, endpos -1, usedbytes=0, bufleft=528383 11655 2012-02-14 16:20:29 Got 161874 bytes 11655 2012-02-14 16:20:29 ../bin/xymond_client: Got message 1 @client#1|0|127.0.0.1|neptune.lib.iastate.edu|sunos 11655 2012-02-14 16:20:29 startpos 161874, fillpos 161874, endpos -1 11655 2012-02-14 16:20:29 Opening file ../etc/localclient.cfg 11655 2012-02-14 16:20:29 Compiling regex ^/zones.*/ 11655 2012-02-14 16:20:29 Client report from host neptune.lib.iastate.edu 11655 2012-02-14 16:20:29 neptune.lib.iastate.edu: Duplicate client message at time 0, seq 1, lastseq 0 11655 2012-02-14 16:20:29 Want msg 2, startpos 161874, fillpos 161874, endpos -1, usedbytes=0, bufleft=366509 11655 2012-02-14 16:20:29 get_xymond_message: Returning NULL due to EOF + rm -f ../tmp/msg.neptune.lib.iastate.edu.txt I'm not sure where to go from here. Does local mode still work for most people? -Tracy

2 2

xymonnet - fatal signal caught
by incin＠incin.me 05 Jan '15

05 Jan '15

Hello, This is my first post to the mailing list and I was hoping to get some help with an issue I am having. My xymon server has been running great with no issues for months, version xymon-server-4.3.17_3 on FreeBSD10. This morning xymonnet has crashed. Here is the output from the xymonlaunch.log file: 06:45:07 Task xymonnet terminated by signal 6 06:50:11 Task xymonnet terminated by signal 6 06:55:11 Task xymonnet terminated by signal 6 7:00:12 Task xymonnet terminated by signal 6 07:05:13 Task xymonnet terminated by signal 6 7:10:14 Task xymonnet terminated by signal 6 07:20:16 Task xymonnet terminated by signal 6 Server was rebooted: 07:26:48 xymonlaunch starting 07:26:48 Loading tasklist configuration from (location of file here) 07:26:48 Loading hostnames 07:26:49 Loading saved state 07:26:49 Setting up network listener on 0.0.0.0:1984 07:26:49 Setting up signal handlers 7:26:49 Setting up xymond channels 07:26:49 Setting up logfiles 07:31:02 Task xymonnet terminated by signal 6 07:36:04 Task xymonnet terminated by signal 6 7:41:09 Task xymonnet terminated by signal 6 7:46:11 Task xymonnet terminated by signal 6 Before it started crashing there were no changes (in xymon config files) or updates made. We add new hosts and checks every few days. I checked the other logs for xymon and things looks ok. Other areas of xymon work as well. Maybe I am over looking a log file and missing something obvious of why it keeps crashing. Any thoughts on where to look next? Thank you, --

4 10

graphs that use multiple RRD files as input
by sgb＠pics.com 01 Dec '14

01 Dec '14

I figured this out. First in cgioptions.cfg I had to add CGI_SVC_OPTS="... --multigraphs=,disk,inode,qtree,quotas,snapshot,TblSpace,if_load,DBAreas" Initially I added just my custom "DBAreas" but that broke the others. The html.c code says if mulitgraphs is blank then put "disk...if_load" as defaults but if it isn't blank then those don't get loaded so we have to basically add them back. Adding the mods to cgioptions.cfg worked to a degree. It was graphing the first 4 of my rrds onto one graph but it was only creating the one graph. To fix that problem I had to add " Into the message/text that is sent Like this INFO=$INFO\n" " status $MACHINE.$TEST $COLOR $INFO Steve From: Steve Brown Sent: Wednesday, November 26, 2014 11:10 PM To: xymon at xymon.com Subject: graphs that use multiple RRD files as input I have a graph setup on a custom test that is using multiple RRD files as input. The graph is working but it is combining all the RRDs into a single graph instead of splitting them up like the built in "disk" graphs. Is there a parameter missing in my graphs.cfg definition or some other place I need to modify in order to have Xymon automatically split the graph up into multiple graphs? Thanks Steve [DBAreas] FNPATTERN DBAreas,(.*).rrd TITLE Area Size YAXIS KB DEF:kba at RRDIDX@=@RRDFN@:kbarea:AVERAGE LINE3:kba at RRDIDX@#@COLOR@:Area at RRDPARAM@ GPRINT:kba at RRDIDX@:LAST: \: %5.1lf (cur) GPRINT:kba at RRDIDX@:MAX: \: %5.1lf (max) GPRINT:kba at RRDIDX@:MIN: \: %5.1lf (min) GPRINT:kba at RRDIDX@:AVERAGE: \: %5.1lf (avg)\n Disk splits into more than 1 graph

3 3

Building a new server - part 2
by everett.vernon＠gmail.com 01 Dec '14

01 Dec '14

OK, I was correct about the library packages. Once I installed them, it resolved most of my problems, and the configure script completed OK. On to the make. (Or gmake in my case) And we hit the next hurdle. gcc -g -O2 -Wall -Wno-unused -D_REENTRANT -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DSunOS -I/var/tmp/xymon-4.3.17/include -I/opt/csw/include -o xymonnet xymonnet.o contest.o httptest.o httpresult.o ldaptest.o dns.o dns2.o httpcookies.o -L -lcares -L/opt/csw/lib -lldap -llber ../lib/libxymontime.a -lrt ../lib/libxymoncomm.a -L/usr/sfw/lib -lssl -lcrypto -lresolv -lsocket -lnsl -lrt ../lib/libxymon.a -L/opt/csw/lib -lpcre Undefined first referenced symbol in file ares_process dns.o ares_gethostbyname dns.o ares_strerror dns.o ares_init_options dns.o ares_search dns.o ares_fds dns.o ares_destroy dns.o ares_timeout dns.o ares_expand_name dns2.o ld: fatal: Symbol referencing errors. No output written to xymonnet collect2: ld returned 1 exit status Makefile:33: recipe for target 'xymonnet' failed gmake[1]: *** [xymonnet] Error 1 gmake[1]: Leaving directory '/var/tmp/xymon-4.3.17/xymonnet' build/Makefile.rules:102: recipe for target 'xymonnet-build' failed gmake: *** [xymonnet-build] Error 2 Any ideas? Regards Vernon -- "Accept the challenges so that you can feel the exhilaration of victory" - General George Patton

3 11

Subjectline shows red status, body green status
by hj.beckers＠kreis-steinfurt.de 28 Nov '14

28 Nov '14

I just received a xymon alert with the subject line: Xymon [530795] xxx.yyy.de:smtp CRITICAL (RED) but the message body shows: "green Fri Nov 28 12:01:26 2014 smtp ok Service smtp on xxx.yyy.de is OK (up) 220 xxx.yyy Mail Gateway ready Seconds: 0.00 See ..." My rrd-status.log contains some "bug"-messages regarding this server: 2014-04-28 16:10:19 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1398694219, different data 2014-09-30 13:46:46 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1412077606, different data 2014-11-26 12:23:52 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417001031, different data 2014-11-26 12:23:52 xxx.yyy.de/tcp.smtp.rrd: Bug - duplicate RRD data with same timestamp 1417001031, different data 2014-11-26 14:54:46 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417010086, different data 2014-11-27 01:18:24 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417047503, different data 2014-11-27 08:31:01 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417073461, different data 2014-11-27 20:15:26 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417115726, different data 2014-11-27 22:36:20 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417124180, different data 2014-11-27 23:41:50 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417128110, different data 2014-11-28 00:17:07 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417130226, different data 2014-11-28 01:27:33 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417134452, different data 2014-11-28 06:44:36 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417153476, different data 2014-11-28 09:25:30 xxx.yyy.de/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1417163130, different data there is only 1 entry for the smtp.rrd file, all others are for the conn-test. Any hints? Hermann-Josef Beckers

1 0

Fwd: Building a new server - part 2
by everett.vernon＠gmail.com 28 Nov '14

28 Nov '14

Forgot to include the list. Of course, refering to my notes, I have hit (and worked around) that issue before. mv /usr/ccs/bin/ld /usr/ccs/bin/ld.orig And we get further, but not much. gcc -g -O2 -Wall -Wno-unused -D_REENTRANT -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DSunOS -I/var/tmp/xymon-4.3.17/include -I/opt/csw/include -I/opt/csw/include -DRRDTOOL12 -I/opt/csw/include -c -o perfdata.o perfdata.c In file included from perfdata.c:20: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/math.h:26:26: iso/math_iso.h: No such file or directory In file included from /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/math.h:336, from perfdata.c:20: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:30:24: sys/ieeefp.h: No such file or directory In file included from /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/math.h:336, from perfdata.c:20: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:104: error: field `fpclass' has incomplete type /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:128: error: field `rd' has incomplete type Makefile:130: recipe for target 'perfdata.o' failed gmake[1]: *** [perfdata.o] Error 1 gmake[1]: Leaving directory '/var/tmp/xymon-4.3.17/web' build/Makefile.rules:111: recipe for target 'web-build' failed gmake: *** [web-build] Error 2 On 28 November 2014 at 10:24, Vernon Everett <everett.vernon at gmail.com> wrote: > Hi Roland > > Thanks for the quick response. > > I have built Xymon on Solaris many times too, and agree, it should just > work. > I did find something interesting just a minute ago. > Looking through the Makefile, to check what it's looking for, and notices > something odd about the c-ares definitions. See below. > Notice the CARESLIBS has no directory defined after the -L > I changed that to CARESLIBS = -L/opt/csw/lib -lcares > And we moved on. > Only to hit another one. > gcc -g -O2 -Wall -Wno-unused -D_REENTRANT -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 -DSunOS -I/var/tmp/xymon-4.3.17/include > -I/opt/csw/include -I/opt/csw/include -I/opt/csw/include -DRRDTOOL12 -c -o > do_rrd.o do_rrd.c > gcc -o xymond_rrd xymond_rrd.o xymond_worker.o do_rrd.o > client_config.o ../lib/libxymontime.a -lrt ../lib/libxymoncomm.a > -L/usr/sfw/lib -lssl -lcrypto -lresolv -lsocket -lnsl -lrt -L/opt/csw/lib > -lrrd -L/opt/csw/lib -lpcre > Undefined first referenced > symbol in file > XRenderCreateLinearGradient /opt/csw/lib/libcairo.so.2 > XRenderCreateRadialGradient /opt/csw/lib/libcairo.so.2 > XRenderCreateSolidFill /opt/csw/lib/libcairo.so.2 > ld: fatal: Symbol referencing errors. No output written to xymond_rrd > collect2: ld returned 1 exit status > Makefile:62: recipe for target 'xymond_rrd' failed > gmake[1]: *** [xymond_rrd] Error 1 > gmake[1]: Leaving directory '/var/tmp/xymon-4.3.17/xymond' > build/Makefile.rules:108: recipe for target 'xymond-build' failed > gmake: *** [xymond-build] Error 2 > > My next Xymon install will be on Linux! > No exceptions! > > --- snip --- > > # C-ARES settings > SYSTEMCARES = yes > CARESINCDIR = -I/opt/csw/include > *CARESLIBS = -L -lcares* > RPATHVAL += > > # PCRE settings > PCREINCDIR = -I/opt/csw/include > PCRELIBS = -L/opt/csw/lib -lpcre > RPATHVAL += /opt/csw/lib > > # RRDtool settings > RRDDEF = -DRRDTOOL12 > RRDINCDIR = -I/opt/csw/include > RRDLIBS = -L/opt/csw/lib -lrrd > RPATHVAL += /opt/csw/lib > DORRD = yes > # > # OpenSSL settings > SSLFLAGS = -DHAVE_OPENSSL -DHAVE_SSLV2_SUPPORT > SSLINCDIR = -I/opt/csw/include > SSLLIBS = -L/usr/sfw/lib -lssl -lcrypto > RPATHVAL += /usr/sfw/lib > DOSSL = yes > > --- snip --- > > > > On 28 November 2014 at 10:07, Roland Soderstrom < > Rolands at logicaltech.com.au> wrote: > >> I’ve compiled 4.3.17 on Solaris Sparc and x86 with OpenCSW, so it >> should work. >> >> >> >> This is roughly what I do. >> >> pkgutil -y -i coreutils >> >> pkgutil -y -i gzip >> >> pkgutil -y -i wget >> >> pkgutil -y -a berkeleydb48 >> >> pkgutil -y -i freetype >> >> pkgutil -y -i libart >> >> pkgutil -y -i libpng15_15 >> >> pkgutil -y -i libtool >> >> pkgutil -i -y gcc4core gcc4g++ gmake >> >> pkgutil -i -y pcre libpcre_dev >> >> pkgutil -i -y rrdtool rrdtool_dev >> >> pkgutil -i -y openssl libssl_dev >> >> pkgutil -i -y openldap_client openldap_dev >> >> pkgutil -i -y fping >> >> >> >> export PATH=/usr/bin:/usr/sbin:/opt/csw/bin:/opt/csw/sbin:/usr/ccs/bin >> >> >> >> Make SURE /usr/local/<something> or /usr/sfw/<something> is not in any >> path. >> >> export LD_LIBRARY_PATH=”” >> >> crle >> >> >> >> which gmake >> >> /opt/csw/bin/gmake >> >> which ld >> >> /usr/ccs/bin/ld >> >> MAKE=gmake ; /configure >> >> gmake >> >> >> >> - Roland >> >> >> >> *From:* Xymon [mailto:xymon-bounces at xymon.com] *On Behalf Of *Vernon >> Everett >> *Sent:* Friday, 28 November 2014 12:18 PM >> *To:* Xymon mailinglist >> *Subject:* [Xymon] Building a new server - part 2 >> >> >> >> OK, I was correct about the library packages. >> >> Once I installed them, it resolved most of my problems, and the configure >> script completed OK. >> >> On to the make. (Or gmake in my case) >> And we hit the next hurdle. >> gcc -g -O2 -Wall -Wno-unused -D_REENTRANT -D_LARGEFILE_SOURCE >> -D_FILE_OFFSET_BITS=64 -DSunOS -I/var/tmp/xymon-4.3.17/include >> -I/opt/csw/include -o xymonnet xymonnet.o contest.o httptest.o >> httpresult.o ldaptest.o dns.o dns2.o httpcookies.o -L -lcares >> -L/opt/csw/lib -lldap -llber ../lib/libxymontime.a -lrt >> ../lib/libxymoncomm.a -L/usr/sfw/lib -lssl -lcrypto -lresolv -lsocket >> -lnsl -lrt ../lib/libxymon.a -L/opt/csw/lib -lpcre >> Undefined first referenced >> symbol in file >> ares_process dns.o >> ares_gethostbyname dns.o >> ares_strerror dns.o >> ares_init_options dns.o >> ares_search dns.o >> ares_fds dns.o >> ares_destroy dns.o >> ares_timeout dns.o >> ares_expand_name dns2.o >> ld: fatal: Symbol referencing errors. No output written to xymonnet >> collect2: ld returned 1 exit status >> Makefile:33: recipe for target 'xymonnet' failed >> gmake[1]: *** [xymonnet] Error 1 >> gmake[1]: Leaving directory '/var/tmp/xymon-4.3.17/xymonnet' >> build/Makefile.rules:102: recipe for target 'xymonnet-build' failed >> gmake: *** [xymonnet-build] Error 2 >> >> Any ideas? >> >> Regards >> Vernon >> >> -- >> >> "Accept the challenges so that you can feel the exhilaration of victory" >> >> - General George Patton >> > > > > -- > "Accept the challenges so that you can feel the exhilaration of victory" > - General George Patton > -- "Accept the challenges so that you can feel the exhilaration of victory" - General George Patton -- "Accept the challenges so that you can feel the exhilaration of victory" - General George Patton

3 2

Building a new Server
by everett.vernon＠gmail.com 27 Nov '14

27 Nov '14

Hi all Trying to build a new server. And not having much luck. MAKE=gmake ./configure.server MAKE=gmake ./configure.server --pcreinclude /opt/csw/include/ --pcrelib /opt/csw/lib/pkgconfig/ and MAKE=gmake ./configure.server --pcreinclude /opt/csw/include/ --pcrelib /opt/csw/lib/ all give the exact same result below. + uname -s OS=SunOS In file included from test-pcre.c:1: /opt/csw/include/pcre.h:90:20: stdlib.h: No such file or directory In file included from test-pcre.c:1: /opt/csw/include/pcre.h:489: warning: parameter names (without types) in function declaration /opt/csw/include/pcre.h:491: warning: parameter names (without types) in function declaration /opt/csw/include/pcre.h:496: warning: parameter names (without types) in function declaration /opt/csw/include/pcre.h:498: warning: parameter names (without types) in function declaration /opt/csw/include/pcre.h:503: warning: parameter names (without types) in function declaration /opt/csw/include/pcre.h:505: warning: parameter names (without types) in function declaration test-pcre.c: In function `main': test-pcre.c:8: error: `NULL' undeclared (first use in this function) test-pcre.c:8: error: (Each undeclared identifier is reported only once test-pcre.c:8: error: for each function it appears in.) Makefile.test-pcre:4: recipe for target 'test-compile' failed gmake: *** [test-compile] Error 1 + test 2 -eq 0 + echo ERROR: Cannot compile using PCRE library. ERROR: Cannot compile using PCRE library. PCREOK=NO + gmake -f Makefile.test-pcre test-link PCRELIB=-L/opt/csw/lib + sed -es@/@_ at g + uname -s OS=SunOS gcc: test-pcre.o: No such file or directory Makefile.test-pcre:7: recipe for target 'test-link' failed gmake: *** [test-link] Error 1 + test 2 -eq 0 + echo ERROR: Cannot link with PCRE library. ERROR: Cannot link with PCRE library. PCREOK=NO + gmake -f Makefile.test-pcre clean + sed -es@/@_ at g + uname -s OS=SunOS + cd .. + test NO = NO + echo Missing PCRE include- or library-files. These are REQUIRED for xymond Missing PCRE include- or library-files. These are REQUIRED for xymond + echo PCRE can be found at http://www.pcre.org/ PCRE can be found at http://www.pcre.org/ + echo If you have PCRE installed, use the "--pcreinclude DIR" and "--pcrelib DIR" If you have PCRE installed, use the "--pcreinclude DIR" and "--pcrelib DIR" + echo options to configure to specify where they are. options to configure to specify where they are. + exit 1 Have the following pcre related packages installed. bash-3.00# pkgutil -l | grep -i pcre CSWlibpcre-dev CSWlibpcre0 CSWlibpcre1 CSWlibpcre16-0 CSWlibpcre32-0 CSWlibpcrecpp0 CSWlibpcreposix0 CSWpcre CSWpcrert What's missing here? -- "Accept the challenges so that you can feel the exhilaration of victory" - General George Patton

2 4

graphs that use multiple RRD files as input
by sgb＠pics.com 27 Nov '14

27 Nov '14

I have a graph setup on a custom test that is using multiple RRD files as input. The graph is working but it is combining all the RRDs into a single graph instead of splitting them up like the built in "disk" graphs. Is there a parameter missing in my graphs.cfg definition or some other place I need to modify in order to have Xymon automatically split the graph up into multiple graphs? Thanks Steve [DBAreas] FNPATTERN DBAreas,(.*).rrd TITLE Area Size YAXIS KB DEF:kba at RRDIDX@=@RRDFN@:kbarea:AVERAGE LINE3:kba at RRDIDX@#@COLOR@:Area at RRDPARAM@ GPRINT:kba at RRDIDX@:LAST: \: %5.1lf (cur) GPRINT:kba at RRDIDX@:MAX: \: %5.1lf (max) GPRINT:kba at RRDIDX@:MIN: \: %5.1lf (min) GPRINT:kba at RRDIDX@:AVERAGE: \: %5.1lf (avg)\n [cid:image001.png at 01D009CD.379965D0] Disk splits into more than 1 graph [cid:image002.png at 01D009CD.C8E83070]

1 0

Monitoring sql server 2012 - Error - Length specified in network packet payload did not match number of bytes read
by anoopw14＠gmail.com 26 Nov '14

26 Nov '14

Hello, I am trying to implement an Sql server 2012 monitoring script. Installed the dbcheck.pl script from this link : http://sourceforge.net/projects/hobbit-perl-cl/ . While running I am getting an error. Sql server log : "Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: XXXXXXXXx]" xymon log : ERROR on 192.168.1.1 : Timeout connecting to DBI:Sybase:host=192.168.1.1;port=1433;encryptPassword=1! Can anybody please help me to resolve this error ? Thanks Anoop

1 1