Nagios with NDOUtils

[ffrcaraballo]

I have nagios running with ndo2db, but I can not insert data from nagios.
It does not show me error, I check the logs but I can not find information to see what the reason is.
In the logs of nagios does not show anything of ndo2db:

root@lsmnagios:/home/fernando# tail /usr/local/nagios/var/nagios.log
[1480607558] Warning: Host 'Sw_VdelParque_BoleteriaASC' has no default contacts or contactgroups defined!
[1480607558] Warning: Host 'Sw_VdelParque_BoleteriaDSC' has no default contacts or contactgroups defined!
[1480607558] Warning: Host 'Sw_WCMorris_BoleteriaDSC' has no default contacts or contactgroups defined!
[1480607558] Successfully launched command file worker with pid 21365
[1480607558] TIMEPERIOD TRANSITION: 24X7;-1;1
[1480607558] TIMEPERIOD TRANSITION: 24x7;-1;1
[1480607558] TIMEPERIOD TRANSITION: 24x7_sans_holidays;-1;1
[1480607558] TIMEPERIOD TRANSITION: none;-1;0
[1480607558] TIMEPERIOD TRANSITION: us-holidays;-1;0
[1480607558] TIMEPERIOD TRANSITION: workhours;-1;1
root@lsmnagios:/home/fernando# grep ndo /usr/local/nagios/var/nagios.log
root@lsmnagios:/home/fernando#

Services are running:

root@lsmnagios:/home/fernando# service ndo2db status
● ndo2db.service - Nagios Data Out Daemon
Loaded: loaded (/lib/systemd/system/ndo2db.service; disabled)
Active: active (running) since jue 2016-12-01 12:50:51 ART; 1min 49s ago
Docs: http://www.nagios.org/documentation
Process: 7681 ExecStopPost=/bin/rm -f /usr/local/nagios/var/ndo2db.pid (code=exited, status=0/SUCCESS)
Main PID: 21133 (ndo2db)
CGroup: /system.slice/ndo2db.service
└─21133 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f

dic 01 12:50:51 lsmnagios systemd[1]: Started Nagios Data Out Daemon.

root@lsmnagios:/home/fernando# service nagios status
● nagios.service - LSB: nagios host/service/network monitoring and management system
Loaded: loaded (/etc/init.d/nagios)
Active: active (running) since jue 2016-12-01 12:52:38 ART; 9min ago
Process: 21282 ExecStop=/etc/init.d/nagios stop (code=exited, status=0/SUCCESS)
Process: 21312 ExecStart=/etc/init.d/nagios start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/nagios.service
├─21341 /usr/local/nagios/bin/nagios -d /etc/nagios/nagios.cfg
├─21342 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
├─21343 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
├─21345 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
├─21346 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
├─21347 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
├─21348 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
└─21365 /usr/local/nagios/bin/nagios -d /etc/nagios/nagios.cfg

dic 01 12:52:38 lsmnagios nagios[21341]: Warning: Host 'Sw_VdelParque_BoleteriaASC' has no default contacts or contactgroups defined!
dic 01 12:52:38 lsmnagios nagios[21341]: Warning: Host 'Sw_VdelParque_BoleteriaDSC' has no default contacts or contactgroups defined!
dic 01 12:52:38 lsmnagios nagios[21341]: Warning: Host 'Sw_WCMorris_BoleteriaDSC' has no default contacts or contactgroups defined!
dic 01 12:52:38 lsmnagios nagios[21341]: Successfully launched command file worker with pid 21365
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: 24X7;-1;1
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: 24x7;-1;1
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: 24x7_sans_holidays;-1;1
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: none;-1;0
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: us-holidays;-1;0
dic 01 12:52:38 lsmnagios nagios[21341]: TIMEPERIOD TRANSITION: workhours;-1;1
root@lsmnagios:/home/fernando#

Does anyone have advice where I can search to fix it?

Thank you very much and greetings

[tgriep]

Make sure the broker_module line is in your nagios.cfg file. If that is not there, Nagios will not write the data to SQL. An example of what is should look like is below.

Code: Select all

broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

Other than that, we would have to see the ndomod.cfg and the ndo2db.cfg files to see their settings.

[ffrcaraballo]

I already had that in the nagios.cfg

Code: Select all

