Error message when check sql servers with Nagios Client Inst

[Kxfrancois]

I kept getting invalid syntax errors:

pip install --upgrade pip
Traceback (most recent call last):
File "/usr/bin/pip", line 7, in <module>
from pip._internal import main
File "/usr/lib/python2.6/site-packages/pip/_internal/__init__.py", line 40, in <module>
from pip._internal.cli.autocompletion import autocomplete
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/autocompletion.py", line 8, in <module>
from pip._internal.cli.main_parser import create_main_parser
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/main_parser.py", line 8, in <module>
from pip._internal.cli import cmdoptions
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/cmdoptions.py", line 75
binary_only = FormatControl(set(), {':all:'})
^
SyntaxError: invalid syntax
You have new mail in /var/spool/mail/root
[root@BURMON001 ~]# pip install urllib3[secure] --upgrade
Traceback (most recent call last):
File "/usr/bin/pip", line 7, in <module>
from pip._internal import main
File "/usr/lib/python2.6/site-packages/pip/_internal/__init__.py", line 40, in <module>
from pip._internal.cli.autocompletion import autocomplete
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/autocompletion.py", line 8, in <module>
from pip._internal.cli.main_parser import create_main_parser
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/main_parser.py", line 8, in <module>
from pip._internal.cli import cmdoptions
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/cmdoptions.py", line 75
binary_only = FormatControl(set(), {':all:'})
^
SyntaxError: invalid syntax
[root@BURMON001 ~]# pip install urllib3 --upgrade
Traceback (most recent call last):
File "/usr/bin/pip", line 7, in <module>
from pip._internal import main
File "/usr/lib/python2.6/site-packages/pip/_internal/__init__.py", line 40, in <module>
from pip._internal.cli.autocompletion import autocomplete
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/autocompletion.py", line 8, in <module>
from pip._internal.cli.main_parser import create_main_parser
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/main_parser.py", line 8, in <module>
from pip._internal.cli import cmdoptions
File "/usr/lib/python2.6/site-packages/pip/_internal/cli/cmdoptions.py", line 75
binary_only = FormatControl(set(), {':all:'})
^
SyntaxError: invalid syntax

[tgriep]

There seems to be an issue with upgrading pip that causes an incompatibility so I figured out an alternate way to get this done.
The yum remove python-pip will generate some errors but that seems to be OK but to fix the pip errors and install the pymssql module, run the following as root.

Code: Select all

yum remove python-pip
yum install python-pip -y
yum install python-devel -y
yum install freetds-devel -y
pip install pymssql==2.1.1

If the install of the pymssql module works, then test running the plugin with an AD username.

[Kxfrancois]

I received this error after running the last command:

[root@BURMON001 ~]# pip install pymssql==2.1.1
You are using pip version 7.1.0, however version 18.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Collecting pymssql==2.1.1
/usr/lib/python2.6/site-packages/pip/_vendor/requests/packages/urllib3/util/ssl_.py:90: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/late ... ormwarning.
InsecurePlatformWarning
Using cached https://files.pythonhosted.org/packages ... 1.1.tar.gz
Complete output from command python setup.py egg_info:
setup.py: platform.system() => 'Linux'
setup.py: platform.architecture() => ('64bit', 'ELF')
setup.py: platform.linux_distribution() => ('CentOS', '6.9', 'Final')
setup.py: platform.libc_ver() => ('glibc', '2.2.5')
setup.py: Not using bundled FreeTDS
setup.py: include_dirs = ['/usr/local/include']
setup.py: library_dirs = ['/usr/local/lib']
Couldn't find index page for 'setuptools_git' (maybe misspelled?)
No local packages or download links found for setuptools-git
Traceback (most recent call last):
File "<string>", line 20, in <module>
File "/tmp/pip-build-bOlyOk/pymssql/setup.py", line 450, in <module>
ext_modules = ext_modules(),
File "/usr/lib64/python2.6/distutils/core.py", line 113, in setup
_setup_distribution = dist = klass(attrs)
File "/usr/lib/python2.6/site-packages/setuptools/dist.py", line 221, in __init__
self.fetch_build_eggs(attrs.pop('setup_requires'))
File "/usr/lib/python2.6/site-packages/setuptools/dist.py", line 245, in fetch_build_eggs
parse_requirements(requires), installer=self.fetch_build_egg
File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 538, in resolve
dist = best[req.key] = env.best_match(req, self, installer)
File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 780, in best_match
return self.obtain(req, installer) # try and download/install
File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 792, in obtain
return installer(requirement)
File "/usr/lib/python2.6/site-packages/setuptools/dist.py", line 293, in fetch_build_egg
return cmd.easy_install(req)
File "/usr/lib/python2.6/site-packages/setuptools/command/easy_install.py", line 466, in easy_install
raise DistutilsError(msg)
distutils.errors.DistutilsError: Could not find suitable distribution for Requirement.parse('setuptools-git')

----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-bOlyOk/pymssql

[tgriep]

It looks like the python setuptools needs to be installed. Run this as root to install it.

Code: Select all

yum install python-setuptools

Then try the pip command again.

[Kxfrancois]

The install was successful and i was able to install 2.1.1 but now I get a new error message when testing:

18456, "Login failed for user 'SRV-Nagios-Monitor'.DB-Lib error message 18456, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n

[tgriep]

So, it went back to the original failure message.
Any chance you can use just a SQL login account?

[Kxfrancois]

That seemed to have worked for one server. Now I am getting other errors for some of the tests.

(No output on stdout) stderr: /bin/sh: -c: line 0: syntax error near unexpected token `)'

(20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n')

[tgriep]

Typically when you see this error is that there is a missing single quote or a double quote is missing. Check the command to verify that they are there.
Also, it there are and special characters in the username or password that would cause the error as well so they would have to be escaped.
This KB article can help on that.
https://support.nagios.com/kb/article/n ... s-580.html

[Kxfrancois]

That worked! Thank you so much!

[tgriep]

Your very welcome. Glad it helped.