Nagios ndomod not loading

[naund]

It was all installed from ports.

Code: Select all

Grants for root@localhost
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*F20FBE41FF5FB12A8D503744FD633FD13E82D18F' WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

[abrist]

Just root? Try one more:

Code: Select all

echo "select * from information_schema.user_privileges;" | mysql -p<password>

[naund]

Here is the output.

Code: Select all

GRANTEE TABLE_CATALOG   PRIVILEGE_TYPE  IS_GRANTABLE
'root'@'localhost'      def     SELECT  YES
'root'@'localhost'      def     INSERT  YES
'root'@'localhost'      def     UPDATE  YES
'root'@'localhost'      def     DELETE  YES
'root'@'localhost'      def     CREATE  YES
'root'@'localhost'      def     DROP    YES
'root'@'localhost'      def     RELOAD  YES
'root'@'localhost'      def     SHUTDOWN        YES
'root'@'localhost'      def     PROCESS YES
'root'@'localhost'      def     FILE    YES
'root'@'localhost'      def     REFERENCES      YES
'root'@'localhost'      def     INDEX   YES
'root'@'localhost'      def     ALTER   YES
'root'@'localhost'      def     SHOW DATABASES  YES
'root'@'localhost'      def     SUPER   YES
'root'@'localhost'      def     CREATE TEMPORARY TABLES YES
'root'@'localhost'      def     LOCK TABLES     YES
'root'@'localhost'      def     EXECUTE YES
'root'@'localhost'      def     REPLICATION SLAVE       YES
'root'@'localhost'      def     REPLICATION CLIENT      YES
'root'@'localhost'      def     CREATE VIEW     YES
'root'@'localhost'      def     SHOW VIEW       YES
'root'@'localhost'      def     CREATE ROUTINE  YES
'root'@'localhost'      def     ALTER ROUTINE   YES
'root'@'localhost'      def     CREATE USER     YES
'root'@'localhost'      def     EVENT   YES
'root'@'localhost'      def     TRIGGER YES
'root'@'localhost'      def     CREATE TABLESPACE       YES
'root'@'enthqdciptmon1a'        def     SELECT  YES
'root'@'enthqdciptmon1a'        def     INSERT  YES
'root'@'enthqdciptmon1a'        def     UPDATE  YES
'root'@'enthqdciptmon1a'        def     DELETE  YES
'root'@'enthqdciptmon1a'        def     CREATE  YES
'root'@'enthqdciptmon1a'        def     DROP    YES
'root'@'enthqdciptmon1a'        def     RELOAD  YES
'root'@'enthqdciptmon1a'        def     SHUTDOWN        YES
'root'@'enthqdciptmon1a'        def     PROCESS YES
'root'@'enthqdciptmon1a'        def     FILE    YES
'root'@'enthqdciptmon1a'        def     REFERENCES      YES
'root'@'enthqdciptmon1a'        def     INDEX   YES
'root'@'enthqdciptmon1a'        def     ALTER   YES
'root'@'enthqdciptmon1a'        def     SHOW DATABASES  YES
'root'@'enthqdciptmon1a'        def     SUPER   YES
'root'@'enthqdciptmon1a'        def     CREATE TEMPORARY TABLES YES
'root'@'enthqdciptmon1a'        def     LOCK TABLES     YES
'root'@'enthqdciptmon1a'        def     EXECUTE YES
'root'@'enthqdciptmon1a'        def     REPLICATION SLAVE       YES
'root'@'enthqdciptmon1a'        def     REPLICATION CLIENT      YES
'root'@'enthqdciptmon1a'        def     CREATE VIEW     YES
'root'@'enthqdciptmon1a'        def     SHOW VIEW       YES
'root'@'enthqdciptmon1a'        def     CREATE ROUTINE  YES
'root'@'enthqdciptmon1a'        def     ALTER ROUTINE   YES
'root'@'enthqdciptmon1a'        def     CREATE USER     YES
'root'@'enthqdciptmon1a'        def     EVENT   YES
'root'@'enthqdciptmon1a'        def     TRIGGER YES
'root'@'enthqdciptmon1a'        def     CREATE TABLESPACE       YES
'root'@'127.0.0.1'      def     SELECT  YES
'root'@'127.0.0.1'      def     INSERT  YES
'root'@'127.0.0.1'      def     UPDATE  YES
'root'@'127.0.0.1'      def     DELETE  YES
'root'@'127.0.0.1'      def     CREATE  YES
'root'@'127.0.0.1'      def     DROP    YES
'root'@'127.0.0.1'      def     RELOAD  YES
'root'@'127.0.0.1'      def     SHUTDOWN        YES
'root'@'127.0.0.1'      def     PROCESS YES
'root'@'127.0.0.1'      def     FILE    YES
'root'@'127.0.0.1'      def     REFERENCES      YES
'root'@'127.0.0.1'      def     INDEX   YES
'root'@'127.0.0.1'      def     ALTER   YES
'root'@'127.0.0.1'      def     SHOW DATABASES  YES
'root'@'127.0.0.1'      def     SUPER   YES
'root'@'127.0.0.1'      def     CREATE TEMPORARY TABLES YES
'root'@'127.0.0.1'      def     LOCK TABLES     YES
'root'@'127.0.0.1'      def     EXECUTE YES
'root'@'127.0.0.1'      def     REPLICATION SLAVE       YES
'root'@'127.0.0.1'      def     REPLICATION CLIENT      YES
'root'@'127.0.0.1'      def     CREATE VIEW     YES
'root'@'127.0.0.1'      def     SHOW VIEW       YES
'root'@'127.0.0.1'      def     CREATE ROUTINE  YES
'root'@'127.0.0.1'      def     ALTER ROUTINE   YES
'root'@'127.0.0.1'      def     CREATE USER     YES
'root'@'127.0.0.1'      def     EVENT   YES
'root'@'127.0.0.1'      def     TRIGGER YES
'root'@'127.0.0.1'      def     CREATE TABLESPACE       YES
'root'@'::1'    def     SELECT  YES
'root'@'::1'    def     INSERT  YES
'root'@'::1'    def     UPDATE  YES
'root'@'::1'    def     DELETE  YES
'root'@'::1'    def     CREATE  YES
'root'@'::1'    def     DROP    YES
'root'@'::1'    def     RELOAD  YES
'root'@'::1'    def     SHUTDOWN        YES
'root'@'::1'    def     PROCESS YES
'root'@'::1'    def     FILE    YES
'root'@'::1'    def     REFERENCES      YES
'root'@'::1'    def     INDEX   YES
'root'@'::1'    def     ALTER   YES
'root'@'::1'    def     SHOW DATABASES  YES
'root'@'::1'    def     SUPER   YES
'root'@'::1'    def     CREATE TEMPORARY TABLES YES
'root'@'::1'    def     LOCK TABLES     YES
'root'@'::1'    def     EXECUTE YES
'root'@'::1'    def     REPLICATION SLAVE       YES
'root'@'::1'    def     REPLICATION CLIENT      YES
'root'@'::1'    def     CREATE VIEW     YES
'root'@'::1'    def     SHOW VIEW       YES
'root'@'::1'    def     CREATE ROUTINE  YES
'root'@'::1'    def     ALTER ROUTINE   YES
'root'@'::1'    def     CREATE USER     YES
'root'@'::1'    def     EVENT   YES
'root'@'::1'    def     TRIGGER YES
'root'@'::1'    def     CREATE TABLESPACE       YES
'nconf'@'localhost'     def     USAGE   NO
'cacti'@'localhost'     def     USAGE   NO
''@'localhost'  def     USAGE   NO
''@'enthqdciptmon1a'    def     USAGE   NO

