MS SQL Wizard

[Flava]

MS SQL Wizard returning null output as status information. I have attached a pic.

[scottwilkerson]

Have you installed the prereq's?

From the Download page

Before installing this wizard please refer to the documentation here:

http://exchange.nagios.org/directory/Do ... qs/details

[Flava]

so is it safe to remove these Dependencies; I am using NagiosXI 2011 R2.2; I dont have any special plugins installed other the ones supplies with the VMware image.

Code: Select all

Error: Package: perl-DBD-Sybase-1.10-1.el6.rf.i686 (@rpmforge)
           Requires: libtds.so.5
           Removing: freetds-0.64-1.el6.rf.i686 (@rpmforge)
               libtds.so.5
           Updated By: freetds-0.91-2.el6.i686 (epel)
               Not found
Error: Package: nagiosxi-deps-2011r1.9-1.noarch (@/nagiosxi-deps-2011r1.9-1.noarch)
           Requires: freetds = 0.64
           Removing: freetds-0.64-1.el6.rf.i686 (@rpmforge)
               freetds = 0.64-1.el6.rf
           Updated By: freetds-0.91-2.el6.i686 (epel)
               freetds = 0.91-2.el6
Error: Package: nagiosxi-deps-2011r1.9-1.noarch (@/nagiosxi-deps-2011r1.9-1.noarch)
           Requires: freetds-devel = 0.64
           Removing: freetds-devel-0.64-1.el6.rf.i686 (@rpmforge)
               freetds-devel = 0.64-1.el6.rf
           Updated By: freetds-devel-0.91-2.el6.i686 (epel)
               freetds-devel = 0.91-2.el6
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

[scottwilkerson]

You should be able to run the install with --skip-broken as you already have newer versions of these.

[Flava]

It is still reporting the old version as installed...

Code: Select all

yum info freetds
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.sov.uk.goscomb.net
 * epel: ftp.heanet.ie
 * extras: mirror.sov.uk.goscomb.net
 * rpmforge: apt.sw.be
 * updates: mirror01.th.ifl.net
Installed Packages
Name        : freetds
Arch        : i686
Version     : 0.64
Release     : 1.el6.rf
Size        : 4.2 M
Repo        : installed
From repo   : rpmforge
Summary     : Implementation of the Sybase/Microsoft TDS (Tabular DataStream) protocol
URL         : http://www.freetds.org/
License     : LGPL
Description : FreeTDS is a project to document and implement the TDS (Tabular
            : DataStream) protocol. TDS is used by Sybase and Microsoft for
            : client to database server communications. FreeTDS includes call
            : level interfaces for DB-Lib, CT-Lib, and ODBC.

Available Packages
Name        : freetds
Arch        : i686
Version     : 0.91
Release     : 2.el6
Size        : 569 k
Repo        : epel
Summary     : Implementation of the TDS (Tabular DataStream) protocol
URL         : http://www.freetds.org/
License     : LGPLv2+ and GPLv2+
Description : FreeTDS is a project to document and implement the TDS (Tabular
            : DataStream) protocol. TDS is used by Sybase(TM) and Microsoft(TM) for
            : client to database server communications. FreeTDS includes call
            : level interfaces for DB-Lib, CT-Lib, and ODBC.

Dependency problems...

Code: Select all

yum install freetds --skip-broken
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.sov.uk.goscomb.net
 * epel: ftp.heanet.ie
 * extras: mirror.sov.uk.goscomb.net
 * rpmforge: apt.sw.be
 * updates: mirror01.th.ifl.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package freetds.i686 0:0.64-1.el6.rf will be updated
--> Processing Dependency: libtds.so.5 for package: perl-DBD-Sybase-1.10-1.el6.rf.i686
--> Processing Dependency: libtds.so.5 for package: freetds-devel-0.64-1.el6.rf.i686
--> Processing Dependency: libtdssrv.so.2 for package: freetds-devel-0.64-1.el6.rf.i686
--> Processing Dependency: freetds = 0.64 for package: nagiosxi-deps-2011r1.9-1.noarch
--> Processing Dependency: freetds = 0.64-1.el6.rf for package: freetds-devel-0.64-1.el6.rf.i686
---> Package freetds.i686 0:0.91-2.el6 will be an update
--> Running transaction check
---> Package freetds.i686 0:0.64-1.el6.rf will be updated
--> Processing Dependency: libtds.so.5 for package: perl-DBD-Sybase-1.10-1.el6.rf.i686
--> Processing Dependency: freetds = 0.64 for package: nagiosxi-deps-2011r1.9-1.noarch
---> Package freetds-devel.i686 0:0.64-1.el6.rf will be updated
--> Processing Dependency: freetds-devel = 0.64 for package: nagiosxi-deps-2011r1.9-1.noarch
---> Package freetds-devel.i686 0:0.91-2.el6 will be an update
--> Finished Dependency Resolution

Packages skipped because of dependency problems:
    freetds-0.91-2.el6.i686 from epel
    freetds-devel-0.91-2.el6.i686 from epel

Code: Select all

rpm -qa freetds
freetds-0.64-1.el6.rf.i686

[scottwilkerson]

Did you get pymssql installed?

Are you receiving the same error?

[Flava]

how do you authenticate as domain account? escaping doesn't seem to work...i tried domain\\username and it complains UNKNOWN: Invalid characters in the username

[scottwilkerson]

I believe you need to add single quotes like

Code: Select all

'Domain\\User'

[Flava]

Nope, no luck...but sql authentication work just fine; I dont want to create an account and permission it on hundred of servers when I have domain account for monitoring already.

[scottwilkerson]

Can I have you test the following from the command line

Code: Select all

cd /usr/local/nagios/libexec
./check_mssql_database.py -H 'IP_ADDRESS' -U 'Domain\\User' -P 'Password' -T 'master' -p 1433 --activetrans --warning 10 --critical 20

Replacing your IP_ADDRESS and Domain\\User and Password

And report results.

Thanks