Storing data from Nagios to MariaDB using ndoutils

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
youngek
Posts: 34
Joined: Tue Feb 14, 2017 2:46 pm

Storing data from Nagios to MariaDB using ndoutils

Post by youngek »

Getting the errors below on trying to install ndoutils 2.1.3. I run ./configure then I notice this error:

*** 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=DIR argument to specify the
location of the MySQL library, We assume mysql_config is in DIR/bin
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

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

I am running RHEL 7.5 with Mariadb. I have these packages installed
MariaDB-server-10.3.9-1.el7.centos.x86_64
MariaDB-common-10.3.9-1.el7.centos.x86_64
MariaDB-client-10.3.9-1.el7.centos.x86_64
MariaDB-devel-10.3.9-1.el7.centos.x86_64
MariaDB-compat-10.3.9-1.el7.centos.x86_64
Last edited by youngek on Mon Sep 10, 2018 2:53 pm, edited 2 times in total.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Storing data from Nagios to MariaDB using ndoutils

Post by ssax »

What OS/ver are you doing this on?

Did you follow the guide and install the prerequisites?

https://support.nagios.com/kb/article.php?id=406

Are you missing mysql-devel package?
youngek
Posts: 34
Joined: Tue Feb 14, 2017 2:46 pm

Re: Storing data from Nagios to MariaDB using ndoutils

Post by youngek »

RHEL 7.5. Yes I have followed the pre reqs. I had it installed and the socket file would not get created after start up so I removed it. And now I am trying to reinstall it.
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: Storing data from Nagios to MariaDB using ndoutils

Post by npolovenko »

@youngek, Please make sure that the strict trans table option is disabled in your MariaDB.
https://support.nagios.com/kb/article/n ... s-780.html

Then please run the configure script with the following option as suggested in the error log:
./configure --with-mysql=/usr/lib/mysql
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked