[Xymon] Monitoring sql server 2012 - Error - Length specified in network packet payload did not match number of bytes read
Anoop Mohan
anoopw14 at gmail.com
Wed Nov 26 11:46:21 CET 2014
Hello,
Please find the debug log of dbcheck.pl script. I checked with
wireshark and no request is generating to sql server port 1433.
Can anybody help please ?
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disabled_hosts line 1235
Wed Nov 26 11:29:51 2014:DEBUG: GET DISABLED HOSTS
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disabled_hosts line 1235
Wed Nov 26 11:29:51 2014:DEBUG: /usr/local/xymon/server/data/disabled
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_local_cmd line 442
Wed Nov 26 11:29:51 2014:DEBUG:
RESULT= 0, COMMAND= /usr/local/xymon/server/bin/bbhostgrep dbcheck
,VALUE=0.0.0.0 192.168.1.1 # dbcheck
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_local_cmd line 442
Wed Nov 26 11:29:51 2014:DEBUG:
RESULT= 0, COMMAND= /usr/local/xymon/server/bin/bbhostgrep dbcheck
,VALUE=0.0.0.0 192.168.1.1 # dbcheck
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::initialize_host_test line 318
Wed Nov 26 11:29:51 2014:DEBUG: hostname: 192.168.1.1
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::initialize_host_test line 318
Wed Nov 26 11:29:51 2014:DEBUG: hostadress: 192.168.1.1
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 276
Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0 data0=uptime,
data1=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65
Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0
data0=DBCheck, data1=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309
Wed Nov 26 11:29:51 2014:DEBUG: LINE=fulltest, EVENT=DBCheck,
CHECK=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65
Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0
data0=ChkConn, data1=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309
Wed Nov 26 11:29:51 2014:DEBUG: LINE=conn, EVENT=ChkConn, CHECK=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65
Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0
data0=TblSpace, data1=status+60
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309
Wed Nov 26 11:29:51 2014:DEBUG: LINE=tablespace, EVENT=TblSpace,
CHECK=status+60
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=pinlib, DEFW=95, DEFA=90, WARN=95,
ALERT=90
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=blbuff, DEFW=95, DEFA=90, WARN=95,
ALERT=90
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=rowcache, DEFW=95, DEFA=90, WARN=95,
ALERT=90
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disk_level line 1312
Wed Nov 26 11:29:51 2014:DEBUG: KEY=tblspcheck, hostname=192.168.1.1,
WP(1=%)=1, WARN=90, AP(1=%)=1, ALERT=95
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=tblsp, DEFW=90, DEFA=95, WARN=90%,
ALERT=95%
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=hitcache, DEFW=95, DEFA=90, WARN=95,
ALERT=90
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=rollback, DEFW=90, DEFA=95, WARN=90,
ALERT=95
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=session, DEFW=90, DEFA=95, WARN=90,
ALERT=95
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=process, DEFW=90, DEFA=95, WARN=90,
ALERT=95
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=memreq, DEFW=90, DEFA=95, WARN=90,
ALERT=95
Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319
Wed Nov 26 11:29:51 2014:DEBUG: KEY=extent, DEFW=90, DEFA=95, WARN=90,
ALERT=95
Wed Nov 26 11:29:51 2014:ERROR on 192.168.1.1: Timeout connecting to
DBI:Sybase:host=192.168.1.1;port=1433;encryptPassword=1!
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1235
Wed Nov 26 11:29:51 2014:DEBUG: TEST=conn, TYPE=status+60, EVENT=ChkConn,
SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1235
Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname:
192,168,1,1, type: status+60, event: ChkConn, time: 00:00:00, color=red
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 352
Wed Nov 26 11:29:51 2014:DEBUG: TEST=tablespace, TYPE=status+60,
EVENT=TblSpace, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 352
Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname:
192,168,1,1, type: status+60, event: TblSpace, time: 00:00:00, color=clear
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1347
Wed Nov 26 11:29:51 2014:DEBUG: TEST=uptime, TYPE=status+60, EVENT=uptime,
SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1347
Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname:
192,168,1,1, type: status+60, event: uptime, time: 00:00:00, color=clear
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_time line 889
Wed Nov 26 11:29:51 2014:DEBUG: exec 0.0.0.0 192.168.1.1 # dbcheck,
TIME=00:00:00
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1265
Wed Nov 26 11:29:51 2014:DEBUG: TEST=dbcheck, TYPE=status+60,
EVENT=dbcheck, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1265
Thanks
Anoop
On 21 November 2014 at 11:58, Anoop Mohan <anoopw14 at gmail.com> wrote:
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20141126/3cbaf8b3/attachment.html>
More information about the Xymon
mailing list