#loadctl_options=jobs_max=100;backoff_limit=10;rampup_change=5
# Load Livestatus Module
#broker_module=/usr/lib/check_mk/livestatus.o /var/log/nagios/rw/live
#event_broker_options=-1
# added by setup.sh of check_mk
cfg_dir=/usr/local/nagios/etc/check_mk.d
# Load Livestatus Module
#broker_module=/usr/lib/check_mk/livestatus.o /var/log/nagios/rw/live
# added by setup.sh of check_mk
cfg_dir=/etc/nagios/check_mk.d

#NDOUtils Broker Module
event_broker_options=-1
broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg

#Conf. ndomod.cfg

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



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

tcp_port=5668



# ENCRYPTION
# This option determines if the module will use SSL to encrypt the
# network traffic between module and ndo2db daemon.
# Both sides have to enable this feature which depends on SSL Libraries
# like openssl or kerberos
# This option is only valid if the output type
# option specified above is "tcpsocket".
#
# A value of '1' will enable this feature

use_ssl=0



# 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=/usr/local/nagios/var/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 OPTIONS
# These options determine what data the NDO NEB Module will process
#
acknowledgement_data=1
adaptive_contact_data=1
adaptive_host_data=1
adaptive_program_data=1
adaptive_service_data=1
aggregated_status_data=1
comment_data=1
contact_status_data=1
downtime_data=1
event_handler_data=1
external_command_data=1
flapping_data=1
host_check_data=1
host_status_data=1
log_data=1
main_config_data=1
notification_data=1
object_config_data=1
process_data=1
program_status_data=1
retention_data=1
service_check_data=1
service_status_data=1
state_change_data=1
system_command_data=1
timed_event_data=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

#Conf ndo2db.cfg

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=/usr/local/nagios/var/ndo2db.pid



# 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=/usr/local/nagios/var/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



# ENCRYPTION
# This option determines if the ndo2db daemon will accept SSL to encrypt the
# network traffic between module and ndo2db daemon.
# Both sides have to enable this feature which depends on SSL Libraries
# like openssl or kerberos
# This option is only valid if the output type
# option specified above is "tcpsocket".
#
# A value of '1' will enable this feature

use_ssl=0



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

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

db_port=3306



# DATABASE SOCKET
# This option specifies the path to the socket to use for local DB connections.
#
# MySQL's default location is /tmp/mysql.sock, but /var/lib/mysql/mysql.sock
# is common for RPM distributions, and /var/run/mysqld/mysqld.sock is seen on
# Ubuntu...
#
# You normally do not need to set this option unless you experience connection
# problems with messages in NDO2DB's log like:
#   "Can't connect to local MySQL server through socket ..."

#db_socket=/var/lib/mysql/mysql.sock



# 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=ndoutils
db_pass=SanMartin2o16



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

# Keep external commands for 31 days
max_externalcommands_age=44640

# Keep notifications for 31 days
max_notifications_age=44640

# Keep contactnotifications for 31 days
max_contactnotifications_age=44640

# Keep contactnotificationmethods for 31 days
max_contactnotificationmethods_age=44640

# Keep logentries for 90 days
max_logentries_age=129600

# Keep acknowledgements for 31 days
max_acknowledgements_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=0



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



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

debug_file=/usr/local/nagios/var/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

Regards

[tgriep]

Edit your ndo2db.cfg file and enable the debug level so you can see if there are any errors on the debug file.
Edit the ndo2db.cfg file and change the following from

Code: Select all

debug_level=0

to

Code: Select all

debug_level=-1

Save and restart ndo by running

Code: Select all

service ndo2db restart

Then look in the following file for any errors.
/usr/local/nagios/var/ndo2db.debug

If you get it working, just put that settings back to 0

[ffrcaraballo]

Enable debug but file is empty, write nothing
The tables in the database are not filled either