[abrist]

Well, I think the db is the wrong tree as your permissions look ok - Lets check the ndo configs. Can you post the contents of:

Code: Select all

/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagios/etc/ndomod.cfg

[naund]

Here they are.

Code: Select all

#####################################################################
# NDO2DB DAEMON CONFIG FILE
#
# Last Modified: 01-02-2009
#####################################################################



# LOCK FILE
# This is the lockfile that NDO2DB will use to store its PID number
# in when it is running in daemon mode.

lock_file=/var/spool/nagios/ndo2db.lock



# USER/GROUP PRIVILIGES
# These options determine the user/group that the daemon should run as.
# You can specify a number (uid/gid) or a name for either option.

ndo2db_user=nagios
ndo2db_group=nagios



# 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=/var/spool/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.
# If you modify the table prefix, you'll need to modify the SQL script for
# creating the database!

db_prefix=nagios_



# 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=root
db_pass=********



## 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





# DEBUG LEVEL
# This option determines how much (if any) debugging information will
# be written to the debug file.  OR values together to log multiple
# types of information.
# Values: -1 = Everything
#          0 = Nothing
#          1 = Process info
#          2 = SQL queries

debug_level=-1



# DEBUG VERBOSITY
# This option determines how verbose the debug log out will be.
# Values: 0 = Brief output
#         1 = More detailed
#         2 = Very detailed

