plugin check_mssql.pl linux RELH8

[igae1]

Hi!
We are migrating nagioxi from relh7 to relh8. We have compiled the check_mssql and check_mssql.pl plugin on the new server, when we run the plugin it gives us the following error: "UNKNOWN - Could not find tsql-executable". The executable does not exist on the server although the server has mssql-tools18 unixODBC-devel installed.
Do we need to install something else?

THANKS

[lgute]

Hi @igae1, thanks for reaching out.

We could use some more information in order to help you.

1. What version of XI are you running?
2. How are you compiling the plugins?

[igae1]

Dear Nagios Support Team,

Thank you for your prompt response.

Our NagiosXI version is 5.8.9

check_mssql.pl plugin

We attempted to install the check_mssql.pl plugin from the Nagios-plugins repository version 2.4.9 using the following commands:

Code: Select all

wget --no-check-certificate -O nagios-plugins.tar.gz https://github.com/nagios-plugins/nagios-plugins/archive/release-2.4.9.tar.gz
tar zxf nagios-plugins.tar.gz
cd /tmp/nagios-plugins-release-2.4.9/
./tools/setup
./configure

However, we encountered an issue where check_mssql.pl was not installed. We temporarily resolved this by copying it from our production server, though this may not be the best approach. The installation log (session.log) attached does not indicate any warnings related to this plugin.

We are now facing an error due to the missing tsql executable:

[nagios@samosw01 libexec]$ ./check_mssql.pl -H <Hostaddress> -p <port> -U <user> -P <password> -D <database> -Q <query>
UNKNOWN - Could not find tsql-executable.

After installing mssql-tools on RHEL 8, we noticed tsql was not included (only sqlcmd was installed). I am uncertain of the required dependencies to address this issue.

check_mssql plugin

I downloaded the check_mssql plugin from Nagios Exchange: https://exchange.nagios.org/directory/P ... ql/details but found limited installation information. I proceeded with installing the following dependencies:

Code: Select all

yum install php
yum install php-pdo

Despite this, we are encountering another error:

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

It appears both issues may be linked by a common dependency problem. Could you advise on the correct dependencies needed for these plugins to function properly on a RHEL 8 system?

Thank you for your assistance.

Best regards,

[harrisj5]

TSQL is part of FreeTDS, so you need to install FreedTDS

[igae1]

Thank you for your response.

Finally could install freetds from EPEL8 Repo and then check_mssql and check_mssql.pl dependencies were fulfilled.

Code: Select all

yum install freetds 
yum install freetds-devel