drwxrwsr-x 2 nagios nagios 4096 dic 1 23:59 archives
-rw-r--r-- 1 nagios nagios 15825 dic 2 05:46 livestatus.log
-rw-r--r-- 1 nagios nagios 5 dic 2 05:46 nagios.lock
-rw-r--r-- 1 nagios nagios 19181 dic 2 05:46 nagios.log
-rw-r--r-- 1 nagios nagios 0 dic 2 05:39 ndo2db.debug
-rw-r--r-- 1 nagios nagios 5 dic 2 05:47 ndo2db.pid
srwxr-xr-x 1 nagios nagios 0 dic 2 05:47 ndo.sock
-rw-r--r-- 1 nagios nagios 99130 dic 2 05:46 objects.cache
-rw-r--r-- 1 nagios nagios 12655 nov 1 08:40 objects.precache
-rw------- 1 nagios nagios 151828 dic 2 05:46 retention.dat
drwxrwsr-x 2 nagios nagcmd 4096 dic 2 05:46 rw
drwxr-sr-x 3 root nagios 4096 oct 31 08:11 spool
-rw-rw-r-- 1 nagios nagios 151687 dic 2 06:26 status.dat

[tgriep]

Can you login as root to the Nagios server, run the following and post the output here?

Code: Select all

ps -ef --cols=300
echo 'show tables;' | mysql  -t -u ndoutils -pSanMartin2o16 nagios

[ffrcaraballo]

root@lsmnagios:~# ps -ef --cols=300

Code: Select all

