check_mssql_database.py gives exceptions.TypeError

[sgargano]

No, it is 2008R2.

Code: Select all

[root@chlugmw1 libexec]# grep Version /usr/local/nagios/libexec/check_mssql_database.py
# Version    : 2.1.1

Same error with version 2.0.1 of the script.

Here is the result of the query:

Code: Select all

entity_name	subentity_name	permission_name
database		CONNECT
database		SELECT
database		EXECUTE 
entity_name	subentity_name	permission_name
server		CONNECT SQL
server		VIEW ANY DATABASE 

[ssax]

Does your user, password, table, or instance have any special characters in them? If so, please surround them in single quotes like so and try again:

Code: Select all

./check_mssql_database.py -H SERVERNAME -U 'USER' -P 'PASSWORD' -T TABLE -I INSTANCE --time2connect  --warning 1 --critical 2

[sgargano]

there are no special characters. In any case I tried to add the quotes but nothing changes.

[npolovenko]

@sgargano, Can you run the following commands and see if it fixes the issue?

yum install python-pip
pip install cython

Can you also check logs on the mssql server side to see what kind of errors show up when authentication fails?

[sgargano]

Hello,

it looks to be fixed now.

So to summarize:
-both warning and critical values should be declared (cannot miss one of this)
-the values must be between quotes if contains special characters
-installed cython

Thanks for your support

[scottwilkerson]

Hello,

it looks to be fixed now.

So to summarize:
-both warning and critical values should be declared (cannot miss one of this)
-the values must be between quotes if contains special characters
-installed cython

Thanks for your support

Great!



Locking thread