debug_verbosity=2



# DEBUG FILE
# This option determines where the daemon should write debugging information.

debug_file=/var/spool/nagios/ndo2db.debug



# MAX DEBUG FILE SIZE
# This option determines the maximum size (in bytes) of the debug file.  If
# the file grows larger than this size, it will be renamed with a .old
# extension.  If a file already exists with a .old extension it will
# automatically be deleted.  This helps ensure your disk space usage doesn't
# get out of control when debugging.

max_debug_file_size=1000000

Code: Select all

#####################################################################
# NDOMOD CONFIG FILE
#
# Last Modified: 09-05-2007
#####################################################################


# 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=/var/spool/nagios/ndo.dat
#output=127.0.0.1
output=/var/spool/nagios/ndo.sock
#output=/var/run/ndo.sock


# TCP PORT
# This option determines what port the module will connect to in
# order to send output.  This option is only vlaid if the output type
# option specified above is "tcpsocket".

tcp_port=5668



# OUTPUT BUFFER
# This option determines the size of the output buffer, which will help
# prevent data from getting lost if there is a temporary disconnect from
# the data sink.  The number of items specified here is the number of
# lines (each of variable size) of output that will be buffered.

output_buffer_items=5000



# BUFFER FILE
# This option is used to specify a file which will be used to store the
# contents of buffered data which could not be sent to the NDO2DB daemon
# before Nagios shuts down.  Prior to shutting down, the NDO NEB module
# will write all buffered data to this file for later processing.  When
# Nagios (re)starts, the NDO NEB module will read the contents of this
# file and send it to the NDO2DB daemon for processing.

buffer_file=/var/spool/nagios/ndomod.tmp



# FILE ROTATION INTERVAL
# This option determines how often (in seconds) the output file is
# rotated by Nagios.  File rotation is handled by Nagios by executing
# the command defined by the file_rotation_command option.  This
# option has no effect if the output_type option is a socket.

file_rotation_interval=14400



# FILE ROTATION COMMAND
# This option specified the command (as defined in Nagios) that is
# used to rotate the output file at the interval specified by the
# file_rotation_interval option.  This option has no effect if the
# output_type option is a socket.
#
# See the file 'misccommands.cfg' for an example command definition
# that you can use to rotate the log file.

#file_rotation_command=rotate_ndo_log



# FILE ROTATION TIMEOUT
# This option specified the maximum number of seconds that the file
# rotation command should be allowed to run before being prematurely
# terminated.

file_rotation_timeout=60



# RECONNECT INTERVAL
# This option determines how often (in seconds) that the NDO NEB
# module will attempt to re-connect to the output file or socket if
# a connection to it is lost.

reconnect_interval=15



# RECONNECT WARNING INTERVAL
# This option determines how often (in seconds) a warning message will
# be logged to the Nagios log file if a connection to the output file
# or socket cannot be re-established.

reconnect_warning_interval=15
#reconnect_warning_interval=900



# DATA PROCESSING OPTION
# This option determines what data the NDO NEB module will process.
# Do not mess with this option unless you know what you're doing!!!!
# Read the source code (include/ndbxtmod.h) to determine what values
# to use here.  Values from source code should be OR'ed to get the
# value to use here.  A value of -1 will cause all data to be processed.
# Read the source code (include/ndomod.h) and look for "NDOMOD_PROCESS_"
# to determine what values to use here.  Values from source code should
# be OR'ed to get the value to use here.  A value of -1 will cause all
# data to be processed.

data_processing_options=-1



# CONFIG OUTPUT OPTION
# This option determines what types of configuration data the NDO
# NEB module will dump from Nagios.  Values can be OR'ed together.
# Values:
#         0 = Don't dump any configuration information
#         1 = Dump only original config (from config files)
#         2 = Dump config only after retained information has been restored
#         3 = Dump both original and retained configuration

config_output_options=2

[sreinhardt]

Are you seeing any entries in /var/spool/nagios/ndo2db.debug?

[naund]

File is completely empty.

[sreinhardt]

Are you seeing anything related to ndo in the nagios log?

Code: Select all

grep -Ri 'ndo' /usr/local/nagios/var/nagios.log

[naund]

That returns nothing at all.

[sreinhardt]

My mistake, it looks like your log file is in an odd place. Try:

Code: Select all

grep -Ri 'ndo' /var/spool/nagios/nagios.log