UID        PID  PPID  C STIME TTY          TIME CMD
root         1     0  0 oct28 ?        00:00:28 /sbin/init
root         2     0  0 oct28 ?        00:00:00 [kthreadd]
root         3     2  0 oct28 ?        04:46:27 [ksoftirqd/0]
root         5     2  0 oct28 ?        00:00:00 [kworker/0:0H]
root         7     2  0 oct28 ?        04:29:07 [rcu_sched]
root         8     2  0 oct28 ?        00:00:00 [rcu_bh]
root         9     2  0 oct28 ?        00:00:02 [migration/0]
root        10     2  0 oct28 ?        00:01:19 [watchdog/0]
root        11     2  0 oct28 ?        00:00:44 [watchdog/1]
root        12     2  0 oct28 ?        00:00:02 [migration/1]
root        13     2  0 oct28 ?        03:43:53 [ksoftirqd/1]
root        15     2  0 oct28 ?        00:00:00 [kworker/1:0H]
root        16     2  0 oct28 ?        00:00:47 [watchdog/2]
root        17     2  0 oct28 ?        00:00:09 [migration/2]
root        18     2  0 oct28 ?        04:02:03 [ksoftirqd/2]
root        20     2  0 oct28 ?        00:00:00 [kworker/2:0H]
root        21     2  0 oct28 ?        00:00:34 [watchdog/3]
root        22     2  0 oct28 ?        00:00:09 [migration/3]
root        23     2  0 oct28 ?        04:40:48 [ksoftirqd/3]
root        25     2  0 oct28 ?        00:00:00 [kworker/3:0H]
root        26     2  0 oct28 ?        00:00:00 [khelper]
root        27     2  0 oct28 ?        00:00:00 [kdevtmpfs]
root        28     2  0 oct28 ?        00:00:00 [netns]
root        29     2  0 oct28 ?        00:00:01 [khungtaskd]
root        30     2  0 oct28 ?        00:00:00 [writeback]
root        31     2  0 oct28 ?        00:00:00 [ksmd]
root        32     2  0 oct28 ?        00:00:00 [khugepaged]
root        33     2  0 oct28 ?        00:00:00 [crypto]
root        34     2  0 oct28 ?        00:00:00 [kintegrityd]
root        35     2  0 oct28 ?        00:00:00 [bioset]
root        36     2  0 oct28 ?        00:00:00 [kblockd]
root        41     2  0 oct28 ?        00:00:00 [kswapd0]
root        42     2  0 oct28 ?        00:00:00 [vmstat]
root        43     2  0 oct28 ?        00:00:00 [fsnotify_mark]
root        49     2  0 oct28 ?        00:00:00 [kthrotld]
root        50     2  0 oct28 ?        00:00:00 [ipv6_addrconf]
root        52     2  0 oct28 ?        00:00:00 [deferwq]
root        92     2  0 oct28 ?        00:00:00 [acpi_thermal_pm]
root        93     2  0 oct28 ?        00:00:00 [cciss_scan]
root        94     2  0 oct28 ?        00:00:00 [khubd]
root        95     2  0 oct28 ?        00:00:00 [kpsmoused]
root        96     2  0 oct28 ?        00:00:00 [ata_sff]
root        97     2  0 oct28 ?        00:00:00 [scsi_eh_0]
root        98     2  0 oct28 ?        00:00:00 [scsi_tmf_0]
root        99     2  0 oct28 ?        00:00:00 [scsi_eh_1]
root       100     2  0 oct28 ?        00:00:00 [scsi_tmf_1]
root       105     2  0 oct28 ?        00:00:00 [scsi_eh_2]
root       106     2  0 oct28 ?        00:00:00 [scsi_tmf_2]
root       109     2  0 oct28 ?        00:06:03 [kworker/0:1H]
root       110     2  0 oct28 ?        00:04:39 [kworker/2:1H]
root       111     2  0 oct28 ?        00:05:59 [kworker/1:1H]
root       113     2  0 oct28 ?        00:05:00 [kworker/3:1H]
root       138     2  0 oct28 ?        00:03:42 [jbd2/cciss!c0d0]
root       139     2  0 oct28 ?        00:00:00 [ext4-rsv-conver]
root       169     2  0 oct28 ?        00:00:00 [kauditd]
root       177     1  0 oct28 ?        00:00:00 /lib/systemd/systemd-udevd
root       179     1  0 oct28 ?        00:04:13 /lib/systemd/systemd-journald
root       218     2  0 oct28 ?        00:00:00 [edac-poller]
root       229     2  0 oct28 ?        00:00:00 [ttm_swap]
root       240     2  0 oct28 ?        00:00:00 [radeon-crtc]
root       266     2  0 oct28 ?        00:00:00 [jbd2/cciss!c0d0]
root       267     2  0 oct28 ?        00:00:00 [ext4-rsv-conver]
root       431     1  0 oct28 ?        00:00:02 /sbin/rpcbind -w
statd      440     1  0 oct28 ?        00:00:00 /sbin/rpc.statd
root       445     2  0 oct28 ?        00:00:00 [rpciod]
root       447     2  0 oct28 ?        00:00:00 [nfsiod]
root       454     1  0 oct28 ?        00:00:00 /usr/sbin/rpc.idmapd
root       455     1  0 oct28 ?        00:00:30 /usr/sbin/cron -f
daemon     456     1  0 oct28 ?        00:00:00 /usr/sbin/atd -f
root       457     1  0 oct28 ?        00:00:04 /usr/sbin/sshd -D
root       459     1  0 oct28 ?        00:00:06 /lib/systemd/systemd-logind
message+   461     1  0 oct28 ?        00:00:01 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
root       467     1  0 oct28 ?        00:00:59 /usr/sbin/rsyslogd -n
root       469     1  0 oct28 ?        00:00:00 /usr/sbin/acpid
root       745     1  0 oct28 tty1     00:00:00 /sbin/agetty --noclear tty1 linux
root       851     2  0 dic04 ?        00:00:47 [kworker/1:1]
root      1765     2  0 07:05 ?        00:00:00 [kworker/u16:2]
root      4589     2  0 07:22 ?        00:00:00 [kworker/u16:1]
root      5636     2  0 oct31 ?        00:00:00 [xfsalloc]
root      5637     2  0 oct31 ?        00:00:00 [xfs_mru_cache]
root      5638     2  0 oct31 ?        00:00:00 [xfslogd]
root      5641     2  0 oct31 ?        00:00:00 [jfsIO]
root      5642     2  0 oct31 ?        00:00:00 [jfsCommit]
root      5643     2  0 oct31 ?        00:00:00 [jfsCommit]
root      5644     2  0 oct31 ?        00:00:00 [jfsCommit]
root      5645     2  0 oct31 ?        00:00:00 [jfsCommit]
root      5646     2  0 oct31 ?        00:00:00 [jfsSync]
root      5665     2  0 oct31 ?        00:00:00 [bioset]
postfix   5859  8842  0 07:30 ?        00:00:00 cleanup -z -t unix -u -c
postfix   5877  8842  0 07:30 ?        00:00:00 trivial-rewrite -n rewrite -t unix -u -c
postfix   5930  8842  0 07:30 ?        00:00:00 local -t unix
postfix   5958  8842  0 07:30 ?        00:00:00 local -t unix
postfix   6010  8842  0 07:30 ?        00:00:00 local -t unix
postfix   6027  8842  0 07:30 ?        00:00:00 pickup -l -t unix -u -c
root      6098   457  0 07:30 ?        00:00:00 sshd: fernando [priv]
fernando  6122  6098  0 07:30 ?        00:00:00 sshd: fernando@pts/0
fernando  6123  6122  0 07:30 pts/0    00:00:00 -bash
root      6134  6123  0 07:30 pts/0    00:00:00 sudo bash
root      6135  6134  0 07:30 pts/0    00:00:00 bash
nagios    6152  6310  0 07:30 ?        00:00:00 /usr/lib/nagios/plugins/check_ping -H 172.23.40.41 -w 200.0,20% -c 600.0,60% -p 5
nagios    6153  6305  0 07:30 ?        00:00:00 /usr/lib/nagios/plugins/check_ping -H 172.23.40.46 -w 200.0,20% -c 600.0,60% -p 5
nagios    6154  6309  0 07:30 ?        00:00:00 /usr/lib/nagios/plugins/check_ping -H 172.23.40.51 -w 200.0,20% -c 600.0,60% -p 5
nagios    6155  6153  0 07:30 ?        00:00:00 /bin/ping -n -U -w 10 -c 5 172.23.40.46
nagios    6156  6154  0 07:30 ?        00:00:00 /bin/ping -n -U -w 10 -c 5 172.23.40.51
nagios    6157  6152  0 07:30 ?        00:00:00 /bin/ping -n -U -w 10 -c 5 172.23.40.41
nagios    6158  6306  0 07:30 ?        00:00:00 /usr/lib/nagios/plugins/check_ping -H 172.23.40.73 -w 3000.0,80% -c 5000.0,100% -p 5
nagios    6159  6158  0 07:30 ?        00:00:00 /bin/ping -n -U -w 30 -c 5 172.23.40.73
root      6160  6135  0 07:30 pts/0    00:00:00 ps -ef --cols=300
nagios    6303     1  0 dic02 ?        00:02:06 /usr/local/nagios/bin/nagios -d /etc/nagios/nagios.cfg
nagios    6304  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6305  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6306  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6307  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6309  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6310  6303  0 dic02 ?        00:00:03 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios    6327  6303  0 dic02 ?        00:00:04 /usr/local/nagios/bin/nagios -d /etc/nagios/nagios.cfg
nagios    6404     1  0 dic02 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
root      6405     2  0 dic02 ?        00:00:00 [kworker/3:1]
root      7004     1  0 nov24 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql     7352  7004  0 nov24 ?        00:05:39 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
root      7380     2  0 dic03 ?        00:01:44 [kworker/0:0]
root      8694     1  0 nov15 ?        00:00:00 /usr/sbin/xinetd -pidfile /run/xinetd.pid -stayalive -inetd_compat -inetd_ipv6
root      8842     1  0 nov15 ?        00:00:24 /usr/lib/postfix/master
root     13053     2  0 02:01 ?        00:00:08 [kworker/2:1]
nagios   15532     1  0 nov01 ?        00:02:55 /usr/local/pnp4nagios/bin/npcd -d -f /etc/pnp4nagios/npcd.cfg
postfix  17542  8842  0 nov15 ?        00:00:40 qmgr -l -t unix -u
root     19129     2  0 dic02 ?        00:01:27 [kworker/1:2]
nagios   19850     1  0 nov02 ?        00:06:59 /usr/bin/python /usr/bin/mkeventd -C /etc/check_mk --statedir /var/lib/mkeventd --logdir /var/lib/mkeventd -P /var/log/nagios/rw/mkeventd/events -E /var/log/nagios/rw/mkeventd/eventsocket -S /var/log/nagios/rw/mkeventd/status --pidfile /var/log/nagios/
snmp     21202     1  0 nov03 ?        00:13:19 /usr/sbin/snmpd -Lsd -Lf /dev/null -u snmp -g snmp -I -smux mteTrigger mteTriggerConf -p /run/snmpd.pid
root     27005     2  0 06:25 ?        00:00:01 [kworker/3:0]
root     27018     2  0 06:25 ?        00:00:03 [kworker/0:2]
www-data 27020 28920  0 06:25 ?        00:00:00 /usr/sbin/apache2 -k start
www-data 27021 28920  0 06:25 ?        00:00:00 /usr/sbin/apache2 -k start
www-data 27022 28920  0 06:25 ?        00:00:00 /usr/sbin/apache2 -k start
www-data 27024 28920  0 06:25 ?        00:00:00 /usr/sbin/apache2 -k start
www-data 27025 28920  0 06:25 ?        00:00:00 /usr/sbin/apache2 -k start
root     28920     1  0 nov29 ?        00:00:08 /usr/sbin/apache2 -k start
root     30119     2  0 dic04 ?        00:00:01 [kworker/2:2]

