Nagios core comaptibilty with mysql 5.5 or mysql 5.1

[ravish78]

I need to build a new setup for nagios which monitors around 150 servers.I am trying to install nagios core version 3.
I have couple of questions.

1) Is nagios core compatible with My Sql 5.1 or MySql 5 5.
2) Which would be more easy to maintain infuture.

[scottwilkerson]

Core by itself doesn't use MySQL, but some of the common database connection packages do such as ndo2db

as far as I know there should be no issues running ndo2db on a MySQL 5.5 server.

[ravish78]

Thank you very much for your response.

We have successfully installed nagios core in two monitoring stations which are monitoring different set of servers.
Nagios monitoring is working absolutley fine

We have installed MySQL-server-5.5.21-1.rhel5 in both servers and when trying to install ndoutils we are getting this messages
----------------------------------------------------------------------------------------------------------------------------------
*** MySQL library could not be located... **************************

You chose to compile NDOutils with MySQL support, but I was unable to
locate the MySQL library on your system. If the library is
installed, use the --with-mysql-lib argument to specify the
location of the MySQL library.
installed, use the --with-mysql=DIR argument to specify the
location of the MySQL library, We assume mysql_config is in DIR/dir
NOTE: After you install the necessary libraries on your system:
1. Make sure /etc/ld.so.conf has an entry for the directory in
which the MySQL libraries are installed.
2. Run 'ldconfig' to update the run-time linker options.
3. Run 'make devclean' in the NDBXT distribution to clean out
any old references to your previous compile.
4. Rerun the configure script.

TIP: Try the following....
./configure --with-mysql=/usr/lib/mysql

********************************************************************


configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating docs/docbook/en-en/Makefile
config.status: creating subst
config.status: creating include/config.h
config.status: include/config.h is unchanged


*** Configuration summary for ndoutils 1.4b9 10-27-2009 ***:

General Options:
-------------------------
NDO2DB user: nagios
NDO2DB group: nagios
---------------------------------------------------------------------------------------------------------------------------------------
Can you please help on this?

Below is the output of ld.so.conf

[email protected]>more /etc/ld.so.conf
include ld.so.conf.d/*.conf

[mguthrie]

If you recompile ndoutils it should pick up the updated version of mysql.

[ravish78]

This is fresh installation and we did not upgrade mysql.We are still getting problem with ndoutils installs.

the below packages are present
$ rpm -qa | grep -i mysql
MySQL-devel-5.5.21-1.rhel5
MySQL-client-5.5.21-1.rhel5
MySQL-shared-5.5.21-1.rhel5
perl-DBD-MySQL-3.0007-2.el5
MySQL-server-5.5.21-1.rhel5
MySQL-shared-compat-5.5.21-1.rhel5
$

Not sure how to go ahead.Mysql seems to be running .
Any help is appreciated

[agriffin]

NDOUtils is linked against a non-existent version of MySQL. It needs to be recompiled. If you are using a package instead of a source install, you should be contacting the package maintainers instead.

[ravish78]

Thank u all for your response.We are able to succesfully install
Nagios Core 3.2.1
ndoutils-1.4b9

We had compatilbility issue with 1.5 and it did not work properly.1.4b9 is fine.

Now we are upgrading it to nagiox xi.

[agriffin]

Glad you got it working!