MSSQL services issue

[RIDS_I2MP]

Hi Team,

We are trying to configure MSSQL services on a DB server but we are getting below error:

(No output returned from plugin)

UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql on rpm systems or php-sybase on deb systems.


check_mssql_database 0.1.0 - Copyright 2020 Nagios Enterprises, LLC.
Portions Copyright others (see source code).

Usage: /usr/local/nagios/libexec/check_mssql_server.php <options>

usage = "usage: %prog --checktype type -H hostname -U username -P password --mode testname
-w warning -c critical [-i instancename] [--perftype type] [--custom 'args']
[-v

Our Nagios XI version is 5.7.1
I am attaching the profile of Nagios XI server here for your reference. Please help us on the same.

Thanks in advance!!

[RIDS_I2MP]

Hello Team,

Can someone please help me with this issue?
I tried checking everything I could but no luck.

Error:
UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql on rpm systems or php-sybase on deb systems.

As per the error message, I am providing some information here, please check.

[root@HO1-NAGIOSXI tmp]# rpm -qa | grep php*
php-devel-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
graphviz-2.40.1-39.el8.x86_64
php-pear-1.10.5-9.module_el8.1.0+209+03b9a8ff.noarch
php-pecl-ssh2-1.2-2.el8.x86_64
php-pdo-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-ldap-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
graphite2-1.3.10-10.el8.x86_64
python3-cryptography-2.3-2.el8.x86_64
php-cli-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-mysqlnd-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-json-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-snmp-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-common-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-gd-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-process-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
libmspack-0.7-0.1.alpha.el8.3.x86_64
php-fpm-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-mbstring-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-imap-7.2.11-1.el8.x86_64
php-pgsql-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
php-xml-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64
graphviz-gd-2.40.1-39.el8.x86_64
[root@HO1-NAGIOSXI tmp]#



[root@HO1-NAGIOSXI libexec]# pip3 install pymssql
WARNING: Running pip install with root privileges is generally not a good idea. Try `pip3 install --user` instead.
Requirement already satisfied: pymssql in /usr/local/lib64/python3.6/site-packages



[root@HO1-NAGIOSXI libexec]# ls -lrt check_mssql*
-rwxrwxr-x. 1 apache nagios 24835 Jun 14 13:43 check_mssql
-rwxrwxr-x. 1 apache nagios 131817 Jun 14 13:43 check_mssql_server.php
[root@HO1-NAGIOSXI libexec]# pwd
/usr/local/nagios/libexec
[root@HO1-NAGIOSXI libexec]#


Thanks for your help!!

[jbrunkow]

UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql on rpm systems or php-sybase on deb systems.

It appears that your system is asking you to install some dependencies for this.

It appears that you have used rpm on this system, so I am assuming that you have Red Hat, CentOS, or similar. Can you try running that pip command as sudo instead of as root? That is what the last error message was suggesting.

Code: Select all

sudo yum install php-pdo
sudo yum install php-mssql

[RIDS_I2MP]

Hello,

php-pdo-7.2.24-1.module_el8.2.0+313+b04d0a66.x86_64

php-pdo I installed.

But for php-mssql, I am unable to do it.

[root@HO1-NAGIOSXI tmp]# sudo yum install php-mssql
Last metadata expiration check: 0:31:53 ago on Wed 08 Jul 2020 08:23:56 AM +04.
No match for argument: php-mssql
Error: Unable to find a match: php-mssql
[root@HO1-NAGIOSXI tmp]#

Could you please provide a way to download php-mssql package.

[jbrunkow]

Actually, we believe you may have uncovered a bug related to CentOS/RHEL 8. Thank you for bringing this to our attention. We have notified our developers and they are working to resolve it, and we will deploy a fix as soon as we can.

[RIDS_I2MP]

Thanks for the update!!

Please update us as soon as you get a fix.

[jbrunkow]

Yes. I will reply to this thread once the fix is available.

[jbrunkow]

Hey there! Good news, I think the bug you ran into is fixed. I believe an upgrade to the latest version will resolve your issue.

Fixed python setup for Ubuntu 20 systems which have both Python 2 and Python 3 installed

Nagios XI change log

[RIDS_I2MP]

Hello,

We upgraded Nagios to 5.7.2, but still the issue persistes

[jbrunkow]

Oh no! It's possible that the upgrade failed for some reason. Can you show us your upgrade log if there is one present?

Code: Select all

/usr/local/nagiosxi/tmp/upgrade.log

You may also want to make sure that the old installation files are removed from the system.

Code: Select all

cd /tmp
rm -rf nagiosxi xi*.tar.gz
wget http://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz
tar xzf xi-latest.tar.gzcd nagiosxi./upgrade

It never hurts to send ( PM ) us a profile either! We can find lots of information about your system in there. You can download the profile by navigating to System Profile under System Config on the left pane > and clicking the Download Profile button on that page.