root@lsmnagios:~# echo 'show tables;' | mysql -t -u ndoutils -pSanMartin2o16 nagios

Code: Select all

+----------------------------------------+
| Tables_in_nagios                       |
+----------------------------------------+
| nagios_acknowledgements                |
| nagios_commands                        |
| nagios_commenthistory                  |
| nagios_comments                        |
| nagios_configfiles                     |
| nagios_configfilevariables             |
| nagios_conninfo                        |
| nagios_contact_addresses               |
| nagios_contact_notificationcommands    |
| nagios_contactgroup_members            |
| nagios_contactgroups                   |
| nagios_contactnotificationmethods      |
| nagios_contactnotifications            |
| nagios_contacts                        |
| nagios_contactstatus                   |
| nagios_customvariables                 |
| nagios_customvariablestatus            |
| nagios_dbversion                       |
| nagios_downtimehistory                 |
| nagios_eventhandlers                   |
| nagios_externalcommands                |
| nagios_flappinghistory                 |
| nagios_host_contactgroups              |
| nagios_host_contacts                   |
| nagios_host_parenthosts                |
| nagios_hostchecks                      |
| nagios_hostdependencies                |
| nagios_hostescalation_contactgroups    |
| nagios_hostescalation_contacts         |
| nagios_hostescalations                 |
| nagios_hostgroup_members               |
| nagios_hostgroups                      |
| nagios_hosts                           |
| nagios_hoststatus                      |
| nagios_instances                       |
| nagios_logentries                      |
| nagios_notifications                   |
| nagios_objects                         |
| nagios_processevents                   |
| nagios_programstatus                   |
| nagios_runtimevariables                |
| nagios_scheduleddowntime               |
| nagios_service_contactgroups           |
| nagios_service_contacts                |
| nagios_service_parentservices          |
| nagios_servicechecks                   |
| nagios_servicedependencies             |
| nagios_serviceescalation_contactgroups |
| nagios_serviceescalation_contacts      |
| nagios_serviceescalations              |
| nagios_servicegroup_members            |
| nagios_servicegroups                   |
| nagios_services                        |
| nagios_servicestatus                   |
| nagios_statehistory                    |
| nagios_systemcommands                  |
| nagios_timedeventqueue                 |
| nagios_timedevents                     |
| nagios_timeperiod_timeranges           |
| nagios_timeperiods                     |
+----------------------------------------+

[tgriep]

Can you post this file so we can view it?

Code: Select all

/lib/systemd/system/ndo2db.service

Also run this on the server as root and post the output here.

Code: Select all

/usr/local/nagios/bin/ndo2db

Thanks.

[ffrcaraballo]

root@lsmnagios:/lib/systemd/system# /lib/systemd/system/ndo2db.service
bash: /lib/systemd/system/ndo2db.service: Permiso denegado
root@lsmnagios:/lib/systemd/system# /usr/local/nagios/bin/ndo2db

NDO2DB 2.1.2
Copyright (c) 2009 Nagios Core Development Team and Community Contributors
Copyright (c) 2005-2008 Ethan Galstad
Last Modified: 11-14-2016
License: GPL v2

Stores Nagios event and configuration data to a database for later retrieval
and processing. Clients that are capable of sending data to the NDO2DB daemon
include the LOG2NDO utility and NDOMOD event broker module.

Usage: /usr/local/nagios/bin/ndo2db -c <config_file> [-i] [-f]

-i = Run under INETD/XINETD.
-f = Do not fork daemon.

I start the service with /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg

Thank

[tgriep]

Can you run following command and post the output here?

Code: Select all

grep -i broker /etc/nagios/nagios.cfg

Thanks