NDOUtils and Mysql libraries assistance needed

[Natalie Aloi]

I change it but am still getting could not sink data error...

# DATABASE TABLE PREFIX
# Determines the prefix (if any) that should be prepended to table names.
#db_prefix=
db_prefix=ndo_

then I stopped ndo2db and restarted it, then restarted nagios
[root at nagios nagios]# ps -ef | grep ndo2db
root 601 1 0 13:04 ? 00:00:00 ndo2db -c /etc/nagios/ndo2db.cfg
root 11550 12431 0 16:01 pts/1 00:00:00 grep ndo2db
[root at nagios nagios]# kill 601
[root at nagios nagios]# ps -ef | grep ndo2db
root 13403 12431 0 16:07 pts/1 00:00:00 grep ndo2db
[root at nagios nagios]# cd /usr/sbin
[root at nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
[root at nagios sbin]# sudo service nagios restart
Running configuration check...done
Stopping nagios: .done.
Starting nagios: done.
[root at nagios sbin]# tail /var/log/nagios/nagios.log
[1245960534] Caught SIGTERM, shutting down...
[1245960534] Successfully shutdown... (PID=3070)
[1245960534] ndomod: Shutdown complete.
[1245960534] Event broker module '/usr/sbin/ndomod.o' deinitialized successfully.
[1245960535] Nagios 2.11 starting... (PID=14253)
[1245960535] LOG VERSION: 2.0
[1245960535] ndomod: NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (nagios at nagios.org)
[1245960535] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...
[1245960535] Event broker module '/usr/sbin/ndomod.o' initialized successfully.
[1245960535] Finished daemonizing... (New PID=14254)

-----Original Message-----
From: Michael Friedrich [mailto:michael.friedrich at univie.ac.at]
Sent: Thursday, June 25, 2009 02:18 PM
To: 'Natalie Aloi'
Cc: 'Nagios Users Mail-list'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed

Your database table scheme is with prefix "ndo_" so you have to set that in your ndo2db.cfg too

and make sure you start ndo2db first and then nagios.


Natalie Aloi wrote: woohoo! Thanks Michael!
[root at nagios src]# cp ndomod-2x.o /usr/sbin/ndomod.o
cp: overwrite `/usr/sbin/ndomod.o'? y
[root at nagios src]# cp ndo2db-2x /usr/sbin/ndo2db
[root at nagios src]# cd /usr/sbin
[root at nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
[root at nagios sbin]# ps -ef | grep ndo2db
root 601 1 0 13:04 ? 00:00:00 ndo2db -c /etc/nagios/ndo2db.cfg
root 617 12431 0 13:04 pts/1 00:00:00 grep ndo2db
[root at nagios sbin]#

Except!...shoot!...I am getting that dumb error but I have those lines verified - ndo2db.cfg and ndomod.cfg files included

[root at nagios nagios]# tail /var/log/nagios/nagios.log
[1245950692] Caught SIGTERM, shutting down...
[1245950692] Successfully shutdown... (PID=739)
[1245950692] ndomod: Shutdown complete.
[1245950692] Event broker module '/usr/sbin/ndomod.o' deinitialized successfully.
[1245950693] Nagios 2.11 starting... (PID=1813)
[1245950693] LOG VERSION: 2.0
[1245950693] ndomod: NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (nagios at nagios.org)
[1245950693] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...
[1245950693] Event broker module '/usr/sbin/ndomod.o' initialized successfully.
[1245950693] Finished daemonizing... (New PID=1814)

[root at nagios nagios]# more ndomod.cfg
#####################################################################
# NDOMOD CONFIG FILE
#
# Last Modified: 01-10-2006
#####################################################################

# INSTANCE NAME
# This option identifies the "name" associated with this particular
# instance of Nagios and is used to seperate data coming from multiple
# instances. Defaults to 'default' (without quotes).
instance_name=default

# OUTPUT TYPE
# This option determines what type of output sink the NDO NEB module
# should use for data output. Valid options include:
# file = standard text file
# tcpsocket = TCP socket
# unixsocket = UNIX domain socket (default)
#output_type=file
#output_type=tcpsocket
output_type=unixsocket

# OUTPUT
# This option determines the name and path of the file or UNIX domain
# socket to which output will be sent if the output type option specified
# above is "file" or "unixsocket", respectively. If the output type
# option is "tcpsocket", this option is used to specify the IP address
# of fully qualified domain name of the host that the module should
# connect to for sending output.
#output=/usr/local/nagios/var/ndo.dat
#output=127.0.0.1
output=/var/run/nagios/ndo.sock

[root at nagios nagios]# more ndo2db.cfg
#####################################################################
# NDO2DB DAEMON CONFIG FILE
#
# Last Modified: 02-12-2006
#####################################################################

# SOCKET TYPE
# This option determines what type of socket the daemon will create
# an accept connections from.
# Value:
# unix = Unix domain socket (default)
# tcp = TCP socket
socket_type=unix
#socket_type=tcp

# SOCKET NAME
# This option determines the name and path of the UNIX domain
# socket that the daemon will create and accept connections from.
# This option is only valid if the socket type specified above
# is "unix".
#socket_name=/usr/local/nagios/var/ndo.sock
socket_name=/var/run/nagios/ndo.sock

# TCP PORT
# This option determines what port the daemon will listen for
# connections on. This option is only vlaid if the socket type
# specified above is "tcp".
tcp_port=5668

# DATABASE SERVER TYPE
# This option determines what type of DB server the daemon should
# connect to.
# Values:
# mysql = MySQL
# pgsql = PostgreSQL
db_servertype=mysql

# DATABASE HOST
# This option specifies what host the DB server is running on.
db_host=localhost

# DATABASE PORT
# This option specifies the port that the DB server is running on.
# Values:
# 3306 = Default MySQL port
# 5432 = Default PostgreSQL port
db_port=3306

# DATABASE NAME
# This option specifies the name of the database that should be used.
db_name=nagios

# DATABASE TABLE PREFIX
# Determines the prefix (if any) that should be prepended to table names.
db_prefix=
#db_prefix=ndo_

# DATABASE USERNAME/PASSWORD
# This is the username/password that will be used to authenticate to the DB.
# The user needs at least SELECT, INSERT, UPDATE, and DELETE privileges on
# the database.
#db_user=ndouser
#db_pass=ndopassword
db_user=nagios
db_pass=nagios

## TABLE TRIMMING OPTIONS
# Several database tables containing Nagios event data can become quite large
# over time. Most admins will want to trim these tables and keep only a
# certain amount of data in them. The options below are used to specify the
# age (in MINUTES) that data should be allowd to remain in various tables
# before it is deleted. Using a value of zero (0) for any value means that
# that particular table should NOT be automatically trimmed.
# Keep timed events for 24 hours
max_timedevents_age=1440
# Keep system commands for 1 week
max_systemcommands_age=10080
# Keep service checks for 1 week
max_servicechecks_age=10080
# Keep host checks for 1 week
max_hostchecks_age=10080
# Keep event handlers for 31 days
max_eventhandlers_age=44640
[root at nagios nagios]#




-----Original Message-----
From: Michael Friedrich [mailto:michael.friedrich at univie.ac.at]
Sent: Thursday, June 25, 2009 12:39 PM
To: 'Natalie Aloi'
Cc: 'Nagios Users Mail-list'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed

uhm... you should copy the new compiled binary to your nagios/bin directory, but i don't think that will resolv the error anyways.

give us a plot of your ndo2db.cfg please.



Natalie Aloi wrote: I guess I'm a timid user..(not running make earlier)
So ran make - I didn't get any errors but it still says support for database servers not found does that mean I need to re-run for postgresql? 

[root at nagios ndoutils-1.3.1]# make
cd ./src/; make ; cd ..
make[1]: Entering directory `/tmp/ndoutils-1.3.1/src'
gcc -g -O2 -DHAVE_CONFIG_H -c -o io.o io.c
gcc -g -O2 -DHAVE_CONFIG_H -c -o utils.o utils.c
gcc -g -O2 -DHAVE_CONFIG_H -o file2sock file2sock.c io.o utils.o -lm -lnsl
gcc -g -O2 -DHAVE_CONFIG_H -o log2ndo log2ndo.c io.o utils.o -lm -lnsl
make ndo2db-2x
make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
gcc -g -O2 -DHAVE_CONFIG_H -c -o db.o db.c
gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -c -o dbhandlers-2x.o dbhandlers.c
gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -o ndo2db-2x ndo2db.c dbhandlers-2x.o io.o utils.o db.o -L/usr/lib/mysql -lnsl -lmysqlclient
make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
make ndo2db-3x
make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -c -o dbhandlers-3x.o dbhandlers.c
gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -o ndo2db-3x ndo2db.c dbhandlers-3x.o io.o utils.o db.o -L/usr/lib/mysql -lnsl -lmysqlclient
make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
make ndomod-2x.o
make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -o ndomod-2x.o ndomod.c io.o utils.o -shared -lnsl
make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
make ndomod-3x.o
make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -o ndomod-3x.o ndomod.c io.o utils.o -shared -lnsl
make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
gcc -g -O2 -DHAVE_CONFIG_H -o sockdebug sockdebug.c io.o utils.o -lm -lnsl
make[1]: Leaving directory `/tmp/ndoutils-1.3.1/src'
[root at nagios /]# cd /tmp/ndoutils-1.3.1

[root at nagios ndoutils-1.3.1]# ndo2db-2x -c /etc/nagios/ndo2db.cfg
Support for the specified database server is either not yet supported, or was not found on your system.
[root at nagios ndoutils-1.3.1]#

-----Original Message-----
From: Natalie Aloi [mailto:naloi at experisdatacenters.com]
Sent: Thursday, June 25, 2009 09:41 AM
To: 'Nagios Users Mail-list'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed

Ok...making progress...after rerunning the config the sql libraries were found but now I get about postgresql support....Do I need this? Or Can I just run make?
MySQL library and include file(s) were found!
checking for PQconnectdb in -lpq... no

*** PostgreSQL library could not be located... *********************
You chose to compile NDBXT with PostgreSQL support, but I was
unable to locate the PostgreSQL library on your system. If the
library is installed, use the --with-pgsql-lib argument to specify
the location of the PostgreSQL library.
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 PostgreSQL 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.
********************************************************************

checking libpq-fe.h usability... no
checking libpq-fe.h presence... no
checking for libpq-fe.h... no

*** PostgreSQL include file could not be located... ****************
You chose to compile NDBXT with PostgreSQL support, but I was unable
to locate <libpq-fe.h> on your system. If the include file is
installed, use the --with-pgsql-inc argument to specify the location
of the PostgreSQL include file.
********************************************************************

configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating include/config.h

*** ndoutils 1.3.1 02-15-2006 ***

Type 'make' to compile the NDO utilities.
[root at nagios ndoutils-1.3.1]#

-----Original Message-----
From: Natalie Aloi [mailto:naloi at experisdatacenters.com]
Sent: Thursday, June 25, 2009 09:29 AM
To: 'Nagios Users Mail-list'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed

So this is what's in ld.so.conf.d....do I just do steps 2-4 now since there is already a file that points to it - or do I need to rename mysql-i386.conf to mysql.conf?

[root at nagios ld.so.conf.d]# ls -lat
total 32
drwxr-xr-x 144 root root 12288 2009-06-23 04:06 ..
drwxr-xr-x 2 root root 4096 2009-04-28 16:01 .
-rw-r--r-- 1 root root 23 2009-04-27 08:31 xulrunner-32.conf
-rw-r--r-- 1 root root 15 2009-03-07 18:39 mysql-i386.conf
-rw-r--r-- 1 root root 16 2008-10-21 05:02 tix-i386.conf
-rw-r--r-- 1 root root 20 2008-07-07 15:49 qt-i386.conf
[root at nagios ld.so.conf.d]# more mysql-i386.conf
/usr/lib/mysql
[root at nagios ld.so.conf.d]#

-----Original Message-----
From: Guy Waugh [mailto:guidosh at gmail.com]
Sent: Thursday, June 25, 2009 09:07 AM
To: 'Natalie Aloi'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed

Hello,

On Thu, Jun 25, 2009 at 1:57 PM, Natalie Aloi <naloi at experisdatacenters.com> wrote:
Hi I am having trouble getting ndoutils to work 
during my install I found this information logged:

*** MySQL library could not be located... **************************
You chose to compile NDBXT 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.
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-lib=/usr/lib/mysql
I have a question about step 1. When I more the file all it has in it is this information:

[root at nagios etc]# more ld.so.conf
include ld.so.conf.d/*.conf

My question is what is the syntax of the libraries I have no idea what to add into this file.
Do I just add "/usr/lib/mysql" ?


The best thing to do would be to create a file in '/etc/ld.so.conf.d' called 'mysql.conf' that contains, as you suggest, one line thus: '/usr/lib/mysql' (without the quotes). Then, proceed with steps 2, 3 and 4 above.

Cheers,
Guy.


I am running Fedora 9
mysql has been installed (see below:)
[root at nagios etc]# rpm -qa | grep mysql
qt-mysql-4.5.0-14.fc9.i386
mysql-administrator-5.0r12-8.fc9.i386
mysql-server-5.0.77-1.fc9.i386
mysql-devel-5.0.77-1.fc9.i386
mysql-connector-odbc-3.51.24r1071-1.fc9.i386
mysql-connector-java-3.1.12-5.fc9.i386
php-mysql-5.2.6-2.fc9.i386
mysql-5.0.77-1.fc9.i386
libdbi-dbd-mysql-0.8.3-2.fc9.i386
mysql-libs-5.0.77-1.fc9.i386
nagios-plugins-mysql-1.4.13-9.fc9.i386
mysql-gui-common-5.0r12-8.fc9.i386
below is infor from mysql for nagios db for ndoutils....
mysql> use nagios
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-------------------------------------+
| Tables_in_nagios |
+-------------------------------------+
| ndo_acknowledgements |
| ndo_commands |
| ndo_commenthistory |
| ndo_comments |
| ndo_configfiles |
| ndo_configfilevariables |
| ndo_conninfo |
| ndo_contact_addresses |
| ndo_contact_notificationcommands |
| ndo_contactgroup_members |
| ndo_contactgroups |
| ndo_contactnotificationmethods |
| ndo_contactnotifications |
| ndo_contacts |
| ndo_customobjectvariables |
| ndo_downtimehistory |
| ndo_eventhandlers |
| ndo_externalcommands |
| ndo_flappinghistory |
| ndo_host_contactgroups |
| ndo_host_parenthosts |
| ndo_hostchecks |
| ndo_hostdependencies |
| ndo_hostescalation_contactgroups |
| ndo_hostescalations |
| ndo_hostextinfo |
| ndo_hostgroup_members |
| ndo_hostgroups |
| ndo_hosts |
| ndo_hoststatus |
| ndo_instances |
| ndo_logentries |
| ndo_notifications |
| ndo_objects |
| ndo_processevents |
| ndo_programstatus |
| ndo_runtimevariables |
| ndo_scheduleddowntime |
| ndo_service_contactgroups |
| ndo_servicechecks |
| ndo_servicedependencies |
| ndo_serviceescalation_contactgroups |
| ndo_serviceescalations |
| ndo_serviceextinfo |
| ndo_servicegroup_members |
| ndo_servicegroups |
| ndo_services |
| ndo_servicestatus |
| ndo_statehistory |
| ndo_systemcommands |
| ndo_timedeventqueue |
| ndo_timedevents |
| ndo_timeperiod_timeranges |
| ndo_timeperiods |
+-------------------------------------+
54 rows in set (0.00 sec)
mysql>

Network Operations Center Manager 
Experis Data Center LLC 
8209 Valley Pike 
PO Box 535 
Middletown,VA 22645 
phone:540-869-8702 
cell:240-988-3267 
fax:540-869-8710 
mailto:e-mail%3Analoi at experisdatacenters.com

------------------------------------------------------------------------------

_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null



------------------------------------------------------------
------------------------------------------------------------------------------ 
------------------------------------------------------------
_______________________________________________Nagios-users mailing listNagios-users at lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/nagios-users::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null

------------------------------------------------------------
------------------------------------------------------------------------------ 
------------------------------------------------------------
_______________________________________________Nagios-users mailing listNagios-users at lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/nagios-users::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090625/3990d029/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null