MSSQL Service Checks

[EWHMike]

I have successfully installed and configured NagiosXI on a RedHat 5.4 server. I am trying to get MSSQL service checks to work but it is complaining about missing components, php-freetds is installed but something else is not working correctly. The plug-in throws the following error:

UNKNOWN: MSSQL support is not installed on this server.

Using some google-fu there is a lot about recompiling PHP but I wanted the official info from Nagios. Please help as I wish to purchase XI but need to get this very important component working. Thanks in advance.


System Info:
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Linux nagios 2.6.18-164.11.1.el5 #1 SMP Wed Jan 6 13:26:04 EST 2010 x86_64 x86_64 x86_64 GNU/Linux

[root@nagios bin]# ./nagios -V
Nagios Core 3.2.0
Copyright (c) 2009 Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 08-12-2009
License: GPL

[root@nagios etc]# yum list installed | grep -i php
php.x86_64 5.1.6-24.el5_4.5 installed
php-cli.x86_64 5.1.6-24.el5_4.5 installed
php-common.x86_64 5.1.6-24.el5_4.5 installed
php-devel.x86_64 5.1.6-24.el5_4.5 installed
php-gd.x86_64 5.1.6-24.el5_4.5 installed
php-mysql.x86_64 5.1.6-24.el5_4.5 installed
php-odbc.x86_64 5.1.6-24.el5_4.5 installed
php-pdo.x86_64 5.1.6-24.el5_4.5 installed
php-pear.noarch 1:1.4.9-6.el5 installed
php-pgsql.x86_64 5.1.6-24.el5_4.5 installed
php-snmp.x86_64 5.1.6-24.el5_4.5 installed
[root@nagios /]# yum list all | grep -i freetds
freetds.x86_64 0.64-1.el5.rf installed
freetds-devel.x86_64 0.64-1.el5.rf installed

[mmestnik]

PHP?

All you should need is one of these:

Code: Select all

yum provides perl"(DBD::Sybase)"

and this http://exchange.nagios.org/directory/Pl ... th/details

[EWHMike]

PHP?

All you should need is one of these:

Code: Select all

yum provides perl"(DBD::Sybase)"

and this http://exchange.nagios.org/directory/Pl ... th/details

Thanks for the response, but NagiosXI has the built-in check_mssql service check that is written in PHP. I am not a fan of the perl version and prefer to use the checks that are included with XI to avoid issues in the future.

I haven't found any additional info on this yet. Thanks!

[tonyyarusso]

From the script (xi/subcomponents/extraplugins/plugins/check_mssql), I see the following dependencies statement:

# Requires:
# yphp_cli-5.2.5_1 *
# yphp_mssql-5.2.5_1 *
# freetds *

You have freetds and php-cli in your list, but I don't see php-mssql in your output, which I suspect is the problem. Additionally, the version number specified for php-cli is higher than that present on your system, which may be why you were finding stuff about recompiling PHP, although I'm not sure how critical the version actually is myself (not familiar enough with the script). (No, I don't know what the leading Ys are about either.)

Hopefully that helps point you in the right direction.

[EWHMike]

From the script (xi/subcomponents/extraplugins/plugins/check_mssql), I see the following dependencies statement:

# Requires:
# yphp_cli-5.2.5_1 *
# yphp_mssql-5.2.5_1 *
# freetds *

You have freetds and php-cli in your list, but I don't see php-mssql in your output, which I suspect is the problem. Additionally, the version number specified for php-cli is higher than that present on your system, which may be why you were finding stuff about recompiling PHP, although I'm not sure how critical the version actually is myself (not familiar enough with the script). (No, I don't know what the leading Ys are about either.)

Hopefully that helps point you in the right direction.

Yeah, I got that from the script too. The problem is that I cannot find a php_mysql package anywhere. The only info I found was to recompile PHP itself. I can't believe that this is the answer considering that I am expected to pay for NagiosXI and it can't even install itself or them provide working instructions. I called their support and they asked me to post this here, now it's 3 days later and no response from anyone at Nagios. I really want to buy the product and I really want to pay them for ongoing support but I think they should at least help to get the demo running.

[aessem]

hi,

try with google "rpmfind php-mssql", search for the rpm and match with your php version (output of php -v). no guarantee to work since the module is very sensitive even to minor version. i use this method to search for php-mssql and php-mcrypt module which not found on dag yum repo, but not tested it yet. rebuild php is the last resort

mik

[EWHMike]

hi,

try with google "rpmfind php-mssql", search for the rpm and match with your php version (output of php -v). no guarantee to work since the module is very sensitive even to minor version. i use this method to search for php-mssql and php-mcrypt module which not found on dag yum repo, but not tested it yet. rebuild php is the last resort

mik

I was hoping to avoid that but yes, it does work. Adding rpmfind to the google search turned up matching php-mssql package in EPEL. Thanks!

[aessem]

Cool, so the mssql check running Ok then?

[jamesconner]

PHP?

All you should need is one of these:

Code: Select all

yum provides perl"(DBD::Sybase)"

and this http://exchange.nagios.org/directory/Pl ... th/details

As a side note ... the 1-prereqs script for the manual installation uses the same syntax as the command above for its wildcard search for the Sybase plugin. Unfortunately, it doesn't work with the latest versions of yum. The script needs a tad bit of a touch up.

[root@bob xi]# yum provides perl"(DBD::Sybase)"
Loaded plugins: rhnplugin, security
Warning: 3.0.x versions of yum would erroneously match against filenames.
You can use "*/perl(DBD::Sybase)" and/or "*bin/perl(DBD::Sybase)" to get that behaviour

[root@bob xi]# uname -a
Linux bob 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

[root@bob xi]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)

[root@bob xi]# rpm -qa | grep yum
yum-updatesd-0.9-2.el5
yum-metadata-parser-1.1.2-3.el5
yum-utils-1.1.16-13.el5
yum-3.2.22-26.el5
yum-security-1.1.16-13.el5
yum-rhn-plugin-0.5.4-15.el5