Nagios XI install often fails while installing the dependency pymssql.

As a part of our Server Management Services, we help our Customers to fix Nagios related errors regularly.

Let us today discuss the possible causes and fixes for this error.

Why does installing XI fails to install dependency pymssql?

Nagios XI install often fails with the error message as shown below :

--> Processing Dependency: pymssql for package: nagiosxi-deps-2012r2.9-1.noarch
--> Finished Dependency Resolution
Error: Package: nagiosxi-deps-2012r2.9-1.noarch (/nagiosxi-deps-2012r2.9-1.noarch)
Requires: pymssql
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
RESULT=1

===================
INSTALLATION ERROR!
===================
Installation step failed - exiting.
Check for error messages in the install log (install.log).

If you require assistance in resolving the issue, please include install.log
in your communications with Nagios XI technical support.

The script that failed was: './1-prereqs'

This message indicates that it failed to install the dependency pymssql. Normally, it happens because some of the original packages are not available through the standard repositories.

Thus, to resolve the problem, we need to add the Nagios Repository to the yum package manager.

Installing XI fails to install dependency pymssql – Solution

The steps to add the Nagios Repository defer for each operating system. For instance, let us look at the steps to install it on Centos and Ubuntu:

Installation of Nagios Repo in CentOS/RHEL

Version 6 (32 and 64 bit)
# rpm -Uvh https://repo.nagios.com/nagios/6/nagios-repo-6-4.el6.noarch.rpm
# yum update

Version 7 (64 bit)
# rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
# yum update

Version 8 (64 bit)

# rpm -Uvh https://repo.nagios.com/nagios/8/nagios-repo-8-1.el8.noarch.rpm
# yum update

Pre-requisites for Nagios XI

If we are installing it on CentOS 8 we will need to add the following:

# yum install epel-release -y
# yum config-manager --enable PowerTools

Similarly, if we are installing it on RHEL 8 we will need to add the following:

# yum install epel-release -y
# subscription-manager repos --enable codeready-builder-for-rhel-8-x86_64-rpms

Installation of Nagios XI

Now, we can install Nagios XI with the series of steps given below:

Install the Nagios XI package:
# yum install nagiosxi
Upgrading Nagios XI
# yum update nagiosxi
Installation of NCPA
# yum install ncpa

Installation of Nagios Repo in Ubuntu/Debian

To install Nagios Repo in Ubuntu/Debian, follow the series of steps given below:

First, add to the apt sources list

#apt-get install apt-transport-https
#echo "deb https://repo.nagios.com/deb/$(lsb_release -cs) /" > /etc/apt/sources.list.d/nagios.list

Now, add the public GPG key

#wget -qO - https://repo.nagios.com/GPG-KEY-NAGIOS-V2 | apt-key add -

Then, update the repositories

#apt-get update

Installation and Upgrade of NCPA

#apt-get install ncpa

Finally, after making these changes we will be able to re-run the fullinstall script to install Nagios XI.

[Need any further assistance in fixing Nagios errors?– We’re available 24*7]

Conclusion

In short, install of Nagios XI often fails to install dependency pymssql as some of the original packages are not available through the standard repositories. Today, we saw how our Support Engineers fix this error by adding the Nagios Repository to the package manager.