<html> <head> <style> .hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } </style> </head> <body class='hmmessage'> In my environment... WORKS: ./tsql -S mssqlsvr -p 1433 -U nagios -P password DOES NOT WORK: ./tsql -S mssqlsvr.domain.com -p 1433 -U nagios -P password locale is "en_US.UTF-8" locale charset is "UTF-8" Msg 20002, Level 9, State -1, Server OpenClient, Line -1 Adaptive Server connection failed There was a problem connecting to the server in my freetds.conf file... [mssqlsvr] host = mssqlsvr.domain.com port = 1433 tds version = 8.0 I vaguely recall also having some environment path / lib issues... but that may have been a different issue. -- Mat W. - <A href="http://www.techadre.com/">http://www.techadre.com</A> > Date: Fri, 11 Sep 2009 10:51:20 +0200 > Subject: Re: [Nagios-users] CHECK_MSSQL CRITICAL allways as output when use check_sql for MSSQL checking > From: arlytex@gmail.com > To: lmw94002@hotmail.com > CC: nagios-users@lists.sourceforge.net > > Good it works for someone :) hopefully it will work for me too :) > > anyway when I run > > ./check_mssql -H MSSQL ss -p 1433 -U nagios -P PASSWORD > CHECK_MSSQL CRITICAL > > again same error. > > where in my /etc/freetds.conf I have > > # A typical Microsoft server MSSQL server defined. > [MSSQL] > host = sss.sss.sss.sss > port = 1433 > tds version = 8.0 > > I installed Freetds from source code and when I run > > ./tsql -S sss.sss.sss.sss -U nagios -p 1433 > locale is "en_US.UTF-8" > locale charset is "UTF-8" > Password: > Msg 20008, Level 9, State -1, Server OpenClient, Line -1 > Unable to open socket > There was a problem connecting to the server > > I get password prompt and after I enter password it ends with above > error without connecting. > I am not really sure what could be reason for behaviour like this, I > can connect to MSSQL 2005 server > on port 1433 but when used freetds for some reason it hangs. I > compiled freetds with support for tdsver=8.0 > > Thank you for comments > > Nice regards, > > Arlen > > > > > > > > On Thu, Sep 10, 2009 at 11:13 PM, Mathew Walker <lmw94002@hotmail.com> wrote: > > I use FreeDTS... works like a champ. > > > > but note how the "host" is defined in the freedts.conf file between the > > square brakcets, not the FQDN or IP address when running the check from the > > command line. > > > > eg. try... > > > > ./check_mssql -H MSSQL ss -p 1433 -U USER -P PASSWORD > > > > -- > > Mat W. - http://www.techadre.com > > > > > > > >> Date: Thu, 10 Sep 2009 22:46:55 +0200 > >> From: arlytex@gmail.com > >> To: jim@jimavery.me.uk > >> CC: nagios-users@lists.sourceforge.net > >> Subject: Re: [Nagios-users] CHECK_MSSQL CRITICAL allways as output when > >> use check_sql for MSSQL checking > >> > >> On Thu, Sep 10, 2009 at 6:21 PM, Jim Avery <jim@jimavery.me.uk> wrote: > >> > 2009/9/9 Arlen Drina <arlytex@gmail.com>: > >> >> Hi all, > >> >> > >> >> I am using check_sql for checking MSSQL server ( or I would like to > >> >> check MSSQL servers ). I compiled > >> >> freetds with --with-tdsver=8.0 support on my debian system and all > >> >> went ok, in /etc/freetds.conf I have > >> >> > >> >> [global] > >> >> # TDS protocol version > >> >> #; tds version = 4.2 > >> >> tds version = 8.0 > >> >> > >> >> # A typical Microsoft server > >> >> [MSSQL] > >> >> host = sss.sss.sss.sss > >> >> port = 1433 > >> >> tds version = 8.0 > >> >> > >> >> and when I run ./check_mssql -H sss.sss.sss.sss -p 1433 -U USER -P > >> >> PASSWORD > >> >> > >> >> I am constantly getting output > >> >> > >> >> CHECK_MSSQL CRITICAL > >> >> > >> >> Ok, I tried to solve this myself and I found at \ > >> >> > >> >> > >> >> http://exchange.nagios.org/directory/Plugins/Databases/Others/check_sql/details > >> >> that is recommneded to change host-->server in line > >> >> > >> >> my $cs = "DBI:$driver:" . ($database ? "database=$database;" : '') . > >> >> "server=$hostname" . ($port ? ";port=$port" : ''); > >> >> > >> >> so I changed that, but still I am getting same output for above > >> >> command. > >> >> > >> >> I am just trying to get minimal response from MSSQL server, connection > >> >> to port 1433 is open and I can connect via > >> >> telnet sss.sss.sss.sss 1433 and it works. > >> >> > >> >> Any hint is welcome, I exhausted all my ideas, and thank you in advance > >> > > >> > > >> > I don't use freetds. Instead, I installed php5-sybase (and any > >> > dependencies if there were any, I can't remember) from the debian > >> > repositories (I'm using Ubuntu). > >> > > >> > I can run the plugin from the command line like so: > >> > > >> > /usr/local/nagios/libexec/check_mssql -H 10.10.10.123 -U loginid -P > >> > mypassword > >> > OK: Connect time=0.004189 seconds. > >> > > >> > Of course, the user "loginid" must be configured in MSSQL with the > >> > password "mypassword" to authenticate to the database. > >> > > >> > Some of our MSSQL servers have a specific instance, in which case you > >> > need to find the port number the instance is listening on, then use > >> > the following syntax to do the check: > >> > > >> > /usr/local/nagios/libexec/check_mssql -H 10.10.10.123:1375 -u > >> > loginid -P mypassword > >> > OK: Connect time=0.045179 seconds. > >> > > >> > (1375 is the port number for this instance but it varies from one to the > >> > next) > >> > > >> > I found the check_mssql didn't like the hostname syntax when using IP > >> > addresses like this, so I changed it a bit by removing both the > >> > "Validate the hostname" and "Validate the username" sections. > >> > > >> > I also (very sloppily) altered the part where it checks if the > >> > expected result is emtpy like so: > >> > > >> > 287c205 > >> > < if ($querytype == "query" && !empty($expected_result)) { > >> > --- > >> > > if ($querytype == "query" && (!empty($expected_result) || > >> > $expected_result == "0")) { > >> > > >> > That was because I wanted to do a check which expected a result "0". > >> > > >> > > >> > hth, > >> > > >> > Jim > >> > > >> > >> After your post I installed php5-sybase and still getting same error : > >> CHECK_MSSQL CRITICAL > >> > >> I am using command: ./check_mssql -H sss.sss.sss.sss -U user -P pass > >> > >> user and password are valid and I can connect with them to database. > >> MSSQL server listen on port 1433 > >> and I can connect on port 1433 when run > >> > >> telnet sss.sss.sss.sss 1433 > >> > >> Is there something special necessary to enable on MSSQL side, some > >> deamon, whatever, ...I expected > >> it to work with php5-sybase but it does not. > >> > >> Thank you for reply and regards, > >> > >> Arlen > >> > >> > >> > > >> > ------------------------------------------------------------------------------ > >> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > >> > 30-Day > >> > trial. Simplify your report design, integration and deployment - and > >> > focus on > >> > what you do best, core application coding. Discover what's new with > >> > Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> > _______________________________________________ > >> > Nagios-users mailing list > >> > Nagios-users@lists.sourceforge.net > >> > https://lists.sourceforge.net/lists/listinfo/nagios-users > >> > ::: Please include Nagios version, plugin version (-v) and OS when > >> > reporting any issue. > >> > ::: Messages without supporting info will risk being sent to /dev/null > >> > > >> > >> > >> ------------------------------------------------------------------------------ > >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > >> 30-Day > >> trial. Simplify your report design, integration and deployment - and focus > >> on > >> what you do best, core application coding. Discover what's new with > >> Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> _______________________________________________ > >> Nagios-users mailing list > >> Nagios-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/nagios-users > >> ::: Please include Nagios version, plugin version (-v) and OS when > >> reporting any issue. > >> ::: Messages without supporting info will risk being sent to /dev/null > > > > ________________________________ > > With Windows Live, you can organize, edit, and share your photos. Click > > here. <hr />Windows Live: Keep your friends up to date with what you do online. <a href='http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009' target='_new'>Find out more.</a></body> </html>