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
plugin check_mssql.pl linux RELH8
Re: plugin check_mssql.pl linux RELH8
Hi @igae1, thanks for reaching out.
We could use some more information in order to help you.
We could use some more information in order to help you.
- What version of XI are you running?
- How are you compiling the plugins?
Please let us know if you have any other questions or concerns.
-Laura
-Laura
Re: plugin check_mssql.pl linux RELH8
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:
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:
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:
Despite this, we are encountering another error:
Thank you for your assistance.
Best regards,
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
We are now facing an error due to the missing 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.[nagios@samosw01 libexec]$ ./check_mssql.pl -H <Hostaddress> -p <port> -U <user> -P <password> -D <database> -Q <query>
UNKNOWN - Could not find tsql-executable.
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
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?UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql.
Thank you for your assistance.
Best regards,
You do not have the required permissions to view the files attached to this post.
Re: plugin check_mssql.pl linux RELH8
TSQL is part of FreeTDS, so you need to install FreedTDS
Re: plugin check_mssql.pl linux RELH8
Thank you for your response.
Finally could install freetds from EPEL8 Repo and then check_mssql and check_mssql.pl dependencies were fulfilled.
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