NDOUtils and Mysql libraries assistance needed

Michael Friedrich michael.friedrich at univie.ac.at
Thu Jun 25 20:18:13 CEST 2009


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 <mailto: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
>>                 <mailto: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
>>                     <mailto: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 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 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
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090625/60726684/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


More information about the Users mailing list