Jure_Simsic_106
Aug 06, 2007Nimbostratus
MSSQL monitor not working
I have a pool with one mssql server and I wanted to set up the MSSQL monitor type. The problem is, it doesn't seem to make any mssql connection attempts at all.
I've filled out the username, pwd, db name, send/recieve string, but it seems the check doesn't get executed at all (from tcpdump). If I set the monitor to tcp or tcp_half_open, the pool s alive, if I change it to the MSSQL check, there is no traffic being generated towards the mssql and the check offlines the service..
Any ideas what to do. There is a *debug* option for the monitor and I've found the log in /var/log/MSSQL...
This is the output (but no traffic seen on the interface):
********** Debugging session beginning at: Mon Aug 6 12:47:22 2007
Arguments 1-2:
::ffff:10.60.0.105
1433
Environment variables:
COUNT=0
DATABASE=mobitelplanet
DEBUG=yes
MON_TMPL_NAME=DB-MSSQL
NODE_IP=::ffff:10.60.0.105
NODE_PORT=1433
PASSWORD=XXXXXXXXXXXXXX
RECVCOLUMN=
RECVROW=0
RECV_I=6
SEND=select day(getdate())
USERNAME=lbcheck
count='0' converts to '0'
pidfile exists -- checking for correctness of pid...
DBDaemon says its pid is 18831
pid of 18831 is correct!
Recvd: 'com.microsoft.jdbc.sqlserver.SQLServerDriver
'
Recvd: 'jdbc:microsoft:sqlserver://10.60.0.105:1433;databaseName=mobitelplanet;
'
Recvd: 'lbcheck
'
Recvd: '!Bch3cK0$!Bch3cK0$
'
Recvd: '0
'
Recvd: 'select day(getdate())
'
Recvd: '6
'
Recvd: '0
'
Recvd: '1
'
Recvd: 'debug
'
Recvd: 'Loading database driver com.microsoft.jdbc.sqlserver.SQLServerDriver
'
Recvd: 'Error loading driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': jav
a.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver!Down
!
'
Error receiving up/down message