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