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!
[r...@nagios src]# cp ndomod-2x.o /usr/sbin/ndomod.o
cp: overwrite `/usr/sbin/ndomod.o'? y
[r...@nagios src]# cp ndo2db-2x /usr/sbin/ndo2db
[r...@nagios src]# cd /usr/sbin
[r...@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
[r...@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
[r...@nagios sbin]#
Except!...shoot!...I am getting that dumb error but I have those lines verified - ndo2db.cfg and ndomod.cfg files included [r...@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 (nag...@nagios.org <mailto:nag...@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)
[r...@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
[r...@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
[r...@nagios nagios]#



    -----Original Message-----
    *From:* Michael Friedrich [mailto:michael.friedr...@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?
[r...@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'
    [r...@nagios /]# cd /tmp/ndoutils-1.3.1
    [r...@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.
    [r...@nagios ndoutils-1.3.1]#

        -----Original Message-----
        *From:* Natalie Aloi [mailto:na...@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.
        [r...@nagios ndoutils-1.3.1]#

            -----Original Message-----
            *From:* Natalie Aloi [mailto:na...@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?
[r...@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
            [r...@nagios ld.so.conf.d]# more mysql-i386.conf
            /usr/lib/mysql
            [r...@nagios ld.so.conf.d]#

                -----Original Message-----
                *From:* Guy Waugh [mailto:guid...@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
                <na...@experisdatacenters.com
                <mailto:na...@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:
[r...@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:)
                    [r...@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%3ana...@experisdatacenters.com

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

                    _______________________________________________
                    Nagios-users mailing list
                    Nagios-users@lists.sourceforge.net
                    <mailto:Nagios-users@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@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@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@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

Reply via email to